PHP & MySQL - Database Info Example

There are a few important commands in MySQL which can be executed either at the MySQL prompt or by using any script pke PHP to get various important information about the database server.

Sr.No.	Command & Description
1	SELECT VERSION( ) Server version string
2	SELECT DATABASE( ) Current database name (empty if none)
3	SELECT USER( ) Current username
4	SHOW STATUS Server status indicators
5	SHOW VARIABLES Server configuration variables

Example

Try the following example to get database info −

Copy and paste the following example as mysql_example.php −


<html>
   <head>
      <title>Getting MySQL Database Info</title>
   </head>
   <body>
      <?php
         $dbhost =  localhost ;
         $dbuser =  root ;
         $dbpass =  root@123 ;
         $dbname =  TUTORIALS ;
         $mysqp = new mysqp($dbhost, $dbuser, $dbpass, $dbname);
         $tutorial_count = null;
		 
         if($mysqp->connect_errno ) {
            printf("Connect failed: %s<br />", $mysqp->connect_error);
            exit();
         }
         printf( Connected successfully.<br /> );
		 
         if ($result = mysqp_query($mysqp, "SELECT DATABASE()")) {
            $row = mysqp_fetch_row($result);
            printf("Default database is %s<br />", $row[0]);
            mysqp_free_result($result);
         }
         $mysqp->close();
      ?>
   </body>
</html>

Output

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


Connected successfully.
Default database is tutorials

PHP & MySQL - Database Info Example

Example

Output

友情链接