[ Index ]

PHP Cross Reference of vtigercrm-6.1.0

title

Body

[close]

/include/database/ -> PearDatabase.php (summary)

(no description)

File Size: 1083 lines (33 kb)
Included or required: 33 times
Referenced: 0 times
Includes or requires: 4 files
 include/logging.php
 libraries/adodb/adodb.inc.php
 config.performance.php
 libraries/adodb/adodb-xmlschema.inc.php

Defines 3 classes

PreparedQMark2SqlValue:: (2 methods):
  PreparedQMark2SqlValue()
  call()

PerformancePrefs:: (3 methods):
  get()
  getBoolean()
  getInteger()

PearDatabase:: (81 methods):
  getInstance()
  isMySQL()
  isOracle()
  isPostgres()
  println()
  setDieOnError()
  setDatabaseType()
  setUserName()
  setOption()
  setUserPassword()
  setDatabaseName()
  setDatabaseHost()
  getDataSourceName()
  startTransaction()
  completeTransaction()
  hasFailedTransaction()
  checkError()
  change_key_case()
  checkConnection()
  logSqlTiming()
  executeSetNamesUTF8SQL()
  query_batch()
  query()
  convert2Sql()
  pquery()
  flatten_array()
  getEmptyBlob()
  updateBlob()
  updateBlobFile()
  limitQuery()
  getOne()
  getFieldsDefinition()
  getFieldsArray()
  getRowCount()
  num_rows()
  num_fields()
  fetch_array()
  run_query_record_html()
  sql_quote()
  sql_insert_data()
  run_insert_data()
  run_query_record()
  run_query_allrecords()
  run_query_field()
  run_query_list()
  run_query_field_html()
  result_get_next_record()
  sql_expr_datalist()
  sql_expr_datalist_from_records()
  sql_concat()
  query_result()
  query_result_rowdata()
  raw_query_result_rowdata()
  getAffectedRowCount()
  requireSingleResult()
  requirePsSingleResult()
  fetchByAssoc()
  getNextRow()
  fetch_row()
  field_name()
  getQueryTime()
  connect()
  PearDatabase()
  resetSettings()
  quote()
  disconnect()
  setDebug()
  createTables()
  createTable()
  alterTable()
  getColumnNames()
  formatString()
  formatDate()
  getDBDateString()
  getUniqueID()
  get_tables()
  sql_escape_string()
  getLastInsertID()
  escapeDbName()
  check_db_utf8_support()
  get_db_charset()


Class: PreparedQMark2SqlValue  - X-Ref

PreparedQMark2SqlValue($vals)   X-Ref
No description

call($matches)   X-Ref
No description

Class: PerformancePrefs  - X-Ref

Performance perference API

get($key, $defvalue=false)   X-Ref
Get performance parameter configured value or default one


getBoolean($key, $defvalue=false)   X-Ref
No description

getInteger($key, $defvalue=false)   X-Ref
No description

Class: PearDatabase  - X-Ref

getInstance()   X-Ref
Manage instance usage of this class


isMySQL()   X-Ref
No description

isOracle()   X-Ref
No description

isPostgres()   X-Ref
No description

println($msg)   X-Ref
No description

setDieOnError($value)   X-Ref
No description

setDatabaseType($type)   X-Ref
No description

setUserName($name)   X-Ref
No description

setOption($name, $value)   X-Ref
No description

setUserPassword($pass)   X-Ref
No description

setDatabaseName($db)   X-Ref
No description

setDatabaseHost($host)   X-Ref
No description

getDataSourceName()   X-Ref
No description

startTransaction()   X-Ref
No description

completeTransaction()   X-Ref
No description

hasFailedTransaction()   X-Ref
No description

checkError($msg='', $dieOnError=false)   X-Ref
No description

change_key_case($arr)   X-Ref
No description

checkConnection()   X-Ref
No description

logSqlTiming($startat, $endat, $sql, $params=false)   X-Ref
No description

executeSetNamesUTF8SQL($force = false)   X-Ref
Execute SET NAMES UTF-8 on the connection based on configuration.


query_batch($prefixsql, $valuearray)   X-Ref
Execute query in a batch.

For example:
INSERT INTO TABLE1 VALUES (a,b);
INSERT INTO TABLE1 VALUES (c,d);

like: INSERT INTO TABLE1 VALUES (a,b), (c,d)

query($sql, $dieOnError=false, $msg='')   X-Ref
No description

convert2Sql($ps, $vals)   X-Ref
Convert PreparedStatement to SQL statement


pquery($sql, $params=array()   X-Ref
No description

flatten_array($input, $output=null)   X-Ref
Flatten the composite array into single value.
Example:
$input = array(10, 20, array(30, 40), array('key1' => '50', 'key2'=>array(60), 70));
returns array(10, 20, 30, 40, 50, 60, 70);


getEmptyBlob($is_string=true)   X-Ref
No description

updateBlob($tablename, $colname, $id, $data)   X-Ref
No description

updateBlobFile($tablename, $colname, $id, $filename)   X-Ref
No description

limitQuery($sql,$start,$count, $dieOnError=false, $msg='')   X-Ref
No description

getOne($sql, $dieOnError=false, $msg='')   X-Ref
No description

getFieldsDefinition(&$result)   X-Ref
No description

getFieldsArray(&$result)   X-Ref
No description

getRowCount(&$result)   X-Ref
No description

num_rows(&$result)   X-Ref
No description

num_fields(&$result)   X-Ref
No description

fetch_array(&$result)   X-Ref
No description

run_query_record_html($query)   X-Ref
No description

sql_quote($data)   X-Ref
No description

sql_insert_data($table, $data)   X-Ref
No description

run_insert_data($table,$data)   X-Ref
No description

run_query_record($query)   X-Ref
No description

run_query_allrecords($query)   X-Ref
No description

run_query_field($query,$field='')   X-Ref
No description

run_query_list($query,$field)   X-Ref
No description

run_query_field_html($query,$field)   X-Ref
No description

result_get_next_record($result)   X-Ref
No description

sql_expr_datalist($a)   X-Ref
No description

sql_expr_datalist_from_records($a,$field)   X-Ref
No description

sql_concat($list)   X-Ref
No description

query_result(&$result, $row, $col=0)   X-Ref
No description

query_result_rowdata(&$result, $row=0)   X-Ref
No description

raw_query_result_rowdata(&$result, $row=0)   X-Ref
Get an array representing a row in the result set
Unlike it's non raw siblings this method will not escape
html entities in return strings.

The case of all the field names is converted to lower case.
as with the other methods.

param: &$result The query result to fetch from.
param: $row The row number to fetch. It's default value is 0

getAffectedRowCount(&$result)   X-Ref
No description

requireSingleResult($sql, $dieOnError=false,$msg='', $encode=true)   X-Ref
No description

requirePsSingleResult($sql, $params, $dieOnError=false,$msg='', $encode=true)   X-Ref
No description

fetchByAssoc(&$result, $rowNum = -1, $encode=true)   X-Ref
No description

getNextRow(&$result, $encode=true)   X-Ref
No description

fetch_row(&$result, $encode=true)   X-Ref
No description

field_name(&$result, $col)   X-Ref
No description

getQueryTime()   X-Ref
No description

connect($dieOnError = false)   X-Ref
No description

PearDatabase($dbtype='',$host='',$dbname='',$username='',$passwd='')   X-Ref
Constructor


resetSettings($dbtype,$host,$dbname,$username,$passwd)   X-Ref
No description

quote($string)   X-Ref
No description

disconnect()   X-Ref
No description

setDebug($value)   X-Ref
No description

createTables($schemaFile, $dbHostName=false, $userName=false, $userPassword=false, $dbName=false, $dbType=false)   X-Ref
No description

createTable($tablename, $flds)   X-Ref
No description

alterTable($tablename, $flds, $oper)   X-Ref
No description

getColumnNames($tablename)   X-Ref
No description

formatString($tablename,$fldname, $str)   X-Ref
No description

formatDate($datetime, $strip_quotes=false)   X-Ref
No description

getDBDateString($datecolname)   X-Ref
No description

getUniqueID($seqname)   X-Ref
No description

get_tables()   X-Ref
No description

sql_escape_string($str)   X-Ref
No description

getLastInsertID($seqname = '')   X-Ref
No description

escapeDbName($dbName='')   X-Ref
No description

check_db_utf8_support()   X-Ref
No description

get_db_charset()   X-Ref
No description



Generated: Fri Nov 28 20:08:37 2014 Cross-referenced by PHPXref 0.7.1