browse.php

用PHP,mySQL实现产品进销存的网站。是初学PHP很好的教材

<?
//初始化session
session_cache_expire(30);
session_start();

// 如果没有登录，退出
if(!isset($_SESSION['user'])) {
   echo "<p align=center>";
   echo "<font color=#FF0000 size=5><strong><big>";
   echo "您还没有登录,请<a href='login.php'>登录</a>!";
   echo "</big></strong></font></p>";
   exit();
}
include ('head.php');
require ('dbconnect.php');
?>
<?
echo "<h2 align=center>查看存货</h2>";
// 构造sql语句浏览查询
$sql="select * from stock order by buytime desc";
$result=mysql_query($sql,$conn) or die ("查询数据失败: ".mysql_error());
echo "<table border=1 width='100%' align=center>";
echo "<th >产品ID</th>";
echo "<th >产品名称</th>";
echo "<th >厂商名称</th>";
echo "<th >产品型号</th>";
echo "<th >产品品牌</th>";
echo "<th >产品介绍</th>";
echo "<th >购买时间</th>";
echo "<th >购买价格</th>";
echo "<th >欲售价格</th>";
echo "<th >存货数量</th>";
echo "<th >存货花费</th>";

while($row=mysql_fetch_array($result)){
	// 得到存货信息
	echo "<tr>";
	echo "<td align=center>$row[productid]</td>";
	// 获得该产品的详细信息
	$psql="select * from product where productid='$row[productid]'";
	$presult=mysql_query($psql,$conn);
	$prow=mysql_fetch_array($presult);	
	echo "<td align=center>$prow[name]</td>";
	// 获得该产品的厂商名称
	$cresult=mysql_query("select * from company where id='$prow[companyid]'",$conn);
	$crow=mysql_fetch_array($cresult);
	echo "<td align=center>$crow[name]</td>";
	echo "<td align=center>$prow[type]</td>";
	echo "<td align=center>$prow[brand]</td>";
	echo "<td align=center>$prow[introduction]</td>";
	echo "<td align=center>$row[buytime]</td>";
	echo "<td align=center>$row[buyprice]</td>";
	echo "<td align=center>$row[sellprice]</td>";
	echo "<td align=center>$row[amount]</td>";	
	echo "<td align=center>$row[cost]</td>";
	echo "</tr>";
}
echo "</table>";
echo "<h1></h1>";
echo "<div align=center><a href='modify.php'>修改欲售价格</a></div>";
?>