PHP-MySQL Lesson: Select Database

Select Database

After we have establish the connection in MySQL server, we have to select a database. To do that we are going to use the mysql_select_db() function.




databasename – the database name you want to use.

connection – Specifies the MySQL connection

Example script:

$conn = mysql_connect("localhost","root","")
or die("could not connect");
or die("could not select database!");

In our example we have first establish a connection in our MySQL server. Then we have selected the database employee (the name of our database) using the mysql_select_db() function. The die statement will be executed if the connection fails.

, , , , ,

Post navigation

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.