Home >Backend Development >PHP Tutorial >How to use PHP array sorting function array_multisort to sort tables_PHP tutorial
What we bring to you today is a The prototype of the function is array_multisort($sortKeyArray,$ascOrDesc,$sortArray). The first parameter in the PHP array sorting function array_multisort is for A sort column array needs to be constructed to maintain the corresponding relationship between the array key values. The second parameter is a predefined constant, SORT_ASC - sort in ascending order, SORT_DESC - sort in descending order, and the third parameter is the array to be sorted. There is another parameter that can be omitted, which is the sorted data type, which is skipped here. It will become clear if you look at the following example.
<ol class="dp-xml"> <li class="alt"> <span><strong><font color="#006699"><span class="tag"><?</SPAN><SPAN class=tag-name>php</SPAN></FONT></STRONG><SPAN> </SPAN></SPAN><LI class=""><SPAN> </SPAN><LI class=alt><SPAN>class Storage </SPAN><LI class=""><SPAN> { </SPAN><LI class=alt><SPAN> function getSellList() </SPAN><LI class=""><SPAN> { </SPAN><LI class=alt><SPAN> global $db; </SPAN><LI class=""><SPAN> $db-</SPAN><SPAN class=tag><STRONG><FONT color=#006699>></span></font></strong></span><span>query("set names utf8"); </span> </li> <li class="alt"> <span> $db-</span><span class="tag"><strong><font color="#006699">></font></strong></span><span>query("select * from sold_record"); </span> </li> <li class=""> <span> while ($</span><span class="attribute"><font color="#ff0000">row</font></span><span>=$db-</span><span class="tag"><strong><font color="#006699">></font></strong></span><span>get_array()) </span> </li> <li class="alt"><span> { </span></li> <li class=""><span> $array[]=$row; </span></li> <li class="alt"><span> } </span></li> <li class=""> <span> $db-</span><span class="tag"><strong><font color="#006699">></font></strong></span><span>free(); </span> </li> <li class="alt"><span> return $array; </span></li> <li class=""><span> } </span></li> <li class="alt"><span> } </span></li> <li class=""><span> </span></li> <li class="alt"> <span>$</span><span class="attribute"><font color="#ff0000">storage</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">new</font></span><span> Storage(); </span> </li> <li class=""> <span> $</span><span class="attribute"><font color="#ff0000">sellList</font></span><span>=$storage-</span><span class="tag"><strong><font color="#006699">></font></strong></span><span>getSellList(); </span> </li> <li class="alt"> <span> foreach ($sellList as $</span><span class="attribute"><font color="#ff0000">key</font></span><span> =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> $row) </span> </li> <li class=""><span> { </span></li> <li class="alt"><span> $cust[$key] = $row['customer_id']; </span></li> <li class=""><span> $prod[$key] = $row['product']; </span></li> <li class="alt"><span> $pty[$key] = $row['ptype']; </span></li> <li class=""><span> $sdt[$key]=$row['sell_date']; </span></li> <li class="alt"><span> } </span></li> <li class=""> <span> $</span><span class="attribute"><font color="#ff0000">asdes</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">"yes"</font></span><span>; </span> </li> <li class="alt"><span> if($_GET[up]=="yes") </span></li> <li class=""><span> { </span></li> <li class="alt"> <span> $</span><span class="attribute"><font color="#ff0000">asdes</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">"no"</font></span><span>; </span> </li> <li class=""> <span> $</span><span class="attribute"><font color="#ff0000">sort</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">SORT_DESC</font></span><span>; </span> </li> <li class="alt"><span> } </span></li> <li class=""><span> elseif($_GET[up]=="no") </span></li> <li class="alt"><span> { </span></li> <li class=""> <span> $</span><span class="attribute"><font color="#ff0000">asdes</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">"yes"</font></span><span>; </span> </li> <li class="alt"> <span> $</span><span class="attribute"><font color="#ff0000">sort</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">SORT_ASC</font></span><span>; </span> </li> <li class=""><span> </span></li> <li class="alt"><span> } </span></li> <li class=""><span> </span></li> <li class="alt"><span> switch ($_GET[order]) </span></li> <li class=""><span> { </span></li> <li class="alt"><span> case "cname": </span></li> <li class=""><span> array_multisort($cust,$sort,$sellList); </span></li> <li class="alt"><span> break; </span></li> <li class=""><span> case "product": </span></li> <li class="alt"><span> array_multisort($prod,$sort,$sellList); </span></li> <li class=""><span> break; </span></li> <li class="alt"><span> case "ptype": </span></li> <li class=""><span> array_multisort($pty,$sort,$sellList); </span></li> <li class="alt"><span> break; </span></li> <li class=""><span> case "date": </span></li> <li class="alt"><span> array_multisort($sdt,$sort,$sellList); </span></li> <li class=""><span> break; </span></li> <li class="alt"><span> } </span></li> <li class=""><span> </span></li> <li class="alt"> <span> </span><span class="tag"><strong><font color="#006699">?></font></strong></span><span> </span> </li> </ol>
The above code is the specific code written by the PHP array sorting function array_multisort to sort the table.