Php array sorting problem, solve! * ** Sort the array by username from left to right, and sort the array by cardid from large to small If username is the same * $ listarray (0 & gt; array (cardid & gt; 1001, username & gt; zhangsan), 1 & gt; array (cardid & gt; 1002, sorting of user php arrays, solving!
/**
* Sort the array by username matching from left to right, and sort the array by cardid from large to small If username is the same
*/
$ List = array (
0 => array ('cardid' => 1001, 'username' => 'hangsan '),
1 => array ('cardid' => 1002, 'username' => 'zhangsanfeng '),
2 => array ('cardid' => 1003, 'username' => 'sbzhangsan '),
3 => array ('cardid' => 1005, 'username' => 'sbzhangsanisyou '),
4 => array ('cardid' => 1007, 'username' => 'hangsan '),
);
Matching string: $ q = 'hangsan ';
The sorted result should be
$ List = array (
0 => array ('cardid' => 1007, 'username' => 'hangsan '),
1 => array ('cardid' => 1001, 'username' => 'hangsan '),
2 => array ('cardid' => 1003, 'username' => 'zhangsanfeng '),
3 => array ('cardid' => 1005, 'username' => 'sbzhangsanisyou '),
4 => array ('cardid' => 1007, 'username' => 'sbzhangsan '),
);
------ Solution --------------------
SQL is easy to use
SQL code
SELECT * FROM table WHERE username LIKE '% zhangsan %' order by locate ('zhangsan', username) ASC, cardid DESC
------ Solution --------------------
If you want to sort arrays, sort them.
PHP code
$ List = array (0 => array ('cardid' => 1001, 'username' => 'hangsan'), 1 => array ('cardid' => 1002, 'username' => 'zhangsanfeng'), 2 => array ('cardid' => 1003, 'username' => 'sbzhangsan '), 3 => array ('cardid' => 1005, 'username' => 'sbzhangsanisyou'), 4 => array ('cardid' => 1007, 'username' => 'hangsan'),); $ q = 'hangsan'; foreach ($ list as $ v) {$ r1 [] = $ v ['cardid']; list ($ r2 [], $ r3 []) = explode ($ q, $ v ['username']);} array_multisort ($ r2, $ r3, $ r1, SORT_DESC, $ list); print_r ($ list );
------ Solution --------------------
The result given by the landlord is different from your own description.
PHP code
"Sort. php "29L, 801C written [User: root Time: 02: 58: 29 Path:/home/liangdong/php] $ php sort. php Array ([4] => Array ([cardid] => 1007 [username] => zhangsan) [1] => Array ([cardid] => 1002 [username] => zhangsanfeng) [0] => Array ([cardid] => 1001 [username] => zhangsan) [3] = & gt; Array ([cardid] = & gt; 1005 [username] = & gt; SBzhangsanisyou) [2] => Array ([cardid] => 1003 [username] => SBzhangsan) [User: root Time: 02: 58: 31 Path: /home/liangdong/php] $ cat sort. php
1001, 'username' => 'hangsan'), array ('cardid' => 1002, 'username' => 'hangsanfeng'), array ('cardid' => 1003, 'username' => 'sbzhangsan'), array ('cardid' => 1005, 'username' => 'sbzhangsanisyou'), array ('cardid' => 1007, 'username' => 'zhangsan'),); $ name = "zhangsan"; uasort ($ list, function ($ left, $ right) {global $ name; $ lndx = strpos ($ left ['username'], $ name); $ rndx = strpos ($ right ['username'], $ name ); $ lid = $ left [' Cardid']; $ rid = $ right ['cardid']; if ($ lndx ===false & $ rndx! = False | $ lndx! = False & $ rndx = false) {// return $ lndx = false if the name is not included? -1: 1;} if ($ lndx ==$ rndx) {return $ rid-$ lid;} else {return $ lndx-$ rndx ;}}); print_r ($ list);?>