先说下数组用数组里面的数据做key的用处,当两张表的关联关系为一对一的时候,你可以不用join连接,分别取出两张表的数据,经过处理依旧可以得到你想要的数据
$arrb=array(array(a1,b1,c1,d1),array(a2,b2,c2,d2),array(a3,b3,c3,d3));
$arrbchangge=array();//用数组本身的值,来做key
foreach($arrb as $arrb1){
$arrbchangge[$arrb1[0]]=$arrb1;
}
echo '$arrb的数组为:'; print_r($arrb);echo '<br>';
echo '改变后$arrbchangge的数组为:';print_r($arrbchangge);echo '<br>';
打印结果:
$arrb的数组为:Array( [0] => Array ( [0] => a1 [1] => b1 [2] => c1 [3] => d1 )
[1] => Array ( [0] => a2 [1] => b2 [2] => c2 [3] => d2 )
[2] => Array ( [0] => a3 [1] => b3 [2] => c3 [3] => d3 ))
改变后$arrbchangge的数组为:
Array( [a1] => Array ( [0] => a1 [1] => b1 [2] => c1 [3] => d1 )
[a2] => Array ( [0] => a2 [1] => b2 [2] => c2 [3] => d2 )
[a3] => Array ( [0] => a3 [1] => b3 [2] => c3 [3] => d3 ))
下面说一下如何得到你想要的数据:
代码:
<?phpheader("content-Type: text/html; charset=Utf-8");
$arra=array(array(a1,B1,C1,D1),
array(a2,B2,C2,D2),
array(a3,B3,C3,D3));
$arrb=array(array(a1,b1,c1,d1),
array(a2,b2,c2,d2),
array(a3,b3,c3,d3));
$arrbchangge=array();
//用数组本身的值,来做key
foreach($arrb as $arrb1){
$arrbchangge[$arrb1[0]]=$arrb1;
}
foreach($arra as $arra1){
//$arra,$arrb假设是从两张表查询出来的数据,可以看的出字段1是对印的关联关系
print_r($arra1);echo '<br/>';
//根据字段1来得到数据,这样,就可以组合成和join一样的一组数据了
}
打印结果:
Array( [0] => a1 [1] => B1 [2] => C1 [3] => D1)
Array( [0] => a1 [1] => b1 [2] => c1 [3] => d1)
Array( [0] => a2 [1] => B2 [2] => C2 [3] => D2)
Array( [0] => a2 [1] => b2 [2] => c2 [3] => d2)
Array( [0] => a3 [1] => B3 [2] => C3 [3] => D3)
Array( [0] => a3 [1] => b3 [2] => c3 [3] => d3)