public function get_main() { $type = Check::isUserType(); if ($type == 'admin') { $sql = 'SELECT * FROM `films-info` WHERE status = \'OK\' ORDER BY date_add DESC'; } elseif ($type == 'user') { $sql = 'SELECT * FROM `films-info` WHERE permission = \'user\' OR permission = \'all\' AND status = \'OK\' ORDER BY date_add DESC'; } else { $sql = 'SELECT * FROM `films-info` WHERE permission = \'all\' AND status = \'OK\' ORDER BY date_add DESC'; } $result = mysql_query($sql); if ($result) { $content = '<h1 class="video-title">Новинки мирового кинопроката и блокбастеры</h1>'; while ($film = mysql_fetch_object($result)) { $genre = explode(',', $film->genre); $content .= '<div class="video"> <img src="' . $film->image . '"> <div class="video_content"> <p><a class="" href="/film/index/' . $film->href . '">' . $film->name . '</a></p> <p class="video_info">' . $film->year . ', ' . $film->country . ', ' . $genre[0] . '</p> </div> </div>'; } $json['header'] = 'main'; $json['content'] = $content; return json_encode($json); } else { echo mysql_error(); } }
public function get_films() { $type = Check::isUserType(); if ($type == 'admin') { $sql = 'SELECT * FROM `films-info` WHERE status = \'OK\' AND type = \'film\' ORDER BY date_add DESC'; } elseif ($type == 'user') { $sql = 'SELECT * FROM `films-info` WHERE permission = \'user\' OR permission = \'all\' AND type = \'film\' AND status = \'OK\' ORDER BY date_add DESC'; } else { $sql = 'SELECT * FROM `films-info` WHERE permission = \'all\' AND status = \'OK\' AND type = \'film\' ORDER BY date_add DESC'; } $result = mysql_query($sql); if ($result) { return $result; } else { echo mysql_error(); } }