PHP Tutorial - PHP mysqli_select_db() Function

Definition

The mysqli_select_db() function changes the default database.

Syntax

PHP mysqli_select_db() Function has the following syntax.

mysqli_select_db(connection,dbname);

Parameter

Parameter	Is Required	Description
connection	Required.	MySQL connection to use
dbname	Required.	Default database to use

Return

It returns TRUE on success. FALSE on failure.

Example

Change the default database


<?php/*from   w  w w .  j  av  a  2 s. c o m*/
    $con=mysqli_connect("localhost","my_user","my_password","my_db");
    if (mysqli_connect_errno($con)){
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
    
    // Change database to "test"
    mysqli_select_db($con,"test");
    
    
    mysqli_close($con);
?>