What I’m trying to solve:
User, inputs a zipcode like 08212, or any US zipcode for that matter and jquery UI Autocomplete
calls this source file:
../src/php/registration/getFanLoc.php
, that file does a query against the database for certain fields (described below) based on the zipcode entered.
Have a form/jquery on index.php :
Assume that all the jquery UI code is already in this file
<script type="text/javascript">
$(document).ready(function()
{
$('#zip').autocomplete({
source: "../src/php/registration/getFanLoc.php",
maxLength: 5
});
});
</script>
<form method="post" id="FanDetail">
<div class="ui-widget">
<label for="zip">Zip: </label>
<input id="zip" name="zipcode" value="US Zipcode" onFocus="clearText(this)" /><br />
</div>
</form>
the getFanLoc.php file - that queries mysql for any records corresponding to the 5 digit zipcode entered:
<?php
try{
///////////////////////////////////////////////////////////
$zip = mysql_real_escape_string($_POST['zipcode']); //////
///////////////////////////////////////////////////////////
require_once('../../cfg/dbi.php') or die('Cant require dbi');
$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$sth = $dbh->prepare(
'SELECT fanDetLocID, fanDetLocCity, fanDetLocState FROM fanDetailLocation WHERE fanDetLocZip = ?');
$sth->bindParam(1, $zip);
$sth->execute();
while ($res = $sth->fetch(PDO::FETCH_ASSOC)) {
$location = "<a href='#' value='$res['fanDetLocID']>".$res['fanDetLocCity'].", ".$res['fanDetLocState']."</a>";
}
echo $location;
}
catch(PDOException $e){
file_put_contents('../../../PDODBConnectionErrors.txt', 'ERROR: [getFanLoc.php] about '.$e->getMessage().'<br>', FILE_APPEND);
}
?>
I was originally having trouble, because it wasn’t connecting to the database and PDODBConnectionErrors.txt
had the errors, but I’ve since
FIXED
that part, and now it doesnt do anything, but now doesnt throw an error in the file either.
Anyone see what I’m doing wrong?
I’m pretty newbie working with the
autocomplete jQuery UI widget
, so go easy on me