 |
|
ดูยากจัง
connect.php
Code (PHP)
<?php
$link = mssql_connect('nirut', 'homcc', 'homcc');
mssql_select_db('HOMC', $link);
?>
searchhn.php
Code (PHP)
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>ทดสอบ AJAX</title>
<script language="javascript">
var objRequest = createRequestObject();
function createRequestObject() {
var objTemp = false;
if (window.XMLHttpRequest) {
objTemp = new XMLHttpRequest();
}
else if (window.ActiveXObject) {
objTemp = new ActiveXObject("Microsoft.XMLHTTP");
}
return objTemp;
}
function getData() {
if (objRequest) {
var pmeters = 'hn='+document.getElementById("hn").value;
objRequest.open("POST", "show_hn_aj.php");
objRequest.onreadystatechange = handleResponse;
objRequest.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
objRequest.setRequestHeader("Content-length", pmeters.length);
objRequest.setRequestHeader("Connection", "close");
objRequest.send(pmeters);
}
}
function handleResponse() {
var objDiv = document.getElementById("targetDiv");
if (objRequest.readyState == 4 ) {
objDiv.innerHTML = objRequest.responseText;
}
}
</script>
</head>
<body>
<h3>การพิมพ์ Label คนไข้</h3>
<input type="text" name="hn" id="hn" maxlength="7" style="width :60px">
<input type="button" value="Ok" onclick="getData()">
<br><br>
<div id="targetDiv"></div>
</body>
</html>
จากนั้นก็เรียกไปที่ search_hn_aj.php
Code (PHP)
<?php
include('_functions/phpFunction.php');
require('_connections/Connect.php');
$hn='';
$ladmit_n='';
$numc='';
if(isset($_POST['hn'])) {$hn=$_POST['hn'];} else {$hn='not data';}
$hn=string_Format($_POST['hn'],7);
$query="select * from Con_emp where hn='$hn'";
$rs=mssql_query($query,$link);
$resid=mssql_query($query);
$numc=mssql_num_rows($resid);
echo $query;
echo $numc; //ทดสอบดูจำนวน record แต่มันไม่ขึ้น
mssql_free_result($rs);
?>
<FORM NAME="form1" method="post" action="frm_pang_test.php">
<table border="1" width="677" border="0">
<tr>
<td>HN</td>
<td></td>
<td>AN</td>
<td></td>
</tr>
<tr>
<td>Name</td>
<td></td>
<td>Age</td>
<td></td>
</tr>
<tr>
<td>Ward</td>
<td></td>
<td>Current_room</td>
<td></td>
</tr>
<tr>
<td>Admit Date</td>
<td></td>
<td>Admit_Time</td>
<td></td>
</tr>
</table>
<table width="582" border="0">
<tr>
<td width="111"><div align="center">row</div></td>
<td width="194"><input type="text" name="row" id="row" onKeyPress="inputDate(self, this);"maxlength="2"style="width :50px" value ="1"> (1-10)</td>
<td width="95">column</td>
<td width="137">
<label></label><input type="text" name="col" id="col" onKeyPress="inputDate(self, this);"maxlength="2"style="width :50px" value ="1"> (1-3)</td>
<td width="23"> </td>
</tr>
</table>
<table width="582" border="0">
<tr>
<td width="228">จำนวนที่ต้องการพิมพ์</td>
<td width="344"><input type="text" name="total" id="total" onKeyPress="inputDate(self, this);"maxlength="2" style="width :50px" value="30" ></td>
</tr>
</table>
<table width="583" border="0">
<tr>
<td><div align="center">
<input type="submit" name="button" id="button" value="ตกลง">
</div></td>
</tr>
</table>
</form>
|
 |
 |
 |
 |
| Date :
2010-07-21 11:21:54 |
By :
50121680 |
|
 |
 |
 |
 |
|
|
 |
Quote:
