<div class="right">
<?
ini_set("register_globals","Off");
ini_set("error_reporting","E_ERROR");
$hostname="localhost";
$username="root";
$password="root";
$DBname="pss";
$conn = mysql_connect($hostname,$username,$password);
if(!$conn)
die("ไม่สามารถติดต่อฐานข้อมูลได้");
mysql_select_db($DBname,$conn) or die("ไม่สามารถเลือกใช้ฐานข้อมูลได้");
mysql_query(" SET NAMES 'tis620'; ");
mysql_query(" SET character_set_results='tis620'; ") ;
$mcopyright = "Copyright © 2008 ";
$conn = mysql_connect($hostname,$username,$password);
if(!$conn)
die("ไม่สามารถติดต่อกับ MySQL ได้");
mysql_select_db($DBname,$conn) or die("ไม่สามารถใช้งานฐานข้อมูลได้");
$file_path3 = "file/".$mupfilepic_name;
if((isset($mupfilepic))&&($mupfilepic != ""))
{
move_uploaded_file($mupfilepic,$file_path3);
//copy($mpicture,"$file_path\\$mpicture_name") or die("ไม่สามารถ Upload File ได้");
}
if($stat_save=="add"){
$mtype_id = $_POST['mtype_id'];
$mhead_dow = $_POST['mhead_dow'];
$sql = " INSERT INTO dow";
$sql .= " ( ";
$sql .= " type_id, ";
$sql .= " head_dow, ";
$sql .= " file_dow) ";
$sql .= " VALUES ( ";
$sql .= " $mtype_id, ";
$sql .= " '$mhead_dow', ";
$sql .= " '$mupfilepic_name'); ";
//print $sql;
mysql_query($sql,$conn) or die("ไม่สามารถบันทึกข้อมูลได้ ADD");
}
if($stat_save=="edit")
{
$mtype_id = $_POST['mtype_id'];
$mhead_dow = $_POST['mhead_dow'];
$sql = " update dow set ";
$sql .= " type_id = $mtype_id, ";
$sql .= " head_dow = '$mhead_dow', ";
if($mupfilepic_name != ""){
$sql .= " file_dow = '$mupfilepic_name' ";
}
$sql .= " where id_dow = $mid_dow ";
mysql_query($sql,$conn) or die("ไม่สามารถบันทึกข้อมูลได้ ");
$stat_save = "add";
}
if(empty($stat_post)){ $stat_post = "add"; }
if(empty($stat_save)){ $stat_save = "add"; }
if($stat_post=="del")
{
$sqldel = "select * from dow where id_dow = $mid_dow ";
$resultdel = mysql_query($sqldel,$conn);
while ($rsdel=mysql_fetch_array($resultdel))
{
if($rsdel[file_dow]!=""){
unlink("file/".$rsdel[file_dow]);
}
}
$sqldel = "delete from dow where id_dow = $mid_dow ";
mysql_query($sqldel,$conn);
}
if($stat_post=="edit")
{
$sqlsel = "select * from dow where id_dow = $mid_dow ";
$resultsel = mysql_query($sqlsel,$conn);
while ($rssel=mysql_fetch_array($resultsel))
{
$vid_dow = $rssel[id_dow];
$vtype_id = $rssel[type_id];
$vhead_dow = $rssel[head_dow];
}
$stat_save = "edit";
}
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>ผู้ดูแลระบบ</title>
<!-- <meta http-equiv="Content-Type" content="text/html; charset=windows-874">
--><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script type="text/javascript" language="JavaScript1.2" src="menu1/stmenu.js"></script>
<script type="text/javascript" language="JavaScript1.2" src="menu2/stmenu.js"></script>
</head>
<body>
<table width="870" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" background="images/content_body.gif"><div align="left">
<table width="847" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="29%"></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td background="images/content_body.gif"><table width="847" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="693" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><br></td>
</tr>
<tr>
<td><br> <form action="upfile.php?stat_save=<?= $stat_save; ?>&mid_dow=<?= $mid_dow; ?>" method="post" enctype="multipart/form-data" name="form2">
<table width="75%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="2%" height="32" background="image/nb_01.gif"> </td>
<? if($stat_save=="edit"){
$mword="แก้ไขข้อมูล";
}else{ $mword="เพิ่มข้อมูล"; } ?>
<td height="32" colspan="2" valign="bottom" bgcolor="#2C783B">
<div align="center" class="style7">
<?= $mword; ?>
</div></td>
<td width="2%" background="image/nb_04.gif"> </td>
</tr>
<tr>
<td background="image/nb_05.gif"> </td>
<td width="24%" valign="top" bgcolor="#BBD1BC"> </td>
<td width="72%" valign="top" bgcolor="#BBD1BC"><div align="right"><span class="style6">
<? if($stat_post=="edit"){ ?>
<a href="upfile.php">[เพิ่มข้อมูล]</a>
<? } ?>
</span> </div></td>
<td background="image/nb_07.gif"> </td>
</tr>
<tr>
<td background="image/nb_05.gif"> </td>
<td valign="top" bgcolor="#EBF5EB"><div align="right"><span class="style12">ประเภท;</span></div></td>
<td valign="top" bgcolor="#EBF5EB"><select name="mtype_id" id="mtype_id">
<option value="1" selected>ประเภทที่1 </option>
<option value="2" >ประเภทที่2</option>
<option value="3">ประเภทที่3</option>
<option value="4">ประเภทที่4</option>
<option value="5">ประเภทที่5</option>
<option value="6">ประเภทที่6</option>
</select></td>
<td background="image/nb_07.gif"> </td>
</tr>
<tr>
<td background="image/nb_05.gif"> </td>
<td valign="top" bgcolor="#BBD1BC"><div align="right" class="style12">หัวข้อ;</div></td>
<td valign="top" bgcolor="#BBD1BC"><div align="left" class="style11 style1">
<input name="mhead_dow" type="text" id="mhead_dow" size="50" maxlength="100">
</div></td>
<td background="image/nb_07.gif"> </td>
</tr>
<tr>
<td background="image/nb_05.gif"> </td>
<td valign="top" bgcolor="#EBF5EB"><div align="right" class="style12">;</div></td>
<td valign="top" bgcolor="#EBF5EB"><div align="left" class="style12"><strong>
</strong></div></td>
<td background="image/nb_07.gif"> </td>
</tr>
<tr>
<td background="image/nb_05.gif"> </td>
<td valign="top" bgcolor="#BBD1BC"><div align="right" class="style12">Upload File : </div></td>
<td valign="top" bgcolor="#BBD1BC"><div align="left" class="style12"><strong>
<input name="mupfilepic" type="file" id="mupfilepic" size="50" maxlength="200">
</strong></div></td>
<td background="image/nb_07.gif"> </td>
</tr>
<tr>
<td height="24"> </td>
<td colspan="2" bgcolor="#EBF5EB"><div align="center">
<input type="submit" name="Submit" value="บันทึก">
<input type="reset" name="Submit2" value="ยกเลิก">
</div></td>
<td> </td>
</tr>
</table></form></td></tr>
</table></td>
</tr>
</table> </td>
</tr>
</table>
</body>
</div>
</html>
Load balance : Server 04
Quote:
