TraceableDB

class TraceableDB extends DoliDB (View source)

TraceableDB class

Used to log queries into DebugBar

Constants

VERSIONMIN

LABEL

Properties

DoliDB $db
string $type
string $forcecharset from  DoliDB
string $forcecollate from  DoliDB
bool $connected from  DoliDB
bool $database_selected from  DoliDB
string $database_name from  DoliDB
string $database_user from  DoliDB
string $database_host from  DoliDB
int $database_port from  DoliDB
int $transaction_opened from  DoliDB
string $lastquery from  DoliDB
string $lastqueryerror from  DoliDB
string $lasterror from  DoliDB
string $lasterrno from  DoliDB
string $prefix_db from  DoliDB
bool $ok from  DoliDB
string $error from  DoliDB
array<array<string, null|true|string>> $queries
protected float $startTime
protected int $startMemory

Methods

string
prefix()

Return the DB prefix found into prefix_db (if it was set manually by doing $dbhandler->prefix_db=...).

from  DoliDB
string
ifsql(string $test, string $resok, string $resko)

Format a SQL IF

string
stddevpop(string $nameoffield)

Return SQL string to aggregate using the Standard Deviation of population

from  DoliDB
string
hintindex(string $nameofindex, int $mode = 1)

Return SQL string to force an index

from  DoliDB
string
regexpsql(string $subject, string $pattern, int $sqlstring = 0)

format a sql regexp

string
idate(int $param, "gmt"|"tzserver" $gm = 'tzserver')

Convert (by PHP) a GM Timestamp date into a string date with PHP server TZ to insert into a date field.

string
lasterrno()

Return last error code

string
sanitize(string $stringtosanitize, int $allowsimplequote = 0, int $allowsequals = 0, int $allowsspace = 0, int $allowschars = 1)

Sanitize a string for SQL forging

from  DoliDB
int
begin(string $textinlog = '')

Start transaction

int
commit(string $log = '')

Validate a database transaction

int
rollback(string $log = '')

Cancel a transaction and go back to initial data values

string
plimit(int $limit = 0, int $offset = 0)

Define limits and offset of request

string[]
getVersionArray()

Return version of database server into an array

string
lastquery()

Return last request executed with query()

string
order(string $sortfield = null, string $sortorder = null)

Define sort criteria of request

string
lasterror()

Return last error label

int|""
jdate(string $string, bool $gm = false)

Convert (by PHP) a PHP server TZ string date into a Timestamps date (GMT if gm=true) 19700101020000 -> 3600 with TZ+1 and gmt=0 19700101020000 -> 7200 whatever is TZ if gmt=1

string
lastqueryerror()

Return last query in error

bool|int|object
getRow(string $sql)

Return first result from query as object Note : This method executes a given SQL query and retrieves the first row of results as an object. It should only be used with SELECT queries Don't add LIMIT to your query, it will be added by this method

from  DoliDB
false|object[]
getRows(string $sql)

Return all results from query as an array of objects. Using this is a bad practice and is discouraged.

from  DoliDB
int
getNextAutoIncrementId(string $table)

Get the last ID of an auto-increment field of a table

from  DoliDB
mixed
prepare(string $sql)

Prepare a SQL statement for execution

from  DoliDB
__construct(DoliDB $db)

Constructor

array<string|int, mixed>|null|int<0, 0>
fetch_row(mysqli_result|resource|SQLite3Result $resultset)

Return datas as an array

bool|SQLite3Result|mysqli_result|resource
DDLCreateDb(string $database, string $charset = '', string $collation = '', string $owner = '')

Create a new database Do not use function xxx_create_db (xxx=mysql, ...) as they are deprecated We force to create database with charset this->forcecharset and collate this->forcecollate

string
convertSQLFromMysql(string $line, string $type = 'ddl')

Convert a SQL request in Mysql syntax to native syntax

int
affected_rows(mysqli_result|resource|SQLite3Result $resultset)

Return the number o flines into the result of a request INSERT, DELETE or UPDATE

string
error()

Return description of last error

DDLListTables($database, string $table = '')

List tables into a database

DDLListTablesFull($database, string $table = '')

List tables into a database with table info

string
decrypt(string $value)

Decrypt sensitive data in database

array<int|string, mixed>|null|false
fetch_array(mysqli_result|resource|SQLite3Result $resultset)

Return datas as an array

string
escape(string $stringtoencode)

Escape a string to insert data

string
escapeforlike(string $stringtoencode)

Escape a string to insert data into a like

int
last_insert_id(string $tab, string $fieldid = 'rowid')

Get last ID after an insert INSERT

string
getPathOfRestore()

Return full path of restore program

bool|mysqli_result|resource
query(string $query, int $usesavepoint = 0, string $type = 'auto', int $result_mode = 0)

Execute a SQL request and return the resultset

void
startTracing()

Start query tracing

void
endTracing(string $sql, mysqli_result|bool|resource $resql)

End query tracing

false|resource|mysqli|mysqliDoli|Connection|SQLite3
connect(string $host, string $login, string $passwd, string $name, int $port = 0)

Connection to server

array<string, string>
getServerParametersValues(string $filter = '')

Return value of server parameters

array<string, string>
getServerStatusValues(string $filter = '')

Return value of server status

string
getDefaultCollationDatabase()

Return collation used in database

int
num_rows(mysqli_result|resource|SQLite3Result $resultset)

Return number of lines for result of a SELECT

string
getPathOfDump()

Return full path of dump program

string
getDriverInfo()

Return version of database client driver

string
errno()

Return generic error code of last operation.

int
DDLCreateTable(string $table, array<string, array{type: string, label?: string, enabled?: int<0, 2>|string, position?: int, notnull?: int, visible?: int<-2, 5>|string, alwayseditable?: int<0, 1>, noteditable?: int<0, 1>, default?: string, index?: int, foreignkey?: string, searchall?: int<0, 1>, isameasure?: int<0, 1>, css?: string, csslist?: string, help?: string, showoncombobox?: int<0, 2>, disabled?: int<0, 1>, arrayofkeyval?: array<int, string>, autofocusoncreate?: int<0, 1>, comment?: string, copytoclipboard?: int<1, 2>, validate?: int<0, 1>}> $fields, string $primary_key, string $type, ?array<string, mixed> $unique_keys = null, string[] $fulltext_keys = null, string[] $keys = null)

Create a table into database

int
DDLDropTable(string $table)

Drop a table into database

?array<int, array{charset: string, description: string}>
getListOfCharacterSet()

Return list of available charset that can be used to store data in database

int
DDLAddField(string $table, string $field_name, array{type: string, label?: string, enabled?: int<0, 2>|string, position?: int, notnull?: int, visible?: int, noteditable?: int, default?: string, extra?: string, null?: string, index?: int, foreignkey?: string, searchall?: int, isameasure?: int, css?: string, csslist?: string, help?: string, showoncombobox?: int, disabled?: int, arrayofkeyval?: array<int, string>, comment?: string} $field_desc, string $field_position = "")

Create a new field into table

int
DDLDropField(string $table, string $field_name)

Drop a field from table

int
DDLUpdateField(string $table, string $field_name, array{type: string, label: string, enabled: int<0, 2>|string, position: int, notnull?: int, visible: int, noteditable?: int, default?: string, index?: int, foreignkey?: string, searchall?: int, isameasure?: int, css?: string, csslist?: string, help?: string, showoncombobox?: int, disabled?: int, arrayofkeyval?: array<int, string>, comment?: string} $field_desc)

Update format of a field into a table

?array<int, array{collation: string}>
getListOfCollation()

Return list of available collation that can be used for database

bool|resource|mysqli_result|SQLite3Result
DDLDescTable(string $table, string $field = "")

Return a pointer of line with description of a table or field

string
getVersion()

Return version of database server

string
getDefaultCharacterSetDatabase()

Return charset used to store data in database

int
DDLCreateUser(string $dolibarr_main_db_host, string $dolibarr_main_db_user, string $dolibarr_main_db_pass, string $dolibarr_main_db_name)

Create a user and privileges to connect to database (even if database does not exists yet)

string
encrypt(string $fieldorvalue, int $withQuotes = 1)

Encrypt sensitive data in database Warning: This function includes the escape and add the SQL simple quotes on strings.

array<array<string, mixed>>
DDLInfoTable(string $table)

List information of columns into a table.

void
free(resource|mysqli_result|SQLite3Result $resultset = null)

Free last resultset used.

bool
close()

Close database connection

string
DDLGetConnectId()

Return connection ID

object|false
fetch_object(mysqli_result|resource|Connection|SQLite3Result $resultset)

Returns the current line (as an object) for the resultset cursor

bool
select_db(string $database)

Select a database

Details

in DoliDB at line 91
string prefix()

Return the DB prefix found into prefix_db (if it was set manually by doing $dbhandler->prefix_db=...).

Otherwise return MAIN_DB_PREFIX (common use).

Return Value

string

The DB prefix

at line 84
string ifsql(string $test, string $resok, string $resko)

Format a SQL IF

Parameters

string $test

Test string (example: 'cd.statut=0', 'field IS NULL')
string $resok

result if test is equal
string $resko

result if test is not equal

Return Value

string

SQL string

in DoliDB at line 116
string stddevpop(string $nameoffield)

Return SQL string to aggregate using the Standard Deviation of population

Parameters

string $nameoffield

Name of field

Return Value

string

SQL string

in DoliDB at line 128
string hintindex(string $nameofindex, int $mode = 1)

Return SQL string to force an index

Parameters

string $nameofindex

Name of index
int $mode

0=Use, 1=Force

Return Value

string

SQL string

at line 97
string regexpsql(string $subject, string $pattern, int $sqlstring = 0)

format a sql regexp

Parameters

string $subject

Field name to test
string $pattern

SQL pattern to match
int $sqlstring

0=the string being tested is a hard coded string, 1=the string is a field

Return Value

string

SQL string

at line 123
string idate(int $param, "gmt"|"tzserver" $gm = 'tzserver')

Convert (by PHP) a GM Timestamp date into a string date with PHP server TZ to insert into a date field.

Function to use to build INSERT, UPDATE or WHERE predica

Parameters

int $param

Date TMS to convert
"gmt"|"tzserver" $gm

'gmt'=Input information are GMT values, 'tzserver'=Local to server TZ

Return Value

string

Date in a string YYYYMMDDHHMMSS

at line 133
string lasterrno()

Return last error code

Return Value

string lasterrno

in DoliDB at line 187
string sanitize(string $stringtosanitize, int $allowsimplequote = 0, int $allowsequals = 0, int $allowsspace = 0, int $allowschars = 1)

Sanitize a string for SQL forging

Parameters

string $stringtosanitize

String to escape
int $allowsimplequote

1=Allow simple quotes in string around val separated by "," but only when string is used as a list of SQL string "'aa', 'bb', 'cc', ..."). Can be used for IN ... 2=Allow all simple quotes. If you use this value, the return MUST be escaped to forge SQL strings.
int $allowsequals

1=Allow equals sign
int $allowsspace

1=Allow space char
int $allowschars

1=Allow a-z chars

Return Value

string

String escaped

at line 144
int begin(string $textinlog = '')

Start transaction

Parameters

string $textinlog

Add a small text into log. '' by default.

Return Value

int

1 if transaction successfully opened or already opened, 0 if error

at line 676
int commit(string $log = '')

Validate a database transaction

Parameters

string $log

Add more log to default log line

Return Value

int

1 if validation is OK or transaction level no started, 0 if ERROR

at line 343
int rollback(string $log = '')

Cancel a transaction and go back to initial data values

@param  string          $log        Add more log to default log line

Parameters

string $log

Add more log to default log line

Return Value

int

1 if cancellation ok or transaction not open, 0 if error

at line 427
string plimit(int $limit = 0, int $offset = 0)

Define limits and offset of request

Parameters

int $limit

Maximum number of lines returned (-1=conf->liste_limit, 0=no limit)
int $offset

Numero of line from where starting fetch

Return Value

string

String with SQL syntax to add a limit and offset

at line 170
string[] getVersionArray()

Return version of database server into an array

Return Value

string[]

Version array

at line 240
string lastquery()

Return last request executed with query()

Return Value

string

Last query

at line 252
string order(string $sortfield = null, string $sortorder = null)

Define sort criteria of request

Parameters

string $sortfield

List of sort fields
string $sortorder

Sort order

Return Value

string

String to provide syntax of a sort sql string

at line 286
string lasterror()

Return last error label

Return Value

string lasterror

at line 651
int|"" jdate(string $string, bool $gm = false)

Convert (by PHP) a PHP server TZ string date into a Timestamps date (GMT if gm=true) 19700101020000 -> 3600 with TZ+1 and gmt=0 19700101020000 -> 7200 whatever is TZ if gmt=1

Parameters

string $string

Date in a string (YYYYMMDDHHMMSS, YYYYMMDD, YYYY-MM-DD HH:MM:SS)
bool $gm

1=Input information are GMT values, otherwise local to server TZ

Return Value

int|""

Date TMS or ''

at line 719
string lastqueryerror()

Return last query in error

Return Value

string lastqueryerror

in DoliDB at line 429
bool|int|object getRow(string $sql)

Return first result from query as object Note : This method executes a given SQL query and retrieves the first row of results as an object. It should only be used with SELECT queries Don't add LIMIT to your query, it will be added by this method

Parameters

string $sql

The sql query string

Return Value

bool|int|object

False on failure, 0 on empty, object on success

in DoliDB at line 455
false|object[] getRows(string $sql)

Return all results from query as an array of objects. Using this is a bad practice and is discouraged.

Note : It should only be used with SELECT queries and with a limit. If you are not able to defined/know what can be the limit, it just means this function is not what you need. Do not use it.

Parameters

string $sql

The sql query string. Must end with "... LIMIT x"

Return Value

false|object[] Result

in DoliDB at line 482
int getNextAutoIncrementId(string $table)

Get the last ID of an auto-increment field of a table

Parameters

string $table

Name of table

Return Value

int

Next ID or -1 if error

in DoliDB at line 497
mixed prepare(string $sql)

Prepare a SQL statement for execution

This method must be implemented by subclasses.

Parameters

string $sql

SQL query to prepare

Return Value

mixed

Driver-specific prepared statement object or false on failure

at line 69
__construct(DoliDB $db)

Constructor

Parameters

DoliDB $db

Database handler

at line 109
array<string|int, mixed>|null|int<0, 0> fetch_row(mysqli_result|resource|SQLite3Result $resultset)

Return datas as an array

Parameters

mysqli_result|resource|SQLite3Result $resultset

Resultset of request

Return Value

array<string|int, mixed>|null|int<0, 0> Array

at line 160
bool|SQLite3Result|mysqli_result|resource DDLCreateDb(string $database, string $charset = '', string $collation = '', string $owner = '')

Create a new database Do not use function xxx_create_db (xxx=mysql, ...) as they are deprecated We force to create database with charset this->forcecharset and collate this->forcecollate

Parameters

string $database

Database name to create
string $charset

Charset used to store data
string $collation

Charset used to sort data
string $owner

Username of database owner

Return Value

bool|SQLite3Result|mysqli_result|resource

Resource result of the query to create database if OK, null if KO

at line 182
string convertSQLFromMysql(string $line, string $type = 'ddl')

Convert a SQL request in Mysql syntax to native syntax

Parameters

string $line

SQL request line to convert
string $type

Type of SQL order ('ddl' for insert, update, select, delete or 'dml' for create, alter...)

Return Value

string

SQL request line converted

at line 195
int affected_rows(mysqli_result|resource|SQLite3Result $resultset)

Return the number o flines into the result of a request INSERT, DELETE or UPDATE

Parameters

mysqli_result|resource|SQLite3Result $resultset

Cursor of the desired request

Return Value

int

Number of lines

See also

num_rows()

at line 206
string error()

Return description of last error

Return Value

string

Error text

at line 218
DDLListTables($database, string $table = '')

List tables into a database

@param string $database Name of database

Parameters

$database
string $table

Name of table filter ('xxx%') @return string[] of tables in an array

at line 230
DDLListTablesFull($database, string $table = '')

List tables into a database with table info

@param string $database Name of database

Parameters

$database
string $table

Name of table filter ('xxx%') @return array<array{0:string,1:string}> List of tables in an array

at line 263
string decrypt(string $value)

Decrypt sensitive data in database

Parameters

string $value

Value to decrypt

Return Value

string

Decrypted value if used

at line 275
array<int|string, mixed>|null|false fetch_array(mysqli_result|resource|SQLite3Result $resultset)

Return datas as an array

Parameters

mysqli_result|resource|SQLite3Result $resultset

Resultset of request

Return Value

array<int|string, mixed>|null|false

Result with row

at line 297
string escape(string $stringtoencode)

Escape a string to insert data

Parameters

string $stringtoencode

String to escape

Return Value

string

String escaped

at line 308
string escapeforlike(string $stringtoencode)

Escape a string to insert data into a like

Parameters

string $stringtoencode

String to escape

Return Value

string

String escaped

at line 321
int last_insert_id(string $tab, string $fieldid = 'rowid')

Get last ID after an insert INSERT

Parameters

string $tab

Table name concerned by insert. Not used under MySql but required for compatibility with Postgresql
string $fieldid

Field name

Return Value

int

Id of row

at line 332
string getPathOfRestore()

Return full path of restore program

Return Value

string

Full path of restore program

at line 358
bool|mysqli_result|resource query(string $query, int $usesavepoint = 0, string $type = 'auto', int $result_mode = 0)

Execute a SQL request and return the resultset

Parameters

string $query

SQL query string
int $usesavepoint

0=Default mode, 1=Run a savepoint before and a rollback to savepoint if error (this allow to have some request with errors inside global transactions). Note that with Mysql, this parameter is not used as Myssql can already commit a transaction even if one request is in error, without using savepoints.
string $type

Type of SQL order ('ddl' for insert, update, select, delete or 'dml' for create, alter...)
int $result_mode

Result mode

Return Value

bool|mysqli_result|resource

Resultset of answer or false

at line 374
protected void startTracing()

Start query tracing

Return Value

void

at line 387
protected void endTracing(string $sql, mysqli_result|bool|resource $resql)

End query tracing

Parameters

string $sql

query string
mysqli_result|bool|resource $resql

query result

Return Value

void

at line 415
false|resource|mysqli|mysqliDoli|Connection|SQLite3 connect(string $host, string $login, string $passwd, string $name, int $port = 0)

Connection to server

Parameters

string $host

Database server host
string $login Login
string $passwd Password
string $name

Name of database (not used for mysql, used for pgsql)
int $port

Port of database server

Return Value

false|resource|mysqli|mysqliDoli|Connection|SQLite3

Database access handler

See also

close()

at line 438
array<string, string> getServerParametersValues(string $filter = '')

Return value of server parameters

Parameters

string $filter

Filter list on a particular value

Return Value

array<string, string>

Array of key-values (key=>value)

at line 449
array<string, string> getServerStatusValues(string $filter = '')

Return value of server status

Parameters

string $filter

Filter list on a particular value

Return Value

array<string, string>

Array of key-values (key=>value)

at line 459
string getDefaultCollationDatabase()

Return collation used in database

Return Value

string

Collation value

at line 472
int num_rows(mysqli_result|resource|SQLite3Result $resultset)

Return number of lines for result of a SELECT

Parameters

mysqli_result|resource|SQLite3Result $resultset

Resulset of requests

Return Value

int

Nb of lines

See also

affected_rows()

at line 483
string getPathOfDump()

Return full path of dump program

Return Value

string

Full path of dump program

at line 493
string getDriverInfo()

Return version of database client driver

Return Value

string

Version string

at line 503
string errno()

Return generic error code of last operation.

Return Value

string

Error code (Examples: DB_ERROR_TABLE_ALREADY_EXISTS, DB_ERROR_RECORD_ALREADY_EXISTS...)

at line 520
int DDLCreateTable(string $table, array<string, array{type: string, label?: string, enabled?: int<0, 2>|string, position?: int, notnull?: int, visible?: int<-2, 5>|string, alwayseditable?: int<0, 1>, noteditable?: int<0, 1>, default?: string, index?: int, foreignkey?: string, searchall?: int<0, 1>, isameasure?: int<0, 1>, css?: string, csslist?: string, help?: string, showoncombobox?: int<0, 2>, disabled?: int<0, 1>, arrayofkeyval?: array<int, string>, autofocusoncreate?: int<0, 1>, comment?: string, copytoclipboard?: int<1, 2>, validate?: int<0, 1>}> $fields, string $primary_key, string $type, ?array<string, mixed> $unique_keys = null, string[] $fulltext_keys = null, string[] $keys = null)

Create a table into database

Parameters

string $table

Name of table
array<string, array{type: string, label?: string, enabled?: int<0, 2>|string, position?: int, notnull?: int, visible?: int<-2, 5>|string, alwayseditable?: int<0, 1>, noteditable?: int<0, 1>, default?: string, index?: int, foreignkey?: string, searchall?: int<0, 1>, isameasure?: int<0, 1>, css?: string, csslist?: string, help?: string, showoncombobox?: int<0, 2>, disabled?: int<0, 1>, arrayofkeyval?: array<int, string>, autofocusoncreate?: int<0, 1>, comment?: string, copytoclipboard?: int<1, 2>, validate?: int<0, 1>}> $fields

Associative table [field name][table of descriptions]
string $primary_key

Name of the field that will be the primary key
string $type

Type of the table
?array<string, mixed> $unique_keys

Associative array Name of fields that will be unique key => value
string[] $fulltext_keys

Field name table that will be indexed in fulltext
string[] $keys

Table of key fields names => value

Return Value

int

Return integer <0 if KO, >=0 if OK

at line 531
int DDLDropTable(string $table)

Drop a table into database

Parameters

string $table

Name of table

Return Value

int

Return integer <0 if KO, >=0 if OK

at line 541
?array<int, array{charset: string, description: string}> getListOfCharacterSet()

Return list of available charset that can be used to store data in database

Return Value

?array<int, array{charset: string, description: string}>

List of Charset

at line 555
int DDLAddField(string $table, string $field_name, array{type: string, label?: string, enabled?: int<0, 2>|string, position?: int, notnull?: int, visible?: int, noteditable?: int, default?: string, extra?: string, null?: string, index?: int, foreignkey?: string, searchall?: int, isameasure?: int, css?: string, csslist?: string, help?: string, showoncombobox?: int, disabled?: int, arrayofkeyval?: array<int, string>, comment?: string} $field_desc, string $field_position = "")

Create a new field into table

Parameters

string $table

Name of table
string $field_name

Name of field to add
array{type: string, label?: string, enabled?: int<0, 2>|string, position?: int, notnull?: int, visible?: int, noteditable?: int, default?: string, extra?: string, null?: string, index?: int, foreignkey?: string, searchall?: int, isameasure?: int, css?: string, csslist?: string, help?: string, showoncombobox?: int, disabled?: int, arrayofkeyval?: array<int, string>, comment?: string} $field_desc

Associative array of description of the field to insert [parameter name][parameter value]
string $field_position

Optional ex .: "after field stuff"

Return Value

int

Return integer <0 if KO, >0 if OK

at line 567
int DDLDropField(string $table, string $field_name)

Drop a field from table

Parameters

string $table

Name of table
string $field_name

Name of field to drop

Return Value

int

Return integer <0 if KO, >0 if OK

at line 580
int DDLUpdateField(string $table, string $field_name, array{type: string, label: string, enabled: int<0, 2>|string, position: int, notnull?: int, visible: int, noteditable?: int, default?: string, index?: int, foreignkey?: string, searchall?: int, isameasure?: int, css?: string, csslist?: string, help?: string, showoncombobox?: int, disabled?: int, arrayofkeyval?: array<int, string>, comment?: string} $field_desc)

Update format of a field into a table

Parameters

string $table

Name of table
string $field_name

Name of field to modify
array{type: string, label: string, enabled: int<0, 2>|string, position: int, notnull?: int, visible: int, noteditable?: int, default?: string, index?: int, foreignkey?: string, searchall?: int, isameasure?: int, css?: string, csslist?: string, help?: string, showoncombobox?: int, disabled?: int, arrayofkeyval?: array<int, string>, comment?: string} $field_desc

Array with description of field format

Return Value

int

Return integer <0 if KO, >0 if OK

at line 590
?array<int, array{collation: string}> getListOfCollation()

Return list of available collation that can be used for database

Return Value

?array<int, array{collation: string}>

List of Collation

at line 602
bool|resource|mysqli_result|SQLite3Result DDLDescTable(string $table, string $field = "")

Return a pointer of line with description of a table or field

Parameters

string $table

Name of table
string $field

Optional : Name of field if we want description of field

Return Value

bool|resource|mysqli_result|SQLite3Result Resource

at line 612
string getVersion()

Return version of database server

Return Value

string

Version string

at line 622
string getDefaultCharacterSetDatabase()

Return charset used to store data in database

Return Value

string Charset

at line 636
int DDLCreateUser(string $dolibarr_main_db_host, string $dolibarr_main_db_user, string $dolibarr_main_db_pass, string $dolibarr_main_db_name)

Create a user and privileges to connect to database (even if database does not exists yet)

Parameters

string $dolibarr_main_db_host

Server IP
string $dolibarr_main_db_user

Username to create
string $dolibarr_main_db_pass

User password to create
string $dolibarr_main_db_name

Database name where user must be granted

Return Value

int

Return integer <0 if KO, >=0 if OK

at line 665
string encrypt(string $fieldorvalue, int $withQuotes = 1)

Encrypt sensitive data in database Warning: This function includes the escape and add the SQL simple quotes on strings.

Parameters

string $fieldorvalue

Field name or value to encrypt
int $withQuotes

Return string including the SQL simple quotes. This param must always be 1 (Value 0 is bugged and deprecated).

Return Value

string

XXX(field) or XXX('value') or field or 'value'

at line 687
array<array<string, mixed>> DDLInfoTable(string $table)

List information of columns into a table.

Parameters

string $table

Name of table

Return Value

array<array<string, mixed>>

Array with information on table

at line 698
void free(resource|mysqli_result|SQLite3Result $resultset = null)

Free last resultset used.

Parameters

resource|mysqli_result|SQLite3Result $resultset

Free cursor

Return Value

void

at line 709
bool close()

Close database connection

Return Value

bool

True if disconnect successful, false otherwise

See also

connect()

at line 729
string DDLGetConnectId()

Return connection ID

Return Value

string

Id connection

at line 741
object|false fetch_object(mysqli_result|resource|Connection|SQLite3Result $resultset)

Returns the current line (as an object) for the resultset cursor

Parameters

mysqli_result|resource|Connection|SQLite3Result $resultset

Handler of the desired request

Return Value

object|false

Object result line or false if KO or end of cursor

at line 754
bool select_db(string $database)

Select a database

Parameters

string $database

Name of database

Return Value

bool

true if OK, false if KO