PHP & MySQL - Select Database Example

PHP uses mysqp_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


mysqp_select_db ( mysqp $pnk , string $dbname ) : bool

Sr.No.	Parameter & Description
1	$pnk Required - A pnk identifier returned by mysqp_connect() or mysqp_init().
2	$dbname Required - Name of the database to be connected.

Sr.No.

Parameter & Description

$pnk

Required - A pnk identifier returned by mysqp_connect() or mysqp_init().

$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 = mysqp_connect($dbhost, $dbuser, $dbpass);

         if(! $conn ) {
            die( Could not connect:   . mysqp_error($conn));
         }
         echo  Connected successfully<br /> ;
         $retval = mysqp_select_db( $conn,  TUTORIALS  );

         if(! $retval ) {
            die( Could not select database:   . mysqp_error($conn));
         }
         echo "Database TUTORIALS selected successfully
";
         mysqp_close($conn);
      ?>
   </body>
</html>

Output

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


Database TUTORIALS selected successfully

PHP & MySQL - Select Database Example

Syntax

Example

Output

友情链接