index.php

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

<?php
//前台首页功能模块的实现
require_once('tpl/head.php');
require_once('./system/dbConn.php');
  //连接数据库		
  $link=connect();
  //查询首页中国大陆地区的六个视频
    $sql1="select * from area where areaname='中国大陆'";
	$result1 = mysqli_query($link,$sql1) or die('查询失败！'.mysql_error($link));  
	$row1=mysqli_fetch_assoc($result1);
	$aid1=$row1["aid"];
	//根据查的的地区id查询中国大陆地区的六条记录
	$sql11="select * from videos where aid='$aid1' limit 6";
	$result11 = mysqli_query($link,$sql11) or die('查询失败！'.mysqli_error($link));  

	 //查询首页美国地区的六个视频
    $sql3="select * from area where areaname='美国'";
	$result3 = mysqli_query($link,$sql3) or die('查询失败！'.mysqli_error($link));  
	$row3=mysqli_fetch_assoc($result3);
	$aid3=$row3["aid"];
	//根据查的的地区id查询美国地区的六条记录
	$sql33="select * from videos where aid='$aid3' limit 6";
	$result33 = mysqli_query($link,$sql33) or die('查询失败！'.mysqli_error($link));  


	//查询首页日本地区的六个视频
    $sql4="select * from area where areaname='日本'";
	$result4 = mysqli_query($link,$sql4) or die('查询失败！'.mysqli_error($link));  
	$row4=mysqli_fetch_assoc($result4);
	$aid4=$row4["aid"];
	//根据查到的地区id查询日本的六条记录
	$sql44="select * from videos where aid='$aid4' limit 6";
	$result44 = mysqli_query($link,$sql44) or die('查询失败！'.mysqli_error($link));  

//查询首页显示的点击排行4个视频和下载排行的4个视频
    $sql5="select * from videos  order by clicks desc  limit 4";
	$sql6="select * from videos  order by downloads desc  limit 4";
	$result5 = mysqli_query($link,$sql5) or die('查询失败！'.mysqli_error($link));  
	$result6 = mysqli_query($link,$sql6) or die('查询失败！'.mysqli_error($link));  
	?>
<div class="container">
<!--幻灯片开始-->
<div id="carousel-example-generic" class="carousel slide" data-ride="carousel">
    <!-- Indicators -->
    <ol class="carousel-indicators">
        <li data-target="#carousel-example-generic" data-slide-to="0" class="active"></li>
        <li data-target="#carousel-example-generic" data-slide-to="1"></li>
        <li data-target="#carousel-example-generic" data-slide-to="2"></li>
    </ol>

    <!-- Wrapper for slides -->
    <div class="carousel-inner">
        <div class="item active">
            <img src="assets/images/image1.jpg" class="img-responsive" alt="image 1">

            <div class="carousel-caption">
              
            </div>
        </div>
        <div class="item">