[ class tree: core ] [ index: core ] [ all elements ]

Procedural File: functions-db-MySQL.php

Source Location: /functions-db-MySQL.php

Page Details

Standard support for MySQL databases

database core functions

Constants
DATABASE_SOFTWARE  [line 11]

DATABASE_SOFTWARE = 'MySql'

[ Top ]


Functions
db_affected_rows  [line 170]

void db_affected_rows( )

[ Top ]
db_close  [line 194]

Closes the database


void db_close( )

[ Top ]
db_collation  [line 258]

void db_collation( )

[ Top ]
db_connect  [line 19]

Connect to the database server and select the database.

Parameters:
bool   $noerrmsg:  set to false to omit error messages
   $errorstop: 

API Tags:
Return:  if successful connection

Information Tags:
Since:  0.6

true db_connect( [ $errorstop = true], bool $noerrmsg  )

[ Top ]
db_create  [line 213]

create the database


void db_create( )

[ Top ]
db_create_table  [line 263]
Parameters:
   &$sql: 


void db_create_table( &$sql  )

[ Top ]
db_error  [line 163]

void db_error( )

[ Top ]
db_fetch_assoc  [line 153]
Parameters:
   $resource: 


void db_fetch_assoc( $resource  )

[ Top ]
db_fetch_row  [line 177]
Parameters:
   $result: 


void db_fetch_row( $result  )

[ Top ]
db_getSQLmode  [line 249]

Queries the SQL session mode


void db_getSQLmode( )

[ Top ]
db_insert_id  [line 139]

void db_insert_id( )

[ Top ]
db_list_fields  [line 286]
Parameters:
   $table: 
   $raw: 


void db_list_fields( $table, [ $raw = false]  )

[ Top ]
db_num_rows  [line 187]
Parameters:
   $result: 


void db_num_rows( $result  )

[ Top ]
db_permissions  [line 221]

Returns user's permissions on the database


void db_permissions( )

[ Top ]
db_quote  [line 131]

mysql_real_escape_string standin that insures the DB connection is passed.

Parameters:
string   $string: 


string db_quote( string $string  )

[ Top ]
db_result  [line 146]
Parameters:
   $result: 
   $row: 
   $field: 


void db_result( $result, $row, [ $field = 0]  )

[ Top ]
db_setSQLmode  [line 242]

Sets the SQL session mode to empty


void db_setSQLmode( )

[ Top ]
db_show  [line 271]
Parameters:
   $what: 
   $aux: 


void db_show( $what, [ $aux = '']  )

[ Top ]
db_software  [line 204]

void db_software( )

[ Top ]
db_table_update  [line 267]
Parameters:
   &$sql: 


void db_table_update( &$sql  )

[ Top ]
db_truncate_table  [line 299]
Parameters:
   $table: 


void db_truncate_table( $table  )

[ Top ]
query  [line 64]

The main query function. Runs the SQL on the connection and handles errors.

Parameters:
string   $sql:  sql code
bool   $noerrmsg:  set to false to supress the error message
   $errorstop: 

API Tags:
Return:  of the sql statements

Information Tags:
Since:  0.6

results query( string $sql, [ $errorstop = true], bool $noerrmsg  )

[ Top ]
query_full_array  [line 106]

Runs a SQL query and returns an array of associative arrays of every row returned.

Parameters:
string   $sql:  sql code
bool   $errorstop:  set to false to supress the error message
string   $key:  optional array index key

API Tags:
Return:  of the sql statements

Information Tags:
Since:  0.6

results query_full_array( string $sql, [bool $errorstop = true], [string $key = NULL]  )

[ Top ]
query_single_row  [line 89]

Runs a SQL query and returns an associative array of the first row.

Doesn't handle multiple rows, so this should only be used for unique entries.

Parameters:
string   $sql:  sql code
bool   $errorstop:  set to false to supress the error message

API Tags:
Return:  of the sql statements

Information Tags:
Since:  0.6

results query_single_row( string $sql, [bool $errorstop = true]  )

[ Top ]


Documentation generated on Tue, 20 Dec 2011 16:07:17 +0100 by phpDocumentor 1.4.3