Newer
Older
<?php
/* connect to the database */
$link = mysqli_connect(
'localhost',
'ma302ap',
'anspj597',
'ma302ap_recordstore'
);
/* check connection succeeded */
if (mysqli_connect_errno()) {
exit(mysqli_connect_error());
}
$sql1 = "SELECT title, genre FROM record WHERE year = 2014";
$result1 = mysqli_query($link, $sql1);
if ($result1 === false) {
echo( "No records found." );
echo mysqli_error($link);
} else {
echo( "<h1>Some records were found!</h1><br>" );
/* fetch associative array */
while ($row = mysqli_fetch_assoc($result1)) {
echo($row['title']." ".$row['genre']);
$sql2 = "SELECT * FROM record";
$result2 = mysqli_query($link, $sql2);
$num_rows = mysqli_num_rows($result2);
echo ($num_rows. " rows");
/* free result set */
mysqli_free_result($result1);
mysqli_free_result($result2);
}
mysqli_close($link);
?>