- Messages
- 18
- Reaction score
- 0
- Points
- 16
View attachment 264466
Hello po mga master! ito po kasi ung gusto kong gayahin na pag select ng rooms.
pano po ba nag karon ng ganitong out put? na every select ko ng room quantity or room no. automatic nag aadd ung value ng price nila sa iisang
column?
www.booking.com
index.php
====================
<?php
include("connect.php");
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Representation of AJAX</title>
<script type="text/javascript">
function update(str)
{
var xmlhttp;
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("data").innerHTML = xmlhttp.responseText;
}
}
xmlhttp.open("GET","demo.php?opt="+str, true);
xmlhttp.send();
}
</script>
</head>
<body>
<?php
$sqlroom = mysql_query("SELECT * FROM room WHERE ManagerID=105");
while($getroom = mysql_fetch_array($sqlroom)){?>
<select id="optionA" onchange="update(this.value)">
<?php
$x = 0;
do {
echo "The number is: $x <br>";
$x++;
?>
<option value="<?php $price = $x * $getroom['rate']; echo $getroom['room_id']; ?>">
<?php echo $x.' (PHP '; echo $price.')';?></option>
<?php } while ($x <= $getroom['qty']); ?>
</select>
<?php } ?>
<br/>
<select id="data">
<option>Select an Option...</option>
</select>
</body>
</html>
===============================
demo.php
<?php
include("connect.php");
$opt = $_GET['opt'];
$sqlroom = mysql_query("SELECT * FROM room WHERE room_id=$opt");
while($getroom = mysql_fetch_array($sqlroom)){
echo '<option value="opt1_1">';
echo $getroom['type'];
echo '</option>';
}
?>
===============================
ito pa lang po kasi ung out put na nagawa ko. TIA po sa tutulong.
Hello po mga master! ito po kasi ung gusto kong gayahin na pag select ng rooms.
pano po ba nag karon ng ganitong out put? na every select ko ng room quantity or room no. automatic nag aadd ung value ng price nila sa iisang
column?
www.booking.com
index.php
====================
<?php
include("connect.php");
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Representation of AJAX</title>
<script type="text/javascript">
function update(str)
{
var xmlhttp;
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("data").innerHTML = xmlhttp.responseText;
}
}
xmlhttp.open("GET","demo.php?opt="+str, true);
xmlhttp.send();
}
</script>
</head>
<body>
<?php
$sqlroom = mysql_query("SELECT * FROM room WHERE ManagerID=105");
while($getroom = mysql_fetch_array($sqlroom)){?>
<select id="optionA" onchange="update(this.value)">
<?php
$x = 0;
do {
echo "The number is: $x <br>";
$x++;
?>
<option value="<?php $price = $x * $getroom['rate']; echo $getroom['room_id']; ?>">
<?php echo $x.' (PHP '; echo $price.')';?></option>
<?php } while ($x <= $getroom['qty']); ?>
</select>
<?php } ?>
<br/>
<select id="data">
<option>Select an Option...</option>
</select>
</body>
</html>
===============================
demo.php
<?php
include("connect.php");
$opt = $_GET['opt'];
$sqlroom = mysql_query("SELECT * FROM room WHERE room_id=$opt");
while($getroom = mysql_fetch_array($sqlroom)){
echo '<option value="opt1_1">';
echo $getroom['type'];
echo '</option>';
}
?>
===============================
ito pa lang po kasi ung out put na nagawa ko. TIA po sa tutulong.