function randomReview()
{
$db = new Database(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
while (true) {
// First we select a random film from the first 1000
$randIndex = rand(1, 1000);
$db->connect();
$result = $db->query("SELECT * FROM films WHERE position = " . $randIndex);
$film = $db->fetch_array_assoc($result);
//if (!$film) continue;
// Let's get film's bad review
$db->connect();
$result = $db->query("SELECT * FROM reviews WHERE id = '" . $film['id'] . "' AND rating <= 4 LIMIT 0, 1");
$review = $db->fetch_array_assoc($result);
if ($review) {
echo $film['name'] . "(" . $film['rating'] . ")" . PHP_EOL . PHP_EOL;
echo $review['title'] . PHP_EOL;
echo $review['review'] . PHP_EOL;
break;
}
}
}
<?php
include_once "json/Database.php";
$trackid = $_GET['id'];
$db = new Database("pdb10.runhosting.com", "998905_mx", "mxmichigan1234", "998905_mx");
$q = "SELECT * FROM tracks WHERE id = " . $trackid;
$r = $db->query($q);
$track = $db->fetch_array_assoc($r);
$q = "SELECT * FROM schedule WHERE trackid = " . $trackid;
$r = $db->query($q);
$jsonschedule = json_decode($db->fetch_all_json($r));
$schedule = $jsonschedule->DATA;
echo print_r($track);
echo print_r($schedule);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Track</title>
<!-- Bootstrap core CSS -->
<link href="../css/bootstrap.min.css" rel="stylesheet" />
<link href="../css/site.css" rel="stylesheet" />
<link href="../css/font-awesome.min.css" rel="stylesheet" />
<link rel="stylesheet" href="../css/pikaday.css">
<link rel="stylesheet" href="../css/jquery.timepicker.css" />
