 |
|
ตัวอย่างน่ะค่ะ
$("input#personal_no").focus().autocomplete({
source: [
<?php
$newCon->dbquery("select * from person order by personal_no");
while($data=$newCon->fetch_assoc()){
echo "{label:\"{$data["personal_no"]}:{$data["fname"]}:{$data["lname"]}\", ",
"value:\"{$data["personal_no"]}\", ",
"personal_no:\"{$data["personal_no"]}\", } , ";
}
?>
],
response: function( event, ui ) {
},
select: function(event, ui) {
$.post("checkValid.php",{"idno":ui.item.personal_no} , function(backingData){
if(backingData != "valid")
alert(backingData);
else
$("input#personal_no").val( ui.item.personal_no );
});
return false;
}
});
checkValid.php
// เชื่อมต่อฐานข้อมูล
$newCon->dbquery("select * from person where personal_no = '{$_POST["idno"]}' ");
$data=$newCon->fetch_assoc();
if($newCon->num_rows()>0) echo "valid"; else echo "ไม่พบข้อมูลชุดนี้ในฐานข้อมูลค่ะ \"{$_POST["idno"]}\" ";
|
 |
 |
 |
 |
Date :
2013-08-05 12:00:05 |
By :
survivor |
|
 |
 |
 |
 |
|
|
 |