PDO Connections to MySQL from PHP

[@randommonkey5418]

insanely soothing voice - much fun to listen too and also: great explanation

[@westfield90]

Thank you. I really appreciate your clear concise explanations and the variety of topics. Just one question. Do you need a minimal version of PHP in order to use PDO?

[@SteveGriffith-Prof3ssorSt3v3]

Version 5.1 of PHP is where PDO was added. You would be hard pressed to find a server that isn't running at least that version, if not version 7. Here is the reference for PDO - php.net/manual/en/class.pdo.php

[@webstuff56]

I didn't know you did PHP as well--I've been refocusing here, good news

[@SteveGriffith-Prof3ssorSt3v3]

There is a long list of topics that I have worked with. It's always a matter of having enough time to try and put all that information together into videos.

[@webstuff56]

I'm glad to see it, Steve. Thank you. I always knew server side was my passion. But I think like most everyone gets trapped thinking they must master JS. Then JS becomes this full-time program that seems you can never get enough of. I think the key to JS is in understanding where it's ok to stop. For your basic web developer, I think the basics along with the DOM and AJAX one should figure out this is where to walk away from. Otherwise you get trapped in an endless cycle where you become obsessed with trying to become something you dont need to be at the expense of everything else. I am so loving PHP and mysql: the two amigos ;) so much can be done with them.

[@prashanthkumar0]

your channel is awesome ...

[@KentaroxKondo]

Thank you so much!

[@webstuff56]

when would one use mysqli or any other connection method? and why would one be preferred over the other?

[@SteveGriffith-Prof3ssorSt3v3]

The mysql methods came first but were insecure. Then mysqli which was mysql improved. The PDO was added. PDO is a much better implementation which includes support for transactions. It is the best choice. No need for anything else.

[@webstuff56]

what would the DNS be if the file here was on a external webserver: $db = new PDO('mysql: host=what????; is it the domain name of the website associated with this?

[@SteveGriffith-Prof3ssorSt3v3]

It can be the domain name or an ip address. As long as the external server allows connections from external sources. When you create permissions for the users on the MySQL RDBMS you need to indicate whether it can be accessed from localhost or from external.

[@webstuff56]

Yes thank you; I'm referring to a hosted website

[@prashanthkumar0]

great

[@banglaanimereviewssl4729]

sir i need some help because i have tried many time but it said "couldn't find the server"

[@SteveGriffith-Prof3ssorSt3v3]

Is your webserver running? Is your MySQL server running? correct ip address? correct port number?