What are some best practices for updating table data in PHP without redirecting to a separate page?

When updating table data in PHP without redirecting to a separate page, you can use AJAX to send the data asynchronously to the server and update the database without reloading the page. This allows for a seamless user experience and improves the performance of the application. 

<?php
// Check if the request is an AJAX request
if(isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
    // Handle the update logic here
    // For example, update the database with the new data
    $newData = $_POST['new_data'];
    
    // Perform the update query
    // $sql = "UPDATE table_name SET column_name = :new_data WHERE id = :id";
    // $stmt = $pdo->prepare($sql);
    // $stmt->execute(['new_data' => $newData, 'id' => $id]);
    
    // Send a response back to the client
    echo json_encode(['success' => true]);
    exit;
} else {
    // Redirect to an error page if the request is not AJAX
    header('Location: error.php');
    exit;
}
?>

Keywords

PHP AJAX jQuery MySQL form submission

Related Questions