php mysql select 语句；没有得到输出

Question

我想从数据库中输出从应用程序发送的短信总数。

以这种方式:日期 2016-06-09 |共发送 4 |已交付 3 |失败2|

| date       | total_sent | delivered | failed |
+------------+------------+-----------+--------+
| 2016-06-09 |          4 |         3 |      1 |
+------------+------------+-----------+--------+

但是我的 php 代码不起作用。请有人带我...

$sql = mysql_query("SELECT DATE(time_sent) AS date,COUNT(*) as total_sent,SUM(status = 'Success') as delivered,SUM(status = 'failed') AS failed FROM smsdb GROUP BY DATE(time_sent) ");

$result1 = mysqli_query($con, $sql);
$resultarr = mysqli_fetch_assoc($result1);
$time_sent = $resultarr['time_sent'];


echo $time_sent;   

Answer 1

将 $sql 变量设置为字符串:$sql = "SELECT DATE(time_sent) AS 日期,COUNT(*) 作为total_sent,SUM(status = '成功') 已交付,SUM(status = '失败') AS 失败 FROM smsdb GROUP BY DATE(time_sent) ";

mysqli_query 的第二个参数必须是字符串:http://php.net/manual/ro/mysqli.query.php

编辑

您想要 time_sent 的值，但在 $resultarr 中您没有该键，因为您已在 mysql 查询中将其重命名为 date:DATE(time_sent) AS date 。数组的键是:“date”、“total_sent”、“delivered”和“failed”。试试这个:$time_sent = $resultarr['date'];