Home >Backend Development >PHP Tutorial >How to use PHP array sorting function array_multisort to sort tables_PHP tutorial

How to use PHP array sorting function array_multisort to sort tables_PHP tutorial

WBOY
WBOYOriginal
2016-07-15 13:29:05970browse

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.


www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/446380.htmlTechArticleWhat we bring to you today is a function whose prototype is array_multisort($sortKeyArray,$ascOrDesc,$sortArray) , the first parameter in the PHP array sorting function array_multisort is to preserve...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn