我有一个表格,用于存储项目参与者的年龄范围。我需要帮助的领域是,我如何访问年龄范围、计数和显示它?例如:
10-19岁-5人,
20-29岁-2人等
这是我检索列表的代码
<?php
try{
// get the age range from the database
$ageQuery = "SELECT ageRange FROM event WHERE eventUserName = :eventUserName ORDER BY id DESC";
$getAges = $conn->prepare($ageQuery);
$getAges->bindValue(':eventUserName', $eventusername);
$getAges->execute();
}
catch (PDOException $e)
{
$error[] = 'Invalid data supplied.';
}
?>
如何获得上面突出显示的结果?
try{
// get the age range from the database
$ageQuery = "SELECT ageRange FROM event WHERE eventUserName = :eventUserName ORDER BY id DESC";
$getAges = $conn->prepare($ageQuery);
$getAges->bindValue(':eventUserName', $eventusername);
$getAges->execute();
}
catch (PDOException $e)
{
$error[] = 'Invalid data supplied.';
}
if($getAges->rowCount() >= 1)
{
$rowAge = $getAges->fetchAll(PDO::FETCH_ASSOC);
}
if(!empty($rowAge)) $rowAge = array_column($rowAge, 'ageRange');
此区域进入页面的html侧。
$rowGender = array_count_values($rowGender);
foreach($rowGender as $key => $val){
echo "$key" . ' <span class="badge">' . "$val" . '</span>' . "<br>";
}
} else{
echo '<span class="badge">' . "Not Available!" . '</span>';
}
你应该期待这样的结果:
Age Distribution<br/>
20 - 29 Years - 1<br/>
30 - 39 Years - 2<br/>
40 - 49 Years - 1<br/>
The number indicate the frequency of people within the stated age range. Please note that this is PHP7 and some radical changes were made to the version.