PHP not writing SQL result to JSON file

Question

What I am trying to achieve is to simply put all the rows of a mysqli result to a JSON file.

My code looks like this:

$sth = mysqli_query($mysqli, "SELECT * FROM table");
$rows = array();
while($r = mysqli_fetch_assoc($sth)) {
    $rows[] = $r;
}
print_r($rows);
$mysqli->close();
$fileobj = fopen("takeOutItems.json", 'w');
fwrite($fileobj,json_encode($rows));
fclose($fileobj);

printing the $rows arrays shows data correctly. fwrite, however, does not change anything in takeOutItems.json.

What am I doing wrong?

@Jerson yes, every single data field is shown in the browser. Updated my issue's description based on your question. — nebulator0, Nov 12 '21 at 09:25
Is it possible that it has to do something with UTF8? there are some fields that show � signs instead the actual characters? — nebulator0, Nov 12 '21 at 09:26
have you tried file_put_contents('takeOutItems.json',json_encode($rows)); ? — Jerson, Nov 12 '21 at 09:27
if it's does not working you'll need to check the directory permission. — Jerson, Nov 12 '21 at 09:28
Can you try to print the json_encode using echo?, will see if the array is parse into json successfully. — Jerson, Nov 12 '21 at 09:30
echo json_encode($rows) not printing anything. Checked write permissions with is_writable and it is writeable. — nebulator0, Nov 12 '21 at 09:32
You may see this, I think the possible problem is the encoding https://stackoverflow.com/questions/19361282/why-would-json-encode-return-an-empty-string — Jerson, Nov 12 '21 at 09:35
That was it! An encoding error resulted the errors. Thank you! — nebulator0, Nov 12 '21 at 09:38

score 2 · Accepted Answer · answered Nov 12 '21 at 09:38

2

The issue was that some data elements were not displayed correctly. Adding $mysqli->set_charset("utf8"); resolved the issue.

answered Nov 12 '21 at 09:38

nebulator0

85
8

1

good work, although you can convert it on utf8 using utf8encode function – Jerson Nov 12 '21 at 09:38
1

Please stop using the deprecated `utf8` charset. Use `utf8mb4` – Dharman Nov 12 '21 at 13:16

PHP not writing SQL result to JSON file

1 Answers1