PHP SQL Select Database

PHP SQL Select DB Statement Syntax

The syntax for the mysql_select_db statement is shown below. This statement will select the database that future queries will be sent to.

bool mysql_select_db ( string database_name [, resource link_identifier])

The value returned is true if there is success, and it is false if the command failed.

PHP SQL Select DB Statement Example

$dbuser="username";

$dbpass="password";

$dbname="mydata";  //the name of the database

$chandle = mysql_connect("localhost", $dbuser, $dbpass) 

    or die("Connection Failure to Database");

echo "Connected to database server<br>";

mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found." . $dbuser);

echo "Database " .  $database . " is selected";

mysql_close($chandle);