How can PHP be used to define a validity period for a specific page to avoid redundant database queries?

To define a validity period for a specific page in PHP to avoid redundant database queries, you can implement a caching mechanism. This involves storing the result of the database query in a cache for a certain period of time, and checking the cache before executing the query again. If the cached data is still valid (within the defined validity period), it can be used instead of querying the database again. 

// Check if cached data is still valid
$cache_file = 'cache/page_data.cache';
$validity_period = 3600; // 1 hour validity period

if (file_exists($cache_file) && time() - filemtime($cache_file) < $validity_period) {
    // Use cached data
    $data = file_get_contents($cache_file);
} else {
    // Query database
    $data = // Your database query here

    // Save data to cache file
    file_put_contents($cache_file, $data);
}

// Use $data for page content
echo $data;

Keywords

PHP validity period specific page database queries optimization

Related Questions