Simple-PHP/index.php at master · Elandriil/Simple-PHP · 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
48
49
50
51
52
<?php include_once "header.php"; ?>
<div class="container my-2">
  <div class="row">
    <div class="col-lg-12">
      <img src="image4.jpg" alt="" class="img-fluid">
    </div>
  </div>
</div>

<div class="container my-2 mt-5">
  <div class="row mt-4">
    <div class="col-lg-4 mt-5">
<?php require_once('categories.php'); ?>
    </div>
    <div class="col-lg-8 ">
    <div class="card p-3 mt-5">
      <div class="card-title"><h2>Latest movies</h2></div>
    <div class="card-deck my-2">
<?php
  $result=queryMysql('SELECT * from film order by aasta limit 3');
  if($result->num_rows){
  $row=$result->fetch_array(MYSQLI_ASSOC);
  //foreach($result->fetch_array(MYSQLI_ASSOC)->chunk(3) as $chunk){
      echo '<div class="card-deck my-2">';
    foreach($result as $row){
    echo '<div class="card border-dark">
          <a href="movie.php?id='.$row['id_film'].'">
              <img src="'.$row['poster_link'].'" alt="" class="card-img-top img-fluid">
          </a>
              <div class="card-body">
                <a href="movie.php?id='.$row['id_film'].'">
                  <h4 class="card-title">'.$row['pealkiri'].'</h4>
                  </a>
              </div>
          </div>';
  }
  echo '</div>';
//}
}else{
  echo '0 results';
}
?>


      </div>
    </div>
  </div>
</div>

<?php include_once "footer.php"; ?>