Getting data from mysql into JSON using PHP works locally but not on server

Question

My code works in 100% locally and returns answer looks like:

[{"id":"1","zuzycie":"40"},{"id":"3","zuzycie":"83.333333333333"}]

The same structure of files and codes are on the server. I don't have a problem with connect to database, so the path is fine. But code on the server is returning [null,null,null,null,null]. Does anyone knows how to fix it?

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

    require_once "../polaczenie.php";

    //get connection
    $mysqli = @new mysqli($host,$db_user,$db_password,$db_name);

    if(!$mysqli){
        die("Connection failed: " . $mysqli->error);
    }

    //query to get data from the table
    $query = sprintf("SELECT id, zuzycie FROM zuzycie_paliwa ORDER BY id ");

    //execute query
    $result = $mysqli->query($query);

    //loop through the returned data
    $data = array();
    foreach ($result as $row) {
        $data[] = $row;
    }

    //free memory associated with result
    $result->close();

    //close connection
    $mysqli->close();

    //now print the data
    print json_encode($data);
?>

Do you have data in your server db? var_dump your $data variable. — gaganshera
– gaganshera, Commented May 10, 2017 at 20:11

wogsland · Accepted Answer · 2017-05-10 20:13:42Z

1

I have my doubts about it working locally, because you're trying to iterate through a mysqli result. Try replacing your foreach loop with

while ($row = $result->fetch_assoc()) {
    $data[] = $row;
}

answered May 10, 2017 at 20:13

wogsland

9,53121 gold badges63 silver badges99 bronze badges

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

1 Comment

Don't Panic Over a year ago

Iterator support was added to mysqli_result in 5.4. It probably did work in the OP's local environment because their PHP version was newer than that, and vice versa on their host's server.

Collectives™ on Stack Overflow

Getting data from mysql into JSON using PHP works locally but not on server

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related