PHP Data Object PDO installation or enable and creating connection string to manage MySQL database

https://www.plus2net.com/php_tutorial/pdo.php
PHP Data Object or PDO is a better option if you have a plan to change your database in future. PDO supports 12 different database, so when we change the database our connection string only changes and the functions we use to manage database remain same.

In a windows system open php.ini file inside our windows or PHP installation folder. Search for it and open in any note pad or in any editor. Search for the word PDO , if any semicolon is there before it then remove it to enable the dll ( support ). If you want MySQL support or SQLite then corresponding dll you can enable or disable here. Save and restart your server.
phpinfo()
phpinfo() is the function which till tell us all about our PHP installation. Write this one line of code inside a file and run in your server.
echo phpinfo();
Full list of your PHP installation details will be displayed. Search for the word PDO inside it and see how support for different Database is available. One such support will be MySQL.
We can check the support by writing two line of codes also. The if condition check will print the support availability.
if(in_array(“mysql”,PDO::getAvailableDrivers())){
echo “You have PDO for MySQL driver installed “;
}else{
echo “PDO driver for MySQL is not installed in your system”;
}
Connecting String
It is always better to keep the connecting string with MySQL login details in a separate file and connect to all user files by using include statement. This helps in better management which large number of pages uses the database connection. When ever host is changed or any login details are changed then this can be updated at a common place and all the user files need to be updated.
#PHP_PDO #PDO #PHPMYSQL #PDOMySQL