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" />