PHP连接数据库、执行SELECT的SQL语句、在页面上输出
PHP连接数据库
打开N11 点击连接——mysql
输入PHP数据库信息 测试连接 成功后第点击确定
双击就可以连接
执行SELECT的SQL语句 在页面上输出
<html>
<head>
<title>刘佳玥</title>
</head>
<body>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "zblong";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
$conn->query("set names 'utf8'");
// Check connection
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
$sql = "SELECT cate_Name FROM `zbp_category`";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出数据
while($row = $result->fetch_assoc()) {
echo "分类名称: " . $row["cate_Name"]. "<br>" ;
}
} else {
echo "0 结果";
} $conn->close();
?>
</body>
</html>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "zblong";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
$conn->query("set names utf8");
// Check connection
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
$sql = "SELECT cate_Name FROM zbp_category";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出数据
while($row = $result->fetch_assoc()) {
echo $row["cate_Name"]. " ";
}
} else {
echo "0 结果";
}
$sql = "SELECT log_Title,log_Content FROM zbp_post";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出数据
while($row = $result->fetch_assoc()) {
echo "<hr><h1>" . $row["log_Title"]. "</h1><br>". $row["log_Content"];
}
} else {
echo "0 结果";
}
$conn->close();
?>
浙公网安备 33010602011771号