PHP to JSON encode with associative array

Question

require "constant.php";
require "database.php";
$sql = "select e.*, b.booth_address, ba.bank_full_name from $app_booth_enrolment e
left join $app_booth_info b on e.booth_id=b.booth_id
left join $app_bank_info ba on e.bank_id=ba.bank_id";
$result = $conn->query($sql);
if($result->num_rows > 0){
    $data = array();
    while($row = $result->fetch_assoc()){
        array_push($data,$row);
    }
    echo $data = json_encode($data);  
    var_dump(json_encode($data));
}else{
    $data['status'] = "No terminal found";
    echo $data = json_encode($data);
}

The echo json_encode($data); print nothing but print_r($data) print an array. How to convert the data array to json format.

try using yii2 encode() function: yiiframework.com/doc-2.0/… — Insane Skull
– Insane Skull, Commented Aug 5, 2015 at 6:05
If that is the case you should then call json_last_error_msg() to see what's gone wrong — Havelock
– Havelock, Commented Aug 5, 2015 at 6:54

smottt · Accepted Answer · 2015-08-05 07:19:10Z

3

Well I found the solution.

Havelock suggested to print json_last_error_msg() and I found malformed UTF-8 characters, possibly incorrectly encoded.

I am using MySQLi so I have to put this line in after database connection for character formatting: mysqli_set_charset($conn, "utf8");.

Thanks Havelock.

edited Aug 5, 2015 at 7:19

smottt

3,33011 gold badges41 silver badges47 bronze badges

answered Aug 5, 2015 at 7:13

Asif Jafri Mohammad Fahim

979 bronze badges

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

Collectives™ on Stack Overflow

PHP to JSON encode with associative array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related