$insert="insert into table_net (t_number,z_number,m_number,bumen,z_username,e_username,net_login,email_login,baan_login,beizhu)values('$ext','$host','$display','$dep','$cnname','$enname','$netlogin','$email','$bann','$re')"; 改成 $insert="insert into table_net (t_number,z_number,m_number,bumen,z_username,e_username,net_login,email_login,baan_login,beizhu) values('$ext','$host','$display','$dep','$cnname','$enname','$netlogin','$email','$bann','$re')";values前面加一个空格
{
echo"<script>alert('Data add succeed!');</script>";
}else{
echo"<script>alert('Data add failed!');</script>";
}
}else{
把这些屏蔽掉再echo $insert;
因为有可能script错误导致echo不出来。一步一步调试才是王道
改成
$insert="insert into table_net (t_number,z_number,m_number,bumen,z_username,e_username,net_login,email_login,baan_login,beizhu) values('$ext','$host','$display','$dep','$cnname','$enname','$netlogin','$email','$bann','$re')";values前面加一个空格
<!--
.aa {
font-family: Arial, Helvetica, sans-serif;
font-size: 10pt;
}
-->
</style>
<?
if ($add)
{
$db = mysql_connect("localhost","root","jason");
mysql_select_db("net_computer",$db);
//$insert="insert into table_net t_number="$ext",z_number="$host",m_number="$display",bumen="$dep",z_username="$cnname",e_username="$enname",net_login="$netlogin",email_login="$email",baan_login="$bann",beizhu="$re",ddtime=now()";
$sql="insert into table_net (t_number,z_number,m_number,bumen,z_username,e_username,net_login,email_login,baan_login,beizhu,ddtime)values('$ext','$host','$display','$dep','$cnname','$enname','$netlogin','$email','$bann','$re',now())";$query=mysql_query($sql);
if ($query)
{
echo"<script>alert('Data add succeed!');</script>";
}else{
echo"<script>alert('Data add failed!');</script>";
}
}else{
?><form id="form1" name="form1" method="post" action="<? echo $PHP_SELF; ?>">
<table width="690" height="167" border="0" cellspacing="1" bgcolor="#CCCCCC" class="aa">
<tr>
<td width="125" bgcolor="#FFFFFF">Extension:</td>
<td colspan="7" bgcolor="#FFFFFF">
<input name="ext" type="text" id="ext" size="10" /> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF">Department:</td>
<td width="72" bgcolor="#FFFFFF"><input name="dep" type="text" id="dep" size="10" /></td>
<td width="99" bgcolor="#FFFFFF">CN-name :</td>
<td width="73" bgcolor="#FFFFFF"><input name="cnname" type="text" id="cnname" size="10" /></td>
<td width="81" bgcolor="#FFFFFF">EN-name:</td>
<td width="73" bgcolor="#FFFFFF"><input name="enname" type="text" id="enname" size="10" /></td>
<td width="66" bgcolor="#FFFFFF">Net-Login:</td>
<td width="76" bgcolor="#FFFFFF"><input name="netlogin" type="text" id="netlogin" size="10" /></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">Email-Login:</td>
<td bgcolor="#FFFFFF"><input name="email" type="text" id="email" size="10" /></td>
<td bgcolor="#FFFFFF">Bann-Login:</td>
<td colspan="5" bgcolor="#FFFFFF"><input name="bann" type="text" id="bann" size="10" /></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">Host computer SN : </td>
<td bgcolor="#FFFFFF"><input name="host" type="text" id="host" size="10" /></td>
<td bgcolor="#FFFFFF">Display SN :</td>
<td colspan="5" bgcolor="#FFFFFF"><input name="display" type="text" id="display" size="10" /></td>
</tr>
<tr>
<td colspan="8" bgcolor="#FFFFFF"><table width="520" border="0" cellpadding="0" cellspacing="0" class="aa">
<tr>
<td width="125">Re:</td>
<td width="395"><label>
<textarea name="re" cols="50" rows="3" id="re"></textarea>
</label></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="8" bgcolor="#FFFFFF"><input name="add" type="submit" id="add" value="Add data" />
<input type="reset" name="Submit2" value="Clear data" />
<input type="button" name="Submit3" value="Close window" onclick="window.close()"/></td>
</tr></table></form>
<?}?>
忘记把register_globals的值改为On了!再次感谢各位!