Class Query

Description

Located in /classes/xQuery.php (line 10)


	
			
Direct descendents
Class Description
InstallQuery
Variable Summary
mixed $_link
Method Summary
Query Query ()
void act ( $sql)
void connect_e ()
void getInsertID ()
void lock ()
string mkSQL (string $fmt, string 1)
void select ( $sql)
void select01 ( $sql)
void select1 ( $sql)
void unlock ()
void _act ( $sql)
void _connect_e ()
void _ident ( $i)
void _numstr ( $n)
Variables
mixed $_link (line 11)
Methods
Constructor Query (line 17)
Query Query ()
act (line 55)
void act ( $sql)
  • $sql
connect_e (line 23)
void connect_e ()
getInsertID (line 102)
void getInsertID ()
lock (line 116)
void lock ()
mkSQL (line 175)

************************************************************************** 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 63)
void select ( $sql)
  • $sql
select01 (line 78)
void select01 ( $sql)
  • $sql
select1 (line 70)
void select1 ( $sql)
  • $sql
unlock (line 130)
void unlock ()
_act (line 88)
void _act ( $sql)
  • $sql
_connect_e (line 30)
void _connect_e ()
_ident (line 248)
void _ident ( $i)
  • $i
_numstr (line 254)
void _numstr ( $n)
  • $n

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