lucidtree/featured.php at master · siulca/lucidtree · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
<div class="featuredRow round">
    <div id="featuredTitle">Featured <span class="pageNum"></span></div>
    <div id="player"></div>
    <div class="sliderBtn sliderPrevious"><div class='label'>&#10092;</div></div>
    <div class="sliderBtn sliderNext"><div class='label'>&#10093;</div></div>
    <div class="sliderMask">
        <ul id="featuredList" class="sliderContent">

<?php
    // get random movie to be featured
    //if (!isset($_SESSION['featured'])) {

      //$sql = $mysqli->prepare("SELECT * FROM docs WHERE featured=1 AND visible=1 AND cover<>'' ORDER BY createdOn DESC");
      //$sql->execute();
      $result = $db->getFeaturedMovies();//$sql->get_result();
      //$result = $mysqli->query($sql) or die("Error: ". mysqli_error($mysqli). " with query ". $sql);

      //$_SESSION['featured'] = mysql_fetch_array($result);
    //}

    //$row = $_SESSION['featured'];
    // list of featured movies
    $html = '';

    // display all rows
    while($row = $result->fetch_array())
    {
      // display image if one exists
      $imgURL = "images/covers/thumbs/". $row['cover'];

      if ($row['cover'] && file_exists($imgURL))
      {
        //$imgSize = getimagesize($imgURL);
        //$imgSizeSmall = imageResize($imgSize[0], $imgSize[1], 120);

        $html .= '<li>';
        $html .= '<a id="movie" href="'.formatURL($row['title']) .'" rel="'.$row['id'].'"><span id="coverHolder"><img id="cover" src="'. $imgURL .'" alt="Click to watch '. $row['title'] .' now."></span>';
        $html .= '<br/><span class="">'.$row['title'].'</span></a>';
        $html .= '</li>';
      }
    }

    echo $html;
?>
        </ul>
    </div>
</div>