Putting it all together

The following example demonstrates an example of PHP connecting to the MySQL server, completing a
query against the data contained in the MySQL server and then closing out the connection to the MySQL
server (the other details of this script will be discussed throughout the remainder of this chapter):

<?php
/* Connect to MySQL server */
$linkID1 = mysql_connect('localhost','root','training') or
die("Could not connect to MySQL server");
/* Query the MySQL Server for Information */
$query = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'world'";
$result = mysql_query($query, $linkID1);
while ($row = mysql_fetch_array($result)) {
print $row[0]."<br>";
}
/* Close the connection to the MySQL server */
mysql_close($linkID1);
?>

Even though it is not necessary to provide the link identifier in the mysql_close() function seeing there is
only one open connect; however, it is best practice to include the link identifier to limit potential problems
when it should be included.