01.
<?php
02.
$con
= mysqli_connect(
'localhost'
,
''
,
''
,
''
);
03.
mysqli_query(
"SET NAMES UTF8"
);
04.
05.
06.
$perpage
= 12;
07.
if
(isset(
$_GET
[
'page'
])) {
08.
$page
=
$_GET
[
'page'
];
09.
}
else
{
10.
$page
= 1;
11.
}
12.
13.
$start
= (
$page
- 1) *
$perpage
;
14.
15.
16.
if
(isset(
$_POST
[
'filter'
]))
17.
{
18.
$filter
=
$_POST
[
'filter'
];
19.
$result
= mysqli_query(
$con
,
"SELECT * FROM products where Product like '%$filter%' or Description like '%$filter%' or Category like '%$filter%' LIMIT "
.
$start
.
","
.
$perpage
);
20.
21.
}
22.
else
23.
{
24.
$result
= mysqli_query(
$con
,
"SELECT * FROM products ORDER BY ID DESC LIMIT "
.
$start
.
","
.
$perpage
);
25.
}
26.
27.
if
(
$result
){
28.
29.
while
(
$row
=mysqli_fetch_array(
$result
)){
30.
31.
$prodID
=
$row
[
"ID"
];
32.
echo
'<ul class="col-sm-4">'
;
33.
echo
'<div
class
=
"product-image-wrapper"
>
34.
<div
class
=
"single-products"
>
35.
<div
class
=
"productinfo text-center"
>
36.
<a href=
"product-details.php?prodid='.$prodID.'"
rel=
"bookmark"
title=
"'.$row['Product'].'"
><img src=
"reservation/img/products/'.$row['imgUrl'].'"
alt=
"'.$row['Product'].'"
title=
"'.$row['Product'].'"
width=
"219"
height=
"150"
/></a>
37.
</a>
38.
39.
<h5><a href=
"product-details.php?prodid='.$prodID.'"
rel=
"bookmark"
title=
"'.$row['Product'].'"
>
'.$row['
Product
'].'
</a></h5>
40.
ราคา<b>
'.$row['
Price
'].'
</b>บาท
41.
<p>หมวด : <a href=
"category.php?filter='.$row['Category'].'"
>
'.$row['
Category
'].'
</p></a>
42.
43.
<a href=
"product-details.php?prodid='.$prodID.'"
class
=
"btn btn-default add-to-cart"
><i
class
=
"fa fa-shopping-cart"
></i><b> ดูรายละเอียด </b></a>
44.
</div>';
45.
echo
'</ul>'
;
46.
}
47.
}
48.
?>
49.
<?php
50.
$sql2
=
"select * from products"
;
51.
$query2
= mysqli_query(
$con
,
$sql2
);
52.
$total_record
= mysqli_num_rows(
$query2
);
53.
$total_page
=
ceil
(
$total_record
/
$perpage
);
54.
55.
if
(
$page
>=2){
56.
$Ppage
= (
$page
-1);
57.
?>
58.
59.
<a href=
"i2.php?page=<?php echo $Ppage ?>"
><span><<<Previous</span></a>
60.
61.
<?php
62.
}
63.
64.
for
(
$i
=1;
$i
<=
$total_page
;
$i
++){
65.
66.
$numPage
=
$page
==
$i
?
"["
.
$i
.
"]"
:
$i
;
67.
68.
?>
69.
70.
<a href=
"i2.php?page=<?php echo $i; ?>"
><?php
echo
$numPage
.
" "
; ?></a>
71.
72.
<?php }
73.
74.
if
(
$page
<
$total_page
){
75.
$Npage
= (
$page
+1);
76.
?>
77.
78.
<a href=
"i2.php?page=<?php echo $Npage;?>"
> <span>Next>>></span></a>
79.
80.
<?php } ?>
81.
<!--php ends here-->
82.
</div>
83.
</div>
84.
</div>
85.
</div>
86.
</div>
87.
</section>
88.
89.
<?php
include
(
'include/home/footer.php'
); ?>