What are some best practices for optimizing PHP scripts to avoid page reloading issues?

Page reloading issues in PHP scripts can be avoided by optimizing the code to minimize unnecessary database queries, reducing the amount of data being transferred between the server and client, and using techniques like AJAX to update parts of the page without reloading the entire page. Example PHP code snippet using AJAX to avoid page reloading:

// index.php
<!DOCTYPE html>
<html>
<head>
    <title>AJAX Example</title>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
    <script>
        $(document).ready(function(){
            $("#btn").click(function(){
                $.ajax({
                    url: 'update.php',
                    type: 'POST',
                    data: {name: 'John'},
                    success: function(response){
                        $("#result").html(response);
                    }
                });
            });
        });
    </script>
</head>
<body>
    <button id="btn">Update Name</button>
    <div id="result"></div>
</body>
</html>

// update.php
<?php
$name = $_POST['name'];
echo "Hello, $name!";
?>