按回车提交不了,用鼠标点确定就可以
做了个页面,按回车提交不了,用鼠标点确定就可以
<?php
<FORM METHOD=POST ACTION="1.php" name="form1">
<table width=550 border=1>
<tr><td colspan=4 bgcolor="#BADCFE"><b><font color="#000099">汇率信息(单位:人民币/100外币)</font></b></td></tr>
<tr><td>币种</td><td>
<?php print_list(12,coin);?>
<tr><td>汇率</td>
<td><INPUT TYPE="text" NAME="exchange_rate" onkeyup= "value=value.replace(/[^\d]/g,'')"></td></tr>
<tr><td colspan=4 align=left>
<INPUT TYPE="submit" name="s_exchange_rate_add" value="确定添加"></td></tr>
</table>
</FORM>
<?php
$oper_date=strftime("%Y-%m-%d");
if($s_exchange_rate_add)
{
$sql1="select id from exchange_rate where coin=$coin";
$res1=mysql_query($sql1);
if(!mysql_fetch_row($res1))
{
$sql2="insert into exchange_rate(coin,exchange_rate,oper_id,oper_date,current_rate) value('$coin','$exchange_rate','$Userid','$oper_date',1)";
mysql_query($sql2);
echo "<font color=#3300FF><B>汇率添加成功</B></font>";
}
else echo "当前汇率已存在,请重新输入";
}
?>