 |
ถ้ากรอกรหัสพนักงาน เสร็จ/ถูกต้อง ให้แสดงชื่อ-นามสกุลจาก DB ให้มาแสดงทันที เขียนไงค่ะ ขอบคุณค่า |
| |
 |
|
|
 |
 |
|
ลองดูนะครับ
ถ้าจะให้ดี น่าจะเขียนโค้ดกำกับด้วยนะครับ
เพราะเลขรหัสพนักงานน่าจะจำนวนเท่ากัน เพื่อไม่ให้มีการเรียกข้อมูลทุกครั้งที่คีย์
ต้องขออภัยถ้ามือใหม่เขียนมั่วไปนิสสสส ^_^
Database นะครับ
-- Database: `ajaxtutor`
--
-- --------------------------------------------------------
--
-- Table structure for table `member`
--
CREATE TABLE IF NOT EXISTS `member` (
`member_id` int(11) NOT NULL auto_increment,
`member_name` varchar(120) NOT NULL,
`member_addr` text NOT NULL,
`member_phone` varchar(10) NOT NULL,
`member_group` varchar(20) NOT NULL default 'user',
PRIMARY KEY (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `member`
--
INSERT INTO `member` (`member_id`, `member_name`, `member_addr`, `member_phone`, `member_group`) VALUES
(1, 'user', '123/1 Thailand', '0811111111', 'user'),
(8, 'admin', '123/1 Thailand', '0811111111', 'admin');
|
ประวัติการแก้ไข
2012-09-03 13:12:10
 |
 |
 |
 |
| Date :
2012-09-03 13:04:43 |
By :
jarun |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
index.php
Code (PHP)
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<title>Title</title>
<link href="styles.css" rel="stylesheet" type="text/css">
<script Language = "Javascript" src="javaquery.js"></script>
</head>
<body bgcolor="#FFFFFF" text="#000000" link="#0000CC">
<form name="myform">
Type : <input type="text" name="search" id="search" onkeypress="call_send()" onsubmit="call_send()" onKeyUp="call_send()" onBlur="call_send()" onChange="call_send()" onSelect="call_send()">
<input type="button" onclick="call_send()" value="OK">
<br>
</form>
<table border=1 cellspacing=0 width="100%" cellpadding="8" bordercolor="#000000">
<tr valign="top">
<td width="61%" bgcolor="#FFCC33"> <div id="cell1">Data</div></td>
</tr>
</table>
</body>
</html>
|
| |
|
|
| |
| Date :
2012-09-03 13:05:56 |
By :
jarun |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
config.php
Code (PHP)
<?
$host="localhost";
$user="root";
$pass="";
$dbname="ajaxtutor";
$conn=mysql_connect($host,$user,$pass);
mysql_select_db($dbname);
mysql_query("SET character_set_results=tis620");
mysql_query("SET character_set_client=tis620");
mysql_query("SET character_set_connection=tis620");
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<title>Title</title>
</head>
<body>
</body>
</html>
show.php
Code (PHP)
<?
include "config.php";
$search = $_REQUEST["search"];
$sql="select * from member where member_id like '%$search%'
or member_name like '%$search%'
or member_addr like '%$search%'
or member_phone like '%$search%'";
$result=mysql_db_query($dbname,$sql);
$NRow=mysql_num_rows($result);
if($NRow==0){
echo "Empty data";
}
else{
echo "<table width=100%>";
echo "<tr>
<td width=10%><u>ID</u></td>
<td width=30%><div class=TabletxtStyle><u>Name</u></div></td>
<td width=30%><u>Address</u></td>
<td width=20%><u>Phone</u></td>
<td width=10%><u>Group</u></td>
</tr>";
while($row=mysql_fetch_array($result)){
$member_id=$row['member_id'];
$member_name=$row['member_name'];
$member_addr=$row['member_addr'];
$member_phone=$row['member_phone'];
$member_group=$row['member_group'];
echo "<tr>";
echo "<td>$member_id</td>
<td>$member_name</td>
<td>$member_addr</td>
<td>$member_phone</td>
<td>$member_group</td>";
echo "</tr>";
}
echo "</table>";
}
?>
javaquery.js
Code (JavaScript)
var req;
var rnd=Math.random();
function createXMLHttpRequest()
{
if (window.XMLHttpRequest)
req=new XMLHttpRequest();
else if (window.ActiveXObject)
req=new ActiveXObject("Microsoft.XMLHTTP");
else{
alert("Browser not support");
return false;
}
}
function call_send()
{
createXMLHttpRequest();
var search=document.getElementById("search").value;
var querystr="show.php?qID="+rnd+"&search="+search;
req.onreadystatechange = statechange;
req.open("post",querystr,true);
req.send(null);
}
function statechange()
{
if (req.readyState==4) {
var x=document.getElementById("cell1");
x.innerHTML = req.responseText;
}
else{
var x=document.getElementById("cell1");
x.innerHTML="<img src=images/indicator.gif border=0> Please wait...";
}
}
function updateName(){
}
|
ประวัติการแก้ไข
2012-09-03 13:15:28
| |
|
|
| |
| Date :
2012-09-03 13:08:29 |
By :
jarun |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
| Date :
2012-09-03 13:10:11 |
By :
jarun |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
เด่วลองดูคะ ขอบคุณค่า
|
| |
|
|
| |
| Date :
2012-09-03 13:45:52 |
By :
Poster |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขอบคุณค่า ได้แล้วนะค่ะ
|
| |
|
|
| |
| Date :
2012-09-04 09:32:32 |
By :
Poster |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
