36 public function ifsql($test, $resok, $resko);
55 public function idate($param);
70 public function begin($textinlog =
'');
84 public function DDLCreateDb($database, $charset =
'', $collation =
'', $owner =
'');
119 public function error();
157 public function order($sortfield =
'', $sortorder =
'');
165 public function decrypt($value);
190 public function escape($stringtoencode);
206 public function sanitize($stringtosanitize);
232 public function rollback($log =
'');
244 public function query($query, $usesavepoint = 0, $type =
'auto', $result_mode = 0);
257 public function connect($host, $login, $passwd, $name, $port = 0);
266 public function plimit($limit = 0, $offset = 0);
299 public function num_rows($resultset);
321 public function errno();
336 public function DDLCreateTable($table, $fields, $primary_key, $type, $unique_keys =
null, $fulltext_keys =
null, $keys =
null);
366 public function DDLAddField($table, $field_name, $field_desc, $field_position =
"");
435 $dolibarr_main_db_host,
436 $dolibarr_main_db_user,
437 $dolibarr_main_db_pass,
438 $dolibarr_main_db_name
451 public function jdate($string, $gm =
false);
461 public function encrypt($fieldorvalue, $withQuotes = 1);
469 public function commit($log =
'');
487 public function free($resultset =
null);
495 public function close();
sanitize($stringtosanitize)
Sanitize a string for SQL forging.
begin($textinlog='')
Start transaction.
order($sortfield='', $sortorder='')
Define sort criteria of request.
lasterrno()
Return last error code.
getVersion()
Return version of database server.
getDefaultCollationDatabase()
Return collation used in database.
plimit($limit=0, $offset=0)
Define limits and offset of request.
escape($stringtoencode)
Escape a string to insert data.
DDLDropField($table, $field_name)
Drop a field from table.
connect($host, $login, $passwd, $name, $port=0)
Connexion to server.
close()
Close database connexion.
getVersionArray()
Return version of database server into an array.
error()
Return description of last error.
getDefaultCharacterSetDatabase()
Return charset used to store data in database.
select_db($database)
Select a database.
lasterror()
Return last error label.
idate($param)
Convert (by PHP) a GM Timestamp date into a string date with PHP server TZ to insert into a date fiel...
commit($log='')
Validate a database transaction.
lastquery()
Return last request executed with query()
DDLDescTable($table, $field="")
Return a pointer of line with description of a table or field.
fetch_row($resultset)
Return datas as an array.
getServerParametersValues($filter='')
Return value of server parameters.
getPathOfRestore()
Return full path of restore program.
last_insert_id($tab, $fieldid='rowid')
Get last ID after an insert INSERT.
getDriverInfo()
Return version of database client driver.
static convertSQLFromMysql($line, $type='ddl')
Convert a SQL request in Mysql syntax to native syntax.
ifsql($test, $resok, $resko)
Format a SQL IF.
DDLCreateDb($database, $charset='', $collation='', $owner='')
Create a new database Do not use function xxx_create_db (xxx=mysql, ...) as they are deprecated We fo...
affected_rows($resultset)
Return the number of lines in the result of a request INSERT, DELETE or UPDATE.
encrypt($fieldorvalue, $withQuotes=1)
Encrypt sensitive data in database Warning: This function includes the escape and add the SQL simple ...
fetch_object($resultset)
Returns the current line (as an object) for the resultset cursor.
jdate($string, $gm=false)
Convert (by PHP) a PHP server TZ string date into a Timestamps date (GMT if gm=true) 19700101020000 -...
getListOfCharacterSet()
Return list of available charset that can be used to store data in database.
getPathOfDump()
Return full path of dump program.
DDLDropTable($table)
Drop a table into database.
DDLInfoTable($table)
List information of columns into a table.
errno()
Return generic error code of last operation.
DDLCreateUser( $dolibarr_main_db_host, $dolibarr_main_db_user, $dolibarr_main_db_pass, $dolibarr_main_db_name)
Create a user and privileges to connect to database (even if database does not exists yet)
free($resultset=null)
Free last resultset used.
DDLGetConnectId()
Return connexion ID.
DDLListTables($database, $table='')
List tables into a database.
decrypt($value)
Decrypt sensitive data in database.
DDLCreateTable($table, $fields, $primary_key, $type, $unique_keys=null, $fulltext_keys=null, $keys=null)
Create a table into database.
DDLUpdateField($table, $field_name, $field_desc)
Update format of a field into a table.
Class to manage Dolibarr database access for an SQL database.
lastqueryerror()
Return last query in error.
num_rows($resultset)
Return number of lines for result of a SELECT.
escapeforlike($stringtoencode)
Escape a string to insert data into a like.
fetch_array($resultset)
Return datas as an array.
query($query, $usesavepoint=0, $type='auto', $result_mode=0)
Execute a SQL request and return the resultset.
DDLAddField($table, $field_name, $field_desc, $field_position="")
Create a new field into table.
getServerStatusValues($filter='')
Return value of server status.
rollback($log='')
Canceling a transaction and returning to old values.
getListOfCollation()
Return list of available collation that can be used for database.
DDLListTablesFull($database, $table='')
List tables into a database with table type.