## 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
Constructor __construct (line 10)

- access: public

Queryi __construct ()

Redefined in descendants as:

- Cart::__construct()
- Integrity::__construct()
- MarcStore::__construct()
- SrchDb::__construct()
- DBTable::__construct()
- Holds::__construct()
- CircCollections::__construct()
- DistCollections::__construct()
- MemberCustomFields::__construct()
- ReportDisplays::__construct()
- MemberAccounts::__construct()
- MaterialFields::__construct()
- History::__construct()
- MarcBlocks::__construct()
- MarcTags::__construct()
- MarcSubfields::__construct()
- Opts::__construct()
- Hosts::__construct()
- BiblioImages::__construct()
- Themes::__construct()
- CopiesCustomFields::__construct()
- Sites::__construct()
- CoreTable::__construct()
- Bookings::__construct()
- Staff::__construct()
- Biblios::__construct()
- Copies::__construct()
- Members::__construct()
- DmTable::__construct()
- Collections::__construct()
- MemberCustomFields_DM::__construct()
- BiblioCopyFields::__construct()
- MediaTypes::__construct()
- TransactionTypes::__construct()
- CopyStatus::__construct()
- CopiesCustomFields_DM::__construct()
- States::__construct()
- MemberTypes::__construct()
- Calendars::__construct()

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