php数组的排序有关问题，求解

php中文网

发布： 2016-06-13 13:26:31

原创

1080人浏览过

php数组的排序问题，求解！
/**
*对数组按username从左至右匹配排序，username一样则按cardid从大到小排序
*/
$list = array(
0=>array('cardid'=>1001,'username'=>'zhangsan'),
1=>array('cardid'=>1002,'username'=>'zhangsanfeng'),
2=>array('cardid'=>1003,'username'=>'SBzhangsan'),
3=>array('cardid'=>1005,'username'=>'SBzhangsanisyou'),
4=>array('cardid'=>1007,'username'=>'zhangsan'),
);
匹配字符串：$q = 'zhangsan';

排序后的结果应该为
$list = array(
0=>array('cardid'=>1007,'username'=>'zhangsan'),
1=>array('cardid'=>1001,'username'=>'zhangsan'),
2=>array('cardid'=>1003,'username'=>'zhangsanfeng'),
3=>array('cardid'=>1005,'username'=>'SBzhangsanisyou'),
4=>array('cardid'=>1007,'username'=>'SBzhangsan'),
);

------解决方案--------------------
SQL好使不

SQL code


SELECT * FROM table WHERE username LIKE  '%zhangsan%' ORDER BY LOCATE('zhangsan',username) ASC , cardid DESC
<br><font color="#e78608">------解决方案--------------------</font><br>人家要对数组排序，那就对数组排序呗

登录后复制

PHP code

$list = array(
0=&gt;array('cardid'=&gt;1001,'username'=&gt;'zhangsan'),
1=&gt;array('cardid'=&gt;1002,'username'=&gt;'zhangsanfeng'),
2=&gt;array('cardid'=&gt;1003,'username'=&gt;'SBzhangsan'),
3=&gt;array('cardid'=&gt;1005,'username'=&gt;'SBzhangsanisyou'),
4=&gt;array('cardid'=&gt;1007,'username'=&gt;'zhangsan'),
);
$q = 'zhangsan';
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);
<br><font color="#e78608">------解决方案--------------------</font><br>楼主给的结果有悖于自己的描述噢。<br><br>

登录后复制

PHP code

"sort.php" 29L, 801C written                                                                                                                                   
[User:root Time:02:58:29 Path:/home/liangdong/php]$ php sort.php 
Array
(
    [4] =&gt; Array
        (
            [cardid] =&gt; 1007
            [username] =&gt; zhangsan
        )

    [1] =&gt; Array
        (
            [cardid] =&gt; 1002
            [username] =&gt; zhangsanfeng
        )

    [0] =&gt; Array
        (
            [cardid] =&gt; 1001
            [username] =&gt; zhangsan
        )

    [3] =&gt; Array
        (
            [cardid] =&gt; 1005
            [username] =&gt; SBzhangsanisyou
        )

    [2] =&gt; Array
        (
            [cardid] =&gt; 1003
            [username] =&gt; SBzhangsan
        )

)
[User:root Time:02:58:31 Path:/home/liangdong/php]$ cat sort.php 
<?php $list = array(
                        array('cardid'=>1001,'username'=&gt;'zhangsan'),
                        array('cardid'=&gt;1002,'username'=&gt;'zhangsanfeng'),
                        array('cardid'=&gt;1003,'username'=&gt;'SBzhangsan'),
                        array('cardid'=&gt;1005,'username'=&gt;'SBzhangsanisyou'),
                        array('cardid'=&gt;1007,'username'=&gt;'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 &amp;&amp; $rndx !== false || 
                                        $lndx !== false &amp;&amp; $rndx === false) { // 不包含名字的算小的
                                        return $lndx === false ? -1 : 1;
                                }
                                if ($lndx == $rndx) {
                                        return $rid - $lid;
                                } else {
                                        return $lndx - $rndx;
                                }
                });

print_r($list);
?&gt;
 <div class="clear"></div>

登录后复制