PHP not writing SQL result to JSON file [duplicate]

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?

have you tried file_put_contents('takeOutItems.json',json_encode($rows)); ? — Jerson
– Jerson, Commented Nov 12, 2021 at 9:27
if it's does not working you'll need to check the directory permission. — Jerson
– Jerson, Commented Nov 12, 2021 at 9:28
Can you try to print the json_encode using echo?, will see if the array is parse into json successfully. — Jerson
– Jerson, Commented Nov 12, 2021 at 9:30
You may see this, I think the possible problem is the encoding stackoverflow.com/questions/19361282/… — Jerson
– Jerson, Commented Nov 12, 2021 at 9:35

nebulator0 · Accepted Answer · 2021-11-12 09:38:10Z

2

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

answered Nov 12, 2021 at 9:38

nebulator0

852 silver badges9 bronze badges

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

2 Comments

Jerson Over a year ago

good work, although you can convert it on utf8 using utf8encode function

Dharman Over a year ago

Please stop using the deprecated utf8 charset. Use utf8mb4

Collectives™ on Stack Overflow

PHP not writing SQL result to JSON file [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related