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();
146 public function order($sortfield =
null, $sortorder =
null);
154 public function decrypt($value);
179 public function escape($stringtoencode);
195 public function sanitize($stringtosanitize);
221 public function rollback($log =
'');
233 public function query($query, $usesavepoint = 0, $type =
'auto', $result_mode = 0);
246 public function connect($host, $login, $passwd, $name, $port = 0);
255 public function plimit($limit = 0, $offset = 0);
288 public function num_rows($resultset);
310 public function errno();
325 public function DDLCreateTable($table, $fields, $primary_key, $type, $unique_keys =
null, $fulltext_keys =
null, $keys =
null);
355 public function DDLAddField($table, $field_name, $field_desc, $field_position =
"");
424 $dolibarr_main_db_host,
425 $dolibarr_main_db_user,
426 $dolibarr_main_db_pass,
427 $dolibarr_main_db_name
440 public function jdate($string, $gm =
false);
450 public function encrypt($fieldorvalue, $withQuotes = 1);
458 public function commit($log =
'');
476 public function free($resultset =
null);
484 public function close();
sanitize($stringtosanitize)
Sanitize a string for SQL forging.
begin($textinlog='')
Start transaction.
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.
order($sortfield=null, $sortorder=null)
Define sort criteria of request.
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.