建议采用pdo形式链接数据库
示例如下:
//1.连接数据库
try {
$pdo = new PDO("mysql:host=localhost;dbname=school;", "root", MYSQLPASSWORD);
} catch (PDOException $e) {
die("数据库连接失败" . $e->getMessage());
}
//2.解决中文乱码问题
$pdo->query("SET NAMES 'UTF8'");
//3.执行sql语句,并实现解析和遍历
$sql = "SELECT * FROM stu ";
foreach ($pdo->query($sql) as $row) {
echo "
";echo "
{$row['name']}";echo "
{$row['number']}";$sex = $row['sex'] == 'w' ? '女' : '男';
echo "
{$sex}";echo "
{$row['age']}";echo "
{$row['cate']}";echo "
{$row['class']}";echo "
{$row['major']}";echo "
删除
";echo "
";}
?>