最终弄清楚了。谢谢大家的帮助。
<p id="alert"></p> <form id="form" method="post" action="/ajax/update_company_info.php"> <!-- start id-form --> <table border="0" cellpadding="0" cellspacing="0" id="id-form"> <tr> <th valign="top">Business Name:</th> <td><input type="text" name="company_name" /></td> <td></td> </tr> <tr> <th valign="top">Address 1:</th> <td><input type="text" name="address_1" /></td> <td></td> </tr> <tr> <th valign="top">Address 2:</th> <td><input type="text" name="address_2" /></td> <td></td> </tr><tr> <th> </th> <td valign="top"> <input id="where" type="hidden" name="customer_id" value="1" /> <input type="submit" value="Save" id="submit"> </td> <td></td></tr></table><!-- end id-form --></form>
update.js
$(document).ready(function() {$('form').submit(function(evt) { evt.preventDefault(); $.each(this, function() { // VARIABLES: Input-specific var input = $(this); var value = input.val(); var column = input.attr('name'); // VARIABLES: Form-specific var form = input.parents('form'); //var method = form.attr('method'); //var action = form.attr('action'); // VARIABLES: Where to update in database var where_val = form.find('#where').val(); var where_col = form.find('#where').attr('name'); $.ajax({ url: "/ajax/update_company_info.php", data: { val: value, col: column, w_col: where_col, w_val: where_val }, type: "POST", success: function(data) { $('#alert').html("<p>Sent Successfully!</p>"); } }); // end post });// end each input value}); // end submit}); // end readyupdate_customer_info.php
<?phpinclude($_SERVER['document_ROOT'] . '/load.php');function clean($value){ return mysql_real_escape_string($value);}// FORM: Variables were postedif (count($_POST)){ // Prepare form variables for database foreach($_POST as $column => $value) ${$column} = clean($value); // Perform MySQL UPDATE $result = mysql_query("UPDATE customers SET ".$col."='".$val."' WHERe ".$w_col."='".$w_val."'") or die ('Error: Unable to update.');}?>
