访问方式 index.php?type=1&ym=1&zm=2 //1 显示类型为1-电影 从第1条开始 最多显示2条数据
<?php
$type=$_REQUEST["type"];//查询数据关键字
$ym=$_REQUEST["ym"];//起妈
$zm=$_REQUEST["zm"];//显示条数
$conn=mysqli_connect("localhost","435000","密码","435000");
// 连接数据库user
if (!$conn) {
# code...判断链接是否成功
echo "连接失败!";
echo mysqli_connect_error();
exit();
}
mysqli_query($conn,"set names utf8");
// 指定编码格式
$sql="SELECT vod_id,vod_name,vod_pic,vod_area,vod_year FROM `ff_vod` WHERE `vod_cid` = $type ORDER BY `vod_addtime` DESC limit $ym,$zm";
// sql语句
$result=mysqli_query($conn,$sql);
while ($row=$result->fetch_assoc())
{
echo "<pre>";
print_r($row);
echo "---";
}
?>