<?php
define('OPT_DIR', '../lib/');
require '../lib/opt.class.php';
try {
$tpl = new optClass();
$tpl->root = './templates/';
$tpl->compile = './templates_c/';
$tpl->cache = './cache/';
$tpl->gzipCompression = 1;
$tpl->httpHeaders(OPT_HTML);
$tpl->cacheStatus(true, 30);
if (!$tpl->isCached('example10.tpl')) {
require 'db_connect.php';
$r = mysql_query('SELECT id, name, description FROM products ORDER BY id');
$list = array();
while ($row = mysql_fetch_assoc($r)) {
// add the next item
$list[] = array('id' => $row['id'], 'name' => $row['name'], 'description' => $row['description']);
}
$tpl->assign('products', $list);
mysql_close();
}
// cache this template result for 30 seconds
$tpl->parse('example10.tpl');
} catch (optException $exception) {
optErrorHandler($exception);
}
