/ Published in: PHP
URL: http://www.mechanicmatt.com
Simple database class. Run queries, obtain OOP results, etc.
Expand |
Embed | Plain Text
<?php class database { var $host = NULL; var $username = NULL; var $password = NULL; var $databaseName = NULL; var $link = NULL; var $queries = NULL; var $errors = NULL; var $databaseExtras = NULL; function __construct($host, $username, $password, $database) { $this->database($host, $username, $password, $database); } function database($host, $username, $password, $database) { /*$this->database = array ( "host" => $host, "username" => $username, "password" => $password, "database" => $database, "link" => "", "queries" => array (), "errors" => array () );*/ $this->host = $host; $this->username = $username; $this->password = $password; $this->databaseName = $database; $this->link = ""; $this->databaseExtras = new stdClass; $this->link = mysql_connect($this->host, $this->username, $this->password) or die("Could not connect to Database"); } function justquery($sql) { $this->queries[] = $sql; } function loadResult($sql) { if (!($cur = $this->justquery($sql))) { return null; } $ret = null; $ret = $row[0]; } return $ret; } function loadFirstRow($sql) { if (!($cur = $this->justquery($sql))) { return null; } $ret = null; $ret = $row; } return $ret; } function insertid() { } function query($sql, $key = "", $returns = true, $batch = false) { switch ($batch) { default: case true: foreach ($sql as $index => $query) { $this->queries[] = $query; if (!$answer) { } else { if ($returns != false) { if ($key != ""){ $result[$index][$row->$key] = $row; } else { $result[$index][] = $row; } } } else {} } else {} } } break; case false: $this->queries[] = $sql; if (!$answer) { $result = false; } else { if ($returns != false) { if ($key != ""){ $result[$row->$key] = $row; } else { $result[] = $row; } } } else {} } else { $result = true; } } break; } return $result; } function loadObject( $sql, &$object ) { if ($object != null) { if (!($cur = $this->justquery($sql))) { return false; } else {} $this->bindArrayToObject( $array, $object); return true; } else { return false; } } else { if ($cur = $this->justquery($sql)) { return true; } else { $object = null; return false; } } else { return false; } } } function bindArrayToObject( $array, &$obj) { return (false); } $ak = $k; $obj->$k = $array[$ak]; } } } return true; } function formatCSVCell($data) { $useQuotes = false; "\"" => "\"\"", "," => ",", "\n" => "\n" ); foreach ($quotable as $char => $repl) { $useQuotes = true; } else {} } if ($useQuotes == true) { foreach ($quotable as $char => $repl) { } $data = "\"" . $data . "\""; } else { } return $data; } } ?>
Comments
Subscribe to comments
You need to login to post a comment.

It gives error for a non-object call on line 83