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 ); } }?>