Revision: 20320
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at November 12, 2009 05:09 by r3morse
Initial Code
/**
* Database connection class.
* $db = new db(array(host, user, password, database));
* $db->connect();
* $clean = $db->clean($dirty);
* $db->query("");
* $db->disconnect();
*/
class db {
private $db = array();
private $connection;
public function db($args = array()) {
$this->db['server'] = $args['server'];
$this->db['username'] = $args['username'];
$this->db['password'] = $args['password'];
$this->db['database'] = $args['database']; }
public function connect() {
$this->connection = mysqli_connect($this->db["server"], $this->db["username"], $this->db["password"]);
$this->select_db(); }
public function disconnect() {
mysqli_close($this->connection);
$this->connection = null; }
public function select_db() {
mysqli_select_db($this->connection, $this->db["database"]); }
public function query($sql) {
$this->result = mysqli_query($this->connection, $sql); }
public function is_connected() {
return ($this->connection) ? true : false; }
public function clean($dirty) {
if (!is_array($dirty)) {
$dirty = ereg_replace("[\'\")(;|`,<>]", "", $dirty);
$dirty = mysqli_real_escape_string($this->connection, trim($dirty));
$clean = stripslashes($dirty);
return $clean; };
$clean = array();
foreach ($dirty as $p=>$data) {
$data = ereg_replace("[\'\")(;|`,<>]", "", $data);
$data = mysqli_real_escape_string($this->connection, trim($data));
$data = stripslashes($data);
$clean[$p] = $data; };
return $clean; }
}
Initial URL
Initial Description
A very simple class that quickly gets you interacting with a database, as long as you know sql :P.
Initial Title
Simple MySQLi Database Class
Initial Tags
mysql, class, php
Initial Language
PHP