要创建排名,我想先计数,然后在字符串中显示重复条目
$orgasql = "SELECT organisateur FROM events ";
$orgareq = $bdd->prepare($orgasql);
$orgareq->execute();
while($eventrow = $orgareq->fetch(PDO::FETCH_ASSOC)) {
$eventorgaas[] = $eventrow['organisateur'];
}
$eventimploded = implode(',',$eventorgaas);
$eventimploded = implode(',',array_unique(explode(',', $eventimploded)));
echo $eventimploded
?>
当前代码返回此结果:
Holyblood,Nessy,Pokégaia,Sorrow,JOHN
我希望结果是:
Holyblood - 2 ,Nessy - 1,Pokégaia - 1,Sorrow -1,JOHN -1
(在我的数据库中有两个“holyblood”,array_unique delete duplica)