收藏
批改状态：合格
老师批语：做的还是相当不错的, 对刘家内容做了扩展.
流程：
PDO方式连接数据库->将网站所需的数据以二维数组赋值到一个变量->在相应的位置对其数组数据遍历->页面显示
1-1 PDO连接所需参数
<?php return [ 'type'=>'mysql', 'host'=>'127.0.0.1', 'dbname'=>'kuqiwang', 'username'=>'root', 'password'=>'root', ];
点击 "运行实例" 按钮查看在线实例
1-2实例化PDO
<?php
$db = require __DIR__.'\data.php';
$dsn = "{$db['type']}:host={$db['host']};dbname={$db['dbname']}";
$username = $db['username'];
$password = $db['password'];
try{
$pdo = new PDO($dsn,$username,$password);
// echo'连接成功';
}catch(PDOException $e){
die('连接失败'.$e->getMessage());
}点击 "运行实例" 按钮查看在线实例
1-3获取数据表数据
<?php //引用PDO实例化 include 'connect.php'; //首页数据 $sql = "SELECT * FROM `system` WHERE `sys_id`=1"; $mimt = $pdo->prepare($sql); $mimt->execute(); $system = $mimt->fetch(PDO::FETCH_ASSOC);//查询单条数据 //列表数据 $sql = "SELECT * FROM `cates`"; $mimt = $pdo->prepare($sql); $mimt->execute(); $cates = $mimt->fetchAll(PDO::FETCH_ASSOC); //内容数据 $sql = "SELECT * FROM `movies`"; $mimt = $pdo->prepare($sql); $mimt->execute(); $movies = $mimt->fetchAll(PDO::FETCH_ASSOC); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="keywords" content='<?php echo $system["key"] ?>'> <meta name="fdsjkflk" content='<?php echo $system["desc"] ?>'> <link rel="stylesheet" href="static/css/index.css"> <link rel="shortcut icon" type="image/x-icon" href="static/images/<?php echo $system['logo'] ?>"> <title><?php echo $system['title'] ?></title> </head> <body> <!-- 头部 --> <div class="header"> <ul> <div style="float: left;margin-left: 50px;"><a href="index.php"><img src="static/images/<?php echo $system['logo'] ?>" alt="" width="50" height="30"></a></div> <li style="border-left: none;"><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; ?> <li><a href="http://zhibo.renren***/">直播</a></li><br> </ul> </div>
点击 "运行实例" 按钮查看在线实例
1-4 首页遍历
<?php
include __DIR__.'\public-files/header.php';
// 主体内容
echo "<div class='content'>";
echo "<div class='juzhong'>";
foreach($cates as $cate){
echo"<h2>{$cate['alias']}</h2><br>";
echo "<ul>";
foreach($movies as $moive){
if ($cate['cate_id'] === $moive['cate_id']) {
// echo $moive['mov_id'];
echo "<li><a href='xiangqing.php?mov_id=".$moive['mov_id']."'>{$moive['name']}</a></li><br>";
}
}
}
echo"</ul><br>";
echo "</div>";
echo "</div>";
echo "</div>";
include __DIR__.'\public-files/footer.php';
?>点击 "运行实例" 按钮查看在线实例
1-5 头部导航条
<?php
include __DIR__.'\public-files/header.php';
$cate_id = intval($_GET['cate_id']);
?>
<!-- 主体内容 -->
<div class="content">
<div class="juzhong">
<?php foreach($cates as $cate):?>
<?php if (intval($cate['cate_id']) === $cate_id){ ?>
<h2><?php echo $cate['alias'] ?></h2><br>
<?php } ?>
<?php endforeach;?>
<?php foreach($movies as $movie):?>
<?php if(intval($movie['cate_id']) === $cate_id){ ?>
<ul>
<li><a href="xiangqing.php?mov_id=<?php echo $movie['cate_id'] ?>"><?php echo $movie['name'] ?></a></li><br>
</ul>
<?php } ?>
<?php endforeach;?>
</div>
</div>
<?php include __DIR__.'\public-files/footer.php'; ?>点击 "运行实例" 按钮查看在线实例
1-6内容详情遍历
<?php
include __DIR__.'\public-files/header.php';
$mov_id = intval($_GET['mov_id']);
$date = date('Y-m-d H:i',time());
?>
<!-- 主体内容 -->
<div class="content">
<div class="juzhong">
<?php foreach($movies as $movie): ?>
<?php if( intval($movie['mov_id'])=== $mov_id){?>
<h2><?php echo $movie['name']; ?></h2><br>
<p class="laiyuan"><?php echo $date;echo"<span> 来源: {$movie["laiyuan"]}</span>" ?> </p><br>
<p class="yuanbiaoti">原标题：<?php echo $movie['name']; ?></p>
<div class="video">
<video src="static/video/<?php echo $movie['video']; ?>" width="625" height="470" controls="controls" controlsList="nodownload"></video>
</div>
<div class="c-content">
<pre></pre>
<p style="text-indent: 2rem;"><?php echo $movie['detail']; ?></p>
</div>
<?php } ?>
<?php endforeach; ?>
</div>
</div>
<?php include __DIR__.'\public-files/footer.php'; ?>点击 "运行实例" 按钮查看在线实例
以下是根据数据库获取数据遍历显示的内容页面
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
