PDO原生数组实现二级导航
点击数:1341 发布时间2019-02-06 23:15:05
$pdo=new pdo('mysql:host=localhost;dbname=news','root','');
$pdo->query('set names utf8');
$sql='sele * from newstype';
$stmt=$pdo->query($sql);
$rs=$stmt->fetchAll(PDO::FETCH_ASSOC);
$data=[];
foreach($rs as $v){
$sql='sele * from news where typeid='.$v['typeid'];
$stmt=$pdo->query($sql);
$rm=$stmt->fetchAll(PDO::FETCH_ASSOC);
$data[]=[
'info'=>$v,
'con'=>$rm
];
}
foreach($data as $v){
echo $v['info']['typename'];
echo "<br>";
foreach($v['con'] as $k){
echo $k['title'];
echo "<br>";
}
echo "<hr>";
}