5 * Resource Implementation based on the Custom API to use
6 * MySQL as the storage resource for Smarty's templates and configs.
8 * <pre>CREATE TABLE IF NOT EXISTS `templates` (
9 * `name` varchar(100) NOT NULL,
10 * `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
12 * PRIMARY KEY (`name`)
13 * ) ENGINE=InnoDB DEFAULT CHARSET=utf8;</pre>
15 * <pre>INSERT INTO `templates` (`name`, `modified`, `source`) VALUES ('test.tpl', "2010-12-25 22:00:00", '{$x="hello world"}{$x}');</pre>
17 * @package Resource-examples
20 class Smarty_Resource_Mysql extends Smarty_Resource_Custom
25 // prepared fetch() statement
28 // prepared fetchTimestamp() statement
31 public function __construct()
34 $this->db = new PDO("mysql:dbname=test;host=127.0.0.1", "smarty");
36 catch (PDOException $e) {
37 throw new SmartyException('Mysql Resource failed: ' . $e->getMessage());
39 $this->fetch = $this->db->prepare('SELECT modified, source FROM templates WHERE name = :name');
40 $this->mtime = $this->db->prepare('SELECT modified FROM templates WHERE name = :name');
44 * Fetch a template and its modification time from database
46 * @param string $name template name
47 * @param string $source template source
48 * @param integer $mtime template modification timestamp (epoch)
52 protected function fetch($name, &$source, &$mtime)
54 $this->fetch->execute(array('name' => $name));
55 $row = $this->fetch->fetch();
56 $this->fetch->closeCursor();
58 $source = $row[ 'source' ];
59 $mtime = strtotime($row[ 'modified' ]);
67 * Fetch a template's modification time from database
69 * @note implementing this method is optional. Only implement it if modification times can be accessed faster than loading the comple template source.
71 * @param string $name template name
73 * @return integer timestamp (epoch) the template was modified
75 protected function fetchTimestamp($name)
77 $this->mtime->execute(array('name' => $name));
78 $mtime = $this->mtime->fetchColumn();
79 $this->mtime->closeCursor();
81 return strtotime($mtime);