listmenu กับการส่งค่ากลับมา(ถ้าจะปราบเซียนแล้วมั้งเนี่ย)
view pagemember and stadium.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=tis-620" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.line {
border-top-width: 1px;
border-right-width: 0px;
border-bottom-width: 1px;
border-left-width: 0px;
border-top-style: solid;
border-right-style: none;
border-bottom-style: solid;
border-left-style: none;
border-top-color: #CCCCCC;
border-bottom-color: #CCCCCC;
}
.line {
border-right-width: 1px;
border-left-width: 1px;
border-right-style: solid;
border-left-style: solid;
border-right-color: #CCCCCC;
border-left-color: #CCCCCC;
}
-->
</style>
<script language="javascript">
function timenull()
{
alert("null");
}
function timenotnull()
{
alert("notnull");
}
var xmlHttp;
var xmlHttp2;
var xmlHttp3;
var inputField;
var inputField2;
var inputField3;
var aod;
var aod2;
var time;
var spname;
function createXMLHttpRequest()
{
if (window.ActiveXObject)
{
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
else if (window.XMLHttpRequest)
{
xmlHttp = new XMLHttpRequest();
}
}
function createXMLHttpRequest3()
{
if (window.ActiveXObject)
{
xmlHttp3 = new ActiveXObject("Microsoft.XMLHTTP");
}
else if (window.XMLHttpRequest)
{
xmlHttp3 = new XMLHttpRequest();
}
}
function initVars()
{
inputField = document.getElementById("txtnames");
}
function findNames()
{
initVars();
if (inputField.value.length > 0)
{
createXMLHttpRequest();
var url = "stadiumshowprice.php?txtnames=" + inputField.value;
xmlHttp.open("GET", url, true);
spname=inputField.value;
alert(url);
//alert(inputField.value);
//alert("step1");
xmlHttp.onreadystatechange = callback;
xmlHttp.send(null);
}
else
{
alert("step1 erer");
}
}
function callback()
{
if (xmlHttp.readyState == 4)
{
if (xmlHttp.status == 200)
{
//alert("step 2 ");
startRequest();
}
else if
(xmlHttp.status == 204)
{
alert("step 2 erer");
}
}
}
function startRequest()
{
createXMLHttpRequest();
xmlHttp.open("get","stadiumshowprice.php?txtnames="+inputField.value,true);
xmlHttp.onreadystatechange = function ()
{
if (xmlHttp.readyState == 4) {
if (xmlHttp.status == 200) {
displayInfo(xmlHttp.responseText);
//alert("step 3");
}
else
{
displayInfo("พบข้อผิดพลาด: " + xmlHttp.statusText);
alert("step 3 erer");
}
}
};
xmlHttp.send(null);
}
function displayInfo()
{
aod = document.getElementById("divInfo").innerHTML = xmlHttp.responseText;
//alert("step 4");
alert(aod);
startRequest3();
}
function startRequest3()
{
alert("step 10");
createXMLHttpRequest3();
xmlHttp3.open("get","stadiumshowstatus.php?txtnames=" + inputField.value,true);
xmlHttp3.onreadystatechange = function ()
{
if (xmlHttp.readyState == 4) {
if (xmlHttp3.status == 200) {
//alert("step 10");
displayInfo3(xmlHttp3.responseText);
}
else
{
alert("step 8.1 erer");
displayInfo3("พบข้อผิดพลาด: " + xmlHttp3.statusText);
}
}
};
//alert("step 8.2");
xmlHttp3.send(null);
}
function displayInfo3()
{
//alert("step 10");
aod3 = document.getElementById("divInfo3").innerHTML = xmlHttp3.responseText;
alert(aod3);
}
</script>
<link rel="STYLESHEET" type="text/css" href="dhtmlxCalendar/codebase/dhtmlxcalendar.css">
<script>
window.dhx_globalImgPath="dhtmlxCalendar/codebase/imgs/";
</script>
<script src="dhtmlxCalendar/codebase/dhtmlxcommon.js"></script>
<script src="dhtmlxCalendar/codebase/dhtmlxcalendar.js"></script>
<script>
var mCal;
window.onload = function () {
mCal = new dhtmlxCalendarObject('dhtmlxCalendar', false, {isYearEditable: true});
mCal.loadUserLanguage('en-us');
mCal.setYearsRange(2000, 2500);
mCal.attachEvent("onClick",mSelectDate);
mCal.draw();
}
function mSelectDate(date)
{
document.getElementById('mCalInput').innerHTML = mCal.getFormatedDate("%Y-%m-%d", date);
//alert(mCal.getFormatedDate("%d-%m-%Y", date));
time =mCal.getFormatedDate("%Y-%m-%d", date);
//alert (time);
//alert (aod);
//alert(spname);
findreserv();
return true;
}
function createXMLHttpRequest2()
{
if (window.ActiveXObject)
{
//alert("step XML");
xmlHttp2 = new ActiveXObject("Microsoft.XMLHTTP");
}
else if (window.XMLHttpRequest)
{
alert("step XML erer");
xmlHttp2 = new XMLHttpRequest();
}
}
function findreserv()
{
//alert ("step 5");
//alert (time);
//alert (aod);
//alert(spname);
initVars2();
if (inputField.value.length > 0)
{
createXMLHttpRequest2();
var url = "stadiumshowreserve.php?time="+inputField2+"&spname="+inputField3;
xmlHttp2.open("GET", url, true);
alert(url);
//alert("step 5.1");
xmlHttp2.onreadystatechange = callreserve;
xmlHttp2.send(null);
}
else
{
alert("step5.1 erer");
}
}
function initVars2()
{
//alert("step 6");
inputField2 = time;
inputField3 = spname;
//alert(inputField2);
//alert(inputField3);
}
function callreserve()
{
if (xmlHttp2.readyState == 4)
{
if (xmlHttp2.status == 200)
{
//alert("step 7");
startRequest2();
}
else if
(xmlHttp2.status == 204)
{
alert("step 7 erer");
}
}
}
function startRequest2()
{
//alert("step 8");
createXMLHttpRequest2();
xmlHttp2.open("get","stadiumshowreserve.php?time="+inputField2+"&spname="+inputField3,true);
//alert("stadiumshowreserve.php?time="+inputField2+"&spname="+inputField3);
xmlHttp2.onreadystatechange = function ()
{
if (xmlHttp2.readyState == 4) {
if (xmlHttp2.status == 200) {
//alert("step 8.1");
displayInfo2(xmlHttp2.responseText);
}
else
{
alert("step 8.1 erer");
displayInfo2("พบข้อผิดพลาด: " + xmlHttp2.statusText);
}
}
};
//alert("step 8.2");
xmlHttp2.send(null);
}
function displayInfo2()
{
//alert(xmlHttp2.responseText);
alert("step 9");
aod2 = document.getElementById("divInfo2").innerHTML = xmlHttp2.responseText;
alert(aod2);
//reservtime();
}
function reservtime()
{
alert("step 11");
if(aod2==8.00-10.00)
{
alert("8.00-10.00");
}
else if(aod2==10.00-12.00)
{
alert("10.00-12.00");
}
else if(aod2==12.00-14.00)
{
alert("12.00-14.00");
}
else if(aod2==14.00-16.00)
{
alert("14.00-16.00");
}
else if(aod2==16.00-18.00)
{
alert("16.00-18.00");
}
else if(aod2==18.00-20.00)
{
alert("18.00-20.00");
}
else
{
alert("Goodjob");
}
}
</script>
<script>
window.dhx_globalImgPath="dhtmlxCalendar/codebase/imgs/";
</script>
</head>
<body>
<table width="955" border="0" align="center" cellpadding="0" cellspacing="0" background="img/bgwood.jpg" bgcolor="#FFFFFF" >
<!--DWLayoutTable-->
<tr>
<td height="185" colspan="4" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="890" height="180"><img src="img/img2.JPG" alt="" width="970" height="185" /></td>
</tr>
</table></td>
</tr>
<tr>
<td width="296" rowspan="3" valign="top"><img src="img/img12.JPG" width="296" height="125" /></td>
<td height="63" colspan="3" valign="top"><table width="658" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="157"></td>
<td width="335"></td>
<td width="164"></td>
</tr>
<!--DWLayoutTable-->
<tr>
<td height="49" align="center" valign="top"><dfn><strong><a href="#"></a></strong></dfn><a href="pagemember.php"><img src="img2/redl.jpg" alt="หน้าหลัก" width="157" height="51" border="0" /></a></td>
<td align="center" valign="top"><img src="img2/redc.jpg" alt="สนามกีฬา" width="338" height="51" border="0" /></td>
<td align="center" valign="top"><a href="pagemember search.html"></a><a href="homepagemembersearch.php"><img src="img2/redr.jpg" alt="ค้นหา" width="176" height="51" border="0" /></a></td>
</tr>
<tr>
<td height="14"></td>
<td></td>
<td></td>
</tr>
</table></td>
</tr>
<tr>
<td width="12" height="8"></td>
<td width="629"></td>
<td width="18"></td>
</tr>
<tr>
<td height="51" colspan="3" valign="top"><img src="img/headnew.GIF" alt="ข่าวเด่น" width="298" height="51" /></td>
</tr>
<tr>
<td height="22" colspan="4" valign="top" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="19"></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="544" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="1" height="479"></td>
<td width="3"></td>
<td width="292" valign="top">
<form id="form2" name="form2" method="post" action="">
<table width="292" height="206" border="0" cellspacing="0" bordercolor="#666666" background="img/bgwood.jpg" bgcolor="#FFFFFF" style="border-style:solid; cellpadding="0'>
<!--DWLayoutTable-->
<tr>
<td width="16" height="80"></td>
<td width="53"> </td>
<td width="63"></td>
<td width="25"></td>
<td width="70"></td>
<td width="2"></td>
<td width="41"></td>
</tr>
<tr>
<td height="29"></td>
<td valign="top"><img src="img2/members.jpg" width="53" height="27" /></td>
<td colspan="4" valign="top" bgcolor="#FFFFFF">
<?php
@session_start();
echo $_SESSION['$a']?> </td>
<td> </td>
</tr>
<tr>
<td height="24"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="28"></td>
<td valign="top"><img src="img2/credit.JPG" alt="จำนวนเงินของระบบ" width="36" height="27" /></td>
<td valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="63" height="26" valign="top">
<h7><?php
session_start();
echo $_SESSION['$n']?>
</h7></td>
</tr>
</table> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="27"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="27"></td>
<td valign="top"><img src="img2/home.gif" alt="แก้ไขข้อมูลส่วนตัว" width="34" height="24" /></td>
<td colspan="4" valign="top" bgcolor="#FFFFFF"> <a href="pagememberedit.php">
<h7>
Change Profile
</a>
<h7></td>
<td> </td>
</tr>
<tr>
<td height="28"></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="26"></td>
<td rowspan="2" valign="top"><img src="img2/add.gif" alt="จองสนาม" width="36" height="26" /></td>
<td colspan="4" valign="top" bgcolor="#FFFFFF"><h7><a href="pagememberlistreserve.php">Reserve Stadium</a></h7></td>
<td></td>
</tr>
<tr>
<td height="2"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="75"></td>
<td> </td>
<td></td>
<td> </td>
<td> </td>
<td> </td>
<td></td>
</tr>
<tr>
<td height="28"></td>
<td> </td>
<td></td>
<td> </td>
<td valign="top"><a href="homepage.php"><img src="buttom/bottomlogout.GIF" alt="ออกจากระบบ" width="70" height="26" border="0" session_destroy();/></a></td>
<td> </td>
<td></td>
</tr>
<tr>
<td height="85"></td>
<td> </td>
<td></td>
<td> </td>
<td> </td>
<td> </td>
<td></td>
</tr>
</table>
</form><p> </p></td>
</tr>
<tr>
<td height="19"></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="25"></td>
<td colspan="2" valign="top"> <img src="img2/litter.JPG" alt="ติดต่อเรา" width="76" height="30" /> <!-- #BeginDate format:En2 -->17-Feb-2010<!-- #EndDate --></td>
</tr>
</table></td>
<td> </td>
<td valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#666666" background="img/bgwoodc.JPG" bgcolor="#FFFFFF">
<!--DWLayoutTable-->
<tr>
<td width="1" height="17"></td>
<td width="25"></td>
<td width="118"></td>
<td width="58"></td>
<td width="31"></td>
<td width="69"></td>
<td width="21"></td>
<td width="146"></td>
<td width="59"></td>
<td width="114"></td>
</tr>
<tr>
<td height="26"></td>
<td colspan="2" valign="top"><h3>Stadium </h3></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="21"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="50"></td>
<td></td>
<td colspan="2" rowspan="8" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="176" height="162" valign="top">
<div id="dhtmlxCalendar"></div><div id="mCalInput" style="color: navy; font-size:18px; font-family: Verdana; text-align:center; border: 1px solid navy" > </div></td>
</tr>
<tr>
<td height="3"></td>
</tr>
</table></td>
<td></td>
<?php
$DBServer = "localhost";
$DBName = "project";
$DBUsername = "root";
$DBPassword = "1234";
$conn=mysql_connect( $DBServer, $DBUsername, $DBPassword ) or die( "ไม่สามารถติดต่อกับMySQLได้");
mysql_select_db( $DBName ) or die( "ไม่สามารถเลือกใช้ฐานข้อมูล $dbname ได้" );
mysql_query("SET NAMES TIS620");
?>
<td colspan="2" valign="top">
<select id="txtnames" onchange="findNames();">
<option value="">Stadium</option>
<?
$sql ="select * from sportstadium";
$result_show = mysql_query($sql) or die(mysql_error());
while($row_show = mysql_fetch_array($result_show))
{
?>
<option id="txtnames" name="txtnames" value=" <?=$row_show['sp_name_eng']?>">
<?=$row_show['sp_name_eng']?>
</option>
<?
}
?>
</select>
</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="16"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="26"></td>
<td></td>
<td></td>
<td colspan="3" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="146" height="26"> </td>
<td width="90" valign="top" bordercolor="#1941A5" bgcolor="#FFFFFF"><div id="divInfo3"></div></td>
</tr>
</table></td>
<td> </td>
<td></td>
</tr>
<tr>
<td height="36"></td>
<td></td>
<td></td>
<td> </td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="26"></td>
<td></td>
<td> </td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<!--DWLayoutTable-->
<tr>
<td width="64" height="26" valign="top" bgcolor="#FFFFFF"><div id="divInfo"></div></td>
</tr>
<!--DWLayoutTable-->
</table></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="19"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="22"></td>
<td></td>
<td> </td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="64" height="22" valign="top" bgcolor="#FFFFFF"> Credit:Time</td>
</tr>
</table></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="23"></td>
<td></td>
<td> </td>
<td> </td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="45"></td>
<td></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="118"></td>
<td></td>
<td colspan="7" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td height="49" colspan="7" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="502" height="49" valign="top" bgcolor="#FFFFFF"><div id="divInfo2"></div> </td>
</tr>
</table></td>
</tr>
<tr>
<td width="73" height="37" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="76" height="37" valign="top"><img src="img time/1-t8.gif" width="73" height="37" /></td>
</tr>
</table></td>
<td width="74" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="70" height="37" valign="top"><img src="img time/5-t10.gif" width="74" height="37" /></td>
</tr>
</table> </td>
<td width="71" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="72" height="37" valign="top"><img src="img time/9-t12.gif" width="76" height="37" /></td>
</tr>
</table> </td>
<td width="62" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="66" height="37" valign="top"><img src="img time/13-t14.gif" width="71" height="37" /></td>
</tr>
</table> </td>
<td width="64" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="69" height="37" valign="top"><img src="img time/17-t16.gif" width="68" height="37" /></td>
</tr>
</table> </td>
<td width="71" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="74" height="37" valign="top"><img src="img time/21-t18.gif" width="71" height="37" /></td>
</tr>
</table></td>
<td width="69" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="75" height="37" valign="top"><img src="img time/25-t20.gif" width="69" height="37" /></td>
</tr>
</table></td>
</tr>
<tr>
<td height="32" valign="top" bgcolor="#FFFFFF"> </td>
<td valign="top" bgcolor="#FFFFFF"> </td>
<td valign="top" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td valign="top" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td valign="top" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td valign="top" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td valign="top" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="0"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</table></td>
<td> </td>
</tr>
<tr>
<td height="284"></td>
<td></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<!--DWLayoutTable-->
</table></td>
<td> </td>
</tr>
</table>
</body>
</html>
view stadiumshowprice.php
<?php
$DBServer = "localhost";
$DBName = "project";
$DBUsername = "root";
$DBPassword = "1234";
$a=$_GET["txtnames"];
$conn=mysql_connect( $DBServer, $DBUsername, $DBPassword ) or die( "ไม่สามารถติดต่อกับMySQLได้");
mysql_select_db( $DBName ) or die( "ไม่สามารถเลือกใช้ฐานข้อมูล $dbname ได้" );
$charset="SET NAMES 'tis620'";
mysql_query($charset);
//echo $a;
$sql="SELECT sp_price FROM sportstadium WHERE sp_name_eng='$a'";
//echo $sql;
$result1= mysql_query($sql,$conn);
while($result=mysql_fetch_array($result1))
{
echo"$result[sp_price]";
}
mysql_close();
?>
view stadiumshowstatus.php
<?php
$DBServer = "localhost";
$DBName = "project";
$DBUsername = "root";
$DBPassword = "1234";
$a=$_GET["txtnames"];
$conn=mysql_connect( $DBServer, $DBUsername, $DBPassword ) or die( "ไม่สามารถติดต่อกับMySQLได้");
mysql_select_db( $DBName ) or die( "ไม่สามารถเลือกใช้ฐานข้อมูล $dbname ได้" );
$charset="SET NAMES 'tis620'";
mysql_query($charset);
$sql="SELECT sp_status FROM sportstadium WHERE sp_name_eng='$a'";
$result1= mysql_query($sql,$conn);
while($result=mysql_fetch_array($result1))
{
echo"$result[sp_status]";
}
mysql_close();
?>
การทำงาน
เมื่อกรอกชื่อสนามแล้ว ราคากับสถานะสนามจะเด้งออกมาเองนะครับ
ปัญหาคือค่าที่โยนมาจากเบสที่ 2 เป็นค่าว่าง
ซึ่งผมไม่เข้าใจว่าผมทำเป็น lisemenu มันเป็นค่าว่าง
แค่อีกเวอร์ชั่นโค้ดเดียวกันทำเป็น textbox กับมีค่าออกมา
นี่เป็นครั้งที่ 5 แล้วมั้งครับที่ผมถามคำถามนี้ เพราะครั้งอื่นๆ ก็ไม่มีใครสามารถตอบได้เลย
งั้นขอถามอีกทีนะครับ
ขอบคุณครับTag : - - - -
Date :
2010-02-17 19:21:57
By :
lunifer
View :
863
Reply :
1
ไว้เปลี่ยนไปใช้ jquery จะมาตอบนะงับ แบบนี้ไม่หวายยย ผมแทบไม่เคยเขียน ajax เองเลยต้องเปิดเว็บดูกันยกใหญ่
Date :
2010-02-17 21:30:42
By :
งืม
Load balance : Server 03