เรื่อง การบันทึกลงฐานข้อมูลแบบ Array อยากถามเรื่องการส่งค่าคือตอนนี้ ส่งค่าไปค่าเดียวอะคะ ทำยังไง ถึงจะ Get ไปสองค่าได้ แล้วบันทึกแบบลงฐานข้อมูลแบบ Array ได้คะ
มีปัญหาในเรื่องของการบันทึกข้อมูลแบบ Array คะ จากรูปเป็นหน้าฟอร์มที่ได้จากการค้นหามาคะ Tag PHP, Ajax
ประวัติการแก้ไข
Date :
2010-11-10 23:42:25By :
katae_kapoloView :
1362Reply :
6
อธิบายใหม่ครับ รูปก็ดำมืดหมด
Date :
2010-11-11 02:19:49By :
PlaKriM
Date :
2010-11-11 18:17:32By :
katae_kapolo
มีปัญหาในเรื่องของการบันทึกข้อมูลแบบ Array คะ จากรูปเป็นหน้าฟอร์มที่ได้จากการค้นหามาคะ
ประวัติการแก้ไข
Date :
2010-11-11 18:24:19By :
katae_kapolo
ไฟลด์นี้สำหรับฟอร์มคะCode (PHP) <? include ('chksession3.php'); ?>
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<script type="text/javascript">
function showUser(str)
{
if (str=="")
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","aj_showptproc_pt.php?q="+str,true);
xmlhttp.send();
}
</script>
<title>PT System</title>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-image: url(image/bgb01.gif);
}
.style2 {font-size: 14px}
.style3 {color: #333333}
.style4 {font-size: 14px; color: #333333; }
.style6 {font-size: 14px; color: #666666; }
-->
</style></head>
<body>
<table width="800" height="0" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr valign="top">
<td colspan="2" valign="top"><?include("header1.php");?></td>
</tr>
<tr>
<td colspan="2" valign="top">
<?
include('connect.php');
$id = $_GET['reqno'];
$sql="select PH.REQNO,PH.HN,PH.VISITDATE,PH.PT_TYPE,PH.PATSTATUS,PH.ORDERDOC,PH.REQFROM,
H.hn,H.regNo,PH.SYMTOM,PH.CAUTION,PH.COMPLETE_STAT,PH.REQ_TYPE,PH.PT_STATUS,PH.User_id,C.TYPE_DESC,
rtrim(Ti.titleName) + ' ' + PT.firstName + ' ' + rtrim(PT.lastName) as fullName,
case when H.ipdStatus='0'and H.CardInTime is not Null then 'CardIn'
when H.ipdStatus='0'and H.CardInTime is Null then 'OPD'
when H.ipdStatus='I'then 'IPD'
when H.ipdStatus='D'and H.CardInTime is not Null then 'CardIn' end as StatusHN,
case when H.ipdStatus='0'and H.CardInTime is not Null then ''
when H.ipdStatus='0'and H.CardInTime is Null then D.deptDesc
when H.ipdStatus='I'then I.current_room
when H.ipdStatus='D'and H.CardInTime is not Null then '' end as deptward,
substring(registDate,7,2)+'/'+ substring(registDate,5,2)+'/'+ substring(registDate,1,4)as registdate,
H.dept,D.deptDesc,H.registDate,H.timePt,H.CardInTime,PT.sex,PT.birthDay,
I.ladmit_n,I.ward_id,I.current_room,I.admit_date,I.admit_time,H.regNo,H.ipdStatus,
DateDiff(Year,(convert(DateTime,convert(char,substring(convert(char,PT.birthDay-5430000),1,4)
+(case
when substring(convert(char,PT.birthDay-5430000),5,2)='00' then'07'
else substring(convert(char,PT.birthDay-5430000),5,2)
end )
+(case
when substring(convert(char,PT.birthDay-5430000),7,2)='00' then '01'
else substring(convert(char,PT.birthDay-5430000),7,2)
end )))),convert(DateTime,convert(char,H.registDate-5430000))) as Age
from OPD_H H (nolock)
left join PTREQ_H PH (nolock) on PH.HN= H.hn
left join PATIENT PT (Nolock) on PT.hn= H.hn
left join PTITLE Ti (NOLOCK) on Ti.titleCode = PT.titleCode
left join Ipd_h I (nolock) on I.hn=H.hn and H.regNo=I.regist_flag
left join DEPT D (nolock) on D.deptCode=H.dept
left join PTCON_type C (nolock) on C.CODE_TYPE = PH.PT_TYPE
where PH.REQNO = '$id'
and PH.REGNO= H.regNo and PH.CANCELED='1'
order by PH.REQNO desc";
$result = mssql_query($sql);
while($row = mssql_fetch_array($result))
{
//$row = mssql_fetch_array($result);
$fullname = $row['fullName'];
$hnn = $row['hn'];
$z = $row['hn'];
$reg_no=$row['regNo'];
$statushn=$row['StatusHN'];
$dept=$row['dept'];
$deptward=$row['deptward'];
$deptDesc=$row['deptDesc'];
$registdate=$row['registDate'];
$regist_date=$row['registdate'];
$timept=$row['timePt'];
$cardInTime=$row['CardInTime'];
$ladmit_n=$ladmit_n['ladmit_n'];
$current_room=$row['current_room'];
$admit_date=$row['admit_date'];
$admit_time=$row['admit_time'];
$ward_id=$row['ward_id'];
$sex=$row['sex'];
$birthDay=$row['birthDay'];
$age=$row['Age'];
$ipdStatus=$row['ipdStatus'];
$pt_type=$row['PT_TYPE'];
$orderdoc=$row['ORDERDOC'];
$symtom=$row['SYMTOM'];
$caution=$row['CAUTION'];
$complete_stat=$row['COMPLETE_STAT'];
$req_type=$row['REQ_TYPE'];
$pt_status=$row['PT_STATUS'];
$reqno=$row['REQNO'];
$userid=$row['User_id'];
$type_desc=$row['TYPE_DESC'];
$dateto = date("Y-d-m");
$timeto = date("H:i");
?>
<div align="center"></div>
<form name="form2" method="post" action="adddetail.php">
<table width="750" border="0" align="center" cellpadding="2" cellspacing="2" style="border: 1px dashed #808080">
<tr>
<td width="177" valign="top"><div align="right" class="style2 style3">AN:</div></td>
<td valign="top"><span class="style6"><? echo $ladmit_n;?></span></td>
<td valign="top"><div align="right"><span class="style4">วันที่เข้า รพ.</span></div></td>
<td valign="top"><span class="style3">
<? echo $regist_date; ?>
</span></td>
<td width="76" valign="top"> </td>
<td colspan="3" valign="top"> </td>
<input name="reqno" type="hidden" id="reqno" value="<? echo "$reqno"; ?>">
<input name="reqno_d[]" type="hidden" id="reqno_d" value="<? echo "$reqno"; ?>">
<input name="enterdate" type="hidden" id="enterdate" value="<? echo "$dateto"; ?>">
<input name="keydate[]" type="hidden" id="keydate" value="<? echo "$dateto"; ?>">
<input name="user" type="hidden" id="user" value="<?echo "$userr";?>">
<input name="userr[]" type="hidden" id="userr" value="<?echo "$userr";?>">
</tr>
<tr>
<td valign="top"><div align="right" class="style2 style3">HN-RegNo:</div></td>
<td colspan="3" valign="top"><span class="style6">
<? echo $hnn; ?>
- <? echo $reg_no;?></span></td>
<td valign="top"> </td>
<td width="76" valign="top"> </td>
<td width="8" valign="top"> </td>
<td width="15" valign="top"> </td>
</tr>
<tr>
<td valign="top"><div align="right" class="style2 style3">ชื่อ-สกุล: </div></td>
<td colspan="3" valign="top"><span class="style4"><?echo $fullname;?></span></td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top"><div align="right" class="style2 style3">ห้อง:</div></td>
<td width="128" valign="top"><span class="style4"><? echo $deptward;?></span></td>
<td width="129" valign="top"><div align="right" class="style2 style3">สถานะ:</div></td>
<td width="73" valign="top"><span class="style3"><? echo $statushn;?></span></td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top"><div align="right" class="style2 style3">อายุ : </div></td>
<td valign="top"><span class="style4"><? echo $age;?>ปี</span></td>
<td valign="top"><div align="right" class="style2 style3">เพศ:</div></td>
<td valign="top"><span class="style3"><? echo $sex;?></span></td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top"><div align="right" class="style2 style3">แพทย์ผู้สั่ง:</div></td>
<td colspan="3" valign="top"><span class="style3"><? echo $orderdoc;?></span></td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top"><div align="right" class="style2 style3">ประเภทกายภาพ:</div></td>
<td colspan="3" valign="top"><span class="style3"><? echo $pt_type;?><?echo $type_desc;?></span></td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top"><div align="right" class="style4">อาการสำคัญ : </div></td>
<td colspan="3" valign="top"><input name="symtom" type="text" id="symtom" value ="<?echo $symtom;?>"size="50" /></td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top"><div align="right" class="style4">ข้อควรระวัง : </div></td>
<td colspan="3" valign="top"><textarea name="caution" rows="5" id="caution" cols="50" ><?echo $caution;?></textarea></td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top"><div align="right" class="style4">ประเภทการทำกายภาพ : </div></td>
<td colspan="3" valign="top">
<span class="style4">
<?php
if ($req_type =='H') {
?>
<input name="req_type" type="radio" value="H" checked >
<?php } else { ?>
<input name="req_type" type="radio" value="H" >
<? } ?>
รักษา <br>
<?php
if ($req_type =='R') {
?>
<input name="req_type" type="radio" value="R" checked>
<?php } else { ?>
<input name="req_type" type="radio" value="R" >
<? } ?>
ฟื้นฟู <br>
<?php
if ($req_type =='P') {
?>
<input name="req_type" type="radio" value="P" checked>
<?php } else { ?>
<input name="req_type" type="radio" value="P" >
<? } ?>
ส่งเสริม </span></td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top"><div align="right" class="style4">สภาวะผู้ป่วย:</div></td>
<td colspan="3" valign="top">
<span class="style4">
<?php
if ($pt_status =='A') {
?>
<input name="pt_status" type="radio" value="A" checked >
<?php } else { ?>
<input name="pt_status" type="radio" value="A" >
<? } ?>
Acute <br>
<?php
if ($pt_status =='C') {
?>
<input name="pt_status" type="radio" value="C" checked>
<?php } else { ?>
<input name="pt_status" type="radio" value="C" >
<? } ?>
Chronic </span></td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top"><div align="right" class="style4">กลุ่มกิจกรรม</div></td>
<td colspan="3" valign="top"><select name="users" onChange="showUser(this.value)">
<option value = ''>กรุณาเลือก</option>
<?
include("connect.php");
$sql = "Select * From PTGROUP where PT_TYPE='$pt_type' order by GROUP_CODE asc";
$table = mssql_query($sql) or die ("ติดต่อฐานข้อมูลไม่ได้");
while($row_t=mssql_fetch_array($table))
{
$group_code=$row_t["GROUP_CODE"];
$group_desc=$row_t["GROUP_DESC"];
echo "<option value=".$group_code." >".$group_desc."</option>";
}?>
</select></td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td colspan="8" valign="top"><div id="txtHint"></div></td>
</tr>
<tr>
<td valign="top">
<div align="right">
<?
}
?>
<input type="submit" name="Submit" value="บันทึก" id="Submit" />
</div></td>
<td colspan="3" valign="top"><input type="reset" name="Submit2" value="ยกเลิก" id="label" /></td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td colspan="2" valign="top"><?include("footer.php");?></td>
</tr>
</table>
</body>
</html>
Code (PHP) <html>
<head >
<meta http-equiv="Content-Type" content="text/html; charset=tis-620"/>
</head>
<body>
<table width="80%" border="1">
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td colspan="2"><p> </p>
<p>
<?
include("connect.php");
$q=$_GET["q"];
$regno_d=$_GET['regNo'];
$tb="PTPROC";
$sql="SELECT * FROM $tb where GROUP_CODE='".$q."'";
$result = mssql_query($sql);
?>
<?
while($row = mssql_fetch_array($result)) {
$groupcode=$row["GROUP_CODE"];
$ptproc =$row["PT_PROC"];
$procdesc =$row["PROC_DESC"];
$dateto = date("Y-d-m");
$timeto = date("H:i");
?>
<input type="checkbox" name="ptproc[]" value="<? echo "$ptproc";?>" id='ptproc' ><? echo "$procdesc";?>
<input name="groupcode[]" type="hidden" id="groupcode" value="<? echo "$groupcode";?>">
<input name="keydate[]" type="hidden" id="keydate" value="<? echo " $dateto";?>">
<input name="ptcount[]" type="text" id="ptcount" size="10">
<input name="time_preday[]" type="text" id="time_preday" size="10">
<input name="ptfreq[]" type="text" id="ptfreq" size="10">
<BR>
<?
}
?>
<p> </p>
</body>
</html>
Code (PHP) <?
include("connect.php");
$tb= "PTREQ_D";
$sqld="select* from $tb where REQNO_D = '$reqno'order by REQNO_D desc";
{
$count=count($reqno);
for ($i=0;$i<$count;$i++){
$sqld="insert into PTREQ_D (REQNO_D,PTTYPE,CANCELED,User_id,PTCOUNT,TIME_PERDAY,PTFREQ,GROUP_CODE,PTPROC,ENTER_DATE)
values('$reqno_d[$i]','$req_type[$i]','N[$i]','$userr[$i]','$ptcount[$i]','$time_preday[$i]','$ptfreq[$i]','$groupcode[$i]','$ptproc[$i]','$keydate[$i]')";
$query=mssql_query($sqld);
}
echo ("<center><font color =\"red\" face=\"Ms Sans Serif\" size=\3\"><B>บันทึกข้อมูลเรียบร้อยแล้ว ต่อไปทำการระบุกิจกรรม</B></font><br><br><a href = \"formnewreq.php?reqno=$reqno\" onclick = 'history.back()'> <font color =\"blue\" face=\"Ms Sans Serif\" size=\2\"> <B>คลิก</B> </font></a></center>");
exit;
mssql_close();
}
?>
Date :
2010-11-11 21:26:56By :
katae_kapolo
<input name="reqno[] " type="hidden" id="reqno" value="<? echo "$reqno"; ?>">
ประวัติการแก้ไข
Date :
2010-11-11 21:56:02By :
PlaKriM
<input name="reqno[]" type="hidden" id="reqno" value="<? echo "$reqno"; ?>">Code (PHP) <html>
<head >
<meta http-equiv="Content-Type" content="text/html; charset=tis-620"/>
</head>
<body>
<table width="80%" border="1">
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td colspan="2"><p> </p>
<p>
<?
include("connect.php");
$q=$_GET["q"];
$tb="PTPROC";
$sql="SELECT * FROM $tb where GROUP_CODE='".$q."'";
$result = mssql_query($sql);
echo $q;
?>
<?
while($row = mssql_fetch_array($result)) {
$groupcode=$row["GROUP_CODE"];
$ptproc =$row["PT_PROC"];
$procdesc =$row["PROC_DESC"];
$dateto = date("Y-d-m");
$timeto = date("H:i");
?>
<input type="checkbox" name="ptproc[]" value="<? echo "$ptproc";?>" id='ptproc' ><? echo "$procdesc";?>
<input name="reqno[]" type="hidden" id="reqno" value="<? echo "$reqno"; ?>">
<input name="groupcode[]" type="hidden" id="groupcode" value="<? echo "$groupcode";?>">
<input name="keydate[]" type="hidden" id="keydate" value="<? echo " $dateto";?>">
<input name="ptcount[]" type="text" id="ptcount" size="10">
<input name="time_preday[]" type="text" id="time_preday" size="10">
<input name="ptfreq[]" type="text" id="ptfreq" size="10">
<BR>
<?
}
?>
<p> </p>
</body>
</html>
Date :
2010-11-11 22:44:41By :
katae_kapolo
Server 03
Load balance : Server 03
