Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
<?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);
?>