<?php
header("Content-Type: text/html; charset=UTF-8");
$servername = "localhost"; //服务器名称(本地)
$username = "root"; //登陆账号
$password = "123456"; //登陆密码
$dbname = "ndshop"; //测试数据库名称
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
mysqli_set_charset($conn,"utf8");
// Check connection
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
$sql = "SELECT id, title1, title2 FROM about";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出数据
while($row = $result->fetch_assoc()) {
echo "id: " . $row["id"]. " - Name: " . $row["title1"]. " " . $row["title2"]. "<br>";
}
} else {
echo "0 结果";
}
$conn->close();
header("Content-Type: text/html; charset=UTF-8");
$servername = "localhost"; //服务器名称(本地)
$username = "root"; //登陆账号
$password = "123456"; //登陆密码
$dbname = "ndshop"; //测试数据库名称
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
mysqli_set_charset($conn,"utf8");
// Check connection
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
$sql = "SELECT id, title1, title2 FROM about";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出数据
while($row = $result->fetch_assoc()) {
echo "id: " . $row["id"]. " - Name: " . $row["title1"]. " " . $row["title2"]. "<br>";
}
} else {
echo "0 结果";
}
$conn->close();
?>
在这里header中的代码 是为了防止网页显示乱码
而在$conn 连接数据库后的代码则是为了从数据库读取数据出来的时候 方式乱码问题 需要注意的是这里设置的不是UTF-8而是UTF8