php读取redsources_db数据库的red_resources;数据库账号为root,密码为A啊23456。red_resources表头内容为id,category_id,subcategory_id,details,image。 根据数据库动态创建以下内容: 第一个php文件: 需求1:请根据category_id的类别创建一级分类,并且在一级分类下根据subcategory_id的类别创建二级分类; 需求2:每个分类都是唯一的; 需求3:一级分类分类缩进100格,字体大小为40,颜色为蓝色,字体加粗; 需求4:二级分类为单选框,缩进200格,字体大小为20,颜色为蓝色; 需求5:添加按钮,按钮名称为选择种类。当点击按钮,且二级分类的单选框选择项不为空时,跳转到另外一个页面。并且将当前二级分类的subcategory_id值传入到第二个php文件中; 需求6:当跳转时,需关闭当前mysql的连接; 第二个php文件: 需求7:接受第一个php文件传入的二级分类的subcategory_id的值; 需求8:根据传入的subcategory_id,在数据库中查询该subcategory_id的相同种类的总数量; 请给出完整代码
时间: 2024-03-23 17:41:36 浏览: 18
第一个php文件:
```php
<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "A啊23456";
$dbname = "redresources_db";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// 查询数据库
$sql = "SELECT DISTINCT category_id, subcategory_id FROM red_resources";
$result = $conn->query($sql);
// 创建一级分类和二级分类
echo "<form action='second.php' method='GET'>";
echo "<ul>";
while ($row = $result->fetch_assoc()) {
$category_id = $row["category_id"];
$subcategory_id = $row["subcategory_id"];
// 一级分类
echo "<li style='font-size: 40px; color: blue; font-weight: bold; padding-left: 100px;'>$category_id</li>";
// 二级分类
$sql2 = "SELECT COUNT(*) AS count FROM red_resources WHERE subcategory_id = '$subcategory_id'";
$result2 = $conn->query($sql2);
$row2 = $result2->fetch_assoc();
$count = $row2["count"];
echo "<li style='padding-left: 200px;'>";
echo "<input type='radio' name='subcategory_id' value='$subcategory_id' style='font-size: 20px; color: blue;'>$subcategory_id ($count)";
echo "</li>";
}
echo "</ul>";
// 添加按钮
echo "<input type='submit' name='submit' value='选择种类'>";
echo "</form>";
// 关闭连接
$conn->close();
?>
```
第二个php文件:
```php
<?php
// 获取传入的subcategory_id
$subcategory_id = $_GET["subcategory_id"];
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "A啊23456";
$dbname = "redresources_db";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// 查询数据库
$sql = "SELECT COUNT(*) AS count FROM red_resources WHERE subcategory_id = '$subcategory_id'";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$count = $row["count"];
echo "该分类下共有 $count 种资源。";
// 关闭连接
$conn->close();
?>
```