?? 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 + -