PHP JSON_Encode() returns NULL with UTF-8 (Array within an Array)

Question

I'm trying to retrieve an array from my database, but keep getting returned NULL values or nothing at all.

I have tried converting the entire database with UTF-8 unicode, numerous different methods, and hosting sites.

The response i am getting with print_r and json_encode is as follows:

Array
(
[success] => 
[0] => Array
    (
        [lat] => 
        [lng] => 
        [value] => 
    )

[1] => Array
    (
        [lat] => 
        [lng] => 
        [value] => 
    )

[2] => Array
    (
        [lat] => 
        [lng] => 
        [value] => 
    )

[3] => Array
    (
        [lat] => 
        [lng] => 
        [value] => 
    )

[4] => Array
    (
        [lat] => 
        [lng] => 
        [value] => 
    )

)

0No error{"success":false,"0":{"lat":null,"lng":null,"value":null},"1"{"lat":null,"lng":null,"value":null},"2":{"lat":null,"lng":null,"value":null},"3":{"lat":null,"lng":null,"value":null},"4":{"lat":null,"lng":null,"value":null}}

My php code:

<?php
header('Content-Type: application/json');
$con = mysqli_connect("aaa", "bbb", "ccc", "ddd");

//Sets charset for JSON parsing
//no need anymore, database is utf8_unicode_ci already
//$charset = mysql_query("SET CHARACTER SET utf8");
//utf8_encode($arrItem);

$statement = mysqli_prepare($con, "SELECT * FROM markers    ORDER BY marker_id");
mysqli_stmt_execute($statement)  or die(mysqli_error($con));

$arrRows = array();
$arryItem = array();
$arrRows["success"] = false;
$arryItem["success"] = false;

mysqli_stmt_bind_result($marker_id,$lat,$lng,$value);

    while(mysqli_stmt_fetch($statement)) {
      $arrRows[] = compact('marker_id','lat','lng','value');
    }

    print_r($arrRows);
    echo json_last_error();
    echo json_last_error_msg();
    echo json_encode($arrRows);
?>

The values supposed to be returned are these:

All help is much appreciated, really need to solve this!

If there is something i didn't explain well enough or you need additional info, please let me know. I could post the other methods i tried for my while loop, but was told that using compact() was the most optimal way to do it.

Have you checked your error logs?

Jay Blanchard
– Jay Blanchard

2016-11-07 13:14:05 +00:00
Commented Nov 7, 2016 at 13:14 — Jay Blanchard
– Jay Blanchard, Commented Nov 7, 2016 at 13:14

Jesperhag · Accepted Answer · 2016-11-07 13:16:57Z

1

You need to pass $statement as the first argument to your mysqli_stmt_bind_result() call when using it in a procedural way.

answered Nov 7, 2016 at 13:16

Jesperhag

3232 silver badges12 bronze badges

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

1 Comment

Simon A. Callaghan Jensen Over a year ago

Wow, that actually worked. I feel like an idiot now. Thanks!

Collectives™ on Stack Overflow

PHP JSON_Encode() returns NULL with UTF-8 (Array within an Array)

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