All pastes #28989 Raw Edit

Mine

public php v1 · immutable
#28989 ·published 2005-11-17 06:21 UTC
rendered paste body
<?php		//--> MySQL database class. Used in every file that accesses the database.	class db {		//--> Class variables, global accessibility		public $mysql_host = '';		public $mysql_user = '';		public $mysql_pass = '';		public $mysql_db = '';		public $mysql_qcount = 0;		public $mysql_debug = 0;		public $error = 0;			function __construct( $sql_host='', $sql_user='', $sql_pass='', $sql_db='', $sql_debug=0 ) {			//--> Class constructor method, set up variables for future transactions			$this->mysql_host = $sql_host;			$this->mysql_user = $sql_user;			$this->mysql_pass = $sql_pass;			$this->mysql_db = $sql_db;			$this->mysql_debug = $sql_debug;		}							function sql_connect( ) {			//--> Class function, connect to MySQL server			$this->mysql_connection_result =  mysql_connect( $this->mysql_host, $this->mysql_user, $this->mysql_pass );			if( !$this->mysql_connection_result ) {				$error_msg = "Failed to connect to MySQL server <br />" . mysql_error( );				die( $error_msg );			}			return 1;		}				function sql_select_db( ) {			//--> Class function, select MySQL database			$this->mysql_dbselect_result = mysql_select_db( $this->mysql_db );			if( !$this->mysql_dbselect_result ) {				$error_msg = "Failed to select database <br />" . mysql_error( );				die( $error_msg );			}			return 1;		}				function sql_query_db( $sql_query ) {			//--> Class function, query the selected MySQL database			$this->mysql_qcount++;			$this->mysql_query_result = mysql_query( $sql_query );			//echo ( $sql_query );			if( !$this->mysql_query_result ) {				$error_msg = "Query error <br />" . $sql_query . "<br />" . mysql_error( );				die( $error_msg );			}			return $this->mysql_query_result;		}				function sql_query_insert_many ( $sql_table, $sql_values ) {			//--> Class function, execute many insert queries			foreach( $sql_values as $vals ) {				$sql_query = "INSERT INTO " . $sql_table . " ( " . $val . " ) ";				$this->sql_query_db ( $sql_query );			}			return 1;		}					function sql_query_ret_obj( $sql_query ) {			//--> Class function [Abstraction of $this->$sql_query_db()], query the selected MySQL database and return object			$result = $this->sql_query_db( $sql_query );			return mysql_fetch_object( $result );		}				function sql_ret_obj ( ) {			return mysql_fetch_object( $this->mysql_query_result );		}				function sql_query_ret_array( $sql_query ) {			//--> Class function [Abstraction of $this->$sql_query_db()], query the selected MySQL database and return object			$result = $this->sql_query_db( $sql_query );			return mysql_fetch_array( $result );		}				function sql_get_row( ) {			//--> Class function, get next row from last query executed			if( !isset( $this->mysql_query_result ) ) {				$error_msg = "sql_get_row() before query <br />";				die( $error_msg );			}			return mysql_fetch_row( $this->mysql_query_result );		}				function sql_get_num_rows( ) {			//--> Class function, get number of rows resulting from last query			if( !isset( $this->mysql_query_result ) ) {				$error_msg = "sql_get_num_rows before query <br />";				die( $error_msg );						}			return mysql_affected_rows( $this->mysql_query_result );		}				function sql_get_last_autoid( ) {			//--> Class function, get auto assigned id given to the last INSERT query			if( !isset( $this->mysql_query_result ) ) {				$error_msg = "sql_get_last_autoid before query <br />" . mysql_error( );				die( $error_msg );			}			return mysql_insert_id( $this->mysql_query_result );		}	}?>