php - 如何将sql查询与php数组结合起来？

Question

我一直在努力解决这个问题，但我一个人做不到

所以我有这个 sql 查询:

SELECT * FROM stats WHERE date >= '2014-03-01' and date <= '2014-03-07'

+-----------------------------+
+ date        | visits        +
+-----------------------------+
+  2014-03-02 | 832           +
+  2014-03-03 | 746           +
+  2014-03-06 | 49            +                 
+-----------------------------+

我想将它与一个 php 数组结合起来，所以我得到了这个输出:

$array = array(
    "2014-03-01" => 0,
    "2014-03-02" => 832,
    "2014-03-03" => 746,
    "2014-03-04" => 0,
    "2014-03-05" => 0,
    "2014-03-06" => 49,
    "2014-03-07" => 0,
);

有谁知道如何做到这一点？非常感谢您的帮助

Answer 1

首先创建一个数组:

$array1 = array(
    "2014-03-01" => 0,
    "2014-03-02" => 0,
    "2014-03-03" => 0,
    "2014-03-04" => 0,
    "2014-03-05" => 0,
    "2014-03-06" => 0,
    "2014-03-07" => 0,
);

然后从数据库中获取数组:

$array2 = array(
    "2014-03-02" => 832,
    "2014-03-03" => 746,
    "2014-03-06" => 49,
);

最后得到结果:

$result = array_merge($array1, $array2);