Class objSQL

Database access controller class

obj_access

Extended by

objSQL

Package: objSQL
Copyright: 2012
License: zlib/libpng
Author: MT Jordan <mtjo62@gmail.com>
Version: 3.0.0
Link: http://objsql.sourceforge.net
Located at objSQL.php

Methods summary
`public`	# `__construct( mixed $datasource )` Constructor Constructor Parameters `$datasource` `mixed` $datasource
`public boolean`	# `obj_close( )` Closes current database connection Closes current database connection Returns `boolean`
`public mixed`	# `obj_delete( str $table, str $where = false )` Executes delete query and returns resultset object/resource Executes delete query and returns resultset object/resource Parameters `$table` `str` $table `$where` `str` $where Returns `mixed`
`public boolean`	# `obj_error( )` Returns error flag for current connection instance - true/false Returns error flag for current connection instance - true/false Returns `boolean`
`public str`	# `obj_error_message( )` Returns error message for current connection instance Returns error message for current connection instance Returns `str`
`public str`	# `obj_escape( str $data )` Returns escaped string data for database insertion Returns escaped string data for database insertion Parameters `$data` `str` $data Returns `str`
`public array`	# `obj_info( )` Returns associative array with general database and script information Returns associative array with general database and script information Returns `array`
`public mixed`	# `obj_insert( str $table, array $data_array )` executes insert query and returns resultset object/resource executes insert query and returns resultset object/resource Parameters `$table` `str` $table `$data_array` `array` $data_array Returns `mixed`
`public array`	# `obj_paging( str $table, str $cols = false, str $where = false, str $order_by = false, integer $limit = 1, integer $offset = 1 )` Executes select paging query and returns resultset object/resource and number of pages via $limit Executes select paging query and returns resultset object/resource and number of pages via $limit Parameters `$table` `str` $table `$cols` `str` $cols `$where` `str` $where `$order_by` `str` $order_by `$limit` `integer` $limit `$offset` `integer` $offset Returns `array`
`public mixed`	# `obj_prepare_statement( str $query, array $param_vars = false )` Returns prepared statement instance Returns prepared statement instance Parameters `$query` `str` $query `$param_vars` `array` $param_vars Returns `mixed`
`public mixed`	# `obj_query( str $query )` Executes non-prepared query and returns resultset object/resource Executes non-prepared query and returns resultset object/resource Parameters `$query` `str` $query Returns `mixed`
`public mixed`	# `obj_select( str $table, str $cols = false, str $where = false, str $order_by = false, str $sort_order = false )` Executes select query and returns resultset object/resource Executes select query and returns resultset object/resource Parameters `$table` `str` $table `$cols` `str` $cols `$where` `str` $where `$order_by` `str` $order_by `$sort_order` `str` $sort_order Returns `mixed`
`public mixed`	# `obj_transaction( )` Begins transaction Begins transaction Returns `mixed`
`public mixed`	# `obj_update( str $table, array $data_array, str $where = false )` executes update query and returns resultset object/resource executes update query and returns resultset object/resource Parameters `$table` `str` $table `$data_array` `array` $data_array `$where` `str` $where Returns `mixed`

Properties summary
`public mixed`	`$obj_connection`	`false`	# Database connection object Database connection object