Class Queryi

Description

Located in /classes/Queryi.php (line 7)

mysqli
   |
   --Queryi
Direct descendents
Class Description
Cart
Integrity
MarcStore
SrchDb
DBTable
Method Summary
Queryi __construct ()
void act ( $sql)
void clearLocks ()
void getInsertID ()
void lock ()
string mkSQL (string $fmt, string 1)
void select ( $sql)
void select01 ( $sql)
void select1 ( $sql)
void unlock ()
void _ident ( $i)
void _numstr ( $n)
Variables

Inherited Variables

Inherited from mysqli (Internal Class)

$affected_rows
$client_info
$client_version
$connect_errno
$connect_error
$errno
$error
$error_list
$field_count
$host_info
$info
$insert_id
$protocol_version
$server_info
$server_version
$sqlstate
$stat
$thread_id
$warning_count
Methods
act (line 18)
  • access: public
void act ( $sql)
  • $sql
clearLocks (line 82)
  • access: protected
void clearLocks ()
getInsertID (line 66)
void getInsertID ()
lock (line 87)
  • access: protected
void lock ()
mkSQL (line 148)

************************************************************************** Makes SQL by interpolating values into a format string.

This function works something like printf() for SQL queries. Format strings contain %-escapes signifying that a value from the argument list should be inserted into the string at that point. The routine properly quotes or transforms the value to make sure that it will be handled correctly by the SQL server. The recognized format strings are as follows: %% - is replaced by a single '%' character and does not consume a value form the argument list. %! - inserts the argument in the query unaltered -- BE CAREFUL! %B - treates the argument as a boolean value and inserts either 'Y' or 'N'as appropriate. %C - treats the argument as a column reference. This differs from %I below only in that it passes the '.' operator for separating table and column names on to the SQL server unquoted. %I - treats the argument as an identifier to be quoted. %i - does the same escaping as %I, but does not add surrounding quotation marks. %N - treats the argument as a number and strips off all of it but an initial numeric string with optional sign and decimal point. %Q - treats the argument as a string and quotes it. %q - does the same escaping as %Q, but does not add surrounding quotation marks.

  • return: the result of interpreting $fmt
string mkSQL (string $fmt, string 1)
  • string $fmt: format string
  • string 1: ... optional argument values
select (line 24)
void select ( $sql)
  • $sql
select01 (line 41)
void select01 ( $sql)
  • $sql
select1 (line 32)
void select1 ( $sql)
  • $sql
unlock (line 102)
  • access: protected
void unlock ()
_ident (line 223)
void _ident ( $i)
  • $i
_numstr (line 229)
void _numstr ( $n)
  • $n

Inherited Methods

Inherited From mysqli (Internal Class)

constructor mysqli ( [$host = ], [$user = ], [$password = ], [$database = ], [$port = ], [$socket = ] )
autocommit ( $mode )
change_user ( $user, $password, $database )
character_set_name ( )
close ( )
commit ( )
connect ( [$host = ], [$user = ], [$password = ], [$database = ], [$port = ], [$socket = ] )
debug ( $debug_options )
dump_debug_info ( )
escape_string ( $string_to_escape )
get_charset ( )
get_client_info ( )
get_server_info ( )
get_warnings ( )
init ( )
kill ( $connection_id )
more_results ( )
multi_query ( $query )
next_result ( )
options ( $option, $value )
ping ( )
prepare ( $query )
query ( $query )
real_connect ( [$host = ], [$user = ], [$password = ], [$database = ], [$port = ], [$socket = ], [$flags = ] )
real_escape_string ( $string_to_escape )
real_query ( $query )
refresh ( $options )
rollback ( )
select_db ( $database )
set_charset ( $charset )
set_local_infile_default ( )
set_local_infile_handler ( $link, [$read_callback = ] )
set_opt ( $option, $value )
ssl_set ( $key, $cert, $certificate_authority, $certificate_authority_path, $cipher )
stat ( )
stmt_init ( )
store_result ( )
thread_safe ( )
use_result ( )

Documentation generated on Sun, 28 Jul 2013 15:07:04 -0400 by phpDocumentor 1.4.4