Ajax Developer.ca







PHP Code


require("Sajax.php");
function getProvinces($CountryID)
{
$cnt=0;

$ProvinceStr.="Province: <select id=\"Provinces\" onChange=\"do_getCities(); return false;\">";
$ProvinceStr.="<option value=\"\">Select a Province</option>";

$ree=mysql_query("SELECT * FROM Province WHERE CountryCode='$CountryID' AND (ProvinceCode!=0 || CountryCode='US')") or die(mysql_error());
while($rww=mysql_fetch_array($ree))
{
$cnt++;

$ProvinceStr.="<option value='" . $rww[ProvinceCode] . "'>" . htmlspecialchars(utf8_encode($rww[ProvinceName])) . "</option>";

}
$ProvinceStr.="</select>";

return $ProvinceStr;
}
function getCities($CountryID, $ProvinceID)
{
if(strlen(trim($ProvinceID)) == 1) $ProvinceID="0" . $ProvinceID;

$CitiesStr.="<select id=\"CityID\">";
$re=mysql_query("SELECT * FROM Countries WHERE ADM1='$ProvinceID' AND CC1='$CountryID' ORDER BY FULL_NAME") or die(mysql_error());
while($rw=mysql_fetch_array($re))
{
$CitiesStr.="<option value='" . $rw[FULL_NAME] . "'>" . htmlspecialchars(utf8_encode($rw[FULL_NAME])) . "</option>";
}
$CitiesStr.="</select>";
return $CitiesStr;
}
sajax_init();
// $sajax_debug_mode = 1;

sajax_export("getProvinces");
sajax_handle_client_request();

 

?>


Javascript Code

<script>
<?
sajax_show_javascript();
?>

function do_multiply_cb(z) {
document.getElementById("z").value = z;
}
function do_getProvinces_cb(prov)
{
document.getElementById("prov").innerHTML = prov;
document.getElementById("city").innerHTML = "City: <input type=\"text\" name=\"City\" value=\"\">";
}

function do_getProvinces()
{
document.getElementById("city").innerHTML = "";
document.getElementById("prov").innerHTML = "Loading Provinces..";
CountryID = document.getElementById("Countries").value;
x_getProvinces(CountryID, do_getProvinces_cb)

// refresh()
}
function do_getNames_cb(thename)
{
document.getElementById("thename").innerHTML = thename;
}
function do_getNames()
{
thename=document.getElementById("thename").value;
document.getElementById("thename").innerHTML = "Creating Name..";
x_getNames(thename, do_getNames_cb)
}
function do_getCities_cb(city)
{
document.getElementById("city").innerHTML = city;
}
function do_getCities()
{
document.getElementById("city").innerHTML = "Loading Cities..";
CountryID = document.getElementById("Countries").value;
ProvinceID = document.getElementById("Provinces").value;
x_getCities(CountryID, ProvinceID, do_getCities_cb)
}

</script>

Get SAjax API