โค้ด: เลือกทั้งหมด
$sql = "SELECT * FROM $data WHERE username LIKE '%" . mysqli_real_escape_string($con, $strKeyword) . "%' OR product LIKE '%" . mysqli_real_escape_string($con, $strKeyword) . "%' ORDER BY id Asc Limit $start,$row";
$result = mysqli_query($con, $sql);
while ($fetch = mysqli_fetch_assoc($result)) {
if(empty($result)){
echo ('ไม่มีข้อมูล');
}else{
?>
<tr align="center">
<td>
<?php echo $fetch['id']; ?>
</td>
<td>
<?php echo $fetch['username']; ?>
</td>
<td>
<?php echo $fetch['product']; ?>
</td>
<td>
<?php echo number_format($fetch['cost'], 2); ?>
</td>
<td>
<?php echo number_format($fetch['profit'], 2); ?>
</td>
<td>
<?php echo number_format($fetch['sale_price'], 2); ?>
</td>
<td>
<?php
echo $fetch['create_at'];
?>
</td>
<td>
<?php include 'ip.php'; ?>
</td>
<td>
<a href="showhome.php?id=<?php echo $fetch['id']; ?>">
<i class="glyphicon glyphicon-new-window"></i>
</a>
</td>
</tr>
<?php
}
}
?>
โค้ด: เลือกทั้งหมด
$sql = "SELECT * FROM $data WHERE username LIKE '%" . mysqli_real_escape_string($con, $strKeyword) . "%' OR product LIKE '%" . mysqli_real_escape_string($con, $strKeyword) . "%' ORDER BY id Asc Limit $start,$row";
//echo $sql; exit();
$result = mysqli_query($con, $sql);
while ($fetch = mysqli_fetch_assoc($result)) {
if(!empty($result)){
echo ('ไม่มีข้อมูล');
}else {
?>
<tr align="center">
<td>
<?php echo $fetch['id']; ?>
</td>
<td>
<?php echo $fetch['username']; ?>
</td>
<td>
<?php echo $fetch['product']; ?>
</td>
<td>
<?php echo number_format($fetch['cost'], 2); ?>
</td>
<td>
<?php echo number_format($fetch['profit'], 2); ?>
</td>
<td>
<?php echo number_format($fetch['sale_price'], 2); ?>
</td>
<td>
<?php
echo $fetch['create_at'];
?>
</td>
<td>
<?php include 'ip.php'; ?>
</td>
<td>
<a href="showhome.php?id=<?php echo $fetch['id']; ?>">
<i class="glyphicon glyphicon-new-window"></i>
</a>
</td>
</tr>
<?php
}
}
?>