| Server IP : 134.236.49.22 / Your IP : 216.73.216.114 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/Menu pusdu/plutaluang/list หน้าแรกไม่ได้ใช้/ |
Upload File : |
<?php
$ebits = ini_get('error_reporting');
error_reporting($ebits ^ E_NOTICE);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<title>кԹԡѳä PCU ҧ</title>
<style type="text/css">
<!--
.style3 {color: #FF3300}
.style5 {
font-size: 10px;
color: #00FFFF;
}
.style6 {color: #FF0000}
-->
</style>
</head>
<body>
<div align="center">
<p align="left"><a href="logout.php" class="style6" style="text-decoration: none;">Logout ͡ҡк </a></p>
<p><img src="../img/icon/3.jpg" width="104" height="128"><br>
<span class="style3">ԹյѺкŤѳä</span> <span class="style6">PCU ҧ </span><br>
<br>
<?
$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
$objDB = mysql_select_db("clinic");
mysql_query("Set names 'tis620'");
//*** Add Condition ***//
if($_POST["hdnCmd"] == "Add")
{
$strSQL = "INSERT INTO bangsare ";
$strSQL .="(TBNO,name,address,diac,smear,xray,medicine,Effect,comorbid,status,result) ";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["txtAddTBNO"]."','".$_POST["txtAddname"]."' ";
$strSQL .=",'".$_POST["txtAddaddress"]."' ";
$strSQL .=",'".$_POST["txtAdddiac"]."','".$_POST["txtAddsmear"]."' ";
$strSQL .=",'".$_POST["txtAddxray"]."' ";
$strSQL .=",'".$_POST["txtAddmedicine"]."','".$_POST["txtAddEffect"]."' ";
$strSQL .=",'".$_POST["txtAddcomorbid"]."' ";
$strSQL .=",'".$_POST["txtAddstatus"]."','".$_POST["txtAddresult"]."') ";
$objQuery = mysql_query($strSQL);
if(!$objQuery)
{
echo "Error Save [".mysql_error()."]";
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
//*** Update Condition ***//
if($_POST["hdnCmd"] == "Update")
{
$strSQL = "UPDATE bangsare SET ";
$strSQL .="TBNO = '".$_POST["txtEditTBNO"]."' ";
$strSQL .=",name = '".$_POST["txtEditname"]."' ";
$strSQL .=",address = '".$_POST["txtEditaddress"]."' ";
$strSQL .=",diac = '".$_POST["txtEditdiac"]."' ";
$strSQL .=",smear = '".$_POST["txtEditsmear"]."' ";
$strSQL .=",xray = '".$_POST["txtEditxray"]."' ";
$strSQL .=",medicine = '".$_POST["txtEditmedicine"]."' ";
$strSQL .=",Effect = '".$_POST["txtEditEffect"]."' ";
$strSQL .=",comorbid = '".$_POST["txtEditcomorbid"]."' ";
$strSQL .=",status = '".$_POST["txtEditstatus"]."' ";
$strSQL .=",result = '".$_POST["txtEditresult"]."' ";
$strSQL .="WHERE TBNO = '".$_POST["hdnEditTBNO"]."' ";
$objQuery = mysql_query($strSQL);
if(!$objQuery)
{
echo "Error Update [".mysql_error()."]";
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
//*** Delete Condition ***//
if($_GET["Action"] == "Del")
{
$strSQL = "DELETE FROM bangsare ";
$strSQL .="WHERE TBNO = '".$_GET["CusID"]."' ";
$objQuery = mysql_query($strSQL);
if(!$objQuery)
{
echo "Error Delete [".mysql_error()."]";
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM bangsare ORDER BY Id_num ASC";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
</p>
</div>
<form name="frmMain" method="post" action="<?=$_SERVER["PHP_SELF"];?>">
<input type="hidden" name="hdnCmd" value="">
<table width="1203" border="1">
<tr bordercolor="#00CCFF">
<th width="46"> <div align="center">TBNo. </div></th>
<th width="124"> <div align="center"> ʡ</div></th>
<th width="107"> <div align="center"> </div></th>
<th width="107"> <div align="center">ԹԨ </div></th>
<th width="107"> <div align="center">ŵǨ (Smear) </div></th>
<th width="107"> <div align="center">Chest film </div></th>
<th width="107"> <div align="center">ٵ </div></th>
<th width="107"> <div align="center">ҡâҧ§ </div></th>
<th width="107"> <div align="center">ä </div></th>
<th width="107"> <div align="center">ʶҹ </div></th>
<th width="107"> <div align="center">šѡ </div></th>
</tr>
<?
while($objResult = mysql_fetch_array($objQuery))
{
?>
<?
if($objResult["TBNO"] == $_GET["CusID"] and $_GET["Action"] == "Edit")
{
?>
<tr bordercolor="#666666">
<td width="46" height="58"><div align="center">
<input type="text" name="txtEditTBNO" size="10" value="<?=$objResult["TBNO"];?>">
<input type="hidden" name="hdnEditTBNO" size="10" value="<?=$objResult["TBNO"];?>">
</div></td>
<td align="center"><input type="text" name="txtEditname" size="20" value="<?=$objResult["name"];?>"></td>
<td align="left"><textarea name="txtEditaddress" cols="15" rows="8"><?=$objResult["address"];?>
</textarea></td>
<td align="left"><textarea name="txtEditdiac" cols="15" rows="8"><?=$objResult["diac"];?></textarea></td>
<td align="left"><textarea name="txtEditsmear" cols="15" rows="8"><?=$objResult["smear"];?></textarea></td>
<td align="left"><textarea name="txtEditxray" cols="15" rows="8"><?=$objResult["xray"];?></textarea></td>
<td align="left"><textarea name="txtEditmedicine" cols="15" rows="8"><?=$objResult["medicine"];?></textarea></td>
<td align="left"><textarea name="txtEditEffect" cols="15" rows="8"><?=$objResult["Effect"];?></textarea></td>
<td align="left"><textarea name="txtEditcomorbid" cols="15" rows="8"><?=$objResult["comorbid"];?></textarea></td>
<td align="left"><textarea name="txtEditstatus" cols="15" rows="8"><?=$objResult["status"];?></textarea></td>
<td align="left"><textarea name="txtEditresult" cols="15" rows="8"><?=$objResult["result"];?></textarea></td>
</tr>
<?
}
else
{
?>
<tr bordercolor="#666666">
<td align="center"><?=$objResult["TBNO"];?></td>
<td align="left"><input type="text" value="<?=$objResult["name"];?>"></td>
<td align="left"><textarea cols="15" rows="8"><?=$objResult["address"];?></textarea></td>
<td align="left"><textarea cols="15" rows="8"><?=$objResult["diac"];?></textarea></td>
<td align="left"><textarea cols="15" rows="8"><?=$objResult["smear"];?></textarea></td>
<td align="left"><textarea cols="15" rows="8"><?=$objResult["xray"];?></textarea></td>
<td align="left"><textarea cols="15" rows="8"><?=$objResult["medicine"];?></textarea></td>
<td align="left"><textarea cols="15" rows="8"><?=$objResult["Effect"];?></textarea></td>
<td align="left"><textarea cols="15" rows="8"><?=$objResult["comorbid"];?></textarea></td>
<td align="left"><textarea cols="15" rows="8"><?=$objResult["status"];?></textarea></td>
<td align="left"><textarea cols="15" rows="8"><?=$objResult["result"];?></textarea></td>
</tr>
<?
}
?>
<?
}
?>
</table>
</form>
<div align="center">
<p>
<?
mysql_close($objConnect);
?>
<br>
<br>
<br>
<br>
<br>
<br>
<img src="../img/icon/1.jpg" width="82" height="87"><br>
<span class="style5">Powered by pozedorn@gmail.com çҺѵպ .10 </span><br>
<br>
</p>
</div>
</body>
</html>