config.inc.php
<?php
$db _host= "localhost";
$db _user= "root";
$db _pass= "root";
$db _name= "Stu";
$table _name= "Student";
$link =mysql_connect ($db _host, $db _user, $db _pass) or Die ("Cannot connect to server". Mysql_error ());
mysql_select_db ($db _name, $link); Select the appropriate database, select the STU database here
mysql_query ("SET NAMES UTF8"); Sets the specified encoding
$list _name=5;
?>
showdb.php
<!doctype html>
<meta charset= "UTF-8" >
<meta name= "Generator" content= "editplus®" >
<meta name= "Author" content= "" >
<meta name= "Keywords" content= "" >
<meta name= "Description" content= "" >
<title> display databases on the server </title>
<body>
<?php
Require "config.inc.php"; Referencing a configuration file
$db _list=mysql_list_dbs ($link); To display a database on a server
echo "The database on the server has:<br/>";
while ($row =mysql_fetch_object ($db _list)) {//Iterate through the display database
echo $row->database. " ";
}
?>
</body>
To display a database on a server