Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- $database_host = "127.0.0.1";
- $database_user = "x";
- $database_pass = "x";
- $database_name = "x";
- $db = new database($database_host, $database_user, $database_pass, $database_name);
- class database {
- var $link, $result;
- function database($host, $user, $pass, $db) {
- $this->link = mysqli_connect($host, $user, $pass) or $this->error();
- mysqli_select_db($this->link, $db) or $this->error();
- }
- function query($query) {
- $this->result = mysqli_query($this->link, $query) or $this->error();
- $this->_query_count++;
- return $this->result;
- }
- function countRows($result = "") {
- if ( empty( $result ) )
- $result = $this->result;
- return mysqli_num_rows($result);
- }
- function fetch($result = "") {
- if ( empty( $result ) )
- $result = $this->result;
- return mysqli_fetch_array($this->link, $result);
- }
- function fetch_num($result = "") {
- if ( empty( $result ) )
- $result = $this->result;
- return mysqli_fetch_array($result, MYSQLI_NUM);
- }
- function fetch_assoc($result = "") {
- if ( empty( $result ) )
- $result = $this->result;
- return mysqli_fetch_array($result, MYSQLI_ASSOC);
- }
- function escape($str) {
- return mysqli_real_escape_string($this->link, $str);
- }
- function error() {
- if ( $_GET["debug"] == 1 ){
- die(mysqi_error());
- } else {
- echo "Error in db code";
- }
- }
- }
- function sanitize($data) {
- // apply stripslashes if magic_quotes_gpc is enabled
- //if(get_magic_quotes_gpc())
- // $data = stripslashes($data);
- // a mysqli connection is required before using this function
- //$data = trim(mysqli_real_escape_string($data));
- return $data;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement