if($type_name=="")
{
$sql="select id,title,addtime from jdzcnnet_movie where hidden=0 and looklevel<=2 order by addtime desc limit 0,10";
}
else
{
$sql="select id,title,addtime from jdzcnnet_movie where hidden=0 and looklevel<=2 and class='".urldecode($type_name)."' order by addtime desc limit 0,10";
}
$result=mysql_query($sql);
while($rs=mysql_fetch_object($result))
{?>
| |
=substr_cut($rs->title,12)?> |
=date('m月d日',$rs->addtime)?> |
}
mysql_free_result($result);?>
|
if($type_name=="")
{
$sql="select id,title,hits from jdzcnnet_movie where hidden=0 and looklevel<=2 order by hits desc limit 0,10";
}
else
{
$sql="select id,title,hits from jdzcnnet_movie where hidden=0 and looklevel<=2 and class='".urldecode($type_name)."' order by hits desc limit 0,10";
}
$result=mysql_query($sql);
while($rs=mysql_fetch_object($result))
{?>
| |
=substr_cut($rs->title,12)?> |
=$rs->hits?>次 |
}?>
|
|
|
|
$page=sql_cut($_GET['page']);
$action=sql_cut($_GET['action']);
$keyword=sql_cut($_GET['keyword']);
$typeid=$type_name;
$maxperpage=10; //定义每页显示电影数目
if(!$page or $page==0)
{
$page=1;
}
if ($action!="")
{
$sql="select count(id) from jdzcnnet_movie where ".$action." like '%".$keyword."%' and hidden=0 and looklevel<=2 order by id desc";
}
elseif ($typeid!="")
{
$sql="select count(id) from jdzcnnet_movie where hidden=0 and class='".urldecode($typeid)."' and looklevel<=2 order by id desc";
}
else
{
$sql="select count(id) from jdzcnnet_movie where hidden=0 and looklevel<=2 order by id desc";
}
//echo $sql;
$rs=mysql_fetch_array(mysql_query($sql));
$toltal=$rs[0]; //总电影数目
//echo $toltal;
//分页查询
if ($action!="")
{
$sql1="select * from jdzcnnet_movie where ".$action." like '%".$keyword."%' and hidden=0 and looklevel<=2 order by id desc limit ".($page-1)*$maxperpage.",".($maxperpage)."";
}
elseif ($typeid!="")
{
$sql1="select * from jdzcnnet_movie where hidden=0 and class='".urldecode($typeid)."' and looklevel<=2 order by id desc limit ".($page-1)*$maxperpage.",".($maxperpage)."";
}
else
{
$sql1="select * from jdzcnnet_movie where hidden=0 and looklevel<=2 order by id desc limit ".($page-1)*$maxperpage.",".($maxperpage)."";
}
//echo $sql1;
$result=mysql_query($sql1);
?>
=listpage($maxperpage,$toltal,$page,$action,$keyword,$typeid)?>
$i=0;
while($rs=mysql_fetch_object($result))
{
$i=$i+1;?>
|
| =substr_cut($rs->title,15)?> |
| 主演:=substr_cut($rs->name,8)?> |
| 导演:=substr_cut($rs->director,8)?> |
| 地区:=$rs->area?> |
| 上映:=date('Y-m-d',$rs->addtime)?> |
| 点播:=$rs->hits?>次 |
| 等级:=chklevel($rs->looklevel)?> |
 |
|
|
|
|
|
if ($i % 2 ==0)
{
echo " ";
}
}
?>
=listpage($maxperpage,$toltal,$page,$action,$keyword,$typeid)?>
|