How to extract/split part of the data AJAX Success returning

Question

I have this PHP code to select data from a database:

<?php
include './database_connect.php';

$ppid=$_POST['selectPatientID'];

$query="SELECT * FROM patient WHERE p_Id='$ppid'";

$result=  mysqli_query($conn, $query);
while($row=  mysqli_fetch_array($result)){
    echo ($row['p_fname']); 
    echo ' ';
    echo ($row['p_lname']);
}    
?>

But I need to get the p_fname and p_lname values separately. Is there anything I could do to achieve this?

This is my jQuery:

    <script>
                $(document).ready(function () {
                    $('#selectPatientID').on('change', function (event) {
                        event.preventDefault();
//                        alert("Hi");
                        $.ajax({
                            url: "UDPatient.php",
                            type: 'POST',
                            data: {selectPatientID: $('#selectPatientID').val()},
                            dataType: 'html',
                            success: function (result) {
                                $('#patientName').val(result); //in here, how can I get the p_fname and p_lname separetely and put them in two different input fields?
                            }
                        });
                    });
                });
            </script>

`json_encode()` the array of results in php, and `JSON.parse()` the result in javascript — Manav, Oct 18 '17 at 15:49
@chris85: Yes in my `php` file, there are two values I'm getting from database. How can I get them separately? — Jananath Banuka, Oct 18 '17 at 15:52
Either serve XML or JSON from the file. https://stackoverflow.com/questions/17604071/parse-xml-using-javascript or https://stackoverflow.com/questions/4935632/parse-json-in-javascript — chris85, Oct 18 '17 at 15:58
Also you are open to SQL injections, you should parameterize that query. — chris85, Oct 18 '17 at 15:59

usman ikram · Answer 1 · 2017-10-18T16:03:56.547

you have to json_encode

$row =  mysqli_fetch_array($result)){

header('Content-Type: application/json');// header for json encode response
echo json_encode($row);
exit;

Your jQuery ajax code will be:

$.ajax({
   url: "UDPatient.php",
   type: 'POST',
   data: {selectPatientID: $('#selectPatientID').val()},
   dataType: 'json',// to receive data into json format
   success: function (result) {
       alert(result.p_fname);
       alert(result. p_lname);
   }
});

score 0 · Answer 2 · answered Oct 18 '17 at 15:59

You should try something along the lines of

<?php
include './database_connect.php';

$ppid=$_POST['selectPatientID'];

$query="SELECT * FROM patient WHERE p_Id='$ppid'";

$result=  mysqli_query($conn, $query);


$row=  mysqli_fetch_array($result);
echo json_encode($row);
?>

You add the query results into an array $row, which you json_encode() and echo as the result

<script>
    $(document).ready(function () {
        $('#selectPatientID').on('change', function (event) {
            event.preventDefault();
            $.ajax({
                url: "UDPatient.php",
                type: 'POST',
                data: {selectPatientID: $('#selectPatientID').val()},
                dataType: 'html',
                success: function (result) {
                    var jsonResult = JSON.parse(result);
                    var p_fname = jsonResult.p_fname;
                    var p_lname = jsonResult.p_lname;
                    // whatever else
                }
            });
        });
    });
</script>

The json result can be parsed ( or the dataType set as'json' alternatively').

How to extract/split part of the data AJAX Success returning

2 Answers2