?? addcompany.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 select_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">
<select name="show" onChange="select_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=$userrow[id];
$name=$userrow[name];
$address=$userrow[address];
$tel=$userrow[tel];
$linkman=$userrow[linkman];
$product=$userrow[product];
echo "<option value=$userrow[id] selected>$userrow[id]:$userrow[name]</option>";
}
else {
echo "<option value=$userrow[id]>$userrow[id]:$userrow[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 ($show!=""){
echo "<td width='72%'>$id</td>";
echo "<input type=hidden name='old_id' value=".$id.">";
}
// 添加新記錄
else {
echo "<td width='72%'>自動生成</td>";
}
?>
</tr>
<tr>
<td width="28%" align="center" > </td>
<td width="72%"> </td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">廠商名稱:</td>
<td width="72%">
<?
if ($show!=""){
?>
<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="#FFFFFF" > </td>
<td width="72%"> </td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">廠商地址:</td>
<td width="72%">
<?
if ($show!=""){
?>
<input type="text" name="address" size="60" maxlength="255" value="<?echo $address;?>">
<?}
else {
?>
<input type="text" name="address" size="60" maxlength="255" >
<?}?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#FFFFFF"> </td>
<td width="72%"> </td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">聯系電話:</td>
<td width="72%">
<?
if ($show!=""){
?>
<input type="text" name="tel" size="60" maxlength="100" value="<?echo $tel;?>">
<?}
else {
?>
<input type="text" name="tel" size="60" maxlength="100" >
<?}?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#FFFFFF"> </td>
<td width="72%"> </td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">聯系人:</td>
<td width="72%">
<?
if ($show!=""){
?>
<input type="text" name="linkman" size="60" maxlength="100" value="<?echo $linkman;?>">
<?}
else {
?>
<input type="text" name="linkman" size="60" maxlength="100" >
<?}?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#FFFFFF"> </td>
<td width="72%"> </td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">主要產品:</td>
<td width="72%">
<?
if ($show!=""){
?>
<input type="text" name="product" size="60" maxlength="255" value="<?echo $prodcut;?>">
<?}
else {
?>
<input type="text" name="product" size="60" maxlength="100" >
<?}?>
</td>
</tr>
<tr align="center">
<td colspan="2">
<?php
// 添加新記錄
if ($show==""){
echo "<input type=submit name=reg value='登記入庫'>";
}
// 修改原記錄
else{
echo "<input type=submit name=mod value='完成修改'>";
}
?>
</td>
</tr>
</table>
</form>
<?
}
// 如果是提交后處理
else {
// 查看信息是否填寫完整
if (($name=="")||($address=="")||($tel=="")||($linkman=="")){
echo "<div align=center><font color=red>信息沒有填寫完整!</font></div>";
exit();
}
// 如果是添加新記錄
if ($reg){
$result = mysql_query("SELECT * FROM company WHERE name='$name'",$conn);
$userrow=mysql_fetch_array($result);
if (!empty($userrow)) {
echo "<div align=center><font color=red>相同的公司記錄已經存在!</font></div>";
exit();
}
// 取得當前時間和日前
$now = date("Y-m-d H:i:s");
$query = "insert into company(name, address, tel, linkman, product, addtime) values ('$name','$address', '$tel', '$linkman', '$product', '$now')";
$res = mysql_query($query, $conn) or die("添加廠商失敗: ".mysql_error());
}
elseif ($mod){
// 取得當前時間和日前
$now = date("Y-m-d H:i:s");
$query = "update company set name='$name',address='$address', tel='$tel', linkman='$linkman', product='$product' where id='$old_id'";
$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 + -