本文介绍如何使用Ajax和PHP MySql进行datatable的更新操作。
首先,我们需要创建一个表格以便显示数据。这里我们使用datatable插件来创建表格。可以在这里下载datatable插件:https://datatables.net/
然后,我们需要建立数据库连接。可以使用以下代码:
$server = "localhost";
$username = "username";
$password = "password";
$database = "database";
$conn = mysqli_connect($server, $username, $password, $database);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
if(isset($_POST['id']) && isset($_POST['name']) && isset($_POST['email']) && isset($_POST['phone'])){
$id = $_POST['id'];
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$sql = "UPDATE users SET name='$name', email='$email', phone='$phone' WHERE id='$id'";
if(mysqli_query($conn, $sql)){
echo "success";
}
else{
echo "error";
}
}
$(document).ready(function(){
var dataTable = $('#users-data').DataTable();
$('#users-data').on('submit', 'form', function(e){
e.preventDefault();
var form_data = $(this).serialize();
$.ajax({
url: "update_user.php",
method: "POST",
data: form_data,
success: function(data){
if(data == "success"){
alert("Record has been updated successfully.");
dataTable.ajax.reload();
}
else{
alert("Record could not be updated.");
}
}
});
});
});
这样,我们就可以通过Ajax将datatable中的数据更新到数据库中了。