|
 |
| |
การ Query ข้อมูล 2 ครั้ง ทำอย่างไรหรอครับ ขอตัวอย่างหน่อยครับ |
| |
 |
|
|
 |
 |
|
ต้องออกแบบหน้าตาของโปรแกรมให้ดูประกอบด้วยครับ
ออกจะงงนิดๆ
|
 |
 |
 |
 |
| Date :
2012-09-21 11:48:24 |
By :
sakuraei |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
อันนี้ โค้ดครับ
<?
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("meameeting");
mysql_query("SET NAMES UTF8");
$strSQL = "SELECT Start_Date,Start_Time,End_Time,Name_Room,meet_name,Name_Mem from tbqueue_meeting tm
left join tbroom tr on tm.id_room = tr.id_room
left join tbmember tme on tm.id_member = tme.id_member ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>รายการจองห้องประชุม</td>
</tr>
<tr>
<td>จากวันที่จอง :
<input name="Start_Date" size="16" id="Start_Date" />
<a href="javascript:displayDatePicker('Start_Date')"><img border="0" src="images/calendar.gif" width="16" height="16"></a> ถึง
<input name="End_Date" size="16" id="End_Date">
<a href="javascript:displayDatePicker('End_Date')">
<img border="0" src="images/calendar.gif" width="16" height="16"></a>
<label for="End_Date"></label> </td>
</tr>
<tr>
<td colspan="2">หัวข้อการประชุม :
<label for="txtSearch"></label>
<input name="txtSearch" type="text" id="txtSearch" size="50" />
<input type="submit" name="meet_search" id="meet_search" value=" ค้นหา " /></td>
</tr>
<tr>
<td colspan="2"><table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td align="center" width="10%">วันที่จอง</td>
<td align="center" width="16%">เวลาเริ่มการประชุม</td>
<td align="center" width="16%">ห้องประชุม</td>
<td align="center" width="37%">หัวข้อการประชุม</td>
<td align="center" width="12%">ชื่อผู้จองห้อง</td>
</tr>
<?
while($objResult = mysql_fetch_array($objQuery))
{
?>
<tr>
<td><center><?=$objResult["Start_Date"];?></center>
<td><center><?=$objResult["Start_Time"]." - ".$objResult["End_Time"];?></center>
<td><center><?=$objResult["Name_Room"];?></center>
<td><center><?=$objResult["meet_name"];?></center>
<td><center><?=$objResult["Name_Mem"];?></center>
</tr>
<?
}
?>
******ผมต้องการ Queryเพิ่มแค่นี้อ่าครับ where meet_name like '%$txtSearch%' and Start_Date BETWEEN '$Start_Date' and '$End_Date'";
|
ประวัติการแก้ไข
2012-09-21 12:09:45
2012-09-21 12:11:23
| |
|
|
| |
| Date :
2012-09-21 11:59:30 |
By :
design01 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ต้องใช้ AJAX ครับ
ลองเอาไปประยุกต์ดู
1.php
Code (PHP)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script language="JavaScript">
var HttPRequest = false;
function sendData() {
HttPRequest = false;
if (window.XMLHttpRequest) { // Mozilla, Safari,...
HttPRequest = new XMLHttpRequest();
if (HttPRequest.overrideMimeType) {
HttPRequest.overrideMimeType('text/html');
}
} else if (window.ActiveXObject) { // IE
try {
HttPRequest = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
HttPRequest = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e) {}
}
}
if (!HttPRequest) {
alert('Cannot create XMLHTTP instance');
return false;
}
var url = '2.php';
var keyword = document.getElementById("search").value
var pmeters = 'keyword='+keyword;
//var pmeters = 'myName='+document.getElementById("txtName").value+'&my2='; // 2 Parameters
HttPRequest.open('POST',url,true);
HttPRequest.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
HttPRequest.setRequestHeader("Content-length", pmeters.length);
HttPRequest.setRequestHeader("Connection", "close");
HttPRequest.send(pmeters);
HttPRequest.onreadystatechange = function()
{
if(HttPRequest.readyState == 3) // Loading Request
{
document.getElementById("result").innerHTML = "Now is Loading...";
}
if(HttPRequest.readyState == 4) // Return Request
{
document.getElementById("result").innerHTML = HttPRequest.responseText;
}
}
/*
HttPRequest.onreadystatechange = call function .... // Call other function
*/
}
</script>
</head>
<?
include('connect.php')
?>
<body onload="sendData('')">
<div align="center">Search:<input name="search" id="search" type="text" value="" />
<input name="btn1" type="button" value="search" onclick="sendData();" />
</div>
<div id="result"></div>
</body>
</html>
2.php
Code (PHP)
<?
include('connect.php');
if($keyword == ""){
$sql = "select * from test_table";
$query = mysql_query($sql);
}
else if($keyword != ""){
$sql = "select * from test_table where t_field1 = '$keyword'";
$query = mysql_query($sql);
}
?>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
<table align="center" width="300" border="1">
<tr>
<td bgcolor="#000000"><span class="style1">Field1</span></td>
<td bgcolor="#000000"><span class="style1">Field2</span></td>
<td bgcolor="#000000"><span class="style1">Field3</span></td>
</tr>
<?
while($res = mysql_fetch_array($query)){
?>
<tr>
<td><?=$res["t_field1"]?></td>
<td><?=$res["t_field2"]?></td>
<td><?=$res["t_field3"]?></td>
</tr>
<?
}
?>
</table>
|
| |
|
|
| |
| Date :
2012-09-21 12:24:20 |
By :
popypreaw |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 05
|
