时间戳

首页 > 解决方案 > 如何使用 PHP 从数据库中获取下拉菜单的值

php - 如何使用 PHP 从数据库中获取下拉菜单的值

问题描述

我有一个表格，可以存储计划参与者的年龄范围。我需要帮助的地方是，我如何访问年龄范围、计算和显示它？例如：

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.';
            } 
        ?>

我怎样才能得到上面突出显示的结果？

标签： phpmysqlpdo

解决方案

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.

推荐阅读