seperated storage classes

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();
+		}
+	}
+}
+
+?>