summaryrefslogtreecommitdiffstats
path: root/paste/include/storage/MysqlStorage.php
diff options
context:
space:
mode:
authorAlexander Sulfrian <alexander@sulfrian.net>2009-12-11 03:13:01 +0100
committerAlexander Sulfrian <alexander@sulfrian.net>2009-12-11 03:14:28 +0100
commite98422a09892675f23852320e0d46b4071bf22b4 (patch)
treefad35f88652a9abee2dfc5964d15e76d4bb71563 /paste/include/storage/MysqlStorage.php
parent0398f1f363d5affba0633c104eaf22c1100f8e80 (diff)
downloadrafb-nopaste-e98422a09892675f23852320e0d46b4071bf22b4.tar.gz
rafb-nopaste-e98422a09892675f23852320e0d46b4071bf22b4.tar.xz
rafb-nopaste-e98422a09892675f23852320e0d46b4071bf22b4.zip
seperated storage classes
Diffstat (limited to 'paste/include/storage/MysqlStorage.php')
-rw-r--r--paste/include/storage/MysqlStorage.php95
1 files changed, 95 insertions, 0 deletions
diff --git a/paste/include/storage/MysqlStorage.php b/paste/include/storage/MysqlStorage.php
new file mode 100644
index 0000000..239f113
--- /dev/null
+++ b/paste/include/storage/MysqlStorage.php
@@ -0,0 +1,95 @@
+<?php
+/*
+This software is licensed through a BSD-style License.
+http://www.opensource.org/licenses/bsd-license.php
+
+Copyright (c) 2009 Alexander Sulfrian
+All rights reserved.
+
+Redistribution and use in source and binary forms, with or without
+modification, are permitted provided that the following conditions
+are met:
+
+Redistributions of source code must retain the above copyright notice,
+this list of conditions and the following disclaimer.
+Redistributions in binary form must reproduce the above copyright
+notice, this list of conditions and the following disclaimer in the
+documentation and/or other materials provided with the distribution.
+Neither the name of Jacob D. Cohen nor the names of his contributors
+may be used to endorse or promote products derived from this software
+without specific prior written permission.
+
+THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
+"AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
+LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
+A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
+OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
+SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
+LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
+DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
+THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
+(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
+OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+*/
+
+require_once('StorageEngine.php');
+
+class MysqlStorage extends StorageEngine
+{
+ private $mysql;
+ private $table;
+
+ function __construct($host, $user, $password, $database, $table) {
+ $this->mysql = new mysqli($host, $user, $password, $database);
+ if ($this->mysql->connect_error) {
+ header('HTTP/1.0 503 Service Unavailable');
+ die('MySQL Connect Error ('
+ . $this->mysql->connect_errno . ') '
+ . $this->mysql->connect_error);
+ }
+
+ $this->table = $table;
+ if (! $this->mysql->query("CREATE TABLE IF NOT EXISTS $table (
+pid VARCHAR(40) PRIMARY KEY,
+content MEDIUMTEXT,
+FULLTEXT INDEX (content)
+);"))
+ {
+ header('HTTP/1.0 503 Service Unavailable');
+ die('MySQL Error (' . $this->mysql->errno . ') ' .
+ $this->mysql->error);
+ }
+ }
+
+ function __destruct()
+ {
+ if ($this->mysql)
+ $this->mysql->close();
+ }
+
+ public function setContent($content)
+ {
+ $name = sha1(date('r') . rand(1000));
+
+ if ($config['short_results_path']) {
+ $urlbase = $config['short_results_path'];
+ } else {
+ $urlbase = $config['site_domain'] . $config['site_path'] . '/' . $config['results_dir'];
+ }
+ $content = $this->prepareContent($name, $urlbase . 'get.php?id=' . $name, $content);
+
+ if ($stmt = $this->mysql->prepare(
+ 'INSERT INTO ? (pid, content) VALUES (?, ?)')) {
+
+ /* bind parameters for markers */
+ $stmt->bind_param("sb", $name, $content);
+
+ /* execute query */
+ $stmt->execute();
+
+ $stmt->close();
+ }
+ }
+}
+
+?>