我不是php专家,但这应该可以帮助您:
首先更改主页上的表单区域:
<div > <textarea name="content_txt" id="contentText" cols="45" rows="5"></textarea><br/> <input type="text" id="balance" /><br/> <input type="text" id="acctNum" /><br/> <input type="text" id="monthly" /><br/> <button id="FormSubmit">Add record</button></div>
那么您的myData看起来像这样:
var myData = { content_txt: $("#contentText").val(), balance: $("#balance").val(), acctNum: $("#acctNum").val(), monthly: $("#monthly").val()};然后在ajax响应中:
$("#contentText").val(''); //empty text field after successful submission$("#balance").val('');$("#acctNum").val('');$("#monthly").val('');最后是PHP:
//sanitize post value, PHP filter FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_HIGH$content = filter_var($_POST['content_txt'],FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_HIGH);$balance = filter_var($_POST['balance'],FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_HIGH);$account = filter_var($_POST['acctNum'],FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_HIGH);$monthly = filter_var($_POST['monthly'],FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_HIGH);$qry= "INSERT INTO add_delete_record(content,balance,account,monthly) VALUES('".$content."','".$balance."','".$account."','".$monthly."')";// Insert sanitize string in recordif(mysql_query("INSERT INTO add_delete_record(content,balance,account,monthly) VALUES('".$content."','".$balance."','".$account."','".$monthly."')")){ //Record is successfully inserted, respond to ajax request $my_id = mysql_insert_id(); //Get ID of last inserted record from MySQL echo '<li id="item_'.$my_id.'">'; echo '<div ><a href="#" id="del-'.$my_id.'">'; echo '<img src="images/icon_del.gif" border="0" />'; echo '</a></div>'; echo $content.'</li>'; mysql_close($connecDB);}else{ //output error //header('HTTP/1.1 500 '.mysql_error()); header('HTTP/1.1 500 Looks like mysql error, could not insert record!'); exit();}


