What's supposed to happen: User selects a state, city, and/or radius.
The application then pulls the relevant info and displays it in a table.
The users have the option of selecting available check boxes and clicking submit.
This should mark them as sold.
The problem: I've used foreach to loop the query in each table cell. Now when the user makes selections and clicks submit only one $id (restaurant_id) is being sent to the mark_sold.php page.
select_area.php
<?
include('include/db_con.php');
?>
<html>
<head>
<script type="text/javascript" src="jquery-142.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#city").hide();
$("#state").change( function() {
$("#city").hide();
$("#result").html('Retrieving ...');
$.ajax({
type: "POST",
data: "state=" + $(this).val(),
url: "get_city.php",
success: function(msg){
if (msg != ''){
$("#city").html(msg).show();
$("#result").html('');
}
else{
$("#result").html('<em>No item result</em>');
}
}
});
});
});
</script>
</head>
<form name="FormName" action='available_ads.php' enctype="multipart/form-data" method="post">
<p>
<select id="state" name"state">
<option value="">Choose a State</option>
<option value="AK">Alaska</option>
<option value="AL">Alabama</option>
<option value="AR">Arkansas</option>
<option value="AZ">Arizona</option>
<option value="CA">California</option>
<option value="CO">Colorado</option>
<option value="CT">Connecticut</option>
<option value="DC">District of Columbia</option>
<option value="DE">Delaware</option>
<option value="FL">Florida</option>
<option value="GA">Georgia</option>
<option value="HI">Hawaii</option>
<option value="IA">Iowa</option>
<option value="ID">Idaho</option>
<option value="IL">Illinois</option>
<option value="IN">Indiana</option>
<option value="KS">Kansas</option>
<option value="KY">Kentucky</option>
<option value="LA">Louisiana</option>
<option value="MA">Massachusetts</option>
<option value="MD">Maryland</option>
<option value="ME">Maine</option>
<option value="MI">Michigan</option>
<option value="MN">Minnesota</option>
<option value="MO">Missouri</option>
<option value="MS">Mississippi</option>
<option value="MT">Montana</option>
<option value="NC">North Carolina</option>
<option value="ND">North Dakota</option>
<option value="NE">Nebraska</option>
<option value="NH">New Hampshire</option>
<option value="NJ">New Jersey</option>
<option value="NM">New Mexico</option>
<option value="NV">Nevada</option>
<option value="NY">New York</option>
<option value="OH">Ohio</option>
<option value="OK">Oklahoma</option>
<option value="OR">Oregon</option>
<option value="PA">Pennsylvania</option>
<option value="PR">Puerto Rico</option>
<option value="RI">Rhode Island</option>
<option value="SC">South Carolina</option>
<option value="SD">South Dakota</option>
<option value="TN">Tennessee</option>
<option value="TX">Texas</option>
<option value="UT">Utah</option>
<option value="VA">Vermont</option>
<option value="WA">Washington</option>
<option value="WI">Wisconsin</option>
<option value="WV">West Virginia</option>
<option value="WY">Wyoming</option>
</select>
</p>
<p>
<select id="city" name="city"></select><br>
</p>
<p id="result"> </p>
<input type="text" name="radius" class="formTextbox" size="24"><br>
<input type="submit" name="submit" class="formTextbox" value="Submit">
</form>
</html>available_ads.php (I originally had it set to live update every 5 seconds but it kept clearing my checkboxes)
<?php
// prevent caching (php)
header('Cache-Control: no-cache');
header('Pragma: no-cache');
header('Expires: ' . gmdate(DATE_RFC1123, time()-1));
session_start();
include('include/db_con.php');
?>
<html>
<head>
<meta http-equiv='cache-control' content='no-cache'>
<meta http-equiv='expires' content='0'>
<meta http-equiv='pragma' content='no-cache'>
<title>Available Ads</title>
<style type="text/css">
td.padded {
padding:-5px;
}
</style>
<script type="text/javascript">
function createRequestObject() {
var ro;
var browser = navigator.appName;
if(browser == "Microsoft Internet Explorer"){
ro = new ActiveXObject("Microsoft.XMLHttp");
}else{
ro = new XMLHttpRequest();
}
return ro;
}
var http = createRequestObject();
var httpjob = createRequestObject();
function sndReq(action) {
http.open('get', 'display_area_updater.php?city=<?=$city?>&state=<?=$state1?>&radius=<?=$radius?>');
http.onreadystatechange = handleResponse;
http.send(null);
}
function handleResponse() {
if(http.readyState == 4) {
var response = http.responseText;
document.getElementById('tablesold').innerHTML = response;
}
}
setInterval('sndReq()');
<!--setInterval('sndReq()', 5000);-->
</script>
</head>
<body>
<div id='tablesold'>
Retrieving data
</div>
</body>