-
Notifications
You must be signed in to change notification settings - Fork 4
/
search.php
148 lines (135 loc) · 4.82 KB
/
search.php
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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
<?php
include 'header.php';
if (!isset($_GET['q'])) redirect('404');
$limit = 5;
if(isset($_GET['p'])){
$noPage = $mysqli->real_escape_string($_GET['p']);
}
else $noPage = 1;
$offset = ($noPage - 1) * $limit;
$query = $mysqli->real_escape_string($_GET['q']);
$sqlIndex = "SELECT
berita.id_berita,
berita.judul,
berita.gambar,
berita.teks_berita,
berita.tgl_posting,
berita.dilihat,
admin.id_admin,
admin.nama_lengkap,
kategori.id_kategori,
kategori.kategori
FROM
admin
INNER JOIN berita ON admin.id_admin = berita.id_admin
INNER JOIN kategori ON kategori.id_kategori = berita.id_kategori
WHERE
berita.judul LIKE '%".$query."%' OR
kategori.kategori LIKE '%".$query."%'
ORDER BY
berita.tgl_posting DESC
LIMIT ".$mysqli->real_escape_string($offset).",". $limit;
$sql_rec = "SELECT
Count(berita.id_berita) AS jumlah
FROM
berita
INNER JOIN kategori ON berita.id_kategori = kategori.id_kategori
WHERE
berita.judul LIKE '%".$mysqli->real_escape_string($query)."%' OR
kategori.kategori LIKE '%".$mysqli->real_escape_string($query)."%'";
$total_rec = $mysqli->query($sql_rec);
$jumlah = $total_rec->fetch_assoc();
$total_rec_num = $jumlah['jumlah'];
$qryIndex = $mysqli->query($sqlIndex);
$total_page = ceil($total_rec_num/$limit);
?>
<div class="container-fluid">
<div class="row">
<div class="container konten-wrapper">
<div class="panel panel-default">
<div class="panel-body main">
<div class="col-md-8">
<h4>Berita dengan kata kunci "<strong><?php echo $query;?></strong>"</h4>
<?php while ($post_search = $qryIndex->fetch_assoc()) { ?>
<div class="post">
<div class="row post-title">
<div class="col-sm-12">
<a href="<?php echo $base_url."detail.php?id=".$post_search['id_berita']."&judul=".strtolower(str_replace(" ", "-",$post_search['judul'])); ?>">
<h2><?php echo strtoupper($post_search['judul']); ?></h2>
</a>
</div>
</div>
<div class="row post-meta">
<div class="col-sm-3">
<i class="glyphicon glyphicon-user"></i>
<a href="<?php echo $base_url."author.php?id=".$post_search['id_admin']; ?>">
<?php echo $post_search['nama_lengkap']; ?>
</a>
</div>
<div class="col-sm-3">
<i class="glyphicon glyphicon-calendar"></i>
<?php echo $post_search['tgl_posting']; ?>
</div>
<div class="col-sm-3">
<i class="glyphicon glyphicon-eye-open"></i>
<?php echo $post_search['dilihat']; ?>x
</div>
<div class="col-sm-3">
<i class="glyphicon glyphicon-folder-open"></i>
<a href="<?php echo $base_url."kategori.php?id=".$post_search['id_kategori']."&".
strtolower(str_replace(' ', '-',$post_search['kategori'])); ?>">
<em><?php echo $post_search['kategori']; ?></em>
</a>
</div>
</div>
<div class="row post-content">
<div class="col-sm-12 excerpt">
<img src="<?php echo $base_url."images/".$post_search['gambar']; ?>" class="wow fadeIn">
<?php echo substr($post_search['teks_berita'], 0,200); ?>...
<a href="<?php echo $base_url."detail.php?id=".$post_search['id_berita']."&judul=".
strtolower(str_replace(' ', '-', $post_search['judul'])); ?>">
Selengkapnya <i class="glyphicon glyphicon-chevron-right"></i>
</a>
</div>
</div>
</div>
<?php } ?>
</div>
<?php include 'sidebar.php'; ?>
<div class="col-md-12">
<ul class="pagination">
<?php if ($total_rec_num > $limit) { ?>
<?php if ($noPage > 1 ) { ?>
<li>
<a href="<?php echo $base_url."search.php?q=".$_GET['q']."&p=".($noPage-1);?>">
<i class="glyphicon glyphicon-chevron-left"></i>
</a>
</li>
<?php } ?>
<?php for ($page=1; $page <= $total_page ; $page++) { ?>
<?php if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $total_page)) { ?>
<?php
$showPage = $page;
if ($page==$total_page && $noPage <= $total_page-5) echo "<li class='active'><a>...</a></li>";
if ($page == $noPage) echo "<li class='active'><a href='#'>".$page."</a></li> ";
else echo " <li><a href='".$_SERVER['PHP_SELF']."?q=".$_GET['q']."&p=".$page."'>".$page."</a></li> ";
if ($page == 1 && $noPage >=6) echo "<li class='active'><a>...</a></li>";
?>
<?php } ?>
<?php } ?>
<?php if ($noPage < $total_page) { ?>
<li>
<a href="<?php echo $base_url."search.php?q=".$_GET['q']."&p=".($noPage+1); ?>">
<i class="glyphicon glyphicon-chevron-right"></i>
</a>
</li>
<?php } ?>
<?php } ?>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include 'footer.php';