Monday, 3 September 2018
Subscribe to:
Post Comments (Atom)
$.post
to retrieve multiple data from MySQL. I can't seem to get this working. How do I retrieve multiple data using jquery-ajax from MySQL?$e = $_POST['stu'];
$sq ="SELECT physics, chemistry, agriculture FROM subjects WHERE student = :student";
$stmt = $getdb->prepare($sq);
$stmt->execute(array(':student'=>"123456"));
$rslt = $stmt->fetchAll();
$sd=array();
foreach($rslt as $val){
$sd[] = $val;
}
echo json_encode($sd);
$.post('my.php',
{
stu:"test"
},
function(data){
$.each(data,function(ab){
alert(ab.physics+" || "+ab.chemistry+" || "+item.agriculture);
});
});
echo json_encode(Array($first_array,$second_array), JSON_FORCE_OBJECT);
function(data) {
var my_obj = JSON.parse(data);
var first_arr = my_obj[0];
var second_arr = my_obj[1];
}
Hello Friends! I am Ramana a part time blogger from Hyderabad.
0 comments:
Post a Comment