duanlai1855 2013-05-21 11:16
浏览 72
已采纳

清除html文本字段

I have an HTML form for submitting and retrieves data from MySQL database with two buttons, "Save/Submit" and "New/Reset" It fetch data correctly from MySQL database but when I click on New/Reset button for new contact entry it couldn't clear forms text fields. My HTML and PHP codes are as under:

<?php
//Database Connection file.
include'connect.php';
$sql = mysql_query("SELECT * FROM contact_list WHERE id='1'");
While($result = mysql_fetch_assoc($sql)){
   $fname = $result['fname'];
   $lname = $result['lname'];
   $email = $result['email'];
   $contact = $result['contact'];
}

if(isset($_POST['fname'])&&isset($_POST['lname'])&&isset($_POST['email'])&&
isset($_POST['contact'])){
   $fname = $_POST['fname'];
   $lname = $_POST['lname'];
   $email = $_POST['email'];
   $contact = $_POST['contact'];

if($sql = mysql_query("INSERT INTO contact_list VALUES ('', '$fname', '$lname',
'$email', '$contact')")){
   echo'Contact Save Successfully.';
}else{
   echo'Contact not save.';
}
}
?>
<html>
<form action="sample.php" method="POST">
   First Name:<input type="text" name="fname" value="<?php if(isset($fname))
   {echo $fname;}?>">
   Last Name:<input type="text" name="lname" value="<?php if(isset($lname))
   {echo $lname;}?>">
   Email:<input type="text" name="email" value="<?php if(isset($email))
   {echo $email;}?>">
   Contact:<input type="text" name="contact" value="<?php if(isset($contact))
   {echo $contact;}?>">
//Clean all fields of forms for new entry.
   <input type="reset" value="New">
//Save or submit form data into mysql database
   <input type="submit" value="Save">
</form>
</html>
  • 写回答

1条回答 默认 最新

  • douzai6337 2013-05-21 12:17
    关注

    You can do this easily by using jQuery

    <html>
<head>
<script type="text/javascript">
$(document).ready(function() {
    $("#btnReset").click(function(){
       $("#fname").val("");
       $("#lname").val("");
       $("#email").val("");
       $("#contact").val("");
    }); 
});

</script>
</head>
<form action="sample.php" method="POST">
   First Name:<input type="text" name="fname" value="<?php if(isset($fname))
   {echo $fname;}?>" id="fname">
   Last Name:<input type="text" name="lname" value="<?php if(isset($lname))
   {echo $lname;}?>" id="lname">
   Email:<input type="text" name="email" value="<?php if(isset($email))
   {echo $email;}?>" id="email">
   Contact:<input type="text" name="contact" value="<?php if(isset($contact))
   {echo $contact;}?>" id="contact">
//Clean all fields of forms for new entry.
   <input type="reset" value="New" id="btnReset">
//Save or submit form data into mysql database
   <input type="submit" value="Save" id="btnSave">
</form>
</html>
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题？

悬赏问题

  • ¥15 请教一下各位，为什么我这个没有实现模拟点击
  • ¥15 执行 virtuoso 命令后，界面没有，cadence 启动不起来
  • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作