In this tutorial, I will explain simple and easy steps that will help you to create a database connection with MySql database with PHP applications. It is very easy to write a script in PHP to get connect with most of the popular open source database like MySql.
1 2 | $conn= mysql_connect("hostname", "username", "password") or die("cannot connect to server"); |
Below is the complete example of how to make a connection with MySql using the PHP code. In the below example change the DB_SERVER, DB_USERNAME, DB_PASSWORD, and DB_DATABASE as per your database credential.
1 2 3 4 5 6 7 | <?php #define the variable names define('DB_SERVER', 'localhost'); //Your hostname define('DB_USERNAME', 'root'); // database username define('DB_DATABASE', 'testdb'); // database name |
After defining the database variables, use the below code to make a connection with the database.
1 | $connection = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die('Unable to connect'); |
Now use the below code to select your database to use in your PHP based application.
1 2 3 4 5 6 7 | $database = mysql_select_db(DB_DATABASE) or die('Unable to select'); if (!$database) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($database); |
If you like FreeWebMentor and you would like to contribute, you can write an article and mail your article to [email protected] Your article will appear on the FreeWebMentor main page and help other developers.
Article Tags: Database, How to Connect Database With PHP, mysql database connection, PHP, php database connection
