<?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']);
        echo "<br>";
    }

/* Extension 1 - Output number of rows*/
$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);

?>