在选择区域看不到结果 - can't see the result in the select area

can't see the result in the select area

本文关键字：结果看不到区域选择 | 更新日期: 2023-09-27

我无法在选择区域看到结果

<?php
require 'config.php';
    $query = "SELECT cat_id, category FROM categories LIMIT 1";
    $result = mysqli_query($con,$query);
    if(!$result){
       echo 'Query failed : '.mysqli_error();
       exit(0);
    } 
                        while($row = mysqli_fetch_assoc($result)) {
                            echo '<select name="cat_id">
    ' . $row['cat_id'] . '
    </select>';
                        }
    mysqli_close($con);
?>

我尝试添加HTML select标签，但它仍然不工作。

不适合选择

echo '<select name="cat_id">
    ' . $row['cat_id'] . '
    </select>';

应该是

echo '<select name="cat_id">';
while($row = mysqli_fetch_assoc($result)) {
    echo  '<option value="'.$row['cat_id'] .'">'.$row['cat_id'].'</option>';
   }
echo '</select>';