Once you get connection with MySQLi server, it is required to select a particular database to work with. This is because there may be more than one database available with MySQLi Server.
Syntax
bool mysqli_select_db( db_name, connection );
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
db_name
Required - MySQLi Database name to be selected
|
| 2 |
connection
Optional - if not specified, then last opened connection by mysqli_connect will be used.
|
Example
Here is the example showing you how to select a database.
<html> <head> <title>Connecting MySQLi Server</title> </head> <body> <?php $dbhost = 'localhost:3306'; $dbuser = 'root'; $dbpass = '<Password Here>'; $conn = mysqli_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { echo 'Connected failure<br>'; } echo 'Connected successfully<br>'; mysqli_select_db( 'TUTORIALS' ); //Write some code here mysqli_close($conn); ?> </body> </html>
If connected and Selected database successfully,then the sample output should be like this −
Connected successfully
No comments:
Post a Comment