Receive multiple value from php file via ajax call
ajax, javascript, jquery, php
Solution
AJAX code:-
$('#c_select').change(function(){
$.ajax({
type:'post',
url:'get_course_info_db.php',
data: 'c_id='+ $(this).val(),
success: function(value){
var data = value.split(",");
$('#course_name').val(data[0]);
$('#course_credit').val(data[1]);
}
});
});
PHP code:-
<?php
include('db_connection.php');
$c_id = $_POST['c_id'];
$result = mysql_query("SELECT * FROM course WHERE c_id = '$c_id'");
$all_course_data = mysql_fetch_array($result);
$c_name = $all_course_data['c_name'];
$c_credit = $all_course_data['c_credit'];
echo $c_name.",".$c_credit;
exit();
?>
Problem
Below is my ajax call code. I want to send one data in .php file via ajax call and want to get two values from .php file. This two values I want to set in different 'input' tags whose id are 'course_name' and 'course_credit'. Here my ajax call return correct value(real value from DB table) of 'course_name' input tag. But 'MY PROBLEM IS' the value of input tag whose id is 'course_credit' shows 'success'. How can I get the correct value(real value from DB table) of id 'course_credit' ? I have a 'select' tag which id is 'c_select' HTML: ``` <input type="text" name="course_name" id="course_name" value=""/> <input type="text" name="course_credit" id="course_credit" value=""/> ``` AJAX : ``` $('#c_select').change(function(){ $.ajax({ type:'post', url:'get_course_info_db.php', data: 'c_id='+ $(this).val(), success: function(reply_data1,reply_data2){ $('#course_name').val(reply_data1); $('#course_credit').val(reply_data2); } }); }); ``` get_course_info_db.php ``` <?php include('db_connection.php'); $c_id = $_POST['c_id']; $result = mysql_query("SELECT * FROM course WHERE c_id = '$c_id'"); $all_course_data = mysql_fetch_array($result); $c_name = $all_course_data['c_name']; $c_credit = $all_course_data['c_credit']; echo $c_name,$c_credit; exit(); ?> ```