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
|
<?php
$thisFile= basename($PHP_SELF);
$rowPerPage=20;
if((!$_GET['page'])||($_GET['page']==1)){
$_GET['page']=1;
$startRow=0;
}else{
$startRow=($_GET['page']-1)*$rowPerPage;
}
if($_POST['action']=='DELETE'){
$query="DELETE FROM tbl_customer WHERE id='".$_POST['EditID']."' ";
mysql_query($query);
}
$query="SELECT * FROM tbl_customer ORDER BY id ";
$result=mysql_query($query);
$queryLimit = $query." LIMIT $startRow, $rowPerPage ";
$result=mysql_query($queryLimit);
$result2=mysql_query($query);
$xrow=mysql_num_rows($result2);
$totalPage=ceil($xrow/$rowPerPage);
?>
<!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>Untitled Document</title>
<link href="style.css" rel="stylesheet" type="text/css" />
<script language="javascript">
//--------------------------------
function FormValid(){
if(document.form1.cate_name.value==''){
alert("กรุณาใส่ชื่อ หมวดสินค้า ");
return false;
}else {
document.form1.action.value = 'AddPack';
}
}
//---------------------------------------------------
function EditThis(ids,nums){
document.form1.EditID.value=ids;
document.form1.num.value=nums;
document.form1.action.value = 'EditCate';
document.form1.submit();
}
//---------------------------------------------------
function DeleteThis(ids,img){
if(confirm('ต้องการลบรายการนี้')){
document.form1.EditID.value=ids;
document.form1.action.value = 'DELETE';
document.form1.img.value = img;
document.form1.submit();
}else{
return false;
}
}
</script>
</head>
<body>
<form action="<?php $_SERVER['PHP_SELF']?>" method="post" name="form1" onSubmit="return FormValid();">
<table width="100%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td class="txt10-black"><table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr class="txt10-black">
<td width="100%" height="30" align="left" bgcolor="#FFFFFF" class="txt10-black" ><img src="images/black_icon/16x16/notepad_2.png" width="16" height="16" hspace="5" align="absmiddle" />รายชื่อลูกค้า
<input type="hidden" name="action" id="action" />
<input type="hidden" name="EditID" id="EditID" />
<input type="hidden" name="img" id="img" /></td>
</tr>
<tr>
<td align="left" class="txt10-black"><table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align="center" bgcolor="#E1E1E1"> </td>
<td bgcolor="#E1E1E1"> </td>
<td width="66" align="center" bgcolor="#E1E1E1">รายละเอียด</td>
<td width="39" align="center" bgcolor="#E1E1E1">ลบ</td>
</tr>
<?php $n=1;while($data=mysql_fetch_assoc($result)){ ?>
<tr>
<td width="16" align="center"><img src="images/black_icon/16x16/rnd_br_next.png" width="16" height="16" /></td>
<td><?php echo $data['cust_name']?> </td>
<td align="center">
<a href="main.php?work=memberdetail¤tID=<?php echo $data['id']?>"><img src="images/black_icon/16x16/zoom.png" width="16" height="16" border="0" /></a>
</td>
<td align="center">
<a href="javascript:void(0)" onclick="DeleteThis('<?php echo $data['id']?>','<?php echo $data['cust_name']?>')" title="ลบ รายการนี้">
<img src="images/black_icon/16x16/delete.png" width="16" height="16" border="0" /></a></td>
</tr>
<tr>
<td height="1" colspan="4" align="center" bgcolor="#E1E1E1"></td>
</tr>
<?php $n++; }?>
</table>
<br />
Page :
<?php
for($i=1;$i<=$totalPage;$i++){ ?>
<a href="main.php?work=customerList&page=<?php echo $i?>" >
<?php if($i==$_GET['page'])echo "<b><font size='+1'> ";
echo $i." ";
if($i==$_GET['page'])echo "</font></b>";
?>
</a>
<?php } ?></td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>
|