php - 下拉选择问题

Question

以下下拉列表中填充了来自 sql 数据库的数据:

<form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>" method="post">
    <select name="Select" id="vals" onchange="this.form.submit()" class="btn btn-warning">
        <option value="">-- Select Country --</option>
        <?php 
           $user=new User(); 
           $sql5=DB::getInstance()->get('country', array('user', '=', $user->data()->username)); 
           if (!$sql5->count()) {
             echo 'No data'; 
           } else { 
             foreach ($sql5->results() as $sql5) { ?>
               <option value="<?php echo $sql5->name;?>">
               <?php echo $sql5->name;?></option>';
        <?php }
           } ?>
    </select>
</form>
</div>

然后用户从下拉列表中进行选择，以便输出连接到所选数据的信息:

<? php
if (isset($_POST['Select']) && !empty($_POST['Select'])) {

    $userSelection = $_POST['Select'];
    $sql = DB::getInstance() - > get('country', array('country', '=', $userSelection));
    if (!$sql - > count()) {
        echo 'no data';
    } else {
        foreach($sql - > results() as $sql) {
            echo 'data';
        }

当我从下拉列表中单击一个选项时，没有任何结果。问题出在 $userSelection 上，这是一个空格问题。当我用“中国”替换 $userSelection 时，数据出来了，但是当我尝试时，“中国”什么也没有出来，只有在它前面有一个空格时它才有效。我还检查了我的数据库，值中没有空格。

Answer 1

foreach ($sql5->results() as $sql5) { ?>

You are trying to iterate $sql5->results() and setting the child with the same variable name as the parent, thus replacing the parent. On the other iteration you are doing the same... try:

<select name="Select" id="vals" onchange="this.form.submit()" class="btn btn-warning">
  <option value="">-- Select Country --</option>
  <?php 
  $user=new User(); 
  $sql5=DB::getInstance()->get('country', array('user', '=', $user->data()->username)); 
  if (!$sql5->count()) {
    echo '<option value="no-data">No data</option>'; 
  } else { 
    foreach ($sql5->results() as $item) { 
       echo '<option value="'.$item->name.'">'.$item->name.'</option>';
    }
 }
 ?>
</select>