<?
session_start();
?>
<HTML ><HEAD id=Head1><TITLE>产品信息列表</TITLE>
<LINK href="../images/style.css" type=text/css rel=stylesheet>
<link rel="stylesheet" type="text/css" media="screen" href="../css/tinyTips.css" />
<?
include("../data.php");
include("../config.php");
?>
<META content="MSHTML 6.00.2900.3492" name=GENERATOR></HEAD>
<BODY>
<FORM name="form" method="post" action="" >
<table class="border" width="98%" border="0" align="center" cellpadding="1" cellspacing="0">
<tr>
<td height="565" align="center" valign="top" class="bg_low"><table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle" class="bgtop"><font color="#FFFFFF"><b>产品列表</b></font> </td>
</tr>
</table>
<TABLE cellSpacing=0 cellPadding=3 width="100%" align=center border=0>
<TBODY>
<tr align="center" bgcolor="#FAFAF1" height="22">
<td>序号</td>
<td>产品编号</td>
<td>产品</td>
<td>分类</td>
<td>型号</td>
<td>图片</td>
<td>价格</td>
<td>简介</td>
<td>描述</td>
<td>操作</td>
</tr>
<?
$page=$_GET[page];
if($page){
}else{
$page=1;
}
$sql="select * from chanpin where 1=1";
//$row['title']
$result=mysql_query($sql);
$i=1;
while($row=mysql_fetch_array($result)){
if ($page){
$page_size=20; //每页显示20条记录
$query="select count(*) as total from chanpin where 1=1";
$result=mysql_query($query); //查询总的记录条数
$message_count=mysql_result($result,0,"total"); //为变量赋值
$page_count=ceil($message_count/$page_size); //根据记录总数除以每页显示的记录数求出所分的页数
$offset=($page-1)*$page_size; //计算下一页从第几条数据开始循环
$sql=mysql_query("select * from chanpin where 1=1 limit $offset, $page_size");
$i=1;
while($row=mysql_fetch_array($sql)){
?>
<tr align='center' bgcolor="#FFFFFF" onMouseMove="javascript:this.bgColor='#FCFDEE';" onMouseOut="javascript:this.bgColor='#FFFFFF';" height="22" >
<td ><?=$i?></td>
<td ><?=$row['cpid']?></td>
<td ><?=$row['cp']?></td>
<td ><?=$row['fl']?></td>
<td ><?=$row['xh']?></td>
<td ><?=$row['tp']?></td>
<td ><?=$row['jg']?></td>
<td ><?=$row['jj']?></td>
<td ><?=$row['ms']?></td>
<td><a href="chanpindelete.php?keyid=<?=$row['cpid']?>" onClick="javascript:if(confirm('是否删除')){return true;} else{return false;}">删除</a>|<a href="chanpinmodify.php?keyid=<?=$row['cpid']?>">修改</a>|<a href="chanpindetail.php?keyid=<?=$row['cpid']?>">详细</a></td>
</tr>
<?
$i=$i+1;
}
?>
<?php
}
?>
</TBODY></TABLE></td></tr>
<tr><td class="bgtop"> 页次：<?php echo $page;?>/<?php echo $page_count;?>页
记录：<?php echo $message_count;?> 条 </td>
<?php
if($page!=1)
{
echo "<a href=chanpinlist.php?page=1>首页</a> ";
echo "<a href=chanpinlist.php?page=".($page-1).">上一页</a> ";
}
if($page<$page_count)
{
echo "<a href=chanpinlist.php?page=".($page+1).">下一页</a> ";
echo "<a href=chanpinlist.php?page=".$page_count.">尾页</a>";
}
}
?></td></tr>
</table>
</DIV>
</div>
<table width="98%" border="0" cellpadding="0" cellspacing="1" bgcolor="#D1DDAA" align="center">
<tr bgcolor="#FAFAF1" >
<td >
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center">
产品列表
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="98%" border="0" cellpadding="2" cellspacing="1" bgcolor="#D1DDAA" align="center" style="margin-top:8px">
<tr bgcolor="#E7E7E7">
<td height="24" colspan="12" background="../skin/images/tbg.gif"> 产品信息列表 </td>
</tr>
<tr align="center" bgcolor="#FAFAF1" height="22">
<td>序号</td>
<td>产品编号</td>
<td>产品</td>
<td>分类</td>
<td>型号</td>
<td>图片</td>
<td>价格</td>
<td>简介</td>
<td>描述</td>
<td>操作</td>
</tr>
<?
$sql="select * from chanpin where 1=1";
//$row['title']
$result=mysql_query($sql);
$i=1;
while($row=mysql_fetch_array($result)){
?>
<tr align='center' bgcolor="#FFFFFF" onMouseMove="javascript:this.bgColor='#FCFDEE';" onMouseOut="javascript:this.bgColor='#FFFFFF';" height="22" >
<td ><?=$i?></td>
<td ><?=$row['cpid']?></td>
<td ><?=$row['cp']?></td>
<td ><?=$row['fl']?></td>
<td ><?=$row['xh']?></td>
<td ><?=$row['tp']?></td>
<td ><?=$row['jg']?></td>
<td ><?=$row['jj']?></td>
<td ><?=$row['ms']?></td>
<td><a href="chanpindelete.php?keyid=<?=$row['cpid']?>" onClick="javascript:if(confirm('是否删除')){return true;} else{return false;}">删除</a>|<a href="chanpinmodify.php?keyid=<?=$row['cpid']?>">修改</a>|<a href="chanpindetail.php?keyid=<?=$row['cpid']?>">详细</a></td>
</tr>
<?
$i++;
}
?>
</table>
</FORM></BODY></HTML>
计算机毕业设计 PHP 园艺系统网站mysql数据库web结构apache计算机软件工程网页wamp （316个子文件） 
header.php.bak 3KB css.css.bak 2KB main.php.bak 753B index.html.bak 707B index.php....bak 687B style.css 30KB style.css 22KB css.css 16KB style.css 11KB album.css 8KB css_body.css 7KB head.css 6KB control.css 5KB common1.css 4KB datepicker.css 4KB datepicker.css 4KB css_top_user.css 3KB css_top.css 3KB css_menu_user.css 3KB base.css 3KB css_menu.css 2KB 3css.css 2KB css.css 2KB all.css 2KB wbox.css 2KB style0.css 1KB wbox-min.css 1KB tinyTips.css 797B lrtk.css 402B WdatePicker.css 161B
bj.gif 71KB mico_l.gif 14KB top_nav_on.gif 14KB toolbar_no.gif 13KB view.gif 13KB 02.gif 13KB 01.gif 13KB login.gif 6KB logo_01.gif 5KB right_bg1.gif 3KB right_class_bg.gif 3KB right_bg2.gif 3KB loading.gif 3KB mico_1.gif 3KB top_bg.gif 2KB img.gif 2KB img.gif 2KB left_bg_top.gif 1KB close2.gif 1KB help.gif 1KB datePicker.gif 1KB login_submit.gif 1KB skype.gif 1000B 复件 top_nav_on.gif 967B tpbg.gif 900B close.gif 868B mb_bg.gif 756B noimage.gif 719B rcbox_title.gif 677B login_button.gif 582B main_bg.gif 531B search_button.gif 516B top_nav_link2.gif 475B login_input_hr.gif 430B image_s.gif 338B menunowbg.gif 322B nav_line.gif 270B login_input_bg.gif 260B pbg.gif 258B login_input.gif 254B search_input.gif 243B left_bottom.gif 240B ico_1.gif 204B nav_bg.gif 197B arrowdown.gif 167B body_title_bg.gif 155B toolbar_ok.gif 150B toolbar_del.gif 148B menulist.gif 100B frame_on.gif 95B inputbut_bg.gif 93B ico_5.gif 76B ico_3.gif 76B ico_4.gif 76B ico_2.gif 73B body_title_right.gif 72B body_title_left.gif 72B class_ssr.gif 70B class_sopen.gif 69B class_sclose.gif 68B m_tmid.gif 67B frame-r.gif 59B frame-l.gif 59B kong.gif 55B wbox.gif 49B wbox2.gif 49B news_arrow.gif 48B showshop.htm 8KB main.htm 8KB eshowshop.htm 7KB共 316 条
- 1
- 2
- 3
- 4
资源评论
