从mySql数据库返回php中的JSON [英] Return JSON in php from mySql Database

问题描述

我的数据库中有以下数据：

I have the following data in my database:

我想在下面以JSON格式提供日期：

I want to have the date in the JSON format below:

{
    "labels": ["12.11.2016", "13.11.2016", "14.11.2016", ...],
    "temperature": ["12", "35", "27", ...],
    "humidity": ["56", "70", "87", ...]
}

我当前的代码是：

$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
        // set the PDO error mode to exception
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $conn->setAttribute(PDO::ATTR_CASE, PDO::CASE_UPPER);

        //Select the requested data
        $sql = "SELECT date, temperature, humidity FROM `TestData` ORDER BY date ASC ";

        $statement = $conn->prepare($sql);
        $statement->execute();
        $result = $statement->fetchAll(PDO::FETCH_ASSOC);

        //Values returned for JavaScript
        $labels = array();
        $temperature = array();
        $humidity = array();
        $data = array();

        foreach ($result as $row)
        {
            array_push($labels, $row['date'] );
            array_push($temperature, $row['temperature']);
            array_push($humidity, $row['humidity']);
        }
        $result = null;

        //Load data in one single array
        $data['labels'] = $labels;
        $data['temperature'] = $temperature;
        $data['humidity'] = $humidity;
        //echo $data;
        //echo json_encode($labels , JSON_FORCE_OBJECT);
        echo json_encode($data);

但这只给我以下sh * t：

but this gives me only the following sh*t:

有人有想法吗？即使我已经在互联网上搜索了5个小时，我也无法让它工作：/

Does anyone have an idea here? I just can't get it working even if I already searched the internet for like 5 hours :/

推荐答案

尝试：

array_push($labels, $row['DATE'] );
array_push($temperature, $row['TEMPERATURE']);
array_push($humidity, $row['HUMIDITY']);

由于 $ conn->，看起来所有列名都是大写的; setAttribute（PDO :: ATTR_CASE，PDO :: CASE_UPPER）; 。

这篇关于从mySql数据库返回php中的JSON的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！