php Mysql

Khóa học miễn phí PHP & MySQL – Select Database nhận dự án làm có lương

Posted on by user

PHP & MySQL – Select Database Example

PHP uses mysqli_select_db function to select the database on which queries are to be performed. This function takes two parameters and returns TRUE on success or FALSE on failure.

Syntax

mysqli_select_db ( mysqli $link , string $dbname ) : bool

Sr.No. Parameter & Description
1

$link

Required – A link identifier returned by mysqli_connect() or mysqli_init().
2

$dbname

Required – Name of the database to be connected.

Example

Try the following example to select a database −

Copy and paste the following example as mysql_example.php −

<html>
   <head>
      <title>Selecting MySQL Database</title>
   </head>
   <body>
      <?php
         $dbhost = ''localhost
         $dbuser = ''root
         $dbpass = ''root@123
         $conn = mysqli_connect($dbhost, $dbuser, $dbpass);

         if(! $conn ) {
            die(''Could not connect: '' . mysqli_error($conn));
         }
         echo ''Connected successfully<br />
         $retval = mysqli_select_db( $conn, ''TUTORIALS'' );

         if(! $retval ) {
            die(''Could not select database: '' . mysqli_error($conn));
         }
         echo "Database TUTORIALS selected successfullyn";
         mysqli_close($conn);
      ?>
   </body>
</html>

Output

Access the mysql_example.php deployed on apache web server and verify the output.

Database TUTORIALS selected successfully

Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: Khóa học lập trình nhận lương tại trung tâm Toidayhoc

user