array(2) {
["admin_id"] => int(970)
["update_time"] => array(2) {
[0] => array(2) {
[0] => string(2) ">="
[1] => int(1756224000)
}
[1] => array(2) {
[0] => string(2) "<="
[1] => int(1756294278)
}
}
}
array(1) {
["admin_id"] => array(2) {
[0] => string(2) "in"
[1] => array(1) {
[0] => int(970)
}
}
}
查询表达式错误:970
改为
array(2) {
["admin_id"] => array(2) { // 修改了这个地方
[0] => string(1) "="
[1] => int(970)
}
["update_time"] => array(2) {
[0] => array(2) {
[0] => string(2) ">="
[1] => int(1756224000)
}
[1] => array(2) {
[0] => string(2) "<="
[1] => int(1756294373)
}
}
}
array(1) {
["admin_id"] => array(2) {
[0] => string(2) "in"
[1] => array(1) {
[0] => int(970)
}
}
dump($where);
dump($whzy);
// ⑥优化替换为下边
$ywcDanCountstatis = Db::name('kehu')
->field('count(*) total_count,admin_id')
->where('status',1)
->where($where)
->where($whzy)
->group('admin_id')
->select(); |
array(2) {
["admin_id"] => int(970)
["update_time"] => array(2) {
[0] => array(2) {
[0] => string(2) ">="
[1] => int(1756224000)
}
[1] => array(2) {
[0] => string(2) "<="
[1] => int(1756294278)
}
}
}
array(1) {
["admin_id"] => array(2) {
[0] => string(2) "in"
[1] => array(1) {
[0] => int(970)
}
}
}
查询表达式错误:970
改为
array(2) {
["admin_id"] => array(2) { // 修改了这个地方
[0] => string(1) "="
[1] => int(970)
}
["update_time"] => array(2) {
[0] => array(2) {
[0] => string(2) ">="
[1] => int(1756224000)
}
[1] => array(2) {
[0] => string(2) "<="
[1] => int(1756294373)
}
}
}
array(1) {
["admin_id"] => array(2) {
[0] => string(2) "in"
[1] => array(1) {
[0] => int(970)
}
}
dump($where);
dump($whzy);
// ⑥优化替换为下边
$ywcDanCountstatis = Db::name('kehu')
->field('count(*) total_count,admin_id')
->where('status',1)
->where($where)
->where($whzy)
->group('admin_id')
->select();