Viewing file:  view.php (6.31 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
include 'index_IncludeAdmin.php';
$_SESSION['page'] = 'view.php';
$Device_SL = " SELECT * FROM Device";
$Device_QR = mysqli_query($con,$Device_SL);
$Device_Row = mysqli_num_rows($Device_QR);
$Loop = 1;
$viewLoop_SL = " ( ";
while ($Device = mysqli_fetch_array($Device_QR)) {
if ($Loop>1) {
$viewLoop_SL.= " OR ";
}
$viewLoop_SL .= " view_browser LIKE '%$Device[DeviceText1]%' " ;
$Loop++;
}
$viewLoop_SL .= " ) ";
$Row = "SELECT * FROM view WHERE ";
$Row .= $viewLoop_SL;
$RowQuery = mysqli_query($con,$Row) or die ("Error Query [".$Row."]");
$Num_Rows = mysqli_num_rows($RowQuery);
$Per_page = 200; // Per page
$page = $_GET["page"];
if (isset($_GET[page])){
$_SESSION[numpage] = $_GET[page];
}
else{
$_SESSION[numpage] = '1';
}
if(!$_GET["page"]){
$page=1;
}
$Prev_page = $page-1;
$Next_page = $page+1;
$page_Start = (($Per_page*$page)-$Per_page);
if($Num_Rows<=$Per_page){
$Num_pages =1;
}
else if(($Num_Rows % $Per_page)==0){
$Num_pages =($Num_Rows/$Per_page) ;
}
else{
$Num_pages =($Num_Rows/$Per_page)+1;
$Num_pages = (int)$Num_pages;
}
$i=$page_Start+1;
$view_SL = $Row." ORDER BY view_id desc LIMIT $page_Start , $Per_page ";
$view_QR = mysqli_query($con,$view_SL);
?>
<!DOCTYPE html>
<html>
<head>
<? include 'index_Head.php'; ?>
</head>
<body>
<? include 'index_Navbar.php'; ?>
<div class="container-fluid">
<div class="row">
<div class="col-md-2" id="main-left">
<div class="row">
<div class="col-md-12">
<? include 'index_AdminMenu.php'; ?>
</div>
</div>
</div>
<div class="col-md-10">
<div class="row">
<div class="col-md-12">
<h3> จัดการ การเข้าชม </h3>
<hr>
</div>
</div>
<? include 'index_Alerts.php'; ?>
<div class="row">
<div class="col-md-12">
<div class="panel panel-default">
<div class="panel-heading">
<div class="row">
<div class="col-md-6">
การเข้าชมทั้งหมด
<span class="badge"> <? echo "$Num_Rows"; ?></span>
</div>
<div class="col-md-6 text-right" style="margin: -5px;">
<a class="btn btn-default" onclick="location.reload()">
รีเฟรชหน้า
</a>
<a class="btn btn-default" onclick="goBack()">
<span class="glyphicon glyphicon-backward">
</span>
กลับ
</a>
<?
if ($Q!=1) {
?>
<a class="btn btn-default" href="view.php">
การเข้าชมทั้งหมด
</a>
<?
}
?>
</div>
</div>
</div>
<div class="panel-body">
<div class="table-responsive">
<table class="table table-striped">
<thead>
<tr>
<th>#</th>
<th> รูป </th>
<th> เข้าดูอสังหาริมทรัพย์ </th>
<th> อุปกรณ์ </th>
<th> วัน </th>
<th> เวลา </th>
<th> รายละเอียด , ลบ </th>
</tr>
</thead>
<tbody class="row_position">
<?
while ($view = mysqli_fetch_array($view_QR)) {
$product_SL = " SELECT * FROM product WHERE product_id = '$view[product_id]'";
$product_QR = mysqli_query($con,$product_SL);
$product = mysqli_fetch_array($product_QR);
?>
<tr id="<?php echo $view['view_id'] ?>">
<td><? echo $i; ?></td>
<td style="width: 70px;">
<a target="_blank" href="product_one.php?product_id=<?php echo $product[product_id]; ?>" >
<div class="img100">
<img src="../Files/product_min/<?php echo $product[product_photo]; ?>" />
</div>
</a>
</td>
<td style="max-width: 350px;" class="hide1">
<?
echo $product[product_name];
?>
</td>
<td title="<?php echo substr($view[view_browser],11); ?>">
<div style="padding: 5px;">
<?
$Device_SL = " SELECT * FROM Device ";
$Device_QR = mysqli_query($con,$Device_SL);
$Device_Row = mysqli_num_rows($Device_QR);
while ($Device = mysqli_fetch_array($Device_QR)) {
$viewLoop_SL = " SELECT * FROM view WHERE (
view_browser LIKE '%$Device[DeviceText1]%' OR
view_browser LIKE '%$Device[DeviceText2]%' OR
view_browser LIKE '%$Device[DeviceText3]%' )
AND (view_id = '$view[view_id]' )";
$viewLoop_QR = mysqli_query($con,$viewLoop_SL);
$viewLoop_Row = mysqli_num_rows($viewLoop_QR);
if ($viewLoop_Row>0) {
?>
<img style="width: 41px;height: 41px;" src="../Files/DevicePhoto/<?php echo $Device[DevicePhoto]; ?>" />
<?
}
}
?>
</div>
</td>
<td>
<? echo displaydate($view[view_date]); ?>
</td>
<td>
<? echo $view[view_time]; ?>
</td>
<td style="min-width: 180px;">
<a target="_blank" href="product_one.php?product_id=<?php echo $product[product_id]; ?>" class="btn btn-primary btn-sm">
<span class="glyphicon glyphicon-zoom-in"></span>
รายละเอียด
</a>
<a href="view_del.php?view_id=<?php echo $view[view_id]; ?>" onclick="return confirm(' ยืนยันการลบข้อมูล ? ')" class="btn btn-danger btn-sm">
<span class="glyphicon glyphicon-trash"></span> ลบ
</a>
</td>
</tr>
<?
$i++;
}
?>
</tbody>
</table>
</div>
</div>
<div class="panel-footer">
<? include 'index_pagenum.php'; ?>
</div>
</div>
</div>
<!-- 12 -->
</div>
<!-- row -->
</div>
<!-- 10 -->
</div>
<!-- row -->
</div>
</body>
</html>
|