class.Address_Book_DB.php
changeset 18 846026b8422b
parent 14 2a78703d3c2d
--- a/class.Address_Book_DB.php	Wed Oct 26 20:56:15 2011 +0200
+++ b/class.Address_Book_DB.php	Wed Oct 26 21:44:35 2011 +0200
@@ -1,13 +1,13 @@
 <?
-require "interface.Address_Book.php";
+require_once "interface.Address_Book.php";
 
 class Address_Book_DB implements Address_Book {
-	const INSERT_ENTRY = 'INSERT INTO data (name, tel, email)
-	 		      VALUES(:name, :tel, :email)';
-	const SELECT_ENTRY = 'SELECT name AS NAME, tel AS TEL, email AS MAIL
+	const INSERT_ENTRY = 'INSERT INTO data (name, tel, mail)
+	 		      VALUES(:name, :tel, :mail)';
+	const SELECT_ENTRY = 'SELECT name AS NAME, tel AS TEL, mail AS MAIL
 			      FROM data WHERE name LIKE :name
 			      	           OR tel LIKE :tel
-					   OR email LIKE :email';
+					   OR mail LIKE :mail';
 		
 
 	private $dbh;
@@ -17,7 +17,7 @@
 		array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
 
 		$this->dbh->exec("CREATE TABLE IF NOT EXISTS data
-			(name TEXT, tel TEXT, email TEXT)");
+			(name TEXT, tel TEXT, mail TEXT)");
 
 		$this->dbh->beginTransaction();
 
@@ -25,8 +25,6 @@
 		$sth->execute();
 		$r = $sth->fetch();
 
-		print_r($r);
-
 		if ($r['COUNT'] == 0) 
 			$this->insert(array("Hans Hanson", "0815", "hans@hanson.de"));
 		$this->dbh->commit();
@@ -40,7 +38,7 @@
 		
 		$sth->execute(array("name" => $entry[0],
 				    "tel"  => $entry[1],
-				    "email" => $entry[2]));
+				    "mail" => $entry[2]));
 	}
 			
 	public function get_all_entries() {
@@ -77,20 +75,20 @@
 		if ($sth === null)
 			$sth = $this->dbh->prepare(self::SELECT_ENTRY);
 
-		// $pattern = "%" . trim(trim($pattern), "%") . "%";
+		$pattern = trim($pattern);
+		if (empty($pattern)) return;
 
-		$pattern = trim($pattern);
 		$pattern = trim($pattern, '%');
 		$pattern = "%$pattern%";
 
 		$sth->execute(array("name" => $pattern,
 				    "tel" => $pattern,
-				    "email" => $pattern));
+				    "mail" => $pattern));
 		$entries = array();
 		while ($r = $sth->fetch()) {
 			$entries[] = array('name' => $r['NAME'],
 					   'tel' => $r['TEL'],
-					   'mail' => $r['EMAIL']);
+					   'mail' => $r['MAIL']);
 		}
 		return $entries;
 	}