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