Advertisement
Guest User

Untitled

a guest
May 31st, 2016
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.93 KB | None | 0 0
  1. <form class="sortby_form" action="">
  2. <div class="sortby" method="POST">
  3. <select name="sort_by" class="drop-box">
  4. <option selected hidden <?php if(isset($_POST['sort_by']) && $_POST['sort_by'] == 'option') echo 'selected="selected"'; ?> value="option">Sort by</option>
  5. <option <?php if(isset($_POST['sort_by']) && $_POST['sort_by'] == 'title') echo 'selected="selected"'; ?> value="title">Title</option>
  6. <option <?php if(isset($_POST['sort_by']) && $_POST['sort_by'] == 'year') echo 'selected="selected"'; ?> value="year">Year</option>
  7. <option <?php if(isset($_POST['sort_by']) && $_POST['sort_by'] == 'rating') echo 'selected="selected"'; ?> value="rating">Rating</option>
  8. </select>
  9. </div>
  10. <form>
  11.  
  12. <?php
  13. if (isset($_REQUEST["g"])) {
  14. $g = $_REQUEST["g"];
  15. } else {
  16. $g=0;}
  17.  
  18. $q_sortg = "SELECT id_movie, title, image, plot, rating, id_genre, genre
  19. FROM movie_genre AS mg
  20. INNER JOIN movie AS m ON mg.movie_id_movie = m.id_movie
  21. INNER JOIN genre AS g ON mg.genre_id_genre = g.id_genre
  22. WHERE id_genre = '$g'";
  23. $r_sortg = mysqli_query($dbc, $q_sortg);
  24.  
  25. $i=0;
  26. echo '<div class="row row-eq-height">';
  27.  
  28. while ($row_sortg = mysqli_fetch_array($r_sortg)) {
  29.  
  30. if($row_sortg['id_genre'] == $g) {
  31.  
  32. echo '<div class="col-sm-3 col-lg-3 col-md-3 column">';
  33.  
  34. echo '<div class="thumbnail movie-box">';
  35. 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>';
  36. echo '<div class="caption">';
  37. echo "<h4 class="title-subs"><a href='movies_info.php?m=".$row_sortg['id_movie']."'>".$row_sortg['title']."</a></h4>";
  38. echo "<p class="title-subs">".$row_sortg['plot']."</p>";
  39. echo "</div>";
  40. echo '<div class="ratings align-center">';
  41. echo '<p>';
  42. $ratings = $row_sortg['rating'];
  43.  
  44. $rates = array('$row_sortg' => $ratings);
  45.  
  46. foreach ($rates as $r => $value) {
  47. if($value <= 1.0){
  48. echo '<p>'.$value.'</p>';
  49. echo '<i class="fa fa-star-half-o" aria-hidden="true"></i>';
  50. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  51. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  52. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  53. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  54. }
  55. else if($value <= 2.0){
  56. echo '<p>'.$value.'</p>';
  57. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  58. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  59. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  60. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  61. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  62. }
  63. else if($value <= 3.0){
  64. echo '<p>'.$value.'</p>';
  65. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  66. echo '<i class="fa fa-star-half-o" aria-hidden="true"></i>';
  67. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  68. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  69. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  70. }
  71. else if($value <= 4.0){
  72. echo '<p>'.$value.'</p>';
  73. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  74. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  75. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  76. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  77. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  78. }
  79. else if($value <= 5.0){
  80. echo '<p>'.$value.'</p>';
  81. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  82. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  83. echo '<i class="fa fa-star-half-o" aria-hidden="true"></i>';
  84. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  85. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  86. }
  87. else if($value <= 6.0){
  88. echo '<p>'.$value.'</p>';
  89. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  90. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  91. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  92. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  93. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  94. }
  95. else if($value <= 7.0){
  96. echo '<p>'.$value.'</p>';
  97. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  98. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  99. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  100. echo '<i class="fa fa-star-half-o" aria-hidden="true"></i>';
  101. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  102. }
  103. else if($value <= 8.0){
  104. echo '<p>'.$value.'</p>';
  105. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  106. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  107. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  108. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  109. echo '<i class="fa fa-star-o" aria-hidden="true"></i>';
  110. }
  111. else if($value <= 9.0){
  112. echo '<p>'.$value.'</p>';
  113. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  114. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  115. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  116. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  117. echo '<i class="fa fa-star-half-o" aria-hidden="true"></i>';
  118. }
  119. else if($value <= 10.0){
  120. echo '<p>'.$value.'</p>';
  121. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  122. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  123. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  124. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  125. echo '<i class="fa fa-star" aria-hidden="true"></i>';
  126. }
  127. }//fecha o foreach
  128. echo '</p>';
  129. echo '</div>';
  130. echo "</div>";
  131. echo "</div>";
  132.  
  133.  
  134. $i++;
  135. if ($i%4 == 0){
  136. echo '</div><div class="row row-eq-height">';
  137. } //fecha o if
  138.  
  139. } //fecha o While
  140. }
  141.  
  142. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement