【php开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了php开源代码-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 = my
sql_query("SELECT * FROM company WHERE name='$name'",$conn);
$userrow=mysql_fetch_array($result);
if (!empty($userrow))