php数组的排序问题，求解！

Question

/**
*对数组按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'),
);

Answer 1

对数组按username从左至右匹配排序  这是什么意思？

Answer 2

SQL好使不SELECT * FROM table WHERE username LIKE  '%zhangsan%' ORDER BY LOCATE('zhangsan',username) ASC , cardid DESC 

Answer 3

不用sql哦，直接对数组进行排序！

Answer 4

有问题么？ 我按zhangsan 进行排序，首先匹配完全等于zhangsan的，如果有多条再按cardid降序，不完全匹配，则从左至右匹配zhangsan，如果有2个记录为zhangsanfeng，则也按cardid降序。从左至右，则sbzhangsanfengisyou，优先于sbzhangsan，因为zhangsan是在sbzhangsanfengisyou中间位置，在sbzhangsan却是末尾位置。

Answer 5

人家要对数组排序，那就对数组排序呗$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';
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);Array
(
    [0] => Array
        (
            [cardid] => 1007
            [username] => zhangsan
        )    [1] => Array
        (
            [cardid] => 1001
            [username] => zhangsan
        )    [2] => Array
        (
            [cardid] => 1002
            [username] => zhangsanfeng
        )    [3] => Array
        (
            [cardid] => 1003
            [username] => SBzhangsan
        )    [4] => Array
        (
            [cardid] => 1005
            [username] => SBzhangsanisyou
        ))

Answer 6

楼主给的结果有悖于自己的描述噢。"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] => Array
        (
            [cardid] => 1005
            [username] => SBzhangsanisyou
        )    [2] => Array
        (
            [cardid] => 1003
            [username] => SBzhangsan
        ))
[User:root Time:02:58:31 Path:/home/liangdong/php]$ cat sort.php 
<?php
$list = array(
                        array('cardid'=>1001,'username'=>'zhangsan'),
                        array('cardid'=>1002,'username'=>'zhangsanfeng'),
                        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 ? -1 : 1;
                                }
                                if ($lndx == $rndx) {
                                        return $rid - $lid;
                                } else {
                                        return $lndx - $rndx;
                                }
                });print_r($list);
?>

Answer 7

<?php   
$arr = 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'),
);function sort_ary($x,$y,$kword='zhangsan'){
$a = strpos($x['username'],$kword);
$b = strpos($y['username'],$kword);
if($a == $b){
$temp1 = str_replace($kword,'',$x['username']);
$len1= strlen($temp1);
$temp2 = str_replace($kword,'',$y['username']);
$len2= strlen($temp2); if($len1 == $len2){
return 0;
}else if($len1 < $len2){
return -1;
}else{
return 1;
}
}else if($a < $b){
return -1;
}else if($a > $b){
return 1;
}
}$result = usort($arr,'sort_ary');echo "<pre>";
print_r($arr);
echo "</pre>";
?>

Answer 8

哎呀，我擦，下标不对啊。得用usort

Answer 9

4位的有3位给出了数组排序方法，1位给出了sql方法，谢谢各位了！