6 * Resource Implementation based on the Custom API to use
7 * MySQL as the storage resource for Smarty's templates and configs.
9 * Note that this MySQL implementation fetches the source and timestamps in
10 * a single database query, instead of two seperate like resource.mysql.php does.
13 * <pre>CREATE TABLE IF NOT EXISTS `templates` (
14 * `name` varchar(100) NOT NULL,
15 * `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
17 * PRIMARY KEY (`name`)
18 * ) ENGINE=InnoDB DEFAULT CHARSET=utf8;</pre>
21 * <pre>INSERT INTO `templates` (`name`, `modified`, `source`) VALUES ('test.tpl', "2010-12-25 22:00:00", '{$x="hello world"}{$x}');</pre>
23 * @package Resource-examples
26 class Smarty_Resource_Mysqls extends Smarty_Resource_Custom {
29 // prepared fetch() statement
32 public function __construct() {
34 $this->db = new PDO("mysql:dbname=test;host=127.0.0.1", "smarty", "smarty");
35 } catch (PDOException $e) {
36 throw new SmartyException('Mysql Resource failed: ' . $e->getMessage());
38 $this->fetch = $this->db->prepare('SELECT modified, source FROM templates WHERE name = :name');
42 * Fetch a template and its modification time from database
44 * @param string $name template name
45 * @param string $source template source
46 * @param integer $mtime template modification timestamp (epoch)
49 protected function fetch($name, &$source, &$mtime)
51 $this->fetch->execute(array('name' => $name));
52 $row = $this->fetch->fetch();
53 $this->fetch->closeCursor();
55 $source = $row['source'];
56 $mtime = strtotime($row['modified']);