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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?php
require_once("koneksi.php");
include 'header.php';
$per_hal = 12;
$jumlah_record = mysqli_query($koneksi, "SELECT * FROM t_buku");
$no = 1;
$jum = mysqli_num_rows($jumlah_record);
$halaman = ceil($jum / $per_hal);
$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $per_hal;
global $sql;
$sql = mysqli_query($koneksi, "SELECT * FROM t_buku ORDER BY isbn ASC LIMIT $start, $per_hal");
?>
<!-- breadcrumbs -->
<div class="breadcrumbs">
<div class="container">
<ol class="breadcrumb breadcrumb1 animated wow slideInLeft" data-wow-delay=".5s">
<?php
if (isset($_SESSION['pengunjung'])) {
echo '
<li><span><i class="fa fa-sign-in" aria-hidden="true"></i><a href="login.php"> Masuk</a></span></li>
<li class="active">Daftar Buku</li> ';
}
else {
echo '
<li><a href="index.php"><span class="glyphicon glyphicon-home" aria-hidden="true"></span>Beranda</a></li>
<li class="active">Daftar Buku</li> ';
}
?>
</ol>
<?php
if(isset($_POST['cari'])){
$cari = $_POST['search'];
$sql = mysqli_query($koneksi, "SELECT * FROM t_buku WHERE judul LIKE '%$cari%' ORDER BY isbn");
}
?>
<div class="w3l_search">
<form action="" method="post">
<input type="search" name="search" placeholder="Cari Judul Buku" required="">
<button type="submit" class="btn btn-default search" aria-label="Left Align" name="cari">
<i class="fa fa-search" aria-hidden="true"> </i>
</button>
<div class="clearfix"></div>
</form>
</div>
</div>
</div>
<!-- //breadcrumbs -->
<!-- gourmet -->
<div class="products">
<div class="container">
<div class="agile_top_brands_grids">
<?php
while($data = mysqli_fetch_array($sql)){
?>
<div class="col-md-3 top_brand_left">
<div class="hover14 column">
<div class="agile_top_brand_left_grid">
<?php
if ($data['keterangan'] != 1) {
echo '<div class="agile_top_brand_left_grid_pos">
<img src="images/offer.png" alt=" " class="img-responsive">
</div>';
}
?>
<div class="agile_top_brand_left_grid1">
<figure>
<div class="snipcart-item block" >
<div class="snipcart-thumb">
<a href="singlebook.php?kd=<?php echo $data['isbn'];?>"><img class="col-md-12" title="Klik Disini" src="<?php echo $data['gambar']; ?>" >
<center><h4><?php echo $data['judul']; ?></h4></center>
<center><h4><?php echo $data['pengarang']; ?></h4></center>
<center><h4><?php echo $data['tahun']; ?></h4></center>
<center><h4>Rp.<?php echo number_format($data['harga'],2,",",".");?></h4></center>
</a>
</div>
<div class="snipcart-details top_brand_home_details">
<a href="function.php?act=add&barang_id=<?php echo $data['isbn']; ?>&ref=checkout.php?kd=<?php echo $data['isbn'];?>" >
<input type="submit" name="simpan" value="Pesan" class="button" /></a>
</div>
</div>
</figure>
</div>
</div>
</div>
<br>
</div>
<?php
}
?>
<div class="clearfix"> </div>
</div>
<nav class="numbering">
<div class="pagination paging">
<?php
for($page=1;$page<=$halaman;$page++){
?>
<li><a href="?page=<?php echo $page ?>"><?php echo $page ?></a></li>
<?php
}
?>
</div>
</nav>
</div>
</div>
<!-- gourmet -->
<?php
include 'footer.php';
?>