|
| connect_server ($host='localhost', $login='', $pwd='', $driver='') |
|
| disconnect_server () |
|
| get_serverVersion () |
|
| select_database ($name) |
|
| create_database ($name, $charset='utf8') |
|
| database_exists ($name) |
|
| dump_database ($file=false) |
|
| get_databaseSize () |
|
| get_databaseSummary () |
|
| get_tableList () |
|
| create_table ($name, $fields, $charset='utf8', $autoId=true, $primaryKeys=array('id')) |
|
| execute_query ($sql='', $resName='defaultRes') |
|
| get_queryGeneratedId ($resName='defaultRes') |
|
| get_queryDataLine ($resName='defaultRes') |
|
| get_queryNumDataLine ($resName='defaultRes') |
|
| get_queryError ($resName='defaultRes') |
|
| get_queryAffectedRows ($resName='defaultRes') |
|
| get_queryFieldCount ($resName='defaultRes') |
|
| get_queryFieldType ($fIndex=0, $resName='defaultRes') |
|
| close_ressource ($resName='defaultRes') |
|
| escape_string ($string) |
|
| __construct () |
|
| connect_server ($host='localhost', $login='', $pwd='', $driver='') |
|
| disconnect_server () |
|
| is_connectionActive () |
|
| check_status ($name) |
|
| get_serverVersion () |
|
| select_database ($name) |
|
| create_database ($name, $charset='utf8') |
|
| database_exists ($name) |
|
| dump_database ($file=false) |
|
| get_databaseSize () |
|
| get_databaseSummary () |
|
| get_tableList () |
|
| create_table ($name, $fields, $charset='utf8', $autoId=true, $primaryKeys=array('id')) |
|
| execute_query ($sql='', $resName='defaultRes') |
|
| get_queryGeneratedId ($resName='defaultRes') |
|
| get_queryDataLine ($resName='defaultRes') |
|
| get_queryNumDataLine ($resName='defaultRes') |
|
| get_queryError ($resName='defaultRes') |
|
| get_queryAffectedRows ($resName='defaultRes') |
|
| get_queryFieldCount ($resName='defaultRes') |
|
| get_queryFieldType ($fIndex=0, $resName='defaultRes') |
|
| close_ressource ($resName='defaultRes') |
|
| escape_string ($string) |
|
| get_insertExtra () |
|
PDODBConnection::close_ressource |
( |
|
$resName = 'defaultRes' | ) |
|
Close ressource.
- Parameters
-
- Returns
- boolean result
PDODBConnection::connect_server |
( |
|
$host = 'localhost' , |
|
|
|
$login = '' , |
|
|
|
$pwd = '' , |
|
|
|
$driver = '' |
|
) |
| |
Connect to server.
- Parameters
-
string | $host | |
string | $login | |
string | $pwd | |
string | $driver | |
- Returns
- boolean success
PDODBConnection::create_database |
( |
|
$name, |
|
|
|
$charset = 'utf8' |
|
) |
| |
Create a database.
- Parameters
-
string | $name | |
string | $charset | |
- Returns
- boolean
PDODBConnection::create_table |
( |
|
$name, |
|
|
|
$fields, |
|
|
|
$charset = 'utf8' , |
|
|
|
$autoId = true , |
|
|
|
$primaryKeys = array('id') |
|
) |
| |
Create a table in the database.
- Parameters
-
string | $name | |
array | $fields | |
string | $charset | |
boolean | $autoId | |
array | $primaryKeys | |
- Returns
- boolean success
PDODBConnection::database_exists |
( |
|
$name | ) |
|
Check if a base exists.
- Parameters
-
- Returns
- boolean
PDODBConnection::disconnect_server |
( |
| ) |
|
Close server connection.
- Returns
- boolean success
PDODBConnection::dump_database |
( |
|
$file = false | ) |
|
Dump database.
- Parameters
-
- Returns
- mixed
PDODBConnection::escape_string |
( |
|
$string | ) |
|
Return escaped string.
- Parameters
-
- Returns
- string
PDODBConnection::execute_query |
( |
|
$sql = '' , |
|
|
|
$resName = 'defaultRes' |
|
) |
| |
Execute query.
- Parameters
-
string | $sql | |
string | $resName | |
- Returns
- boolean success
PDODBConnection::get_compatibleType |
( |
|
$type = 'default' | ) |
|
|
private |
Return mysql compatible type from given type.
- Parameters
-
- Returns
- string
MySQL can return : var_string longlong newdecimal geometry
SQLLite may return :
PDODBConnection::get_databaseSize |
( |
| ) |
|
Return database size.
- Returns
- integer
PDODBConnection::get_databaseSummary |
( |
| ) |
|
Return database information summary.
- Returns
- array
PDODBConnection::get_queryAffectedRows |
( |
|
$resName = 'defaultRes' | ) |
|
Return latest query affected rows.
- Parameters
-
- Returns
- integer
PDODBConnection::get_queryDataLine |
( |
|
$resName = 'defaultRes' | ) |
|
Return next query data line.
- Parameters
-
- Returns
- array
PDODBConnection::get_queryError |
( |
|
$resName = 'defaultRes' | ) |
|
Return latest query error.
- Parameters
-
- Returns
- string
PDODBConnection::get_queryFieldCount |
( |
|
$resName = 'defaultRes' | ) |
|
Return latest query field count.
- Parameters
-
- Returns
- integer
PDODBConnection::get_queryFieldType |
( |
|
$fIndex = 0 , |
|
|
|
$resName = 'defaultRes' |
|
) |
| |
Return latest query field type.
- Parameters
-
integer | $fIndex | |
string | $resName | |
- Returns
- string
PDODBConnection::get_queryGeneratedId |
( |
|
$resName = 'defaultRes' | ) |
|
Return id generated by last query.
- Parameters
-
- Returns
- integer
PDODBConnection::get_queryNumDataLine |
( |
|
$resName = 'defaultRes' | ) |
|
Return next query data line with numeric indexes.
- Parameters
-
- Returns
- array
PDODBConnection::get_serverVersion |
( |
| ) |
|
Return database engine version.
- Returns
- string
PDODBConnection::get_tableList |
( |
| ) |
|
Return available table list.
- Returns
- array
PDODBConnection::select_database |
( |
|
$name | ) |
|
Select database.
- Parameters
-
string | $name | the database name |
- Returns
- boolean
The documentation for this class was generated from the following file: