Stud.IP  2.5 Revision
Query Class Reference
Inheritance diagram for Query:
Inheritance graph
Collaboration diagram for Query:
Collaboration graph

Public Member Functions

 _QDebug ($str)
 
 set_db_class ($db_class)
 
 sql2phptype ($type, $format='')
 
 convert ($val, $meta, $special="")
 
 insert_plain_Clause ($table, $fields, $special, $check="soft")
 
 replace_plain_Clause ($table, $fields, $special, $check="soft")
 
 update_plain_Clause ($table, $fields, $special, $where, $check="soft")
 
 update_Clause ($table, $fields, $special, $where, $check="soft")
 
 delete_Clause ($table, $where, $check="soft")
 
 exists ($table, $name, $val)
 
 getrow ($table, $name, $val)
 
 where_plain_Clause ($mywhere, $andor='AND', $where='', $check="soft")
 
 where_Clause ($table, $fields, $op='', $special='', $andor='AND', $where='', $check="soft")
 
 capture_vars ($table)
 
 all_changed_vars ($table, $fields, $where, $check='soft')
 
 metadata_buffered ($table)
 
- Public Member Functions inherited from DB_Sql
 DB_Sql ($query="")
 
 connect ()
 
 query ($Query_String)
 
 next_record ()
 
 seek ($pos)
 
 metadata ($table)
 
 affected_rows ()
 
 num_rows ()
 
 num_fields ()
 
 nf ()
 
 np ()
 
 f ($Name)
 
 p ($Name)
 
 halt ($msg)
 
 DB_Sql ($query="")
 
 connect ()
 
 free_result ()
 
 query ($Query_String)
 
 next_record ()
 
 seek ($pos)
 
 metadata ($table)
 
 affected_rows ()
 
 num_rows ()
 
 num_fields ()
 
 nf ()
 
 np ()
 
 f ($Field_Name)
 
 p ($Field_Name)
 
 halt ($msg)
 
 DB_Sql ($query="")
 
 link_id ()
 
 query_id ()
 
 connect ($Database="", $Host="", $User="", $Password="")
 
 free ()
 
 query ($Query_String)
 
 next_record ()
 
 seek ($pos=0)
 
 lock ($table, $mode="write")
 
 unlock ()
 
 affected_rows ()
 
 num_rows ()
 
 num_fields ()
 
 nf ()
 
 np ()
 
 f ($Name)
 
 p ($Name)
 
 nextid ($seq_name)
 
 metadata ($table='', $full=false)
 
 halt ($msg)
 
 haltmsg ($msg)
 
 table_names ()
 
 queryf ($format)
 
 cache_query ($Query_String)
 
 DB_Sql ($query="")
 
 link_id ()
 
 query_id ()
 
 connect ($Database="", $Host="", $User="", $Password="")
 
 free ()
 
 query ($Query_String)
 
 next_record ()
 
 seek ($pos=0)
 
 lock ($table, $mode="write")
 
 unlock ()
 
 affected_rows ()
 
 num_rows ()
 
 num_fields ()
 
 nf ()
 
 np ()
 
 f ($Name)
 
 p ($Name)
 
 nextid ($seq_name)
 
 metadata ($table='', $full=false)
 
 halt ($msg)
 
 haltmsg ($msg)
 
 table_names ()
 
 queryf ($format)
 
 cache_query ($Query_String)
 
 DB_Sql ($query="")
 
 link_id ()
 
 query_id ()
 
 free ()
 
 query ($Query_String)
 
 next_record ()
 
 affected_rows ()
 
 num_rows ()
 
 num_fields ()
 
 nf ()
 
 np ()
 
 f ($Name)
 
 p ($Name)
 
 metadata ($table='', $full=false)
 
 halt ($msg)
 
 haltmsg ($msg)
 
 queryf ($format)
 
 cache_query ($Query_String)
 
 DB_Sql ($query="")
 
 connect ()
 
 query ($Query_String)
 
 next_record ()
 
 seek ($pos)
 
 metadata ($table, $full=false)
 
 affected_rows ()
 
 num_rows ()
 
 num_fields ()
 
 nf ()
 
 np ()
 
 f ($Name)
 
 p ($Name)
 
 nextid ($seqname)
 
 disconnect ()
 
 halt ($msg)
 
 lock ($table, $mode="write")
 
 unlock ()
 
 table_names ()
 
 add_specialcharacters ($query)
 
 split_specialcharacters ($query)
 
 DB_Sql ($query="")
 
 connect ()
 
 query ($Query_String)
 
 next_record ()
 
 seek ($pos)
 
 metadata ($table)
 
 affected_rows ()
 
 num_rows ()
 
 num_fields ()
 
 nf ()
 
 np ()
 
 f ($Field_Name)
 
 p ($Field_Name)
 
 halt ($msg)
 
 DB_Sql ($query="")
 
 link_id ()
 
 query_id ()
 
 connect ()
 
 query ($Query_String)
 
 next_record ()
 
 seek ($pos)
 
 lock ($table, $mode="write")
 
 unlock ()
 
 metadata ($table, $full=false)
 
 affected_rows ()
 
 num_rows ()
 
 num_fields ()
 
 nf ()
 
 np ()
 
 f ($Name)
 
 p ($Name)
 
 nextid ($seq_name)
 
 disconnect ()
 
 halt ($msg)
 
 haltmsg ($msg)
 
 table_names ()
 
 ifadd ($add, $me)
 
 DB_Sql ($query="")
 
 connect ()
 
 query ($Query_String)
 
 next_record ()
 
 seek ($pos)
 
 lock ($table, $mode="write")
 
 unlock ()
 
 nextid ($seq_name)
 
 metadata ($table)
 
 affected_rows ()
 
 num_rows ()
 
 num_fields ()
 
 nf ()
 
 np ()
 
 f ($Name)
 
 p ($Name)
 
 halt ($msg)
 
 table_names ()
 
 DB_Sql ($query="")
 
 connect ()
 
 query ($Query_String)
 
 next_record ()
 
 seek ($pos)
 
 metadata ($table)
 
 affected_rows ()
 
 num_rows ()
 
 num_fields ()
 
 nf ()
 
 np ()
 
 f ($Name)
 
 p ($Name)
 
 halt ($msg)
 

Data Fields

 $Q_Debug =false
 
 $Q_Debug_print ="<BR><B>QDebug:</B>\n%s\n<BR>\n"
 
 $No_Write =false
 
 $Backslash_N_is_NULL = false
 
 $meta_cache_off = false
 
 $Quoting =1
 
 $Quotechar ="'"
 
 $StrLengTrunc = false
 
 $StrLengWarn = false
 
- Data Fields inherited from DB_Sql
 $Host = ""
 
 $Database = ""
 
 $Link_ID = 0
 
 $Query_ID = 0
 
 $Record = array()
 
 $Row = 0
 
 $Error = ""
 
 $Auto_Free = 0
 
 $User = ""
 
 $Password = ""
 
 $Errno = 0
 
 $Debug = 0
 
 $Halt_On_Error = "yes"
 
 $Seq_Table = "db_sequence"
 
 $type = "mysql"
 
 $revision = "1.2"
 
 $config_prefix = 'DB_STUDIP'
 
 $RowCount
 
 $ColumnCount
 
 $sqoe = 1
 
 $Parse
 
 $UseODBCCursor = 0
 
 $Home = "/u01/app/oracle/product/8.0.4"
 
 $Remote = 1
 
 $OraPutEnv = true
 
 $ora_no_next_fetch =false
 

Additional Inherited Members

- Protected Attributes inherited from DB_Sql
 $pdo
 
 $resultSet
 

Member Function Documentation

◆ _QDebug()

_QDebug (   $str)
Here is the caller graph for this function:

◆ all_changed_vars()

all_changed_vars (   $table,
  $fields,
  $where,
  $check = 'soft' 
)
Here is the call graph for this function:

◆ capture_vars()

capture_vars (   $table)
Here is the call graph for this function:

◆ convert()

convert (   $val,
  $meta,
  $special = "" 
)
Here is the call graph for this function:
Here is the caller graph for this function:

◆ delete_Clause()

delete_Clause (   $table,
  $where,
  $check = "soft" 
)
Here is the call graph for this function:

◆ exists()

exists (   $table,
  $name,
  $val 
)
Here is the call graph for this function:

◆ getrow()

getrow (   $table,
  $name,
  $val 
)
Here is the call graph for this function:

◆ insert_plain_Clause()

insert_plain_Clause (   $table,
  $fields,
  $special,
  $check = "soft" 
)
Here is the call graph for this function:

◆ metadata_buffered()

metadata_buffered (   $table)
Here is the call graph for this function:
Here is the caller graph for this function:

◆ replace_plain_Clause()

replace_plain_Clause (   $table,
  $fields,
  $special,
  $check = "soft" 
)
Here is the call graph for this function:

◆ set_db_class()

set_db_class (   $db_class)

◆ sql2phptype()

sql2phptype (   $type,
  $format = '' 
)
Here is the call graph for this function:
Here is the caller graph for this function:

◆ update_Clause()

update_Clause (   $table,
  $fields,
  $special,
  $where,
  $check = "soft" 
)
Here is the call graph for this function:

◆ update_plain_Clause()

update_plain_Clause (   $table,
  $fields,
  $special,
  $where,
  $check = "soft" 
)
Here is the call graph for this function:

◆ where_Clause()

where_Clause (   $table,
  $fields,
  $op = '',
  $special = '',
  $andor = 'AND',
  $where = '',
  $check = "soft" 
)
Here is the call graph for this function:

◆ where_plain_Clause()

where_plain_Clause (   $mywhere,
  $andor = 'AND',
  $where = '',
  $check = "soft" 
)
Here is the call graph for this function:

Field Documentation

◆ $Backslash_N_is_NULL

$Backslash_N_is_NULL = false

◆ $meta_cache_off

$meta_cache_off = false

◆ $No_Write

$No_Write =false

◆ $Q_Debug

$Q_Debug =false

◆ $Q_Debug_print

$Q_Debug_print ="<BR><B>QDebug:</B>\n%s\n<BR>\n"

◆ $Quotechar

$Quotechar ="'"

◆ $Quoting

$Quoting =1

◆ $StrLengTrunc

$StrLengTrunc = false

◆ $StrLengWarn

$StrLengWarn = false

The documentation for this class was generated from the following file: