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(); ?> ```

Original source