Array ( Array ('id' => 3, 'username' => 'alex ','parentname'=> 'john'
,'proname' => 'tttt' 'num'=> 1 , 'userid' =>6 ,'parentid'=>8 ,
'cpid'=> 0 ,'mobile'=> 15533336666 ,'parentmobile' => 156477765465) );
把最后两个分别放在第2个和第4个位置 ,怎么重新排序?
Array ( Array ('id' => 3, 'username' => 'alex ','mobile'=> 15533336666
,'parentname'=> 'john' ,'parentmobile' => 156477765465 ,'proname' => 'tttt' 'num'=> 1 ,
'userid' =>6 ,'parentid'=>8 ,'cpid'=> 0 );
1、从数据库里取出时,不要简单的 select *
而是 select id, username, mobile .... 这样一一开列,你要求的排列顺序不就有了
2、用 php 代码也是可以的
$a = Array ( Array ('id' => 3, 'username' => 'alex ','parentname'=> 'john'
,'proname' => 'tttt', 'num'=> 1 , 'userid' =>6 ,'parentid'=>8 ,
'cpid'=> 0 ,'mobile'=> 15533336666 ,'parentmobile' => 156477765465) );
$k = Array ('id', 'username', 'mobile', 'parentname', 'parentmobile', 'proname', 'num', 'userid', 'parentid', 'cpid');
foreach($a as $i=>$v) {
extract($v);//该函数使用数组键名作为变量名,使用数组键值作为变量值。将数组$a的所有元素转成变量。
$b[$i] = compact($k);//函数创建一个包含变量名和它们的值的数组。
}
print_r($b);
Array
(
[0] => Array
(
[id] => 3
[username] => alex
[mobile] => 15533336666
[parentname] => john
[parentmobile] => 156477765465
[proname] => tttt
[num] => 1
[userid] => 6
[parentid] => 8
[cpid] => 0
)
)
也可以可以这样写:
$arr = array(
array('id'=>3,'username'=>'alex','parentname'=>'john','proname'=>'tttt','num'=> 1 , 'userid' =>6 ,'parentid'=>8 ,'cpid'=> 0 ,'mobile'=> 15533336666 ,'parentmobile' => 156477765465),
array('id'=>3,'username'=>'alex','parentname'=>'john','proname'=>'tttt','num'=> 1 , 'userid' =>6 ,'parentid'=>8 ,'cpid'=> 0 ,'mobile'=> 15533336666 ,'parentmobile' => 156477765465),
array('id'=>3,'username'=>'alex','parentname'=>'john','proname'=>'tttt','num'=> 1 , 'userid' =>6 ,'parentid'=>8 ,'cpid'=> 0 ,'mobile'=> 15533336666 ,'parentmobile' => 156477765465),
);
$result = array();
$fields = array('id','username','mobile','parentname','parentmobile','proname','num','userid','parentid','cpid');
foreach($arr as $k=>$v){
$tmp = array();
foreach($fields as $f){
$tmp[$f] = $v[$f];
}
$result[] = $tmp;
}
print_r($result);
原文链接:https://bbs.csdn.net/topics/391954223