php表格显示数据库数据_PHP把数据库数据显示到表格里资源-CSDN文库

共13个文件

php：6个

prefs：2个

html：1个

4星 · 超过85%的资源需积分: 50 145 浏览量 2010-12-11 21:05:49 上传评论 1 收藏 114KB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

richangyongpin.rar （13个子文件）

richangyongpin

.project 524B

update_do.php 564B

insert.html 518B

update.php 830B

.settings

org.eclipse.php.core.prefs 140B

org.eclipse.core.resources.prefs 87B

63a6dd6417c9a5fcf73654ba.jpg 95KB

insert.php 570B

yongpin.php 3KB

.buildpath 174B

conn.inc.php 137B

jquery-1.4.2.min.js 70KB

delete.php 398B

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>日常用品价格一览表</title> <style>  </style> <script type="text/javascript" language="javascript" src="js/jquery-1.4.2.min.js"></script> <script> $(document).ready( function(){ $("tr:even").css("background-color","lavender"); $("tr:odd").bind("mouseover",function(){ $(this).css("background-color","skyblue"); } ); $("tr:odd").bind("mouseout",function(){ $(this).css("background-color","#ffffff"); } ); $("tr:even").bind("mouseover",function(){ $(this).css("background-color","skyblue"); } ); $("tr:even").bind("mouseout",function(){ $(this).css("background-color","lavender"); } ); } ); </script> </head> <body background="63a6dd6417c9a5fcf73654ba.jpg"> <table cellpadding='3'> <tr> <th>编号</th> <th>名称</th> <th>价格</th> <th>删除</th> <th>修改</th> </tr> <?php //$pageIndex=1; $pageIndex=isset($_GET["page"])?$_GET["page"]:1; $pageSize=3; $link = mysql_connect ( "localhost", "root", "root" ); mysql_query ( "set names utf8", $link ); mysql_select_db ( "yongpin", $link ); $sqlCount="select count(*) as cnt from things";//从things表中获取行数 $rst=mysql_query($sqlCount,$link); $rowCount=mysql_fetch_array($rst); $pageCount=ceil($rowCount["cnt"]/$pageSize);//取不小于($rowCount["cnt"]/$pageSize)的下一个整数 $offset=($pageIndex-1)*$pageSize; $sql="select * from things limit $offset,$pageSize ";//limit[起始记录行数],[记录条数] $result=mysql_query($sql,$link); while($row=mysql_fetch_array($result)){ ?> <tr> <td><?php echo $row[0];?></td> <td><?php echo $row[1];?></td> <td><?php echo $row[2];?></td> <td><a href="delete.php?id=<?php echo $row[0]; ?>" onclick="return confirm('确定删除吗？')">删除</a></td> <td><a href="update.php?id=<?php echo $row[0]; ?>">修改</a></td> </tr> <?php } mysql_free_result($result); mysql_close($link); ?> <tr> <td colspan="5" align="center"> <?php //分页链接的输出 $firstPageUrl="<a href='yongpin.php?page=1'>首页</a>"; $previosPageUrl="<a href='yongpin.php?page=".($pageIndex-1)."'>上一页</a>"; $nextPageUrl="<a href='yongpin.php?page=".($pageIndex+1)."'>下一页</a>"; $lastPageUrl="<a href='yongpin.php?page=$pageCount'>末页</a>"; if($pageCount>1){ if($pageIndex>1){ echo $firstPageUrl; echo "    "; echo $previosPageUrl; if($pageIndex<$pageCount){ echo "    "; echo $nextPageUrl; echo "    "; echo $lastPageUrl; } }else{ echo "    "; echo $nextPageUrl; echo "    "; echo $lastPageUrl; } } ?> </td> </tr> </table> <form action="insert.html" method='post'> <?php echo "              "; ?> <input type="submit" value="添加" /> <form/> </body> </html>

评论收藏

内容反馈