<?php

 include("PDOdatabase.php");

 

 Class data_laptop {

 public $id_laptop;

 public $tipe_laptop;

 public $processor;

 public $kec_processor;

 public $vga;

 public $ukuran_vga;

 public $memori;

 public $harddisk;

 public $harga;

 public $fitur;

 public $layar;

 public $id_kategori;

 

 public function __construct($id_laptop, $tipe_laptop, $processor, $kec_processor, $vga, $ukuran_vga, $memori, $harddisk, $harga, $fitur, $layar, $id_kategori) {

 $this -> id_laptop = $id_laptop;

 $this -> tipe_laptop = $tipe_laptop;

 $this -> processor = $processor;

 $this -> kec_processor = $kec_processor;

 $this -> vga = $vga;

 $this -> ukuran_vga = $ukuran_vga;

 $this -> memori = $memori;

 $this -> harddisk = $harddisk;

 $this -> harga = $harga;

 $this -> fitur = $fitur;

 $this -> layar = $layar;

 $this -> id_kategori = $id_kategori;

 }

 

 public static function fetchAll($db, $limit = 9999999, $offset = 0) {

 $sql = "SELECT * FROM `data_laptop` ORDER BY `id_laptop` LIMIT $offset,$limit ";

 $query = $db -> prepare($sql);

 $query -> execute();

 $daftar = array();

 foreach ($query->fetchAll(PDO::FETCH_ASSOC) as $key => $value) {

 $daftar[] = new data_laptop($value['id_laptop'], $value['tipe_laptop'], $value['processor'], $value['kec_processor'], $value['vga'], $value['ukuran_vga'], $value['memori'], $value['harddisk'], $value['harga'], $value['fitur'], $value['layar'], $value['id_kategori']);

 }

 return $daftar;

 }

 }

 

 Class kategori {

 public $id_kategori;

 public $nama;

 

 public function __construct($id_kategori, $nama) {

 $this -> id_kategori = $id_kategori;

 $this -> nama = $nama;

 }

 

 public static function getKategori($db, $limit = 9999999, $offset = 0) {

 $sql = "SELECT `nama` FROM `kategori`,`data_laptop` WHERE kategori.id_kat = data_laptop.id_kategori ";

 $query = $db -> prepare($sql);

 $query -> execute();

 $kategori = $query->fetch();

 return $kategori;

 }

 }

?>



<table style="text-align: left" style='border:1px; #ddd; solid; border-collapse:collapse' border=1>

 <thead>

 <tr>

 <th> No </th>

 <th> Tipe Laptop </th>

 <th> Kategori </th>

 <th> Processor </th>

 <th> Kecepatan Processor </th>

 <th> Graphic Card (VGA) </th>

 <th> Ukuran VGA </th>

 <th> Memori (RAM) </th>

 <th> Hard Disk </th>

 <th> Fitur </th>

 <th> Layar </th>

 <th> Harga </th>

 </tr>

 </thead>

 <tbody>

 <?php

 

 foreach (data_laptop::fetchAll($db) as $key => $value) {

 $kat = kategori::getKategori($db); 

 ?>

 <tr>

 <td><?=$key+1?></td>

 <td><?=$value -> tipe_laptop ?></td>

 <td><?=$value -> $kat ?></td> 

 <td><?=$value -> processor ?></td>

 <td><?=$value -> kec_processor ?></td>

 <td><?=$value -> vga ?></td>

 <td><?=$value -> ukuran_vga ?></td>

 <td><?=$value -> memori ?></td>

 <td><?=$value -> harddisk ?></td>

 <td><?=$value -> fitur ?></td>

 <td><?=$value -> layar ?></td>

 <td><?=$value -> harga ?></td>

 </tr>

 <?php

 }

 ?>

 </tbody>

</table>