Ajax表单提交提交按钮

I've got form which when submitted (using AJAX) returns a bunch of client details. The form field collects the user's ID, submits and returns the results. I'd like to use a submit button rather than an onchange on the textbox but am unable to submit the textbox value and have the anything returned.

我有一个表单,当提交(使用AJAX)返回一堆客户端详细信息。表单字段收集用户的ID,提交并返回结果。我想在文本框上使用提交按钮而不是onchange但是无法提交文本框值并返回任何内容。

This seems like it should be simple but I'm again in need of some help.

这似乎应该很简单,但我又需要一些帮助。

Thanks, @rrfive

Form:

<form>
<strong>Client ID:</strong>
<input name="user" type="text" class="textBox" maxlength="10" />
<input type="submit" onclick="showUser(this.form); return false;"> 
</form>

JS:

<script type="text/javascript">
function showUser(str)
{
if (str=="") {
  document.getElementById("txtHint").innerHTML="";
  return;
  }
if (window.XMLHttpRequest) {
  xmlhttp=new XMLHttpRequest();
  }
else {
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
    xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","includes/fetchUser.php?userID="+str,true);
xmlhttp.send();
}
</script>

PHP:

<?php
define('INCLUDE_CHECK',true);
include 'config.php';

$userID=$_GET["userID"];
$sql="SELECT * FROM users WHERE ID = '".$userID."'";
$result = mysql_query($sql);

$returned_rows = mysql_num_rows ($result);

    if ($returned_rows == 0){
        echo '-- No results found --';
    }
    else {
        while($row = mysql_fetch_array($result)) {
        echo "<div class='column'>";
        echo '<label>Name:</label>' . $row['lastName'] . '
        echo '</div>';
        }
     }

mysql_close($con);
?> 

2 个解决方案

#1

You don't need to pass in the whole form, just the "user" input.

您不需要传递整个表单,只需传入“用户”输入。

Form:

<form name="myform">
<strong>Client ID:</strong>
<input name="user" type="text" class="textBox" maxlength="10" />
<input type="submit" onclick="showUser(document.myform.user.value); return false;"> 
</form>

In your PHP, please remember you need to sanitise the input before using it in a database query. Read up on mysql_real_escape_string or prepared statements

在PHP中,请记住在数据库查询中使用它之前需要清理输入。阅读mysql_real_escape_string或预处理语句

#2

<form onsubmit="return false;">