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
|
<?php
if($_SESSION[admin_web]!="admin") {
permission_fail();
}
$navig['manage_main_data']="แก้ไขข้อมูลหลัก";
navigator($navig);
print "<br>";
bar_header("แก้ไขข้อมูลหลัก"); // Bar_Header
fieldset_top(" ข้อมูลหลัก");
if($p_Submit!="") { $Submit=trim($p_Submit); }
if($p_namess!="") { $namess=trim($p_namess); }
if($p_address!="") { $address=trim($p_address); }
if($p_emailss!="") { $emailss=trim($p_emailss); }
if($p_tel!="") { $tel=trim($p_tel); }
if($p_fax!="") { $fax=trim($p_fax); }
if($p_check_footer!="") { $check_footer=trim($p_check_footer); }
if($p_dates!="") { $dates=trim($p_dates); }
$s="SELECT * FROM cms_main_data ";
$r=mysql_query($s);
$d=mysql_num_fields($r);
if($d==6){
// update field
$xx="ALTER TABLE `cms_main_data` ADD `status` INT( 1 ) NOT NULL DEFAULT '1'";
mysql_query($xx);
}
if($Submit!=""){
$sql="UPDATE `cms_main_data` SET `name_web` = '$namess',`address` = '$address',`tel` = '$tel',`fax` = '$fax',`email` = '$emailss',status='$check_footer' WHERE `cms_main_data`.`id_main_data` ='1'";
mysql_query($sql);
$sql="UPDATE `cms_counter` SET `dates` = '$dates'";
mysql_query($sql);
msg_update_data(); // ข้อความแก้ไขแล้ว
refresh_data("index.php?mod=manage_main_data","2"); // refresh หน้าจอ
}
if($Submit==""){
$sql = "SELECT * FROM cms_main_data";
$result = mysql_query($sql) or die(mysql_error());
$data = mysql_fetch_array($result);
$sqls = "SELECT * FROM cms_counter";
$results = mysql_query($sqls) or die(mysql_error());
$datas = mysql_fetch_array($results);
?>
<br><br>
<form action="index.php?mod=manage_main_data" method="post" name="add" id="add">
<table width='100%' border='0' cellspacing='0' align='center' height='20'>
<tr>
<td valign='top'>
<table width="100%" border="0" align="center" cellspacing='0'>
<tr height='30'>
<td><div align="left"> <img src='coremain/images/marker.gif'> <strong>ชื่อหน่วยงาน</strong></div></td>
<td><div align="left"><input name="namess" type="text" size="50" value="<?echo $data[name_web]?>"></td>
</tr>
<tr height='30'>
<td><div align="left"> <img src='coremain/images/marker.gif'> <strong>ที่อยู่</strong></div></td>
<td><div align="left"><input name="address" type="text" size="50" value="<?echo $data[address]?>"></td>
</tr>
<tr height='30'>
<td><div align="left"> <img src='coremain/images/marker.gif'> <strong>อีเมล์</strong></div></td>
<td><div align="left"><input name="emailss" type="text" size="50" value="<?echo $data[email]?>"></td>
</tr>
<tr height='30'>
<td><div align="left"> <img src='coremain/images/marker.gif'> <strong>โทรศัพท์</strong></div></td>
<td><div align="left"><input name="tel" type="text" size="50" value="<?echo $data[tel]?>"></td>
</tr>
<tr height='30'>
<td><div align="left"> <img src='coremain/images/marker.gif'> <strong>โทรสาร</strong></div></td>
<td><div align="left"><input name="fax" type="text" size="50" value="<?echo $data[fax]?>"></td>
</tr>
<tr height='30'>
<td><div align="left"> <img src='coremain/images/marker.gif'> <strong>วันที่จดโดเมนเนม (ปี-เดือน-วัน)</strong></div></td>
<td><div align="left"><input name="dates" type="text" size="50" value="<?echo $datas[dates]?>"></td>
</tr>
<tr height='30'>
<td><div align="left"> <img src='coremain/images/marker.gif'> <strong>แสดงข้อความนี้ข้างล่าง</strong></div></td>
<td><div align="left">
<?php
if($data[status]=="1"){
echo"<INPUT TYPE='checkbox' NAME='check_footer' checked value=1>";
}else{
echo"<INPUT TYPE='checkbox' NAME='check_footer' value=1>";
}
?>
</td>
</tr>
<tr height='30'>
<td colspan="2"><div align="left"></div><div align="left">
<center><br><input type="submit" name="Submit" value="แก้ไขข้อมูลหลัก" onmouseover="this.style.cursor='hand'"></center>
</td>
</tr>
</table><br>
</td>
</tr>
</table>
</form>
<?php }
fieldset_down();
?>
|