Connect To Database Using PDO In OOP PHP | Object Oriented PHP Tutorial | PHP Tutorial | mmtuts

How to Connect to A Database Using PDO PHP | OOP PHP Tutorial | Learn OOP PHP. In this OOP PHP tutorial you will learn how to connect to a database using PDO, which is the prefered method to use in Object Oriented Programming.
Article on PDO vs MySQLi: code.tutsplus....
➤ SPECIAL THANKS TO THE FOLLOWING PATRONS!
Name: Scooterman
Channel Link: / @scooterman9230
Description: I'm a guy.
➤ GET ACCESS TO MY LESSON MATERIAL HERE!
First of all, thank you for all the support you have given me!
I am really glad to have such an awesome community on my channel. It motivates me to continue creating and uploading content! So thank you!
I am now using Patreon to share improved and updated lesson material, and for a small fee you can access all the material. I have worked hard, and done my best to help you understand what I teach.
I hope you will find it helpful :)
Material for this lesson: / oop-php-lessons-26928726

[@alvin8294]

It's my first time to take php oop seriously and I find your series more helpful than my instructor. You earn a sub!

[@tharushakavishan4720]

hey, Dani I from Srilanka. so today I'm a professional web developer and I have a small startup and I have not any college degree my all web developer knowledge learning from you Thank you everything for man

[@Born2DoubleUp]

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

[@odunladeoluwaseun7880]

I was telling people on the forum yesterday that you are one of the best Php tutor on KZbin. kudos. please can you do a video on making crud using Php pdo and oop? I can do it with Php procedural and also mysqli oop. thank you in advance

[@drcod3r329]

please a course about laravel please i want your tutorial sooo bad :)

[@Dani_Krossing]

I have it written down :) but it might be a while before I get to it unfortunitaly

[@ovidiublaga1]

Yes, please

[@abduljabbardumrai7904]

Note: If you wish to use setAttribute, you must set the array attributes passed to the PDO constructor itself. If setting attributes with PDO::setAttribute() after instantiation of the object, the driver will not be using these attributes. So, it should be like this $pdo = new PDO($dsn, $this->username, $this->password, array( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXEPTION ));

[@BogdanGabrielMarinica]

Been looking for this exact subject on your channel! Thanks

[@jeetenzhurlollz8387]

man your tutorials are so awesome

[@tokbunthoeun1488]

Could you please make video about Magic Method in php? Because I love the way your teach.

[@nikolasblues270]

Just in time! Thank u again! Like before even watch the video! :D

[@austrisotersons-andersons2450]

Great tutorial series, very well explained and easy to understand. Keep up the good work!

[@jaydee3807]

Hi there mate, some great tutorials going on. I was wondering if you could cover in this series Dependency injection which is the preferred option over the singleton pattern when it comes to connecting and accessing the database from lets say the user class? Also some helper methods that would make prepared statements else where easier to implement (query, bind, execute..etc.)

[@ehepatoupatrick7511]

Thanks a lot, everything worked on my side

[@osamamughal8010]

Hey bro Your tutorials are awesome,outstanding and mind blowing. Loved it alot.Kindly make complete tutorials on php7 and pdo queries. and also laravel. Thanks alot in advance

[@lawrencemichael5571]

BRILLIANT BRILLIANT BRILLIANT! THANK YOU MY MAN! YO DA BEST!

[@roman222k]

Cool content, thanks a lot mate! That's what I need. Following!

[@alessandrop1984]

Always a big fan of yours!

[@jeromekarldayaon7816]

This course is awesome thank you very much my boy!

[@Awesomedariness]

these tutorials are near perfect .. keep up the good work :)

[@Born2DoubleUp]

would love to see more on PDO!

[@AlineFloresDelon]

thank you so much! i'm your big fan now!

[@benjaminhoppe334]

Great Video! Can you maybe say something how to close this pdo connection?

[@Vincent-fs8ry]

Great video really help Me thanks Man keep up with great content!

[@MrSinha]

Do you know Python? If Yes, then please make tutorials on Python..Many people want to learn python

[@elizavetawallace4356]

Thank you so much!!! Very helpful

[@sonnyb6536]

Hey Daniel. How are you? I know this isn't the video about javascript but it is your latest :D. I was hoping you could make different project videos for javascript so I, we all can learn more about it. Like a simple game using javascript, a curtain webpage, idk. Some interactive projects that use html, css and mostly javascript to help learn by doing. Thank you for all your videos!!!

[@Dani_Krossing]

Hi Sonny :) I am planning on uploading a new JavaScript lesson today, and in the future create more project focused episodes, since these are the ones I have the most success with.

[@sonnyb6536]

Glad to here it Daniel. No worries on when you upload :)

[@ramonmoreno152]

thank you so much for your tutorials!!

[@taospencer1403]

Hi dude, your tutorials are amazing, probably the best on youtube & the easiest to follow, the php doc's say that all mysql functions are deprecated, in the dsn section Can I swap out msql for -> mysqli? My Print_r returned "Array ( [0] => mysql [1] => sqlite [2] => firebird [3] => dblib )"??

[@nainen5337]

I love you and your videos!

[@tentpolesman]

Cool!

[@sven2529]

Is it a good idea to write the credentials directly into the class constructor? Is it really safe? Please I really want to learn how to control a database correctly and absolutely safely. With an access data file or similar.

[@donaldsingh7647]

Thanks. It would be great if you could also set an option to make a one-time donation to support you...

[@khamisyahya1489]

Hello deni I want to ask some question about programing. To help me in it

[@deopurkar]

Yor are a great turor. Please Make a tutorial on Codeigniter.

[@deopurkar]

Hey you didn't reply, are you going make tutorial or not? 😅

[@mishenthakshana3407]

Thankyou

[@boyhagawak2757]

Hi, can you please explain where is the closing connection part?

[@MohamadMohamad-ch5rb]

My duty has done , hit like and go 😅

[@luciorodrigues3589]

Amazing !!!

[@mariamontesba7235]

Thank you 👌👌👌👌

[@fabianl1156]

Make this same tutorial, but with SQL Server. Please 🙏.

[@avinasha3237]

Don't you continue the series anymore as there are many concepts in PHP. The way you teach is very good.

[@Dani_Krossing]

Yes I just started continueing this series :)

[@cleancodez]

laravel please am also waiting men i like your content men,

[@telemarqueernest3687]

thank you

[@assad.rajab-2]

Guys i can't find the Playlist of this Tutorial. could anyone post the link

[@developerenn]

Hi, I have PHP 5.2.4 will PDO work on my server?

[@ravinishad8424]

hey brother we have our project submission on 2nd feb 2019 but we are facing postgres database connection problem in php using fedora can you please help us

[@klemlloydmwenya2224]

I have trouble with my PDO connection and I think you can help me. I have DSN values as they should be ```$conn = new PDO("mysql:host = $serverName; dbname = $dbName; charset = $charset", $userName, $password);```, but when I temper with dbname, the connection still succeeds. I want to have a connection to a specific database on my server. But this all thing gets rather confusing when the connection is happening to a database that doesn't even exist.

[@klemlloydmwenya2224]

Let me reach on phone, whatsapp or some thing. I do have a good number of queries!

[@richarddunne8036]

I used the same code from this tutorial, however, the pdo connection in my data file, I'm getting Undefined variable for dsn, user and pass. Any idea what could/might be causing this?

[@AbdulAzeem-un7hz]

can you please show the query that you are trying to execute?

[@_Omni]

Make a tutorial on Blender :D

[@Dani_Krossing]

I'd love to once I don't have too many courses going at once :)

[@_Omni]

You are the best!

[@crazy_coder]

can you suggest me how can i connect to another database if one if failed to connect...Please help is anyone read this...

[@brianhide6294]

Could not find driver Guys help me, how to fix this

[@matejhopp7529]

Is pdo working on xamp?

[@amarsinghania7080]

Question about pdo oop So I have a log in system with pdo and oop where after a user logs in, he can see a bunch of info on his profile page in a table. I fetch this info in user.php and set the session variables there and check if session variables are set on profile page and display those session variables data in table there. Is this a good practice to have a bunch of session variable or should I use pdo to run fetch queries instead and forward an array to profile ?

[@timmatthews4595]

It would probably be better practice to pass the user id session variable to your user class and have a function fetch all of the profile data for that user and then return this to the profile page in an array. That way you're only using one session variable which is defined outside of the class (and should already be defined to validate authentication etc).

[@amarsinghania7080]

Tim Matthews yeah thats what I did. Thanks !!! Took a bunch of time to figure out how to return a json and then display data in a table created using ajax that converts json to infinite number of table rows depending on how many rows were fetched from the database. Using session variables only for user name verify and display. Rest of the data fetching and mod using pdo statements and separate methods in oop class. Oop php is awesome !!!

[@hasnatkabir8903]

Is the $password and $username attributes mentatory to pass int PDO (...).Can,t i connect the database without these?

[@Dani_Krossing]

We pass them in to keep the database info private to the Dbh class only :) If we include them directly into a protected method, then other classes have access to it as well. Which we don't want.

[@ronaldcsjohnson4790]

Someone please give the link for the complete playlist.

[@Dani_Krossing]

It's on my channel page :)

[@stefan4800]

Do you use Blender for modeling? :)

[@Dani_Krossing]

Well I just started using it :) I have more experience using Cinema4D

[@stefan4800]

Cinema4D is really great! :)

[@Dexter101x]

Just did this, but the error message on the database that never existed didn't appear when I did this, even though the database didn't exist

[@Dexter101x]

Oh I see why, I didn't add the "=" to the dbname and charset bit, bit of a typo

[@emornutaz2946]

when i add the charset (.";charset=".$this->charset) in the dsn than it gives a error that says: Unknown character set. When i remove it it works. Why is that? chars are: uft8mb4

[@gen157]

Experiencing this as well. I've simply commented it out for now. It worked once with it but kept failing after the fact. Everywhere I look people are using it just fine, but fails on mine.

[@AlineFloresDelon]

i know it's late, but here is my comment in case anyone else has the same issue, it must say utf8mb4, i had a similar problem that lasted 3 weeks :S

[@olegs77]

after checking there is still error of empty properties. -----------Fatal error: Uncaught Error: Cannot access empty property-----

[@MadaMediaproduction]

Any help with this case

[@MrSinha]

Are you learning machine learning or algorithms of Artificial Intelligence? Please Reply Me.

[@Dani_Krossing]

Mr. Sinha No :)

[@MrSinha]

That's Ok! But Your Teaching Skills are very good!

[@MrSinha]

Your videos helped me very much while I was learning PHP.

[@molidaloeung428]

Laravel please!!

[@zlackbiro]

You complicated this too much... Its actually very simple. Also, your connection doesnt use prepared statement, witch is fully unsecured way to drive your DataBase...