1. ========= ตัวอย่าง fileld ใน DB ===============
name class type zone
hackman Comsci Web Master zone-it
Karaged BC47 Programer zone-it
========end ===========================
2. File js.js
function createXMLHttpRequest() {
if (window.ActiveXObject) {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
else if (window.XMLHttpRequest) {
xmlHttp = new XMLHttpRequest();
}
}
function startRequest() {
createXMLHttpRequest();
var GN = document.getElementById("Gname").value;
var GC = document.getElementById("Gclass").value;
var GT = document.getElementById("Gtype").value;
var GZ= document.getElementById("Gzone").value;
xmlHttp.onreadystatechange = handleStateChange;
if (GN==0 || GC==0 || GT==0 || GZ==0)
{
alert ("เลือกเงื่อนไขด้วย!!");
return false;
}
xmlHttp.open("GET", "Research.php?gname=" + GN+"&gclass="+GC+">ype="+GT+"&gzone="+GZ, true);
xmlHttp.send(null);
}
function handleStateChange() {
if(xmlHttp.readyState == 4) {
if(xmlHttp.status == 200) {
document.getElementById("TxtShowGraph").innerHTML = xmlHttp.responseText;
}
}
}
===================== end ==========================================
3. Form Search.php ======================================
<HTML>
<HEAD>
<TITLE>Test Search Query > 1 </TITLE>
</HEAD>
<BODY>
Name <INPUT TYPE="text" id="Gname">
Class <SELECT NAME="" id="Gclass">
<option> Choose</option>
<option value="Comsci">Comsci</option>
<option value="BC47">BC47</option>
</SELECT><BR>
Type <SELECT NAME="" id="Gtype">
<option> Choose</option>
<option value="Web Master">Web Master</option>
<option value="Programer">Programer</option>
</SELECT><BR>
Zone <SELECT NAME="" id="GZone">
<option> Choose</option>
<option value="zone-it">zone-it</option>
<option value="Comsci">comsci</option>
</SELECT>
<INPUT TYPE="button" onclick="startRequest()" value="Search">
<div id="TxtShowGraph"></div>
</BODY>
</HTML>
===================================end =============================
4. Research.php =======================================================
<?
include "config.php"; //file Connect
$s1=$_GET["gname"];
$s2=$_GET["gclass"];
$s3=$_GET["gtype"];
$s4=$_GET["gzone"];
$sql=mysql_query("select * from tbtest where name like '%$s1%' AND class='$s2' AND type='$s3' AND zone='$s4' ");
$num=mysql_num_rows($sql);
if ($num = 0) {
echo "Empty Data";
}else{
while ($r=mysql_fetch_array($sql)) {
$name=$r["name"];
$class=$r["class"];
$type=$r["type"];
$zone=$r["zone"];
echo "Name:= $name Class:=$class Type:=$type Zone:=$zone";
}
}
?>
=====================================end ======================================
=====================================end ProJect=================================
thanks @ zone-it.com
Login
