mysql.php
前端页面
<?php
//预定义数据库连接参数
$host = '127.0.0.1';
$dbuser = 'root';
$psd = '123456';
$dbname = 'sql-practise';
//连接到数据库
$db = new mysqli($host, $dbuser, $psd, $dbname);
if ($db->connect_errno <> 0) {
die('连接数据库失败');
}
//设定数据库数据传输的编码
$db->query('SET NAMES UTF8');
//执行
$sql='SELECT * FROM msg ORDER BY id DESC';
$mysqli_result=$db->query($sql);
if($mysqli_result===false){
die('sql执行错误');
}
//循环数据
$rows=[];
while ($row=$mysqli_result->fetch_array(MYSQLI_ASSOC)){
$rows[$row['id']]=$row;
}
//var_dump($rows);//打印数据
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta chars