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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
|
<?php
//------------------------------------------------------------------
if($_POST['action']=='update'){
for($i=1;$i<$_POST['Loops'];$i++){
$query="UPDATE IGNORE tbl_email_contact SET names='".$_POST['txtName'][$i]."' , email='".$_POST['txtEmail'][$i]."' WHERE id='".$_POST['hiddenID'][$i]."' ";
mysql_query($query);
}
mysql_query($query);
}
//------------------------------------------------------------------
if($_POST['action']=='delete'){
$query ="DELETE IGNORE FROM tbl_email_contact WHERE id = '".$_POST['key']."' ";
mysql_query($query);
}
//-----------------------------------------------------------------
if($_POST['action']=='add'){
if(($_POST['names'])&&($_POST['email'])){
$query = " INSERT IGNORE INTO `tbl_email_contact` (`id` ,`email` ,`names`) VALUES ( '' , '".$_POST['email']."', '".$_POST['names']."' ) ";
mysql_query($query);
}
}
$query = "SELECT * FROM `tbl_email_contact` ORDER BY id ASC ";
$result =mysql_query($query);
?>
<!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" />
</head>
<body> <form action="<?php $PHP_SELF?>" method="post" name="form1">
<table width="100%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td colspan="2" class="txt10-black"><span class="kbank"><img src="images/PNG/Users.png" alt="" width="32" height="32" hspace="5" vspace="5" align="absmiddle" />Contact email</span></td>
</tr>
<tr>
<td width="3%"> </td>
<td width="97%">
<table width="474" border="0" cellpadding="3" cellspacing="1" class="tableborder_full" background="images/bgcategory01.png">
<tbody>
<tr>
<td
height="25" colspan="2" valign="middle" nowrap="nowrap" class="navbar_selected" background="images/bgcategory01.png"><span class="txt10-black">
<input name="action" type="hidden" id="action" />
<input name="key" type="hidden" id="key" />
<input name="page" type="hidden" id="page" value="<?php echo $page?>" />
<input name="number" type="hidden" value="<?php echo $number+1;?>"/>
<input type="hidden" name="CKEY" />
<input name="editNum" type="hidden" />
<input name="editType" type="hidden" />
</span></td>
</tr>
<tr>
<td height="15" colspan="2" class="table_color1"></td>
</tr>
<tr>
<td width="93" class="cat_desc"><span class="txt10-black">ชื่อ-นามสกุล </span></td>
<td width="364" class="cat_desc"> <span class="txt10-black">
<input name="names" type="text" id="adname" size="40" maxlength="255" />
</span></td>
</tr>
<tr>
<td class="cat_desc"><span class="txt10-black">อีเมล์</span></td>
<td width="364" class="cat_desc"> <span class="txt10-black">
<input name="email" type="text" id="uname" size="40" maxlength="255" />
</span></td>
</tr>
<tr>
<td colspan="2" align="center" class="cat_desc"><span class="txt10-black">
<input type="button" name="Button" value=" เพิ่ม " onclick="document.form1.action.value='add';form1.submit(); " />
</span></td>
</tr>
<tr>
<td colspan="2" align="center" class="table_color1"> </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td height="148"> </td>
<td>
<table width="700" border="0" cellpadding="3" cellspacing="0" class="tableborder_full">
<tbody>
<tr>
<td
height="15" colspan="3" valign="top" nowrap="nowrap" bgcolor="#E6E6E6" class="txt10-brown"><img src="images/Green-mini.png" width="25" height="25" align="absmiddle" />รายชื่อ email contact </td>
</tr>
<?php $n=1; while($data=mysql_fetch_assoc($result)){ ?>
<tr>
<td width="42" align="center" bgcolor="#F7F7F7"><img src="images/black_icon/16x16/mail.png" width="16" height="16" /></td>
<td height="25" bgcolor="#F7F7F7" class="txt10-black"><label for="txtName[]"></label>
<input name="txtName[<?php echo $n?>]" type="text" id="txtName[<?php echo $n?>]" value="<?php echo $data['names']?>" size="60" maxlength="255" />
<input type="hidden" name="hiddenID[<?php echo $n?>]" id="hiddenID[<?php echo $n?>]" value="<?php echo $data['id']?>"/>
<br />
<input name="txtEmail[<?php echo $n?>]" type="text" id="txtEmail[<?php echo $n?>]" value="<?php echo $data['email']?>" size="60" maxlength="255" />
<br />
</td>
<td width="59" align="center" bgcolor="#F7F7F7"><input type="button" name="Submit22" value=" ลบ " onclick=" if(confirm('ต้องการลบ <?php echo $data['typemane']?>')) {form1.key.value='<?php echo $data['id']?>';form1.action.value='delete';form1.submit(); }else { return false;}"/></td>
</tr>
<tr>
<td colspan="3" align="center" bgcolor="#E6E6E6" height="1"></td>
</tr>
<?php $n++; } ?>
<tr>
<td colspan="3" align="center" bgcolor="#F4F4F4" height="1"><input type="button" name="button" id="button" value="แก้ไขข้อมูล" onclick="document.form1.action.value='update';form1.submit(); " /></td>
</tr>
</tbody>
</table>
<br />
<input type="hidden" name="Loops" value="<?php echo $n?>" />
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table> </form>
</body>
</html>
|