Wednesday, March 28, 2012

Ajax chained selection Php ,mysl

$(document).ready(function() {
$('#wait_1').hide();
$('#ptselect_v').change(function(){
$('#wait_1').show();
$('#result_1').hide();
$.get("func.php", {
func: "ptselect_v",
drop_var: $('#ptselect_v').val()
}, function(response){
$('#result_1').fadeOut();
setTimeout("finishAjax('result_1', '"+escape(response)+"')", 400);
});
return false;
});
});

function finishAjax(id, response) {
$('#wait_1').hide();
$('#'+id).html(unescape(response));
$('#'+id).fadeIn();
}


link this javascript files and libraries inside header tag
jquery.js
dimensions.js
autocomplete.js"

func.php

// Page load dropdown results

function getTierOne()
{
/*$result = mysql_query("SELECT DISTINCT `district` FROM `tbldistrict` ORDER BY `tbldistrict`.`district` ASC ")
or die(mysql_error());

while($tier = mysql_fetch_array( $result ))

{
echo '';
}
*/


echo '';
echo ' ';
echo ' ';
echo ' ';

}


// First selection results

if($_GET['func'] == "ptselect_v" && isset($_GET['func'])) {
drop_1($_GET['drop_var']);
}

function drop_1($drop_var)
{
include"dbcon.php";
//$result1 = mysql_query("SELECT district_id FROM tbldistrict WHERE district='$drop_var' ") or die(mysql_error());
//$row=mysql_fetch_array($result1);
//$district_id=$row[0];
$result = mysql_query("SELECT id,name FROM `di_le` where Sec_no=$drop_var ORDER BY `di_le`.`name` ASC;") or die(mysql_error());

echo '

';

}

No comments:

Post a Comment