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
|
<?php
$error=0;
if($_POST['action']=='DelteCate'){
//-----------------Count sub cate & product-------------------//
$query="DELETE FROM tbl_home_code WHERE id='".$_POST['EditID']."' ";
mysql_query($query);
$query="DELETE FROM tbl_home_data_code WHERE home_code_id='".$_POST['EditID']."' ";
mysql_query($query);
}
//-------------------------------------------------------------cate_img
if($_POST['action']=='AddPack'){
//-----------------------------------------------------------------------//
$query="INSERT INTO `tbl_home_code` (`id` ,`code_name` ,`code_desc`) VALUES ('' , '".$_POST['code_name']."' , '".$_POST['code_desc']."' ) ";
mysql_query($query);
}
//-------------------------------------------------------------
if($_POST['action']=='EditCate'){
$query="UPDATE tbl_home_code SET `code_name` = '".$_POST['textfield'][$_POST['num']]."' WHERE id = '".$_POST['EditID']."' ";
mysql_query($query);
}
//----------------------------------------
//-------------------------------------------------------------
$query="SELECT * FROM tbl_home_code ORDER BY code_name ASC ";
$result=mysql_query($query);
$uploadfolder="../uploadfile/";
?>
<!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.code_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,bgimg){
if(confirm('ต้องการลบรายการนี้')){
document.form1.EditID.value=ids;
document.form1.action.value = 'DelteCate';
document.form1.backgroundImg.value = bgimg;
document.form1.submit();
}else{
return false;
}
}
//---------------------------------------------------
function sortThis(number, toSort , ids ){
document.form1.number.value=number;
document.form1.toSort.value=toSort;
document.form1.EditID.value=ids;
document.form1.action.value='Sort';
document.form1.submit();
}
</script>
</head>
<body>
<form action="<?php $_SERVER['PHP_SELF']?>" method="post" name="form1" onSubmit="return FormValid();" enctype="multipart/form-data">
<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" />code list</td>
</tr>
<tr>
<td align="left"><table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align="center" bgcolor="#E1E1E1"> </td>
<td width="76%" bgcolor="#E1E1E1"> </td>
<td width="1%" align="center" bgcolor="#E1E1E1"> </td>
<td align="center" bgcolor="#E1E1E1" class="txt10-black">เพิ่มข้อมูลรายละเอียด</td>
</tr>
<?php $n=1;while($data=mysql_fetch_assoc($result)){
?>
<tr onMouseover="this.bgColor='#EEEEEE'"onMouseout="this.bgColor='#FFFFFF'">
<td width="5%" align="center"><img src="images/black_icon/16x16/rnd_br_next.png" width="16" height="16" /></td>
<td><?php echo $data['code_name']?></td>
<td align="right"> </td>
<td width="18%" align="center"><a href="main.php?work=blockListDetail2&CodeID=<?php echo $data['id']?>&codeName=<?php echo $data['code_name']?>"><img src="images/black_icon/16x16/tag.png" width="16" height="16" hspace="5" vspace="5" border="0" /></a></td>
</tr>
<tr>
<td height="1" colspan="4" align="center" bgcolor="#E1E1E1"></td>
</tr>
<?php $n++; }?>
</table></td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>
|