prepare("SELECT video_name, video_code FROM videos WHERE video_driver = ? AND video_title = ?"); $title_stmt->bind_param('is',$driver, $params[2]); $title_stmt->execute(); $title_stmt->store_result(); $title_stmt->bind_result($video_name, $video_code); if ($title_stmt->num_rows > 0) { $title_stmt->fetch(); $title .= ' - '.$video_name; $description = $video_name; $image = 'http://img.youtube.com/vi/'.$video_code.'/mqdefault.jpg'; } } ?>
prepare("SELECT driver_id FROM drivers WHERE driver_title = ?"); $content_stmt->bind_param('s',$params[0]); $content_stmt->execute(); $content_stmt->store_result(); $content_stmt->bind_result($driver_id); // Ha van ilyen oldal if ($content_stmt->num_rows > 0) { if (!empty($params[1])) { switch ($params[1]) { case 'fuvarok': include_once('pages/freightPage.php'); break; case 'videok': include_once('pages/videosPage.php'); break; case 'receptek': include_once('pages/cookingPage.php'); break; case 'turak': include_once('pages/hikingPage.php'); break; case 'megemlitesek': include_once('pages/mentionsPage.php'); break; case 'leirasok': include_once('pages/descPage.php'); break; case 'oktato-videok': include_once('pages/instructionPage.php'); break; default: include_once('pages/errorPage.php'); } } else { include_once('pages/contentPage.php'); } // Ha nincs ilyen oldal } else { $fn = 'pages/'.$params[0]; if (!empty($params[1])) $fn = 'pages/'.$params[1]; $fn .= 'Page.php'; if (file_exists($fn)) include_once($fn); else include_once('pages/errorPage.php'); } include_once('pages/footer.php'); ?>