PHP实现图书信息显示

最新推荐文章于 2023-02-10 08:39:44 发布

iteye_5722

最新推荐文章于 2023-02-10 08:39:44 发布

阅读量960

点赞数

分类专栏： PHP 文章标签： PHP 图书信息

PHP 专栏收录该内容

47 篇文章 0 订阅

订阅专栏

一数据库脚本

create database db_book;
use db_book;
create table db_book
(
id INT NOT NULL AUTO_INCREMENT,
bookname varchar(50)notnull,
author varchar(20),
price int,
bookpublic varchar(50),
pubtime date notnull,
PRIMARY KEY (id)
);
insert into db_book values(1,"明日之星","大神",20,"明日之星出版社","2016-12-12");

二 PHP脚本

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>图书信息显示</title>
<link rel="stylesheet" type="text/css" href="css/font.css">
</head>
<body topmargin="0" leftmargin="0" bottommargin="0">
<table width="703" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td  bgcolor="#EF5E0F" ><table width="703" border="0" align="center" cellpadding="0" cellspacing="1">
      <tr>
        <td height="25" colspan="5" bgcolor="#FFFFFF">&nbsp;</td>
      </tr>
      <tr>
        <td width="187" height="25" bgcolor="#F39A40"><div align="center">书名</div></td>
        <td width="173" bgcolor="#F39A40"><div align="center">作者</div></td>
        <td width="101" bgcolor="#F39A40"><div align="center">价格</div></td>
        <td width="131" bgcolor="#F39A40"><div align="center">出版社</div></td>
        <td width="105" bgcolor="#F39A40"><div align="center">出版时间</div></td>
      </tr>
	  <?php
	  $conn=mysql_connect("localhost","root","root");
	  mysql_select_db("db_book",$conn);
	  mysql_query("set names gb2312");
	  $sql=mysql_query("select * from db_book order by id desc",$conn);
	  $info=mysql_fetch_array($sql);
	   if($info==false)
	    {
		  echo "暂无图书信息！";
		}
		else
		{   
		  do
		   {
	  ?>
      <tr>
        <td height="25" bgcolor="#FFFFFF"><div align="center"><?php echo $info[bookname];?></div></td>
        <td height="25" bgcolor="#FFFFFF"><div align="center"><?php echo $info[author];?></div></td>
        <td height="25" bgcolor="#FFFFFF"><div align="center"><?php echo $info[price];?></div></td>
        <td height="25" bgcolor="#FFFFFF"><div align="center"><?php echo $info[bookpublic];?></div></td>
        <td height="25" bgcolor="#FFFFFF"><div align="center"><?php echo $info[pubtime];?></div></td>
      </tr>
	  <?php
	      }while($info=mysql_fetch_array($sql));  
		}
	  
	  ?>
    </table></td>
  </tr>
</table>
</body>
</html>

三运行结果