Convert Data from MySQL to JSON using PHP

Question

I am trying to convert data from my DB to JSON with a PHP script. Everything works great on my local environment (MAMP). As soon as I am trying to put things together on my server, my JSON File is empty :(

What I have so far

my php script

<?php

$connection = mysqli_connect("localhost","root","root","angulardb") or die("Error " . mysqli_error($connection));


$sql = "select * from postings";
$result = mysqli_query($connection, $sql) or die("Error in Selecting " . mysqli_error($connection));


    $emparray = array();
    while($row =mysqli_fetch_assoc($result))
    {
        $emparray[] = $row;

    }




  $fp = fopen('menue.json', 'w');
  fwrite($fp, json_encode($emparray));
  fclose($fp);


  echo json_encode($emparray);

?>

By uploading this script to my server (& update the data), I receive an empty JSON file with no response.

Any Idea what can be wrong??? Is there additional configuration necessary on the server side?

Thanks in advance

To me, this sounds like there is a problem with writing permission to the file/folder. — Christian Lundahl, Nov 10 '15 at 12:33
I added write pwemissions for the entire folder + subfolders — Stefan Braun Braun, Nov 10 '15 at 13:11

score 0 · Answer 1 · answered Nov 10 '15 at 13:42

0

Ok, got it .

the missing chsrset=utf8 caused my problem!

$pdo=new PDO("mysql:dbname=db239256x2330361;host=mysql.webhosting38.1blu.de;charset=utf8","s239256_2330361","20dj93lpav+dd");

answered Nov 10 '15 at 13:42

Stefan Braun Braun

29
2

Convert Data from MySQL to JSON using PHP

1 Answers1

Linked