Posted By

r3morse on 11/12/09

Tagged

Versions (?)

Last Edited at 11/12/09 05:09am

Statistics

Viewed 1140 times

Favorited by 1 user(s)

Related snippets

Simple MySQLi Database Class

/ Published in: PHP

A very simple class that quickly gets you interacting with a database, as long as you know sql :P.

Highlighted TextExpand

/**
 * 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; }

}

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.