Hoping someone would be willing to explain/show me how to use this library.
Normally for caching, I used the file system, roughly like this:
What I want to do now is use the PhpFastCache library instead. What I want is for someone to show me how you would handle DB queries.
Take for example this test page:
How would you go about to cache that using phpFastCache and then what driver would you use, SQLite or the Filesystem?
Normally for caching, I used the file system, roughly like this:
PHP:
<?php
// define the path and name of cached file
$cachefile = 'cached-files/'.date('M-d-Y').'.php';
// define how long we want to keep the file in seconds. I set mine to 5 hours.
$cachetime = 18000;
// Check if the cached file is still fresh. If it is, serve it up and exit.
if (file_exists($cachefile) && time() - $cachetime < filemtime($cachefile)) {
include($cachefile);
exit;
}
// if there is either no file OR the file to too old, render the page and capture the HTML.
ob_start();
?>
<html>
output all your html here.
</html>
<?php
// We're done! Save the cached content to a file
$fp = fopen($cachefile, 'w');
fwrite($fp, ob_get_contents());
fclose($fp);
// finally send browser output
ob_end_flush();
?>
What I want to do now is use the PhpFastCache library instead. What I want is for someone to show me how you would handle DB queries.
Take for example this test page:
PHP:
<table style="width:100%">
<tr>
<th>Name</th>
<th colspan="2">Cellphone</th>
</tr>
<tr>
<?php
$stmt = $pdo->query('SELECT name, cellphone FROM users');
foreach ($stmt as $row)
{
echo <td>. $row['name'] .</td>;
echo <td>. $row['cellphone'] .</td>;
}
?>
</tr>
</table>
How would you go about to cache that using phpFastCache and then what driver would you use, SQLite or the Filesystem?
Last edited: