【php开源代码栏目提醒】:网学会员为广大网友收集整理了,showpl.php,希望对大家有所帮助!
<?php
include("top.php");
include("function.php");
$spid=$_GET[spid];
$id=$_GET[id];
?>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/font.css">
<table width="766" height="438" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="209" height="438" valign="top" bgcolor="#FFFFFF"><div align="center">
<?php
include("left.php");
?>
</div></td>
<td width="581" valign="top" bgcolor="#FFFFFF"><table width="550" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="left"><a href="javascript:history.back();">返回</a></div></td>
</tr>
</table>
<table width="550" border="0" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#FDE9C9">
<td height="25" colspan="4"><div align="center" style="color: #990000">商品评论</div></td>
</tr>
<?php
$sql=mysql_query("select count(*) as total from tb_pingjia where spid='".$_GET[id]."'",$conn);
$info=mysql_fetch_array($sql);
$total=$info[total];
if($total==0)
{
echo "本商品暂无评论信息!";
}
else
{
$pagesize=3;
if ($total<=$pagesize){
$pagecount=1;
}
if(($total%$pagesize)!=0){
$pagecount=intval($total/$pagesize)+1;
}else{
$pagecount=$total/$pagesize;
}
if(($_GET[page])==""){
$page=1;
}else{
$page=intval($_GET[page]);
}
$sql1=mysql_query("select * from tb_pingjia where spid='".$_GET[id]."' order by time desc limit ".($page-1)*$pagesize.",$pagesize ",$conn);
while($info1=mysql_fetch_array($
sql1))
{
?>
<tr>
<td width="70" height="20"><div align="center">商品名称:</div></td>
<td width="181"><div align="left">
<?php
$spid=$info1[spid];
$sql2=
mysql_query("select mingcheng from tb_shangpin where id=".$spid."",$conn);
$info2=mysql_fetch_array($sql2);
echo $info2[mingcheng];
?>
</div></td>
<td width="70"><div align="center">评论时间:</div></td>
<td width="229"><div align="left"><?php echo $info1[time];?></div></td>
</tr>
<tr>
<td height="20"><div align="center">评论者:</div></td>
<td height="20" colspan="3"><div align="left">
<?php
$spid=$info1[userid];
$sql3=mysql_query("select name from tb_user where id=".$spid."",$conn);
$info3=mysql_fetch_array($sql3);
echo $info3[name];
?>
</div></td>
</tr>
<tr>
<td height="20"><div align="center">评论主题:</div></td>
<td height="20" colspan="3"><div align="left"><?php echo unhtml($info1[title]);?></div></td>
</tr>
<tr>
<td height="40"><div align="center">评论内容:</div></td>
<td height="40" colspan="3" valign="bottom"><div align="left"><?php echo unhtml($info1[content]);?></div></td>
</tr>
<tr>
<td height="10" colspan="4" background="images/line1.gif"></td>
</tr>
<?php
}
}
?>
</table>
<table width="550" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="right"> 本站共有该商品评论
<?php
echo $total;
?>
条 每页显示 <?php echo $pagesize;?> 条 第 <?php echo $page;?> 页/共 <?php echo $pagecount; ?> 页
<?php
if($page>=2)
{
?>
<a href="showpl.php?page=1" title="首页"><font face="webdings"> 9 </font></a> <a href="showpl.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>&spid=<?php echo $spid;?>&id=<?php echo $id;?>" title="前一页"><font face="webdings"> 7 </font></a>
<?php
}
if($pagecount<=4){
for($i=1;$i<=$pagecount;$i++){
?>
<a href="showpl.php?page=<?php echo $i;?>&spid=<?php echo $spid;?>&id=<?php echo $id;?>"><?php echo $i;?></a>
<?php
}
}else{
for($i=1;$i<=4;$i++){
?>
<a href="showpl.php?page=<?php echo $i;?>&spid=<?php echo $spid;?>&id=<?php echo $id;?>"><?php echo $i;?></a>
<?php }?>
<a href="showpl.php?page=<?php echo $page-1;?>&spid=<?php echo $spid;?>&id=<?php echo $id;?>" title="后一页"><font face="
webdings"> 8 </font></a> <a href="editgoods.php?id=<?php echo $id;?>&page=<?php echo $pagecount;?>&spid=<?php echo $spid;?>&id=<?php echo $id;?>" title="尾页"><font face="webdings"> : </font></a>
<?php }?>
</div></td>
</tr>
</table></td>
</tr>
</table>
<?php
include("bottom.php");
?>