查找重复的数据

admin8个月前Thinkphp389

$data = Db::name('about_product_list')->field('id,title,count(id) as num')->group('title')->having('num > 1')->select()->toArray();
$ids_array = [];
$max_array = [];
foreach ($data as $k => $v) {
   $ids = Db::name('about_product_list')->where(['title' => $v['title']])->column('id');
   $max = max($ids);
   $max_array = array_merge($max_array, (array)$max);
   $ids_array = array_merge($ids_array, $ids);
}

$valuesOnlyInArray1 = array_diff($max_array, $ids_array);
$valuesOnlyInArray2 = array_diff($ids_array, $max_array);
$uniqueValues = array_merge($valuesOnlyInArray1, $valuesOnlyInArray2);

相关文章

文章中图片路径替换

if ($list['post_content']) { $list['post_content'] = html_entity_decode($list['post_content']);...

fastadmin上传图片并压缩并加水印

public function image() { // $url = 'uploads/20241026/8f32aebb8be904c5c01ea80de534880...

关注公众号登录

/* * 服务端生成带唯一标识二维码并将唯一标识返回给前端 */ public function wx_code() { $scene_str...

支付宝生成支付二维码

public function alipay($pay_order_no = '20241114123331000000195475', $uid = 1, $url = '') {...

thinkphp 加cache锁

$lockKey = 'user_lock_requirement' . $this->user_id; $isLocked = Cache::get($lockKey); if ($isLo...

微信卡卷html 领取的签名

/* * 创建签名 */public function sign(){    $cardId = 'p7YU46qidv5_baigH0Ds4ObP7MDg'; &...