你想做这样的事情吗?
$return_arr = array();$fetch = mysql_query("SELECt * FROM table");while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) { $row_array['id'] = $row['id']; $row_array['col1'] = $row['col1']; $row_array['col2'] = $row['col2']; array_push($return_arr,$row_array);}echo json_enpre($return_arr);它以以下格式返回json字符串:
[{"id":"1","col1":"col1_value","col2":"col2_value"},{"id":"2","col1":"col1_value","col2":"col2_value"}]或类似这样的东西:
$year = date('Y');$month = date('m');$json_array = array(//Each array below must be pulled from database //1st record array( 'id' => 111, 'title' => "Event1", 'start' => "$year-$month-10", 'url' => "http://yahoo.com/"), //2nd record array( 'id' => 222, 'title' => "Event2", 'start' => "$year-$month-20", 'end' => "$year-$month-22", 'url' => "http://yahoo.com/"));echo json_enpre($json_array);


