开发者社区> 问答> 正文

如何从MySQL数据库构建JSON数组?mysql

好的,我一直在绞尽脑汁尝试从mysql构建JSON数组。数组必须采用以下格式。我正在使用fullcalendar,并希望使日历上的事件动态化。下面是构建数组的代码,但当前它无法从mysql获取信息

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

echo json_encode(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/"
)

));

展开
收起
保持可爱mmm 2020-05-17 11:38:32 613 0
1 条回答
写回答
取消 提交回答
  • 你想做这样的事情吗?

    $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_encode($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/" ),来源:stack overflow

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

    )

    );

    echo json_encode($json_array);

    2020-05-17 11:43:08
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像