php多维数组签名,PHP多维数组

/***************************by garcon1986********************************/ 一个三维数组的显示，保存以备以后使用。 !DOCTYPE htmlhtmlhead/headbody?phperror_reporting(E_ALL ^ E_NOTICE);$conn = mysql_connect(localhost,charles,charles);mysql_se

/***************************by

garcon1986********************************/

一个三维数组的显示，保存以备以后使用。

/n";

if ($label !== null && $label !== '') {

$content .= "{$label} :/n";

}

$content .= htmlspecialchars(print_r($vars, true));

$content .= "/n/n";

}

else {

$content = "/n";

if ($label !== null && $label !== '') {

$content .= $label . " :/n";

}

$content .= print_r($vars, true) . "/n";

}

if ($return) {

return $content;

}

echo $content;

return null;

}

/* 不好的例子

$query = "select * from entreprise";

$result = mysql_query($query);

while($row = mysql_fetch_assoc($result)){

$query2 = "select * from site where entreprise_id = $row[entreprise_id]";

$result2 = mysql_query($query2);

$a2 = array();

while($row2 = mysql_fetch_assoc($result2)){

$query3 = "select * from salarie where site_id = $row2[site_id]";

$result3 = mysql_query($query3);

while($row3 = mysql_fetch_assoc($result3)){

$a3[] = array("text"=>$row3[nom]);

}

if($a3[site_id] == $a2[site_id]){

$a2[] = array("text"=>$row2[nom],'children'=>$a3);

}

}

if($a2[entreprise_id] == $a1[entreprise_id]){

$a1[] = array("text"=>$row[id]." ".$row[nom],'children'=>$a2);

}

}

//print_r($a1);

//echo json_encode($a1);

dump($a1);

*/

$entreprise_q = mysql_query("select * from entreprise");

$site_q = mysql_query("select * from site");

$salarie_q = mysql_query("select * from salarie");

$result = array();

$entreprise = array();

$site = array();

$salarie = array();

while($row = mysql_fetch_assoc($salarie_q)){

if(!is_array($salarie[$row['site_id']])){

$salarie[$row['site_id']] = array();

}

$salarie[$row['site_id']][$row['salarie_id']] = $row['nom'];

}

while($row = mysql_fetch_assoc($site_q)){

if(!is_array($site[$row['entreprise_id']])){

$site[$row['entreprise_id']] = array();

}

$site[$row['entreprise_id']][$row['site_id']] = array(

'name' => $row['nom'],

'salarie' => $salarie[$row['site_id']]

);

}

while($row = mysql_fetch_assoc($entreprise_q)){

if(!is_array($entreprise[$row['entreprise_id']])){

$entreprise[$row['entreprise_id']] = array();

}

$entreprise[$row['entreprise_id']] = array(

'name' => $row['nom'],

'sites' => $site[$row['entreprise_id']]

);

}

//echo json_encode($entreprise);

dump($entreprise);

?>

本文原创发布php中文网，转载请注明出处，感谢您的尊重！