PHP Tutorial (& MySQL) #31 - Getting a Single Record

Can someone please explain to me why when you're making requests to and from the database, the queries always start with `mysqli` rather than just `mysql`. What does the `i` stand for?

Your tutorials are the best! Really appreciate your videos=)

You are the best teacher. Im recomending you to all my friends who are starting at computer engeneering and other to learn more and more. Continue the good work. Once i have a job i will gladly donate you because you are helping everyone so much in a way that anyone can learn. Again, thanks a lot.

i keep getting an error saying: Warning: Undefined variable $product. I have changed $pizza to $product in the variables up top, but it gives me the error that the variable is not defined. any ideas?

Can I use $_POST instead of $_GET, when checking is variable set?

THAK U SO MUCH

It's working thank you

I love Ninja!!! Love you ma man!

You are the best
😭😭😍
Thx a lot 🥺👌❤️

Thanks a lot!!! It really helped me. But I am get getting $id not defined or Warning: Undefined variable $id in C:\xampp\htdocs\

such thing is free?
how

It shows undefined variable $pizza even tho i have defined it.. Plz help

Such an amazing course . Love the clear explanation and concepts.

mysqli_fetch_assoc() expects parameter 1 to be mysqli_result

What should I do? I already checked my code and there's no typo. Help!

thank u so much I cant think you enough thanks thanks thanks ❤️

Sighhh. I get confused on which quotes to use. Used a single quote to create a query and I got an uncaught type error. Using a double quote fixed this

can I pass the id in a different way that is more secure??

do we really need to echo the $pizza['id'] in order to get the id value?

lots of fun!

Best tutorial. I've been searching and getting confused until I found this video. Thanks alot.

<?php if($pizza): ?> error on line 47 ...i tried the project files from Git hub and also received that error .Please help i cant continue my lessons

great :) thank you

Hey I sent you a doubt on Instagram.
And I have another one.
In index.php I used $pizza['title'] to get the title on the webpage.
But in more info page I had to use.
$pizza['Title'] for the same database . Why do I have to change the name title for same data base can you clarify.

course files?

thank you Ninja :)

You saved my ass man.

For some reason, I can't get my form information to be placed in the details.php

For some reason when I try to echo the id, nothing happens
<a href="details.php/?id=<?php echo $result -> id ?>"> Más información </a>
but when I try to use any other feature it works...... weird
<a href="details.php/?id=<?php echo $result -> horario ?>"> Más información </a>

Hello The Net Ninja

stuck here Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in.
but when I type the id number myself on URL it displays the info correctly.
Any help with that?

thankx

Hi first at all, thanks for your tutorials!. Please let me ask: I have this error : Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in ...
if I use $sql = 'SELECT * FROM pizzas WHERE id = $id';
But if I use " instead have no problem.... So when do I have to realize when use single quotes or double?, thanks again for your time and videos.

I have a problem with id of pizza! when i input data into the form then click on 'More info' and then go to url to check id, it didnt show an id like id=1 id=2 id =3..., it only show id=0; plx help:)

sql does not recgonize php variable $id it gives an error
$sql = "SELECT * FROM pizzas WHERE id = $id";
the $id gives error as I remove this i can get rid of error
how can I set id to $_GET['id']
EDIT: Solved had to use prepared statement

$sql = 'SELECT * FROM users WHERE id=?';


$stmt = mysqli_stmt_init($conn);
if(!mysqli_stmt_prepare($stmt, $sql)){

echo 'Not done sorry';
} else {

mysqli_stmt_bind_param($stmt, "s", $id);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$member = mysqli_fetch_assoc($result);
}

You are a f*cking legend !!! Your videos are the best buddy keep it up!

Thanks a lot!

thank you .
i write all you previous tuts and continue to next vadio.
the way you explain and solve every problem in form is unbelieving.

hi, I have a quick question, I can see the way we get id from url. In some website we even pass user id via url, how can I secure this information, let say if they change the user id it won't redirect to other users account

Why id without htmlspecislchars()?

thanks dude i have been looking for this for years. i am just joking, but you saved my ass

Thanks for a nice video! I don't have problem understanding this video until #31 but on details page i created pizza variable but the browser show error message like underdefined variable on line 33. Would you help me on this? Thanks!!

Thanks for your great tutorial
I have a question = ( Why did you add a ? before the id )

we want Ph POOP

some other guys create videos of hours just to show this, you're awesome man very clear right to the point, i hope you can continue with POO in the future or maybe make some PHP advanced course in Udemy, thank you!

Nice ninja. Hoping this extends into a PHP OOP series after 👍

Magnificent! It is just so easy! Clear explanations. Fast and detailed. Love it.

Merciii thanks ! God bless you ❤

thank you :)