展开全部
$host="localhost";
$username="root";
$password="root";
$database="aaaa";
$mysqli = new mysqli($host, $username, $password, $database);
if($mysqli->connect_errno){
echo'fail';
exit;
}
//设置数据库编码格式
$mysqli->set_charset("UTF8");
/*编写sql获取分页数据 SELECT*FROM 表名 LIMIT 起始位置,显示条数*/
//$sql="select * from xiao";
$sql="select * from A as a inner join B as b on a.p_id=b.id";
/*把sql语句传送到数据库*/
$query=$mysqli->query($sql);
echo "
echo "
idp_name";while($row = $query->fetch_assoc())
{
//echo "
".$row['id']."".$row['name']."";echo "
".$row['p_s']."".$row['p_name']."";}
echo "
";上面的代码你改改,效636f70793231313335323631343130323136353331333365643637果图如下