[syntax=php]<script>
function showRooms(str)
{
var xmlhttp;
if (str=="")
{
document.getElementById("resultTable").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("resultTable").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","test.php?r="+str,true);
xmlhttp.send();
}
</script></head>
<body>
<?php
require("db_connect.php"); //Database connection
$r=$_GET["r"];
//Get all matching roomtypes posted after not more than 14 days.
$sql="SELECT * FROM room WHERE room_posteddate >= (SELECT SUBDATE( CURRENT_DATE, INTERVAL 14 DAY ) AS LASTDATE ) AND room_posteddate <= CURRENT_DATE AND room_type = '".$r."'";
$result = mysql_query($sql);
echo "<table border='1'>
<tr>
<th>PostCode</th>
<th>Rent/week</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['room_postcode'] . "</td>";
echo "<td>" . $row['room_pwk'] . "</td>";
echo "</tr>";
}
echo "</table>"; mysql_close($dbconn);
?>
<div class="roomtype_results"><form action="">
<select name="roomtype" onchange="showRooms(this.value)">
<option selected="selected" value="">Select a room type:</option>
<option value="single">Single Room</option>
<option value="double ">Double Room</option>
</select></form>
<br><div id="resultTable">Room results will be listed here...</div></div></body></html>[/syntax]
I get the error called undefined index r after db connection set. If seperate the php code into a seperate .php file it works.
How can I make all the code work in the same php file witout seperation??.
AJAX db with PHP
Re: AJAX db with PHP
Essentially, you cant. You could have the php bit check for the form data and only try to use it if it exists.
No offence, but this code is pretty terrible. You should look into using function to separate your logic type code from the html part.
Also you should try to use more valid html, a lot of browser will have trouble processing this.
No offence, but this code is pretty terrible. You should look into using function to separate your logic type code from the html part.
Also you should try to use more valid html, a lot of browser will have trouble processing this.
