PHP array sort / select option form

Question

I have a form in PHP. It is unsorted. I would like to sort it. How would I go by it. This is the following PHP code I have. Thanks for help in advance.

<select id="school_name" name="school_name">
    <option value="">Select School</option>
    <?php for($c=0; $c<sizeof($school_details); $c++){?>                                    
    <option value="<?php echo stripslashes($school_details[$c]["title"]); ?>" 
    <?php if($school_details[$c]["title"]==$appInfo["school_name"]){?> selected="selected" <?php } ?> ><?php echo stripslashes($school_details[$c]["title"]); ?>
    </option>                                 
    <?php } ?>
</select>

possible duplicate of [Sort array by value alphabetically php](http://stackoverflow.com/questions/1673259/sort-array-by-value-alphabetically-php) — Derek, Jun 03 '14 at 21:52
the school name are showing according to the order I have entered in the db. Now would like to alphabetically order them when user is selecting school name — JNL, Jun 03 '14 at 21:53
How do you query the database? With most databases its trivial to change order of the result set with some query parameters (like `ORDER BY` in SQL). — jsalonen, Jun 03 '14 at 21:54

Hamid · Answer 1 · 2016-10-23T15:46:53.600

try somthing like this:

$str = "<select id='school_name' name='school_name'>";
    $options = "";
    for($i = 0; $i<10;$i++)
    {
        $RandomNum = rand(0, 100);
        $options = "" . $options . ("<option value='$RandomNum'>&nbsp" . $RandomNum . "&nbsp </option>\n");
    }

    $optionsArray = explode("\n", $options);
    natsort($optionsArray);
    $sorted_option = implode("|",$optionsArray);

    $select = $str.$sorted_option."</select>";

    echo $select;

score 0 · Accepted Answer · answered Jun 03 '14 at 22:02

0

PHP provides a number of methods for sorting: http://www.php.net/manual/en/array.sorting.php

answered Jun 03 '14 at 22:02

wogsland

9,106
19
57
93

it took me a while but I found the Query so was able to reorder it in jsalonen way – JNL Jun 03 '14 at 23:01

score 0 · Answer 3 · answered Jun 03 '14 at 22:33

You could implement a user defined sort to achieve this. Assuming you want to sort by the value of the 'title' element you would simply add this before your opening select tag:

<?php
uasort($school_details,'cmp');
function cmp($a,$b){
  if($a['title'] == $b['title']){return 0;}
  return ($a['title'] < $b['title']) ? -1 : 1; 
}
?>

PHP array sort / select option form

3 Answers3