json encoding not working in mysql fetch array

Question

$return_arr = array();
$fetch = mysql_query("select `menu_item_name` from menu_option"); 

while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
    $row_array['id'] = $row['menu_item_name'];


    array_push($return_arr,$row_array);
}

echo json_encode($return_arr);

user4640949 · Accepted Answer · 2015-04-10 08:33:38Z

1

Change this:

From
array_push($return_arr,$row_array);
To
$return_arr = array_push($return_arr,$row_array);

answered Apr 10, 2015 at 8:33

user4640949

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

1 Comment

Vijaykanth Dondapati Over a year ago

the problem is solved json encode only utf-8 charset its not encoding latin_utf_cli

Coreus · Accepted Answer · 2015-04-10 08:28:32Z

0

Run your SQL first and ensure that what you're getting back is in fact a result.

This can be done by either running

select menu_item_name from menu_option

manually in mysql shell or through something like MySQL Workbench.

Also, a print_r($return_arr) won't hurt to debug the issue you're having as the code itself should work fine. JSON_ENCODE works. The problem you're having is that you don't have an array.

Side note: It's better to use some form of ORM instead of writing low-level SQL for yourself. Have a look into Doctrine, Propel or Redbean, and save yourself some headaches.

answered Apr 10, 2015 at 8:28

Coreus

5,6803 gold badges40 silver badges53 bronze badges

Collectives™ on Stack Overflow

json encoding not working in mysql fetch array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related