![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Correction status：Uncorrected
Teacher's comments：
Collection
Collection
<?php // 1、创建数据源，连接数据库 (变量写法) $type='mysql'; //数据库类型 $host='127.0.0.1'; //数据库IP地址 $dbname='php'; //数据库名 $username='root'; //数据库账号 $password='root'; //数据库密码 $dsn = "$type:host=$host;dbname=$dbname"; //固定格式 ， :号前后不能有空格 $pdo = new PDO($dsn,$username,$password); //从数据库拿出system表里面的所有数据 $sql = 'SELECT * FROM `system` LIMIT 1'; $stmt = $pdo->prepare($sql); $stmt->execute(); $sys=$stmt->fetch(PDO::FETCH_ASSOC); //echo '<pre>' . print_r($system,true); //从数据库拿出导航栏category所有内容 $sql = 'SELECT * FROM `category`'; $stmt = $pdo->prepare($sql); $stmt->execute(); $cates = $stmt->fetchAll(PDO::FETCH_ASSOC); //echo '<pre>' . print_r($cates,true); //从数据库中拿出列表栏movies数据 $sql = 'SELECT * FROM `movies`'; $stmt = $pdo->prepare($sql); $stmt->execute(); $movies = $stmt->fetchAll(PDO::FETCH_ASSOC); //echo '<pre>' . print_r($movies,true); //?> <!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <link rel="stylesheet" href="../static/css/style.css"> <meta name="description" content="<?php echo $sys['desc'] ?>"> <!-- --><?php // echo $sys['desc'];echo $sys['key']; ?> <meta name="keywords" content="<?php echo $sys['key'] ?>"> <title><?php echo $sys['title'] ?></title> </head> <body> <!--头部导航--> <div class="header"> <ul class="nav"> <li><a href="index.php">首页</a></li> <?php foreach ($cates as $cate) : ?> <li><a href="list.php?cate_id=<?php echo $cate['cate_id']; ?>"><?php echo $cate['alias'] ?></a></li> <?php endforeach; ?> </ul> </div>
点击 "运行实例" 按钮查看在线实例
<!--底部版权--> <body> <div class="footer"> <p class="copyright"><?php echo $sys['copy']; ?>© 版权所有</p> </div> </body> </html>
点击 "运行实例" 按钮查看在线实例
<?php
// 加载公共头部
include __DIR__ . "/inc/header.php";
// 使用双重循环来遍历二个数组
// 外层遍历栏目数组$cates, 内层根据栏目id来查询对应的影视剧信息
foreach ($cates as $cate) {
echo "<h2>{$cate['alias']}</h2>";
echo '<ol>';
// 遍历影视剧数组
foreach ($movies as $movie) {
// 判断当前影视剧所属栏目是否与当前栏目id相同?
if ($cate['cate_id'] === $movie['cate_id']) {
echo "<li><a href='detail.php?mov_id={$movie['mov_id']}'>{$movie['name']}</a></li>";
}
}
echo '</ol>';
}
// 加载公共底部
include __DIR__ . '/inc/footer.php';点击 "运行实例" 按钮查看在线实例
<?php
// 加载公共头部
include __DIR__ . '/inc/header.php';
// 将当前栏目id,, 使用GET方式,通过URL地址传递到列表模板list.php
$cate_id = $_GET['cate_id'];
//$movie_id = $_GET['movie_id'];
foreach ($cates as $cate) {
if ($cate['cate_id'] === $cate_id) {
echo "<h2>{$cate['alias']}</h2>";
echo '<ol>';
foreach ($movies as $movie) {
if ($cate['cate_id'] == $movie['cate_id']) {
echo "<li><a href='detail.php?mov_id={$movie['mov_id']}'>{$movie['name']}</a></li>";
}
}
echo '</ol>';
};
}
// 加载公共底部
include __DIR__ . '/inc/footer.php';点击 "运行实例" 按钮查看在线实例
<?php
// 加载公共头部
include __DIR__ . '/inc/header.php';
$mov_id = $_GET['mov_id'];
// 复制list.php模板直接修改
foreach ($movies as $movie) {
if ($movie['mov_id'] === $mov_id) {
echo "<h3>{$movie['name']}</h3>";
echo '<img src="../static/images/'.$movie['image'].'" alt="" width="300">';
echo "<p style='text-indent: 2em'>{$movie['detail']}</p>";
}
};
// 加载公共底部
include __DIR__ . '/inc/footer.php';点击 "运行实例" 按钮查看在线实例