commit | author | age
|
497620
|
1 |
<?php |
RA |
2 |
$link = mysqli_connect($_ENV["DATABASE_SERVICE_NAME"],$_ENV["DATABASE_USER"],$_ENV["DATABASE_PASSWORD"],$_ENV["DATABASE_NAME"]); |
|
3 |
if (!$link) { |
|
4 |
http_response_code (500); |
|
5 |
error_log ("Error: unable to connect to database\n"); |
|
6 |
die(); |
|
7 |
} |
|
8 |
|
|
9 |
$query = "SELECT count(*) FROM quote"; |
|
10 |
$result = $link->query($query); |
|
11 |
if (!$result) { |
|
12 |
http_response_code (500); |
|
13 |
error_log ("SQL error: " . mysqli_error($link) . "\n"); |
|
14 |
die(); |
|
15 |
} |
|
16 |
|
|
17 |
$row = mysqli_fetch_array($result); |
|
18 |
mysqli_free_result($result); |
|
19 |
|
|
20 |
$id = rand(1,$row[0]); |
|
21 |
|
|
22 |
$query = "SELECT msg FROM quote WHERE id = " . $id; |
|
23 |
$result = $link->query($query); |
|
24 |
if (!$result) { |
|
25 |
http_response_code (500); |
|
26 |
error_log ("SQL error: " . mysqli_error($link) . "\n"); |
|
27 |
die(); |
|
28 |
} |
|
29 |
|
|
30 |
$row = mysqli_fetch_array($result); |
|
31 |
mysqli_free_result($result); |
|
32 |
|
|
33 |
print $row[0] . "\n"; |
|
34 |
|
|
35 |
mysqli_close($link); |
|
36 |
?> |