How to pass values from json_encode using PHP to Ajax

Question

This is my json file after php encode values:

/database/database.php

[{"id":"1","title":"text","text":"ttexte","image":"dsgdsgs","User_id":"1"},{"id":"2","title":"titles","text":"sfsf","image":"safasfa","User_id":"1"}]

This is my Ajax code /js/database.js

$.ajax({
    url: "/database/database.php",
    type: "GET",
    dataType: 'json',
    crossDomain: "true",
    success: function(result) {
        if (result.type == false) {
            alert("Error occured:" + result.data);
            return false;
        }
        $.each(JSON.parse(result.data), function(index, obj) {
            $("#get-all").append(

                "<div class='span12'><div class='row'><div class='span8'><h4><strong><a href='#'>" + obj.title + "</div></a></strong></h4> </div></div>" +
                "<div class='row'><div class='span2'><a href='#' class='thumbnail'><img src='" + obj.id + "' alt=''></a></div><div class='span10'>" +
                "<p>" + obj.text + "    </div></p></div>")
            console.log(obj.text);
        });

    }
});

I'm in /blogs.php to retrieve values using call <script src="js/database.js"></script>

Console log: XHR finished loading: GET "/database/database.php".

I have already done debug and don't receive values.

Possible duplicate of jQuery AJAX Call to PHP Script with JSON Return — user2033671
– user2033671, Commented Jul 25, 2017 at 18:41
@ProfessorAllman i have already see that posts and dont find the answer, i have already done this call with Nodejs and works, with php don´t. — user8364700
– user8364700, Commented Jul 25, 2017 at 18:45
Did you verify that you are setting the correct header in php header('Content-Type: application/json'); and it is getting returned to the browser? — user2033671
– user2033671, Commented Jul 25, 2017 at 18:54
@ProfessorAllman when i use that the code transforms in html all... — user8364700
– user8364700, Commented Jul 25, 2017 at 19:33
Could you post the full source for database.php? be sure to redact any sensitive information — user2033671
– user2033671, Commented Jul 25, 2017 at 19:42

HSR · Accepted Answer · 2017-07-25 19:06:05Z

0

The result returned using AJAX is already JSON parsed, so the JSON.parse is not required and is the reason why it fails.

Just modify your code to avoid that and you should be fine.

$.ajax({
url: "/database/database.php",
type: "GET",
dataType: 'json',
success: function(result) {
    if (result.type == false) {
        alert("Error occured:" + result);
        return false;
    }
    $.each(result, function(index, obj) {
        $("#get-all").append(
            "<div class='span12'><div class='row'><div class='span8'><h4><strong><a href='#'>" + obj.title + "</div></a></strong></h4> </div></div>" +
            "<div class='row'><div class='span2'><a href='#' class='thumbnail'><img src='" + obj.id + "' alt=''></a></div><div class='span10'>" +
            "<p>" + obj.text + "    </div></p></div>")
        console.log(obj.text);
    });

}
});

edited Jul 25, 2017 at 19:06

answered Jul 25, 2017 at 19:01

HSR

1511 silver badge9 bronze badges

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

5 Comments

user8364700 Over a year ago

Hello, @HSR dont works your script, i have tried and show the same message

HSR Over a year ago

I used test.php instead of /database/database.php, I have updated it now, can you confirm that you've changed that as well?

HSR Over a year ago

Oh, that's weird, I seem be getting the console output after the changes. imgur.com/rMydle3

user8364700 Over a year ago

i´m dont getting that

HSR Over a year ago

Are you getting any errors in your console or is it just blank?

Collectives™ on Stack Overflow

How to pass values from json_encode using PHP to Ajax

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related