<?php
class mypdo{
public $link;
public $host;
public $dbname;
public $user;
public $pwd;
public $char;
public function __construct($host,$dbname,$user,$pwd){
$this->host=$host;
$this->dbname=$dbname;
$this->user=$user;
$this->pwd=$pwd;
$this->char='set names utf8';
$this->link=new pdo("mysql:host={$this->host};dbname={$this->dbname}",$this->user,$this->pwd);
$this->link->query($this->char);
}
public function query($sql){
return $this->link->query($sql);
}
public function getAll($sql){
return $this->query($sql)->fetchAll(PDO::FETCH_ASSOC);
}
public function getnum($sql){
return $this->query($sql)->rowCount();
}
}
$pdo=new mypdo("localhost","news","root","");
$sql='select * from newstype';
$rs=$pdo->getAll($sql);
$data=[];
foreach($rs as $v){
$sql='select * from news where typeid='.$v['typeid'];
$rk=$pdo->getAll($sql);
$data[]= [
'info'=>$v,
'con' =>$rk
];
}
foreach($data as $v){
echo $v['info']['typename'].'<br>';
foreach($v['con'] as $s){
echo $s['title'].'<br>';
}
echo "<hr>";
}
?>
