Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form class="sortby_form" action="">
- <div class="sortby" method="POST">
- <select name="sort_by" class="drop-box">
- <option selected hidden <?php if(isset($_POST['sort_by']) && $_POST['sort_by'] == 'option') echo 'selected="selected"'; ?> value="option">Sort by</option>
- <option <?php if(isset($_POST['sort_by']) && $_POST['sort_by'] == 'title') echo 'selected="selected"'; ?> value="title">Title</option>
- <option <?php if(isset($_POST['sort_by']) && $_POST['sort_by'] == 'year') echo 'selected="selected"'; ?> value="year">Year</option>
- <option <?php if(isset($_POST['sort_by']) && $_POST['sort_by'] == 'rating') echo 'selected="selected"'; ?> value="rating">Rating</option>
- </select>
- </div>
- <form>
- <?php
- if (isset($_REQUEST["g"])) {
- $g = $_REQUEST["g"];
- } else {
- $g=0;}
- $q_sortg = "SELECT id_movie, title, image, plot, rating, id_genre, genre
- FROM movie_genre AS mg
- INNER JOIN movie AS m ON mg.movie_id_movie = m.id_movie
- INNER JOIN genre AS g ON mg.genre_id_genre = g.id_genre
- WHERE id_genre = '$g'";
- $r_sortg = mysqli_query($dbc, $q_sortg);
- $i=0;
- echo '<div class="row row-eq-height">';
- while ($row_sortg = mysqli_fetch_array($r_sortg)) {
- if($row_sortg['id_genre'] == $g) {
- echo '<div class="col-sm-3 col-lg-3 col-md-3 column">';
- echo '<div class="thumbnail movie-box">';
- echo '<a href="movies_info.php?m='.$row_sortg['id_movie'].'"><img src="data:image/jpg;base64,'.base64_encode($row_sortg['image']).'" width="250px" height="300px" /></a>';
- echo '<div class="caption">';
- echo "<h4 class="title-subs"><a href='movies_info.php?m=".$row_sortg['id_movie']."'>".$row_sortg['title']."</a></h4>";
- echo "<p class="title-subs">".$row_sortg['plot']."</p>";
- echo "</div>";
- echo '<div class="ratings align-center">';
- echo '<p>';
- $ratings = $row_sortg['rating'];
- $rates = array('$row_sortg' => $ratings);
- foreach ($rates as $r => $value) {
- if($value <= 1.0){
- echo '<p>'.$value.'</p>';
- echo '<i class="fa fa-star-half-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- }
- else if($value <= 2.0){
- echo '<p>'.$value.'</p>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- }
- else if($value <= 3.0){
- echo '<p>'.$value.'</p>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-half-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- }
- else if($value <= 4.0){
- echo '<p>'.$value.'</p>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- }
- else if($value <= 5.0){
- echo '<p>'.$value.'</p>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-half-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- }
- else if($value <= 6.0){
- echo '<p>'.$value.'</p>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- }
- else if($value <= 7.0){
- echo '<p>'.$value.'</p>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-half-o" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- }
- else if($value <= 8.0){
- echo '<p>'.$value.'</p>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
- }
- else if($value <= 9.0){
- echo '<p>'.$value.'</p>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star-half-o" aria-hidden="true"></i>';
- }
- else if($value <= 10.0){
- echo '<p>'.$value.'</p>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- echo '<i class="fa fa-star" aria-hidden="true"></i>';
- }
- }//fecha o foreach
- echo '</p>';
- echo '</div>';
- echo "</div>";
- echo "</div>";
- $i++;
- if ($i%4 == 0){
- echo '</div><div class="row row-eq-height">';
- } //fecha o if
- } //fecha o While
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement