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

Public Member Functions

 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

 $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
 

Protected Attributes

 $pdo
 
 $resultSet
 

Member Function Documentation

◆ add_specialcharacters()

add_specialcharacters (   $query)

◆ affected_rows() [1/10]

affected_rows ( )
Here is the call graph for this function:

◆ affected_rows() [2/10]

affected_rows ( )

◆ affected_rows() [3/10]

affected_rows ( )

◆ affected_rows() [4/10]

affected_rows ( )

◆ affected_rows() [5/10]

affected_rows ( )

◆ affected_rows() [6/10]

affected_rows ( )

◆ affected_rows() [7/10]

affected_rows ( )
Here is the call graph for this function:

◆ affected_rows() [8/10]

affected_rows ( )

◆ affected_rows() [9/10]

affected_rows ( )

◆ affected_rows() [10/10]

affected_rows ( )

◆ cache_query() [1/3]

cache_query (   $Query_String)
Here is the call graph for this function:

◆ cache_query() [2/3]

cache_query (   $Query_String)
Here is the call graph for this function:

◆ cache_query() [3/3]

cache_query (   $Query_String)

◆ connect() [1/9]

connect ( )
Here is the call graph for this function:
Here is the caller graph for this function:

◆ connect() [2/9]

connect ( )
Here is the call graph for this function:

◆ connect() [3/9]

connect ( )
Here is the call graph for this function:

◆ connect() [4/9]

connect ( )
Here is the call graph for this function:

◆ connect() [5/9]

connect ( )
Here is the call graph for this function:

◆ connect() [6/9]

connect ( )
Here is the call graph for this function:

◆ connect() [7/9]

connect ( )
Here is the call graph for this function:

◆ connect() [8/9]

connect (   $Database = "",
  $Host = "",
  $User = "",
  $Password = "" 
)
Here is the call graph for this function:

◆ connect() [9/9]

connect (   $Database = "",
  $Host = "",
  $User = "",
  $Password = "" 
)
Here is the call graph for this function:

◆ DB_Sql() [1/10]

DB_Sql (   $query = "")
Here is the call graph for this function:

◆ DB_Sql() [2/10]

DB_Sql (   $query = "")
Here is the call graph for this function:

◆ DB_Sql() [3/10]

DB_Sql (   $query = "")
Here is the call graph for this function:

◆ DB_Sql() [4/10]

DB_Sql (   $query = "")
Here is the call graph for this function:

◆ DB_Sql() [5/10]

DB_Sql (   $query = "")
Here is the call graph for this function:

◆ DB_Sql() [6/10]

DB_Sql (   $query = "")
Here is the call graph for this function:

◆ DB_Sql() [7/10]

DB_Sql (   $query = "")
Here is the call graph for this function:

◆ DB_Sql() [8/10]

DB_Sql (   $query = "")
Here is the call graph for this function:

◆ DB_Sql() [9/10]

DB_Sql (   $query = "")
Here is the call graph for this function:

◆ DB_Sql() [10/10]

DB_Sql (   $query = "")

◆ disconnect() [1/2]

disconnect ( )
Here is the caller graph for this function:

◆ disconnect() [2/2]

disconnect ( )

◆ f() [1/10]

f (   $Name)

◆ f() [2/10]

f (   $Name)

◆ f() [3/10]

f (   $Name)
Here is the caller graph for this function:

◆ f() [4/10]

f (   $Field_Name)

◆ f() [5/10]

f (   $Field_Name)

◆ f() [6/10]

f (   $Name)

◆ f() [7/10]

f (   $Name)

◆ f() [8/10]

f (   $Name)

◆ f() [9/10]

f (   $Name)

◆ f() [10/10]

f (   $Name)

◆ free() [1/3]

free ( )

◆ free() [2/3]

free ( )
Here is the caller graph for this function:

◆ free() [3/3]

free ( )

◆ free_result()

free_result ( )
Here is the caller graph for this function:

◆ halt() [1/10]

halt (   $msg)

◆ halt() [2/10]

halt (   $msg)
Here is the caller graph for this function:

◆ halt() [3/10]

halt (   $msg)

◆ halt() [4/10]

halt (   $msg)

◆ halt() [5/10]

halt (   $msg)

◆ halt() [6/10]

halt (   $msg)
Here is the call graph for this function:

◆ halt() [7/10]

halt (   $msg)

◆ halt() [8/10]

halt (   $msg)
Here is the call graph for this function:

◆ halt() [9/10]

halt (   $msg)
Here is the call graph for this function:

◆ halt() [10/10]

halt (   $msg)

◆ haltmsg() [1/4]

haltmsg (   $msg)

◆ haltmsg() [2/4]

haltmsg (   $msg)
Here is the caller graph for this function:

◆ haltmsg() [3/4]

haltmsg (   $msg)

◆ haltmsg() [4/4]

haltmsg (   $msg)

◆ ifadd()

ifadd (   $add,
  $me 
)
Here is the caller graph for this function:

◆ link_id() [1/4]

link_id ( )

◆ link_id() [2/4]

link_id ( )

◆ link_id() [3/4]

link_id ( )

◆ link_id() [4/4]

link_id ( )

◆ lock() [1/5]

lock (   $table,
  $mode = "write" 
)

◆ lock() [2/5]

lock (   $table,
  $mode = "write" 
)
Here is the call graph for this function:
Here is the caller graph for this function:

◆ lock() [3/5]

lock (   $table,
  $mode = "write" 
)

◆ lock() [4/5]

lock (   $table,
  $mode = "write" 
)

◆ lock() [5/5]

lock (   $table,
  $mode = "write" 
)
Here is the call graph for this function:

◆ metadata() [1/10]

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

◆ metadata() [2/10]

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

◆ metadata() [3/10]

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

◆ metadata() [4/10]

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

◆ metadata() [5/10]

metadata (   $table,
  $full = false 
)
Here is the call graph for this function:

◆ metadata() [6/10]

metadata (   $table = '',
  $full = false 
)
Here is the call graph for this function:

◆ metadata() [7/10]

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

◆ metadata() [8/10]

metadata (   $table,
  $full = false 
)
Here is the call graph for this function:

◆ metadata() [9/10]

metadata (   $table = '',
  $full = false 
)
Here is the call graph for this function:

◆ metadata() [10/10]

metadata (   $table = '',
  $full = false 
)

◆ next_record() [1/10]

next_record ( )

◆ next_record() [2/10]

next_record ( )

◆ next_record() [3/10]

next_record ( )
Here is the call graph for this function:

◆ next_record() [4/10]

next_record ( )
Here is the caller graph for this function:

◆ next_record() [5/10]

next_record ( )

◆ next_record() [6/10]

next_record ( )
Here is the call graph for this function:

◆ next_record() [7/10]

next_record ( )
Here is the call graph for this function:

◆ next_record() [8/10]

next_record ( )
Here is the call graph for this function:

◆ next_record() [9/10]

next_record ( )
Here is the call graph for this function:

◆ next_record() [10/10]

next_record ( )

◆ nextid() [1/5]

nextid (   $seq_name)
Here is the call graph for this function:

◆ nextid() [2/5]

nextid (   $seqname)
Here is the call graph for this function:

◆ nextid() [3/5]

nextid (   $seq_name)
Here is the call graph for this function:

◆ nextid() [4/5]

nextid (   $seq_name)

◆ nextid() [5/5]

nextid (   $seq_name)
Here is the call graph for this function:

◆ nf() [1/10]

nf ( )
Here is the call graph for this function:

◆ nf() [2/10]

nf ( )
Here is the call graph for this function:

◆ nf() [3/10]

nf ( )
Here is the call graph for this function:

◆ nf() [4/10]

nf ( )
Here is the call graph for this function:

◆ nf() [5/10]

nf ( )
Here is the call graph for this function:

◆ nf() [6/10]

nf ( )
Here is the call graph for this function:

◆ nf() [7/10]

nf ( )
Here is the call graph for this function:

◆ nf() [8/10]

nf ( )
Here is the call graph for this function:

◆ nf() [9/10]

nf ( )

◆ nf() [10/10]

nf ( )
Here is the call graph for this function:

◆ np() [1/10]

np ( )
Here is the call graph for this function:

◆ np() [2/10]

np ( )
Here is the call graph for this function:

◆ np() [3/10]

np ( )
Here is the call graph for this function:

◆ np() [4/10]

np ( )
Here is the call graph for this function:

◆ np() [5/10]

np ( )
Here is the call graph for this function:

◆ np() [6/10]

np ( )
Here is the call graph for this function:

◆ np() [7/10]

np ( )
Here is the call graph for this function:

◆ np() [8/10]

np ( )
Here is the call graph for this function:

◆ np() [9/10]

np ( )

◆ np() [10/10]

np ( )
Here is the call graph for this function:

◆ num_fields() [1/10]

num_fields ( )

◆ num_fields() [2/10]

num_fields ( )

◆ num_fields() [3/10]

num_fields ( )

◆ num_fields() [4/10]

num_fields ( )

◆ num_fields() [5/10]

num_fields ( )

◆ num_fields() [6/10]

num_fields ( )

◆ num_fields() [7/10]

num_fields ( )

◆ num_fields() [8/10]

num_fields ( )

◆ num_fields() [9/10]

num_fields ( )

◆ num_fields() [10/10]

num_fields ( )

◆ num_rows() [1/10]

num_rows ( )

◆ num_rows() [2/10]

num_rows ( )

◆ num_rows() [3/10]

num_rows ( )

◆ num_rows() [4/10]

num_rows ( )
Here is the caller graph for this function:

◆ num_rows() [5/10]

num_rows ( )

◆ num_rows() [6/10]

num_rows ( )

◆ num_rows() [7/10]

num_rows ( )

◆ num_rows() [8/10]

num_rows ( )

◆ num_rows() [9/10]

num_rows ( )

◆ num_rows() [10/10]

num_rows ( )
Here is the call graph for this function:

◆ p() [1/10]

p (   $Name)

◆ p() [2/10]

p (   $Name)

◆ p() [3/10]

p (   $Name)

◆ p() [4/10]

p (   $Field_Name)
Here is the call graph for this function:

◆ p() [5/10]

p (   $Field_Name)
Here is the call graph for this function:

◆ p() [6/10]

p (   $Name)

◆ p() [7/10]

p (   $Name)
Here is the call graph for this function:

◆ p() [8/10]

p (   $Name)

◆ p() [9/10]

p (   $Name)

◆ p() [10/10]

p (   $Name)

◆ query() [1/10]

query (   $Query_String)
Here is the call graph for this function:

◆ query() [2/10]

query (   $Query_String)
Here is the call graph for this function:

◆ query() [3/10]

query (   $Query_String)
Here is the call graph for this function:

◆ query() [4/10]

query (   $Query_String)
Here is the call graph for this function:
Here is the caller graph for this function:

◆ query() [5/10]

query (   $Query_String)
Here is the call graph for this function:

◆ query() [6/10]

query (   $Query_String)
Here is the call graph for this function:

◆ query() [7/10]

query (   $Query_String)
Here is the call graph for this function:

◆ query() [8/10]

query (   $Query_String)
Here is the call graph for this function:

◆ query() [9/10]

query (   $Query_String)
Here is the call graph for this function:

◆ query() [10/10]

query (   $Query_String)

◆ query_id() [1/4]

query_id ( )

◆ query_id() [2/4]

query_id ( )

◆ query_id() [3/4]

query_id ( )

◆ query_id() [4/4]

query_id ( )

◆ queryf() [1/3]

queryf (   $format)
Here is the call graph for this function:

◆ queryf() [2/3]

queryf (   $format)
Here is the call graph for this function:

◆ queryf() [3/3]

queryf (   $format)

◆ seek() [1/9]

seek (   $pos)

◆ seek() [2/9]

seek (   $pos)

◆ seek() [3/9]

seek (   $pos)

◆ seek() [4/9]

seek (   $pos)

◆ seek() [5/9]

seek (   $pos)

◆ seek() [6/9]

seek (   $pos)

◆ seek() [7/9]

seek (   $pos = 0)
Here is the call graph for this function:

◆ seek() [8/9]

seek (   $pos)
Here is the call graph for this function:

◆ seek() [9/9]

seek (   $pos = 0)

◆ split_specialcharacters()

split_specialcharacters (   $query)

◆ table_names() [1/5]

table_names ( )
Here is the call graph for this function:

◆ table_names() [2/5]

table_names ( )
Here is the call graph for this function:

◆ table_names() [3/5]

table_names ( )
Here is the call graph for this function:

◆ table_names() [4/5]

table_names ( )
Here is the call graph for this function:

◆ table_names() [5/5]

table_names ( )

◆ unlock() [1/5]

unlock ( )

◆ unlock() [2/5]

unlock ( )
Here is the call graph for this function:
Here is the caller graph for this function:

◆ unlock() [3/5]

unlock ( )

◆ unlock() [4/5]

unlock ( )

◆ unlock() [5/5]

unlock ( )
Here is the call graph for this function:

Field Documentation

◆ $Auto_Free

$Auto_Free = 0

◆ $ColumnCount

$ColumnCount

◆ $config_prefix

$config_prefix = 'DB_STUDIP'

◆ $Database

$Database = ""

◆ $Debug

$Debug = 0

◆ $Errno

$Errno = 0

◆ $Error

$Error = ""

◆ $Halt_On_Error

$Halt_On_Error = "yes"

◆ $Home

$Home = "/u01/app/oracle/product/8.0.4"

◆ $Host

$Host = ""

◆ $Link_ID

$Link_ID = 0

◆ $ora_no_next_fetch

$ora_no_next_fetch =false

◆ $OraPutEnv

$OraPutEnv = true

◆ $Parse

$Parse

◆ $Password

$Password = ""

◆ $pdo

$pdo
protected

◆ $Query_ID

$Query_ID = 0

◆ $Record

$Record = array()

◆ $Remote

$Remote = 1

◆ $resultSet

$resultSet
protected

◆ $revision

$revision = "1.2"

◆ $Row

$Row = 0

◆ $RowCount

$RowCount

◆ $Seq_Table

$Seq_Table = "db_sequence"

◆ $sqoe

$sqoe = 1

◆ $type

$type = "mysql"

◆ $UseODBCCursor

$UseODBCCursor = 0

◆ $User

$User = ""

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