Line 1 :
Line 2 :
Line 3 :
Line 4 :
Line 5 :
Line 6 :
Line 7 :
Line 8 :
Line 9 :
Line 10:
Line 11:
Line 12:
Line 13:
Line 14:
Line 15:
Line 16:
Line 17:
Line 18:
Line 19:
Line 20:
Line 21:
Line 22:
Line 23:
Line 24:
Line 25:
Line 26:
Line 27:
Line 28:
Line 29:
Line 30:
Line 31:
Line 32:
Line 33:
Line 34:
Line 35:
Line 36:
Line 37:
Line 38:
|
<?php
/**
* Connects to the database.
* Return false if connection failed.
* Be sure to change the $database_name. $database_username , and
* $database_password values to reflect your database settings.
*/
function db_connect() {
$database_name = 'mysql'; // Set this to your Database Name
$database_username = 'root'; // Set this to your MySQL username
$database_password = ''; // Set this to your MySQL password
$result = mysql_pconnect('localhost',$database_username, $database_password);
if (!$result) return false;
if (!mysql_select_db($database_name)) return false;
return $result;
}
$conn = db_connect(); // Connect to database
if ($conn) {
$zipcode = $_GET['param']; // The parameter passed to us
$query = "select * from zipcodes where zipcode = '$zipcode'";
$result = mysql_query($query,$conn);
$count = mysql_num_rows($result);
if ($count > 0) {
$city = mysql_result($result,0,'city');
$state = mysql_result($result,0,'state');
}
}
if (isset($city) && isset($state)) {
// $return_value = $city . "," . $state;
$return_value = '<?xml version="1.0" standalone="yes"?><zip><city>'.$city.'</city><state>'.$state.'</state></zip>';
}
else {
$return_value = "invalid".",".$_GET['param']; // Include Zip for debugging purposes
}
header('Content-Type: text/xml');
echo $return_value; // This will become the response value for the XMLHttpRequest object
?>
|
