【php开源代码栏目提醒】:网学会员php开源代码为您提供sell.php参考,解决您在sell.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');
?>
<script language="
JavaScript">
function product_change(){
// alert(document.form1.showpro.value);
form1.submit();
}
</script>
<html>
<body>
<?php
// 如果是提交前
if ($sell=="") { ?>
<form name="form1" method="post" action="<?php echo $PHP_SELF ?>" >
<table width="60%" border="0" cellspacing="1" cellpadding="3" align="center" bordercolor="#8695AC">
<tr>
<th colspan="2">销 售 登 记</th>
</tr>
<tr align="center">
<td colspan="2"> </td>
</tr>
<tr align="center">
<td colspan="2">
<select name="showpro" onChange="product_change()">
<option value="" selected>选择存货产品</option>
<?php
$sqlp="SELECT * FROM stock ";
$resultp = mysql_query($sqlp,$conn) or die("数据库操作错误");
while ($userrowp=mysql_fetch_Array($resultp)){
// 显示该产品信息
// 获得该产品的详细信息
$psql="select * from product where productid='$userrowp[productid]'";
$presult=mysql_query($psql,$conn);
$prow=mysql_fetch_array($presult);
if ($showpro==$userrowp[productid]){
$productid=$userrowp[productid];
$amount=$userrowp[amount];
$sellprice=$userrowp[sellprice];
$buyprice=$userrowp[buyprice];
$buytime=$userrowp[buytime];
$name=$prow[name];
$brand=$prow[brand];
$type=$prow[type];
$intro=$prow[introduction];
// 获得该产品的厂商名称
$cresult=mysql_query("select * from company where id='$prow[companyid]'",$conn);
$crow=my
sql_fetch_array($cresult);
$companyid=$crow[id];
$companyname=$crow[name];
echo "<option value=$userrowp[productid] selected>$userrowp[productid]:$prow[name]</option>";
}
else {
echo "<option value=$userrowp[productid]>$userrowp[productid]:$prow[name]</option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<td width="28%" align="center" > </td>
<td width="72%"> </td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">厂商ID:</td>
<?
// 选择了存货
if ($showpro!=""){
echo "<td width='72%'>$companyid:$companyname</td>";
}
// 没有选择存货
else {
echo "<td width='72%'>请选择存货</td>";
// 设置产品信息变量为空
$name="";
$brand="";
$type="";
$intro="";
$showpro="";
$amount="";
$sellprice="";
$companyid="";
$companyname="";
}
?>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品ID:</td>
<?
// 选择了存货
if ($showpro!=""){
echo "<td width='72%'>$productid</td>";
echo "<input type=hidden name='productid' value=".$productid.">";
}
// 没有选择存货
else {
echo "<td width='72%'>请选择存货</td>";
}
?>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品名称:</td>
<td width="72%">
<?
// 如果选择了产品,则显示产品信息
if ($showpro!=""){
echo $name;
echo "<input type=hidden name='name' value=".$name.">";
}
// 如果没有选择产品,则不显示任何信息
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品品牌:</td>
<td width="72%">
<?
if ($showpro!=""){
echo $brand;
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品类型:</td>
<td width="72%">
<?
if ($showpro!=""){
echo $type;
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品介绍:</td>
<td width="72%">
<?
if ($showpro!=""){
echo $intro;
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">存货数量:</td>
<td width="72%">
<?
if ($showpro!=""){
echo $amount;
echo "<input type=hidden name='amount' value=".$amount.">";
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">欲售单价:</td>
<td width="72%">
<?
if ($showpro!=""){
echo $sellprice."元";
echo "<input type=hidden name='sellprice' value=".$sellprice.">";
echo "<input type=hidden name='buyprice' value=".$buyprice.">";
echo "<input type=hidden name='buytime' value=".$buytime.">";
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">出售数量:</td>
<td width="72%">
<input type="text" name="sellamount" size="30" maxlength="50">
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">销售总额:</td>
<td width='72%'>自动计算</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">备