📄 addproduct.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 company_change(){
//alert(document.form1.show.value);
form1.submit();
}
function product_change(){
form1.submit();
}
</script>
<html>
<body>
<?php
// 如果是提交前
if (($reg=="")&&($mod=="")) { ?>
<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">
<table width="60%"><tr><td align=center width="50%">
<select name="show" onChange="company_change()">
<option value="" selected>选择产品所属厂商</option>
<?php
$sql="SELECT * FROM company";
$result = mysql_query($sql,$conn) or die("数据库操作错误");
while ($userrow=mysql_fetch_Array($result)){
// 显示该厂商信息
if ($show==$userrow[id]){
// 保存该厂商名字和id用于以后显示
$companyid=$userrow[id];
$companyname=$userrow[name];
echo "<option value=$userrow[id] selected>$userrow[id]:$userrow[name]</option>";
}
else {
echo "<option value=$userrow[id]>$userrow[id]:$userrow[name]</option>";
}
}
?>
</select>
</td>
<td align=center width="50%">
<select name="showpro" onChange="product_change()">
<option value="" selected>选择产品</option>
<?php
$sqlp="SELECT * FROM product where companyid='$companyid'";
$resultp = mysql_query($sqlp,$conn) or die("数据库操作错误");
while ($userrowp=mysql_fetch_Array($resultp)){
// 显示该产品信息
if ($showpro==$userrowp[productid]){
$productid=$userrowp[productid];
$name=$userrowp[name];
$brand=$userrowp[brand];
$type=$userrowp[type];
$intro=$userrowp[introduction];
$other=$userrowp[other];
echo "<option value=$userrowp[productid] selected>$userrowp[productid]:$userrowp[name]</option>";
}
else {
echo "<option value=$userrowp[productid]>$userrowp[productid]:$userrowp[name]</option>";
}
}
?>
</select>
</td></tr></table>
</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 ($show!=""){
echo "<td width='72%'>$companyid:$companyname</td>";
echo "<input type=hidden name='old_id' value=".$companyid.">";
}
// 添加新记录
else {
echo "<td width='72%'>请选择厂商</td>";
// 设置产品信息变量为空
$name="";
$brand="";
$type="";
$intro="";
$other="";
$showpro="";
}
?>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品ID：</td>
<?
// 显示原记录
if ($showpro!=""){
echo "<td width='72%'>$productid</td>";
echo "<input type=hidden name='old_pid' value=".$productid.">";
}
// 添加新记录
else {
echo "<td width='72%'>自动生成</td>";
}
?>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品名称：</td>
<td width="72%">
<?
if ($showpro!=""){
?>
<input type="text" name="name" size="60" maxlength="100" value="<?echo $name;?>">
<?}
else {?>
<input type="text" name="name" size="60" maxlength="100">
<?}?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品品牌：</td>
<td width="72%">
<?
if ($showpro!=""){
?>
<input type="text" name="brand" size="60" maxlength="255" value="<?echo $brand;?>">
<?}
else {?>
<input type="text" name="brand" size="60" maxlength="255" >
<?}?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品类型：</td>
<td width="72%">
<?
if ($showpro!=""){
?>
<input type="text" name="type" size="60" maxlength="255" value="<?echo $type;?>">
<?}
else {?>
<input type="text" name="type" size="60" maxlength="255">
<?}?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品介绍：</td>
<td width="72%">
<?
if ($showpro!=""){
?>
<textarea name="intro" cols="60" rows='5'><?echo $intro;?></textarea>
<?}
else {?>
<textarea name="intro" cols="60" rows='5'></textarea>
<?}?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">备 注：</td>
<td width="72%">
<?
if ($showpro!=""){
?>
<textarea name="other" cols="60" rows='5'><?echo $other;?></textarea>
<?}
else {?>
<textarea name="other" cols="60" rows='5'></textarea>
<?}?>
</td>
</tr>
<tr align="center">
<td colspan="2">
<?php
// 添加新记录
if ($showpro==""){
echo "<input type=submit name=reg value='登记入库'>";
}
// 修改原记录
else{
echo "<input type=submit name=mod value='完成修改'>";
}
?>
</td>
</tr>
</table>
</form>
<?
}
// 如果是提交后处理
else {
// 查看信息是否填写完整
if (($name=="")||($brand=="")||($type=="")||($old_id=="")){
echo "<div align=center><font color=red>信息没有填写完整！</font></div>";
exit();
}
// 如果是添加新记录
if ($reg){
$result = mysql_query("SELECT * FROM product WHERE name='$name' and companyid='$old_id' and brand='$brand' and type='$type'",$conn);
$userrow=mysql_fetch_array($result);
if (!empty($userrow)) {
echo "<div align=center><font color=red>该公司的相同产品记录已经存在！</font></div>";
exit();
}
$query = "insert into product(companyid, name, brand, type, introduction, other) values ('$old_id','$name','$brand', '$type', '$intro', '$other')";
$res = mysql_query($query, $conn) or die("添加产品记录失败: ".mysql_error());
}
elseif ($mod){
$query = "insert into product(companyid, name, brand, type, introduction, other) values ('$old_id','$name','$brand', '$type', '$intro', '$other')";
$query = "update product set name='$name',brand='$brand', type='$type', introduction='$intro', other='$other' where productid='$old_pid'";
$res = mysql_query($query, $conn) or die("修改产品记录失败: ".mysql_error());
}
?>
<p align="center"> </p>
<p align="center"> </p>
<p align="center"><font color="red">恭喜您！！</font><br>
<br>
登记完成！</p>
<p align="center"><a href="<?php echo $PHP_SELF ?>">继续添加</a><br>
</p><?php } ?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -