内联编辑和保存到数据库需要很长时间

Question

I want to make an editable table and directly save it to a database. I use code from:

http://code.jquery.com/jquery-1.10.2.js

Here is the JavaScript function:

<script>
function showEdit(editableObj) {
    $(editableObj).css("background","#FFF");
} 

function saveToDatabase(editableObj,column,id) {
    $(editableObj).css("background","#FFF url(loaderIcon.gif) no-repeat right");
    $.ajax({
        url: "saveedit.php",
        type: "POST",
        data:'column='+column+'&editval='+editableObj.innerHTML+'&id='+id,
        success: function(data){
            $(editableObj).css("background","#FDFDFD");
        }        
   });
}
</script>

And this is the code to save it:

<?php
require_once("dbcontroller.php");
$db_handle = new DBController();
$result = mysql_query("UPDATE php_interview_questions set " . $_POST["column"] . " = '".$_POST["editval"]."' WHERE  id=".$_POST["id"]);
?>

And this is the example of how I put it into PHP:

<tr class="table-row">
    <td><?php echo $k+1; ?></td>
    <td contenteditable="true" onBlur="saveToDatabase(this,'question','<?php echo $faq[$k]["id"]; ?>')" onClick="showEdit(this);"><?php echo $faq[$k]["question"]; ?></td>
    <td contenteditable="true" onBlur="saveToDatabase(this,'answer','<?php echo $faq[$k]["id"]; ?>')" onClick="showEdit(this);"><?php echo $faq[$k]["answer"]; ?></td>
</tr>

When I run the file, it takes a very long time to load and save it. How can I tune this?

Answer 1

Hello why you not download this file http://code.jquery.com/jquery-1.10.2.js in your local machine and use this