json encodes aray

Question

Okay I have been struggling with this for hours. What I am doing is creating array of what I call objects that can be moved around on a calendar.

Below is my code

$year = date('Y');
$month = date('m');

echo json_encode(array(


    array(
        'id' => 111,
        'title' => "Event3",
        'start' => "$year-$month-10",
        'url' => "http://domain.com/"
    ),

    array(
        'id' => 222,
        'title' => "Event2",
        'start' => "$year-$month-20",
        'end' => "$year-$month-22",
        'url' => "http://domain.com/"
    )

));

Now here is my problem. I need to loop through a mysql database to retrieve the information for each object. For some reason I can't get this to work. Please help

Thanks Stan

Answer 1

Have you tried something like this?:

$mysqli = new mysqli ( 'Host', 'User', 'Pass', 'dB');

$myq = $mysqli ->query ( 'SELECT field1, field2, field3 FROM table' );

$arr_result = array();

while ( $myr = $myq->fetch_assoc () ) {
    $array = array(
      'field1' => $myr['field1'],
      'field2' => $myr['field2'],
      'field3' => $myr['field3'],
    );
    $arr_result[] = $array;
}

echo json_encode($arr_result);

Answer 2

If it's only the json_encode() bit that's failing, it could be due to a character encoding issue. The json_encode() function requires that all string members be valid UTF8 strings. From the json_encode() documentation:

This function only works with UTF-8 encoded data.

If your relevant database objects aren't UTF8, you'll see the function call fail.