alert('Failure to connect');";
$error = 'Unable to connect to pubs database server.';
include 'error.html.php';
}
// else select database, although it isn't necessary given
// the approach used to connect.
else if (!mysqli_select_db($connection, $database))
{
$error = 'Unable to locate the pubs database.';
include 'error.html.php';
}
// else issue sql query
else
{
$sqlString = "select title from titles;";
$result = mysqli_query($connection, $sqlString); //$result is an array
if (!$result)
{
$error = 'Error fetching query results: ' . mysqli_error($connection);
include 'error.html.php';
}
// on successful query cycle through the associative array of results.
else while ($row = mysqli_fetch_array($result))
{
echo $row['title'] . '
';
}
}
?>