在PHP中从MySQL结果创建没有重复项的数组 [英] Creating An Array Without Duplicates From A MySQL Result in PHP

问题描述

我正在尝试使用PDO从PHP的MySQL数据库中执行一条select语句.我成功地使用查询结果创建了一个数组.但是，然后，我想过滤出具有相同日期的重复条目，从而创建一个日期数组.

I am trying to do a select statement from my MySQL DB in PHP using PDO. I successfully create an array with the query results. But then, I want to filter out duplicate entries with the same date, thus creating an array of dates.

function grabUsefulDates() {
$sql = "SELECT DATETIME, pointcount FROM `fjbarrett`";
$sql_array = dbSelect($sql);
$datesarray = array();
$i = 0;
while($i < count($sql_array)) {
    if (count($datesarray) == 0) {
        $datesarray[] = datetimeConvertToDate($sql_array[$i]['DATETIME']);
        echo "rollone";
    } else {
        foreach ($datesarray as $f => $date) {
            if ($date !== datetimeConvertToDate($sql_array[$i]['DATETIME'])) {
                echo $date;
                echo " " . datetimeConvertToDate($sql_array[$i]['DATETIME']);
                echo "<br>";
                $datesarray[] = datetimeConvertToDate($sql_array[$i]['DATETIME']);
            }
        }
        }
        $i++;
    }
var_dump($datesarray);
}

该代码将不会运行，但是当我在foreach循环中删除添加到数组"行时，它将运行.有什么建议吗?

This code will not run, but when I remove the "add to array" line within the foreach loop, it will run. Any suggestions?

推荐答案

只需使用此查询:

SELECT DISTINCT DATETIME, pointcount FROM `fjbarrett`;

这篇关于在PHP中从MySQL结果创建没有重复项的数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！