php 寻找相同日期,php - 如何检查重复的日期？ - SO中文参考 - www.soinside.com

我不希望MYSQL显示重复的日期。

我的日期数组：Array

(

[0] => Array

(

[date] => 2020-05-04 00:00:00

)

[1] => Array

(

[date] => 2020-05-05 00:00:00

)

[2] => Array

(

[date] => 2020-05-03 00:00:00

)

[3] => Array

(

[date] => 2020-05-06 00:00:00

)

[4] => Array

(

[date] => 2020-05-04 00:00:00

)

[5] => Array

(

[date] => 2020-05-05 00:00:00

)

[6] => Array

(

[date] => 2020-05-05 00:00:00

)

)

我的PHP和MYSQLI代码：$c = Database::$database->query("

SELECT

`date`

FROM `payments`

WHERE

`currency` = '{$this->settings->payment->currency}'

AND

WEEK(`date`) = WEEK(CURRENT_DATE())")->fetch_all(MYSQLI_ASSOC);

foreach ($c as $key => $value) {

$current_date[] = $value['date'];

$current_sum[] = Database::$database->query("SELECT COUNT(*) AS sum FROM `payments` WHERE `currency` = '{$this->settings->payment->currency}' AND `date` = '{$value['date']}'")->fetch_assoc();

}

我想做什么？

左侧是我当前的坏处，而右侧是我想要得到的。

工作流程：

我必须获取当前一周的所有日期(而不是重复的日期)。然后，我必须获取本周每个日期的所有SUM(*) AS sum(不重复)。

我的JS：var optionslinechart = {

chart: {

toolbar: {

show: false

},

height: 170,

type: 'line'

},

dataLabels: {

enabled: false

},

stroke: {

curve: 'smooth',

width: [ 8 ]

},

xaxis: {

show: false,

type: 'datetime',

categories: = json_encode($data->current_date, true); ?>,

labels: {

show: false,

},

axisBorder: {

show: false,

},

},

grid: {

show: false,

padding: {

left: 15,

right: 15,

bottom: 20

}

},

colors:['#ffffff'],

series: [

{

name: 'SOD',

data: = json_encode(nestedToSingle($data->current_sum), true); ?>,

}

],

tooltip: {

x: {

format: 'dd/MM/yy HH:mm'

}

}

};

var chartlinechart = new ApexCharts(

document.querySelector("#chart-widget1"),

optionslinechart

);

chartlinechart.render();