PDO::ERRMODE_EXCEPTION ); public static function connect($host, $user, $password, $dbname) { if (!isset(self::$connect)) { self::$connect = @new PDO( "mysql:host=$host;dbname=$dbname", $user, $password, self::$settings ); } return self::$connect; } public static function query($sql, $param = array()) { $query = self::$connect->prepare($sql); $query->execute($param); return $query; } public static function TableData($table, $col, $value, $mark, $order, $type) { switch ($type) { case "count": $type_str = "count(id) as cnt"; break; case "data": $type_str = "*"; break; } if (is_array($col)) { foreach ($col as $key => $column) { $this_mark = $mark[$key]; $param[] = $value[$key]; $where .= "$column $this_mark BINARY ? and "; } $where = rtrim($where, "and "); $select = Databaze::query("SELECT $type_str from `$table` where $where $order", $param); } else { $param[] = $value; $select = Databaze::query("SELECT $type_str from `$table` where $col = BINARY ? $order", $param); } if ($type == "count") { $data = $select->fetch(); $data = $data["cnt"]; return $data; } $data = $select->fetchAll(); return $data; } } //example of usage echo 'Playground doesn\'t support DB connection but below is example of usege of this DB class.

'; echo 'Database::TableData("my_table", array("user_id", "book_id", "id"), array(10, 5, 1), array("=", "=", "<>"), "order by date", "count");

'; echo 'this will create select:
'; echo 'SELECT count(id) as cnt from `my_table` where user_id = BINARY 10 and book_id = BINARY 5 and id <> BINARY 1 order by date

'; echo 'Database::TableData("my_table", array("user_id", "book_id", "id"), array(10, 5, 1), array("=", "=", "<>"), "order by date", "data");

'; echo 'this will create select:
'; echo 'SELECT * from `my_table` where user_id = BINARY 10 and book_id = BINARY 5 and id <> BINARY 1 order by date'; try{ $db = new Database(); $db->connect("db_host", "db_user", "DB_password", "DB_name"); //get rows count $counts = Database::TableData("my_table", array("user_id", "book_id", "id"), array(10, 5, 1), array("=", "=", "<>"), "order by date", "count"); $records = Database::TableData("my_table", array("user_id", "book_id", "id"), array(10, 5, 1), array("=", "=", "<>"), "order by date", "data"); }catch(Exception $e){ throw new Exception('Playground doesnt support DB connection.'); }

PDO - helper function select