Can't make a json_encode on a sql result in php

Question

I have the following mysql request in my php file:

 $command = "SELECT weapon_id, weapon_name, weapon_dammage, weapon_munitions FROM weapon;";
 $result = mysqli_query($connection, $command);
 $rows = array();

 while($r = mysqli_fetch_assoc($result)) {
     $rows[] = array(
         'weapon_id' => $r['weapon_id'],
         'weapon_name' => $r['weapon_name'],
         'weapon_dammage' => $r['weapon_dammage'],
         'weapon_munitions ' => $r['weapon_munitions ']
     );
 }

 echo json_encode($rows);

I don't understand why there is nothing returned (I have a blank page). My request is good (tested), and the same code works with anoter request (for example SELECT * FROM player).

Do you know what is the problem and how to solve it?

Thanks a lot!

Make sure you're not having any Fatal error for some reason. Is error reporting on? Also, try `var_dump(json_encode($rows));` instead of `echo` — Rizwan, Feb 16 '17 at 13:49
@MASIDDIQUI No, there is no error. Just a blank page, nothing else.. And var_dump returns 'boolean : false' — iAmoric, Feb 16 '17 at 13:52
Try to remove space and check. 'weapon_munitions' => $r['weapon_munitions'] — user247217, Feb 16 '17 at 13:52
@LucasPierrat try [json_last_error](http://www.php.net/manual/en/function.json-last-error.php) — Rizwan, Feb 16 '17 at 13:52
`ini_set('error_reporting', E_ALL | E_STRICT); ini_set('display_errors', 1); ini_set('html_errors', 1);` on the top and then excute — M A SIDDIQUI, Feb 16 '17 at 13:53
If var_dump returns "boolean: false" as you say, then there's an error with the SQL query. Try running it in a console connection and see what happens. — Ray O'Donnell, Feb 16 '17 at 13:55
@RayO'Donnell but when I copy/paste my request in PhpMyAdmin to test it, it works correctly.. — iAmoric, Feb 16 '17 at 13:56
@RayO'Donnell No, it means the `json_encode` function couldn't work. Many PHP functions return `false` when they can't execute properly. — AymDev, Feb 16 '17 at 13:57
change this `$r['weapon_munitions ']` for this `$r['weapon_munitions']` — Danilo Bustos, Feb 16 '17 at 13:58
@DaniloBustos I remove the blank space, it is not the problem.. — iAmoric, Feb 16 '17 at 13:58
json erro 5 means "Malformed UTF-8 characters, possibly incorrectly encoded". — Rizwan, Feb 16 '17 at 13:59
@LucasPierrat Try [this](http://stackoverflow.com/a/17182431/1541016) — Rizwan, Feb 16 '17 at 14:00
It was a utf8 error yes.. I changed it in my database and the problem is solved.. Thanks for helping me ! — iAmoric, Feb 16 '17 at 14:01
But my database is encoded in utf8. Why there was this problem ? — iAmoric, Feb 16 '17 at 14:02

score 1 · Answer 1 · answered Feb 16 '17 at 15:56

1

Are you using PHP 5.2.0 or higher ? If not, you will have to install the JSON module.

From http://php.net/manual/en/json.installation.php

As of PHP 5.2.0, the JSON extension is bundled and compiled into PHP by default.

You can check your version using phpinfo()

answered Feb 16 '17 at 15:56

Keyvan

71
4

I have PHP 5.6.25 – iAmoric Feb 16 '17 at 16:25

Can't make a json_encode on a sql result in php

1 Answers1