Where MySQL is an open-source database server. These database powers are the most demanding for Web, E-commerce, and Online Transaction Processing (OLTP) applications.
This is a fully integrated transaction-safe, ACID (Atomicity Consistency Isolation Durability) compliant database with full commit, rollback, and crash recovery and row-level locking capabilities.
The MySQL DB delivers the ease of use, scalability, and performance that has made MySQL the world's most popular open-source database.
Into this article, I will show you, how to use the MySQL database with PHP. To use of MySQL database with PHP, make some changes in the php.ini file.
Change 1:
Open ‘php.ini’ file and configure as follows:
From the above file, uncomment the highlighted line by removing semicolon (;) from the front of this line.
Change 2:
Open ‘php.ini’ file and find out ‘extension_dir’ after that set the extension directory path.
Here “C:\php\ext\” is a directory path where I had install PHP.
After making the above two changes in the php.ini file, restart your apache server. Now your MySQL database server is ready for use with PHP.
Leave a Comment