| Server IP : 103.233.193.20 / Your IP : 216.73.216.169 Web Server : Apache/2 System : Linux host1.itclever.com 4.18.0-553.16.1.el8_10.x86_64 #1 SMP Thu Aug 8 17:47:08 UTC 2024 x86_64 User : oriscomadm ( 1120) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,escapeshellarg,escapeshellcmd,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/oriscomadm/domains/oriscom.com/private_html/admin/ |
Upload File : |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ระบบหลังร้าน</title>
<link type="text/css" rel="stylesheet" href="css/common.css">
<link type="text/css" rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="../css/style-pager.css" />
<script language="javascript">
function Confirm(object){
if(confirm('You are Sure DELETE')==true){
return true;
}
return false;
}
</script>
<?php include'../include/class-pager.php'?>
<style>
a{text-decoration:none;}
</style>
</head>
<body id="admin">
<div id="wrapper_admin">
<?php require_once("include/header.php"); ?>
<div id="wrapper_centent">
<div id="manage_button">
<input name="" type="button" class="btn_big" value="เพิ่มรายการ" onclick="window.location='brand_add.php?cid=<?php echo $_GET['cid']?>&sid=<?php echo $_GET['sid']?>'" />
<input name="" type="button" class="btn_big" value="หมวดสินค้า" onclick="window.location='product.php?cid=<?php echo $_GET['cid']?>&sid=<?php echo $_GET['sid']?>'" />
</div>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl">
<tr class="head_tbl">
<td colspan="7">
<form method="get" action="">
ค้นหา <input type="text" name="search" class="input_user" value="<?php echo $_GET['search']?>" /> <input type="submit" value="ค้นหา" />
</form>
</td>
</tr>
<tr class="head_tbl">
<td width="5%">ลำดับ</td>
<td width="15%">รูปภาพ</td>
<td width="60%">Name</td>
<td width="8%">Show/Hide</td>
<td width="12%" style="font-size:11px;">แก้ไข | ลบ</td>
</tr>
<?php
if(empty($_GET['search'])){
$where = "WHERE 1=1";
}else{
$where = "WHERE title_th like '".$_GET['search']."%'";
}
if($_GET['sh']){
mysql_query("UPDATE brand SET shows='".$_GET['sh']."' WHERE id='".$_GET['id']."'");
}
$sql = "SELECT * FROM brand $where";
$sqlquery = mysql_query($sql) or die ("error [".$sql."]");
$Num_Rows = mysql_num_rows($sqlquery);
$Per_Page = 20;
$Page = $_GET["Page"];
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;
}
$sql.= " ORDER BY shows DESC,sort ASC, id ASC LIMIT $Page_Start,$Per_Page";
$rs = mysql_query($sql);
$i=0;
while($arr = mysql_fetch_array($rs)){
$i++;
if($arr['shows']==0){$show='<a href="?sh=1&id='.$arr['id'].'"><font color="#C70003">ซ่อน</font></a>';}
if($arr['shows']==1){$show='<a href="?sh=00&id='.$arr['id'].'"><font color="#00CB30">แสดง</font></a>';}
?>
<tr>
<td><?php echo $i?></td>
<td><img src="<?php echo PATH?>/<?php echo $arr['image']?>" width="100%" /></td>
<td><?php echo $arr['title_th']?></td>
<td><?php echo $show?></td>
<td>
<span class="edit"><a href="brand_edit.php?id=<?php echo $arr['id']?>&cid=<?php echo $_GET['cid']?>&sid=<?php echo $_GET['sid']?>"><img src="images/edit.png" height="24" title="แก้ไข" /></a></span>
<span class="delete"><a href="function.php?ac=brand_del&id=<?php echo $arr['id']?>&cid=<?php echo $_GET['cid']?>&sid=<?php echo $_GET['sid']?>" onclick="return Confirm(this);"><img src="images/delete.png" height="24" title="ลบ" /></a></span>
</td>
</tr>
<?php }?>
</table>
<br />
<div align="right">
<?php
$pages = new Paginator;
$pages->items_total = $Num_Rows;
$pages->mid_range = 10;
$pages->current_page = $Page;
$pages->default_ipp = $Per_Page;
$pages->url_next = $_SERVER["PHP_SELF"]."?id=".$_GET['id']."&Page=";
$pages->paginate();
echo $pages->display_pages()
?>
</div>
</div>
</div>
</body>
</html>