| Server IP : 182.53.201.61 / Your IP : 216.73.217.175 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/er/admin/ |
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>ระบบคลินิกวัณโรค บางเสร่</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">ยินดีต้อนรับเข้าสู่ระบบข้อมูลคนไข้วัณโรค 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 .="(Id_num,TBNO,name,address,diac,smear,xray,medicine,Effect,comorbid,status,result) ";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["txtAddId_num"]."','".$_POST["txtAddTBNO"]."' ";
$strSQL .=",'".$_POST["txtAddname"]."','".$_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="800" border="1">
<tr bordercolor="#00CCFF">
<th width="5"> <div align="center">TBNO </div></th>
<th width="17"> <div align="center">ชื่อ นามสกุล</div></th>
<th width="15"> <div align="center">ที่อยู่ </div></th>
<th width="15"> <div align="center">วินิจฉัย </div></th>
<th width="15"> <div align="center">ผลตรวจเสมหะ (Smear) </div></th>
<th width="15"> <div align="center">Chest film </div></th>
<th width="15"> <div align="center">สูตรยา </div></th>
<th width="15"> <div align="center">อาการข้างเคียง </div></th>
<th width="15"> <div align="center">โรคร่วม </div></th>
<th width="15"> <div align="center">สถานะ </div></th>
<th width="15"> <div align="center">ผลการรักษา </div></th>
<th width="30"> <div align="center">Edit </div></th>
<th width="30"> <div align="center">Delete </div></th>
</tr>
<?
while($objResult = mysql_fetch_array($objQuery))
{
?>
<?
if($objResult["TBNO"] == $_GET["CusID"] and $_GET["Action"] == "Edit")
{
?>
<tr bordercolor="#666666">
<td width="5" height="58">
<div align="center">
<input type="text" name="txtEditTBNO" size="5" value="<?=$objResult["TBNO"];?>">
<input type="hidden" name="hdnEditTBNO" size="5" value="<?=$objResult["TBNO"];?>">
</div></td>
<td align="center"><div align="center">
<input type="text" name="txtEditname" size="15" value="<?=$objResult["name"];?>">
</div></td>
<td align="left"><div align="center">
<textarea name="txtEditaddress" cols="15" rows="8"><?=$objResult["address"];?>
</textarea>
</div></td>
<td align="left"><div align="center">
<textarea name="txtEditdiac" cols="15" rows="8"><?=$objResult["diac"];?>
</textarea>
</div></td>
<td align="left"><div align="center">
<textarea name="txtEditsmear" cols="15" rows="8"><?=$objResult["smear"];?>
</textarea>
</div></td>
<td align="left"><div align="center">
<textarea name="txtEditxray" cols="15" rows="8"><?=$objResult["xray"];?>
</textarea>
</div></td>
<td align="left"><div align="center">
<textarea name="txtEditmedicine" cols="15" rows="8"><?=$objResult["medicine"];?>
</textarea>
</div></td>
<td align="left"><div align="center">
<textarea name="txtEditEffect" cols="15" rows="8"><?=$objResult["Effect"];?>
</textarea>
</div></td>
<td align="left"><div align="center">
<textarea name="txtEditcomorbid" cols="15" rows="8"><?=$objResult["comorbid"];?>
</textarea>
</div></td>
<td align="left"><div align="center">
<textarea name="txtEditstatus" cols="15" rows="8"><?=$objResult["status"];?>
</textarea>
</div></td>
<td align="left"><div align="center">
<textarea name="txtEditresult" cols="15" rows="8"><?=$objResult["result"];?>
</textarea>
</div></td>
<td colspan="2" align="right">
<div align="center">
<input name="btnAdd" type="button" id="btnUpdate" value="Update" OnClick="frmMain.hdnCmd.value='Update';frmMain.submit();">
<input name="btnAdd" type="button" id="btnCancel" value="Cancel" OnClick="window.location='<?=$_SERVER["PHP_SELF"];?>';">
</div></td>
</tr>
<?
}
else
{
?>
<tr bordercolor="#666666">
<td align="center"><?=$objResult["TBNO"];?></td>
<td align="center"><?=$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>
<td align="center"><a href="<?=$_SERVER["PHP_SELF"];?>?Action=Edit&CusID=<?=$objResult["TBNO"];?>">Edit</a></td>
<td align="center"><a href="JavaScript:if(confirm('Confirm Delete?')==true){window.location='<?=$_SERVER["PHP_SELF"];?>?Action=Del&CusID=<?=$objResult["TBNO"];?>';}">Delete</a></td>
</tr>
<?
}
?>
<?
}
?>
<tr bordercolor="#666666">
<td width="5"><div align="center"><input type="text" name="txtAddTBNO" size="5"></div></td>
<td><input type="text" name="txtAddname" size="15"></td>
<td align="right"><textarea name="txtAddaddress" cols="15" rows="8"></textarea></td>
<td align="right"><textarea name="txtAdddiac" cols="15" rows="8"></textarea></td>
<td align="right"><textarea name="txtAddsmear" cols="15" rows="8"></textarea></td>
<td align="right"><textarea name="txtAddxray" cols="15" rows="8"></textarea></td>
<td align="right"><textarea name="txtAddmedicine" cols="15" rows="8"></textarea></td>
<td align="right"><textarea name="txtAddEffect" cols="15" rows="8"></textarea></td>
<td align="right"><textarea name="txtAddcomorbid" cols="15" rows="8"></textarea></td>
<td align="right"><textarea name="txtAddstatus" cols="15" rows="8"></textarea></td>
<td align="right"><textarea name="txtAddresult" cols="15" rows="8"></textarea></td>
<td colspan="2" align="right"><div align="center">
<input name="btnAdd" type="button" id="btnAdd" value="Add" OnClick="frmMain.hdnCmd.value='Add';frmMain.submit();">
</div></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>