Query A Database Using PDO In OOP PHP | Object Oriented PHP Tutorial | PHP Tutorial | mmtuts

up to present day, this video is a big help. saved me on going on a 4th day searching..

🙏

how do you turn the values into a variable and echo them out on page with list of users

in the User class, using 'return' gives me only the first uid, using echo it shows them all

you dont need to execute the statement ?

I'm here! 😎 Great video, just posting a comment to show some support! Keep up the good work. 🤙

//my code

public function insertProd($name){
$this->n=$name;
$this->setDBName("dbProd");
$stmt = $this->connect()->prepare
('
INSERT INTO tblProd
(
name
)
VALUES
(
:n
)
');

//idProd = auto increment

$stmt->bindParam(':n' , $name);
$stmt->execute();
/* return last_insert_id(); <--- I don't know =( */
}

Hello my friend! How to get last_insert_id()? thanks!

Good Day,
May I ask, is it fine if I don't close the cursor?
Thanks

cool

I learn a lot of things Thanks

You confused me with the order that you have your videos.

very nice ..

Thank you so much. You helped me a lot. I have learned a lot of programming languages, but this helps me a lot in all of them.

Thanks for your tutorials, they are quite useful, and you explain well!

I can't find the playlist for PDO. Can anyone link that to me?

Does it really make sense that the User extends the Dbh class. Yes for functionallity of curse but I mean a user hasn't something to do with a DB. And what is when I want the user Class to extends another class like the class Sepecialuser or something like that I can onky extend from one class so when every class which have something to do with Database extends from the Database Class that would be a Problem

why do you let user extend from dbh? user isnt a database ?

Why do you use a while loop on the "getAllUsers()" method? It will only return the first result since nothing after a return is processed. Seem's a bit odd to do it like this?

when is your next oop tutorial coming up i am waiting.....plz

I like watching your tutorials a lot.
I just finished to BCT education College high diploma.
I want to study it about your OOP lesson.
but I don't have money and don't have a bank account.
Please help me.
I have to work for my family.
I don't need much.
I want to study about insert, update, delete or get variable in form to database.
Please call me(+856 20 5531 9304) or send E-mail to me([email protected])
Thank You.

Since we are back to php - would you consider to start with the social network again? :) Your fans are waiting for this already so long ;)

How to integrate a template with OPP?

whoohowwww!! i survived the entire course! thank you!

TO be honest, you have really opened my eyes to programming, I have not been able to create a project all these years
but within 5mnth I knew your page, I have been able to!
thanks thanks thanannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnks...
Also ...kindly help US with a complete PHP OOP PDO Login system

What i need with this tutorial is use cases, how can this be put into use and not something really big.. just the simple how to read from a database, or how to display data from an array into index.html using principle of oop php and how to avoid the traps of creating classes/ functions who become specific and cant be reused ;) if you wanna do bigger stuff then include mysql as almost all uses that for websites or data they wanna show into their websites.

Thanks too you mmtuts will be anticipating your subsequent tuts

dude. you are a ANGEL. =) this tutorial worked perfectly for my site! i'll be sure to put a link to this in my readme-doc.

PLZ UPLOAD MORE PHP ADVANCE TUTORIAL!!!

You're saving my life here, thanks for these awesome tutorials!!

Plz continue advance PHP course with project.

hey man! I learned so much thing from your videos, but i realized you didn't push new one? why did you stop ?

Hello, I copied all the same codes but different database and table name and attributes however I am getting this error "Fatal error: uncaught error: call to a member function query() on null in C:\xxamp\htdocs\test\user.inc.php:16 Stack trace: #0 C:\xxamp\htdocs\test\index.php(19) User->getAllUsers() #1 {main} main thrown in C:\xxamp\htdocs\test\user.inc.php on line 6.

Please help me, on fixing this error. Thank you.

thank you so much

That is part 14, right? I can't find part 1 to 13. Could you support me the links for those parts?

Thanks for the video series. You’ve helped a great deal and explained it well. I think it’s only right I donate something for your time. Please advise how.

Beasted through these videos in about 2hrs. But to be fair, i already had some OOP experience. Best of luck to everybody!

will you continue this series? Or this is all there is to it?

Thank you sir, i was so lost with other tutorials and guides but now i understand exactly what's going on. God bless you.

i getting some error message:
Fatal error: Uncaught PDOException: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected
how to fix it?

I was quite stuck at learning OOP PHP and also the PDO part. Really helpfull and clear explained. Going trough the last part again as I did the series all at once at night. So focus was a little bit lost. Thanks and let see if you have more of these :) !

Pleas more oop php videos.

Can someone please tell me why php is a meme?

I see that he's inheriting from Dbh class, but why?

I'm pretty new to web dev, coming from C/C++ and I'm kinda confused why you inherit from the DB.

Couldn't you just make it like a singleton and use it to connect and query? I know he's doing it OOP style, but I've never seen this before lol

Reason I'm asking is if you wanted to have a class extending from another class. For example Car extends Vehicle. With this approach (assuming here php doesn't allow multi-inheritance), you would not be able to do such a thing.

thank you for your efforts

Enjoyable tutorial!


Can I ask a question, in some of the MVC I've looked at they return the data from the class then do the for or while loops on the view, why do you do a for loop (or while loop) to output the data in the class?

Good video.
Need more about mysqli OOP and select, delete or other.

I​ did that same thing and it did not do anything can you help?

Thank you Bro. 👍 for ur hardwork .

I am getting this error, please help :
Fatal error: Uncaught PDOException: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in C:\xampp\htdocs\dbconnect_pdo\includes\getuser.inc.php:29 Stack trace: #0 C:\xampp\htdocs\dbconnect_pdo\includes\getuser.inc.php(29): PDOStatement->execute(Array) #1 C:\xampp\htdocs\dbconnect_pdo\index.php(22): getUser->getUserWithCountCheck() #2 {main} thrown in C:\xampp\htdocs\dbconnect_pdo\includes\getuser.inc.php on line 29

Great video!