Lesson 6

Language: PHP
<?php
$title = "Database Connection" ;
include ("header.php") ;
//This code adds a connection to the MySQL server
$link = mysql_connect("localhost","alessio","password") ;
 
//This code displays a list of available databases
echo "<h3>The following databases are available:</h3>" ;
$result = mysql_list_dbs() ;
while ($row = mysql_fetch_row($result)) {
echo $row[0], "<p>" ;
}	
//This code selects a db and lists the tables vontained within
echo "<h3>The following tables are in bookstore_db:</h3>" ;
mysql_select_db("bookstore_db") ;
$result = mysql_list_tables("bookstore_db") ;
while ($row = mysql_fetch_row($result)) {
echo $row[0], "<p>" ;	
include ("footer.php") ;
?>

Language: PHP
while ($row = mysql_fetch_row($result)) {
echo $row[0], "<p>" ;

Language: PHP
$result = mysql_list_tables("bookstore_db")

Language: PHP
$result = mysql_query("SELECT * FROM bookstore_db");

Language: PHP
<?php
$title = "Database Connection";
include "header.php";
//This code creates a connection to the MySQL server
$link_id = mysql_connect("localhost", "root", "");
if($link_id) 
 echo "Connected to the MySQL server successfully<br>";
else
  die ("Connection to the MySQL server unsuccessful");
 
//This code displays a list of available databases
echo "<h3>The following databases are available</h3>";
$result = mysql_list_dbs();
while ($row = mysql_fetch_row($result)) {
 echo $row[0], "<p>";
 }
//This code selects a db and lists the tables contained within
echo "<h3>The following tables are in bookstore</h3>";
mysql_select_db("bookstore_db");
//$result = mysql_list_tables("bookstore_db");
$result = mysql_query("SELECT * FROM bookstore_db");
while ($row = mysql_fetch_row($result)) {
 echo $row[0], "<p>";
 }
include "footer.php";
 
?>

Language: PHP
$result = mysql_query("SHOW TABLES FROM bookstore_db");

Language: PHP
$result = mysql_list_tables("bookstore_db") ;