Getting php-generated json from html

Question

I have a form in an html file which sends data to a php file. That php file selects from the database, transforms the results into a json file and sends it back to the html file.

I would like to know how can I get the json from the php; I do get the reply (from the network tab in the inspection menu), but I don't know how to get it (to echo/alert/make a chart with it). Thanks in advance!

This is my code to send the data:

<script type="text/javascript">
    $( function() {
        $( ".datepicker" ).datepicker({
            minDate: new Date(2015, 8 - 1, 25),
            maxDate: "0"
        });
    });

$(function () {
    // On form's submit, takes both input's values...
    $('form').on('submit', function (e) {
        var from = $("#from").val();
        var to = $("#to").val();
        // ...to compare them and displays an error if "to" is smaller than "from"
        if(Date.parse(from) > Date.parse(to)){
            alert("Invalid Date Range");
        }
        else{
            e.preventDefault();
            $.ajax({
                type: 'post',
                url: 'classes/Select.php',
                data: $('form').serialize(),
                success: function () {
                    alert('data sent');
                }
            });
        }
    });
});
</script>

And this is the php part that makes the json (left out all the mysql part and such):

while ($arr = $query->fetch(PDO::FETCH_ASSOC)) {
    echo json_encode($arr);

Have you tried using json_encode()? Can you write your code here? — Chetan Patel
– Chetan Patel, Commented Apr 18, 2017 at 8:18

Junius L · Accepted Answer · 2017-04-18 08:47:08Z

1

Since you are using a loop in your php, create an array that will hold the results, when the loop finishes echo the results with json_encode;

$results = [];
while ($arr = $query->fetch(PDO::FETCH_ASSOC)) {
    $results[] = $arr;
}
echo json_encode($results);

Then in your javascript

    $.ajax({
       type: 'post',
       url: 'classes/Select.php',
       data: $('form').serialize(),
       success: function(data) {
           var results = JSON.parse(data); // convert the results to json
           console.log(results);
       }
   });

edited Apr 18, 2017 at 8:47

answered Apr 18, 2017 at 8:38

Junius L

16.2k6 gold badges61 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Newwt Over a year ago

It works! Might be a dumb question, but why do I have to change my php code? Only to make objects out of the json file?

Junius L Over a year ago

@Newwt so the data can be compatible with both javascript and php. don't forget to mark it as an answer.

delboy1978uk · Accepted Answer · 2017-04-18 08:24:28Z

1

In your javascript ajax call code, you probably have a success: key. Try:

success: function(data) { console.log(data); }

answered Apr 18, 2017 at 8:24

delboy1978uk

12.4k2 gold badges25 silver badges42 bronze badges

2 Comments

Newwt Over a year ago

Nope, doesn't work. It does log the data I send, not the data I receive.

delboy1978uk Over a year ago

Your code in the post has the success: function() with no 'data' in the brackets

Slaiv206 · Accepted Answer · 2017-04-18 08:24:45Z

1

if you get a JSON string use json_decode($json) and you get the value you want:

$json = '{"key-example": 12345}';

$obj = json_decode($json);
print $obj->{'key-example'}; // 12345

answered Apr 18, 2017 at 8:24

Slaiv206

3092 silver badges14 bronze badges

2 Comments

Newwt Over a year ago

I already do, the thing is in the html side, where I don't know what to do to get the php-generated json.

Slaiv206 Over a year ago

make an ajax call and print the response data after convert it into a json with: JSON.parse(data)

Collectives™ on Stack Overflow

Getting php-generated json from html

3 Answers 3

2 Comments

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related