Example
Change the default database for the connection:
<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
// ...some PHP code for database "my_db"...
//
Change database to "test"
mysqli_select_db($con,"test");
//
...some PHP code for database "test"...
mysqli_close($con);
?>
Definition and Usage
The mysqli_select_db() function is used to change the default database for the connection.
Syntax
mysqli_select_db(connection,dbname);
| Parameter | Description |
|---|---|
| connection | Required. Specifies the MySQL connection to use |
| dbname | Required. Specifies the default database to be used |
Technical Details
| Return Value: | TRUE on success. FALSE on failure |
|---|---|
| PHP Version: | 5+ |
< PHP MySQLi Reference