php - 对我的下拉选择进行排序

Question

我下面有这段代码，我该如何修改以对下拉列表进行排序。

<?php
  require_once('includes/init.php');
  $all_sites = find_all('site_info');
?>
<?php

<?php
 if(isset($_POST['add_site'])){
   $req_fields = array('siteid');
   validate_fields($req_fields);
   if(empty($errors)){
     $p_siteid   = remove_junk($db->escape($_POST['siteid']));
     $query  = "INSERT INTO site_table (siteid)";
     $query .=" VALUES ('{$p_siteid}')";

     if($db->query($query)){
       $session->msg('s',"Site Added ");
       redirect('site.php', false);
     } else {
       $session->msg('d',' Sorry failed to add!');
       redirect('site.php', false);
     }
   } else{
     $session->msg("d", $errors);
     redirect('site.php',false);
   }
 }
?>

我的表单 div 正在显示，我认为它是按照列 ID 排序的。

<div class="row">
 <div class="col-md-12">
  <form method="post" action="add_site.php">
      <div class="form-group">
        <div class="input-group">
          <select class="form-control" name="siteid">
           <option value="">Select Site</option>
             <?php foreach ($all_sites as $site): ?>
              <option value="<?php echo (int)$site['id'] ?>">
             <?php echo $site['site_name']; ?></option>
             <?php endforeach; ?>
          </select>
        </div>
      </div>
      <div class="form-group clearfix">
        <button type="submit" name="add_site" class="btn btn-primary">Add Site</button>
      </div>
  </form>
 </div>
</div>

而不是像下面这样显示，

Select Site
2001 
2000
1000
0010
0001

我想像下面的输出一样显示它，

 Select Site
 0001
 0010
 1000
 2000
 2001

谢谢。

Answer 1

您好，请添加排序功能

示例Example

<?php asort($all_sites); ?>
    <select class="form-control" name="siteid">
               <option value="">Select Site</option>
                 <?php foreach ($all_sites as $site): ?>
                  <option value="<?php echo (int)$site['id'] ?>">
                 <?php echo $site['site_name']; ?></option>
                 <?php endforeach; ?>
              </select>