current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

My PHP script, 'getNews.php', (which works when I run it in the terminal and returns the correct data) is as follows:

<?php
header('Content-Type: application/json');

$db = new PDO('mysql:host=hostname;dbname=table', 'name', 'password');

$sql = "SELECT * from `news` ORDER BY date";
$result = $db->query($sql);

echo json_encode($result->fetchAll(PDO::FETCH_ASSOC));
?>

In my Javascript (I have JQuery loaded), I am attempting to pull this data in the following manner:

$(document).ready(function() {
    $.getJSON("getNews.php", function(data) {
        console.log(data);
    });
});

which does nothing. When I change it to:

$(document).ready(function() {
    $.get("getNews.php", function(data) {
        console.log(data);
    });
});

It writes the entire text of the php script to the console. Basically, it doesn't seem to be executing the php script or retrieving the json object at all. Thoughts?

share|improve this question
    
You have a webserver and PHP installed and configured to serve PHP files? –  AbraCadaver Dec 9 '13 at 19:40
    
JSON.parse(data); inside the return function if php is working. –  cocco Dec 9 '13 at 19:40
1  
Your web server isn't properly configured to parse PHP files. –  nickb Dec 9 '13 at 19:40
    
I think you are confusing apples and oranges. console log the whole php website? –  user3071591 Dec 9 '13 at 19:43

2 Answers 2

up vote 0 down vote

Do you have a web server (like or ) installed? "It writes the entire text of the php script to the console." = You aren't invoking a PHP processor. Are you loading it like file:///something, or via http://something?

If you are using HTTP, make sure your web server knows to process PHP files. This usually involves editing a .ini or .cfg file; I can't tell which, because you don't mention what web server you are using.

share|improve this answer
    
I am loading it via something because with file:///something I get a same origin policy error. I'm using my school's web server so I'm not actually sure how to modify that. –  user3084230 Dec 9 '13 at 19:46
    
Then you may not have PHP hooked up to your webserver. What happens if you put this in a page and load it? <?php echo "foo"; ?> –  Ed Cottrell Dec 9 '13 at 19:48
    
Hmm, it seems to just comment out the php. I will contact somebody to see if I need to configure the site to run php somehow. –  user3084230 Dec 9 '13 at 19:51
    
There you go; it's not interpreting the PHP, but is simply serving it up as though it were HTML. –  Ed Cottrell Dec 9 '13 at 19:53
up vote 0 down vote

It writes the entire text of the php script to the console

It could be that your server doesnt have php installed/configured. If thats not the case then see if this works for you

function prsJSN() {
    $.ajax({
        type: "get",
        url: "getNews.php",
        success: function(json) {
            var dataArray = jQuery.parseJSON(json);
        },
        error: function(request, status, error) {
            alert(request.responseText);
        }
    });
}
share|improve this answer
1  
Could also be missing <?php ?> tags –  Señor Reginold Francis Dec 9 '13 at 19:58
    
@SeñorReginoldFrancis good point. It could be as simple as that, but theyre there in the question –  dudemanbearpig Dec 9 '13 at 20:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.