Zend Data Cache

ItemsGateway.php

class ItemsGateway extends AbstractGateway
{
    protected $table = 'SCF906';

    public function fetchAll()
    {
        // Try to fetch from the cache first
        $response = zend_shm_cache_fetch('itemCodes');
        
        // If itemCodes list isn't in cache
        if ($response === false){
            
            $sql = "SELECT * FROM ".$this->table;
            $stmt = $this->db->query($sql,[]);
            $response = [];
            while ($row = db2_fetch_assoc($stmt))
            {
                $response[] = array_map('trim',$row);
            }
            
            // Store the results in cache
            zend_shm_cache_store('itemCodes',$response,24*3600);
        }
        
        return $response;
    }
}