aboutsummaryrefslogtreecommitdiffstats
path: root/library/Smarty/demo/plugins/resource.mysqls.php
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-12-06 14:22:55 -0800
committerredmatrix <redmatrix@redmatrix.me>2015-12-06 14:22:55 -0800
commita88ec1b1af954a447a666d3ff66b1d1df0a645db (patch)
tree7ccfe6a03923ad118910202e21a605e13127192c /library/Smarty/demo/plugins/resource.mysqls.php
parent553b3a5c6c2ba6b93ad1193ec044ee92cf7690aa (diff)
parenta6cb25020bb5200cc3c00ecc941ddb751644fbcc (diff)
downloadvolse-hubzilla-a88ec1b1af954a447a666d3ff66b1d1df0a645db.tar.gz
volse-hubzilla-a88ec1b1af954a447a666d3ff66b1d1df0a645db.tar.bz2
volse-hubzilla-a88ec1b1af954a447a666d3ff66b1d1df0a645db.zip
Merge https://github.com/redmatrix/hubzilla into pending_merge
Diffstat (limited to 'library/Smarty/demo/plugins/resource.mysqls.php')
-rw-r--r--library/Smarty/demo/plugins/resource.mysqls.php62
1 files changed, 0 insertions, 62 deletions
diff --git a/library/Smarty/demo/plugins/resource.mysqls.php b/library/Smarty/demo/plugins/resource.mysqls.php
deleted file mode 100644
index f694ddf11..000000000
--- a/library/Smarty/demo/plugins/resource.mysqls.php
+++ /dev/null
@@ -1,62 +0,0 @@
-<?php
-
-/**
- * MySQL Resource
- * Resource Implementation based on the Custom API to use
- * MySQL as the storage resource for Smarty's templates and configs.
- * Note that this MySQL implementation fetches the source and timestamps in
- * a single database query, instead of two separate like resource.mysql.php does.
- * Table definition:
- * <pre>CREATE TABLE IF NOT EXISTS `templates` (
- * `name` varchar(100) NOT NULL,
- * `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- * `source` text,
- * PRIMARY KEY (`name`)
- * ) ENGINE=InnoDB DEFAULT CHARSET=utf8;</pre>
- * Demo data:
- * <pre>INSERT INTO `templates` (`name`, `modified`, `source`) VALUES ('test.tpl', "2010-12-25 22:00:00", '{$x="hello world"}{$x}');</pre>
- *
- * @package Resource-examples
- * @author Rodney Rehm
- */
-class Smarty_Resource_Mysqls extends Smarty_Resource_Custom
-{
- // PDO instance
- protected $db;
- // prepared fetch() statement
- protected $fetch;
-
- public function __construct()
- {
- try {
- $this->db = new PDO("mysql:dbname=test;host=127.0.0.1", "smarty");
- }
- catch (PDOException $e) {
- throw new SmartyException('Mysql Resource failed: ' . $e->getMessage());
- }
- $this->fetch = $this->db->prepare('SELECT modified, source FROM templates WHERE name = :name');
- }
-
- /**
- * Fetch a template and its modification time from database
- *
- * @param string $name template name
- * @param string $source template source
- * @param integer $mtime template modification timestamp (epoch)
- *
- * @return void
- */
- protected function fetch($name, &$source, &$mtime)
- {
- $this->fetch->execute(array('name' => $name));
- $row = $this->fetch->fetch();
- $this->fetch->closeCursor();
- if ($row) {
- $source = $row['source'];
- $mtime = strtotime($row['modified']);
- } else {
- $source = null;
- $mtime = null;
- }
- }
-}