| Next revision | Previous revision |
| scriptlog:lib:core:dbmysqli [2026/09/26 09:09] – admin admin | scriptlog:lib:core:dbmysqli [2026/09/26 09:34] (current) – admin admin |
|---|
| ======= Docblock Metadata ======= | ======= Docblock Metadata ======= |
| |
| ^ Tag ^ Value ^ | ^ Tag ^ Value ^ |
| | ''@category'' | Core Class | | | ''@category'' | Core Class | |
| | ''@author'' | M.Noermoehammad | | | ''@author'' | M.Noermoehammad | |
| | ''@license'' | MIT | | | ''@license'' | MIT | |
| | ''@version'' | 1.0 | | | ''@version'' | 1.0 | |
| |
| ======= Inheritance ======= | ======= Inheritance ======= |
| //None.// | //None.// |
| |
| ======= Properties (4) ======= | ======= Properties (12) ======= |
| |
| ^ Visibility ^ Type ^ Name ^ Default ^ Line ^ | ^ Visibility ^ Type ^ Name ^ Default ^ Line ^ |
| | ''private'' | ''(untyped)'' | ''$ca'' | ''false;'' | 31 | | | ''private'' | ''(untyped)'' | ''$dbc'' | | 19 | |
| | ''private static'' | ''static'' | ''$config'' | ''[];'' | 35 | | | ''private'' | ''(untyped)'' | ''$dbhost'' | | 21 | |
| | ''public static'' | ''static'' | ''$inst'' | ''null;'' | 39 | | | ''private'' | ''(untyped)'' | ''$dbuser'' | | 23 | |
| | ''public static'' | ''static'' | ''$counter'' | ''0;'' | 41 | | | ''private'' | ''(untyped)'' | ''$dbpass'' | | 25 | |
| | | ''private'' | ''(untyped)'' | ''$dbname'' | | 27 | |
| | | ''private'' | ''(untyped)'' | ''$dbport'' | | 29 | |
| | | ''private'' | ''(untyped)'' | ''$ca'' | ''false'' | 31 | |
| | | ''private static'' | ''static'' | ''$report_mode'' | | 33 | |
| | | ''private static'' | ''static'' | ''$config'' | ''[]'' | 35 | |
| | | ''public'' | ''(untyped)'' | ''$errors'' | | 37 | |
| | | ''public static'' | ''static'' | ''$inst'' | ''null'' | 39 | |
| | | ''public static'' | ''static'' | ''$counter'' | ''0'' | 41 | |
| |
| ======= Methods (22) ======= | ======= Methods (22) ======= |
| |
| ^ Visibility ^ Method ^ Summary ^ Line ^ | ^ Visibility ^ Method ^ Summary ^ Line ^ |
| | public | ''__construct()'' | (undocumented) | 43 | | | public | ''__construct()'' | (undocumented) | 43 | |
| | public | ''__destruct()'' | (undocumented) | 61 | | | public | ''__destruct()'' | (undocumented) | 61 | |
| | public static | ''activateReportMode()'' | activate report mode on MySQLi Driver | 75 | | | public static | ''activateReportMode()'' | activate report mode on MySQLi Driver | 75 | |
| | public static | ''getInstance()'' | getInstance | 90 | | | public static | ''getInstance()'' | getInstance | 90 | |
| | public | ''dbMySQLTransaction()'' | dbMySQLiTransaction() | 106 | | | public | ''dbMySQLTransaction()'' | dbMySQLiTransaction() | 106 | |
| | public | ''dbMySQLCommit()'' | dbMySQLiCommit() | 116 | | | public | ''dbMySQLCommit()'' | dbMySQLiCommit() | 116 | |
| | public | ''dbMySQLInsertId()'' | dbMySQLiLastInsertId | 125 | | | public | ''dbMySQLInsertId()'' | dbMySQLiLastInsertId | 125 | |
| | public | ''disconnect()'' | disconnect() | 134 | | | public | ''disconnect()'' | disconnect() | 134 | |
| | public | ''simpleQuery()'' | simpleQuery | 145 | | | public | ''simpleQuery()'' | simpleQuery | 145 | |
| | public | ''preparedQuery()'' | preparedQuery | 185 | | | public | ''preparedQuery()'' | preparedQuery | 185 | |
| | public | ''preparedSelect()'' | A helper function for SELECT queries | 220 | | | public | ''preparedSelect()'' | A helper function for SELECT queries | 220 | |
| | public | ''preparedInsert()'' | INSERT query from an array | 234 | | | public | ''preparedInsert()'' | INSERT query from an array | 234 | |
| | public | ''preparedUpdate()'' | preparedUpdate | 256 | | | public | ''preparedUpdate()'' | preparedUpdate | 256 | |
| | public | ''escape_string()'' | escape_string | 283 | | | public | ''escape_string()'' | escape_string | 283 | |
| | public | ''filterData()'' | Filtering user data | 303 | | | public | ''filterData()'' | Filtering user data | 303 | |
| | public | ''cleanOutputDisplay()'' | cleanOutputDisplay() | 323 | | | public | ''cleanOutputDisplay()'' | cleanOutputDisplay() | 323 | |
| | public | ''isTableExists()'' | isTableExists | 341 | | | public | ''isTableExists()'' | isTableExists | 341 | |
| | public | ''getNumRows()'' | getNumRows | 362 | | | public | ''getNumRows()'' | getNumRows | 362 | |
| | public | ''getResult()'' | getResult | 386 | | | public | ''getResult()'' | getResult | 386 | |
| | protected | ''setDbRealConnection()'' | setDbRealConnection() | 417 | | | protected | ''setDbRealConnection()'' | setDbRealConnection() | 417 | |
| | private | ''getConfiguration()'' | getConfiguration | 470 | | | private | ''getConfiguration()'' | getConfiguration | 470 | |
| | private | ''caRootPath()'' | caRootPath() | 482 | | | private | ''caRootPath()'' | caRootPath() | 482 | |
| |
| |
| simpleQuery | simpleQuery |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$sql'' | ''(untyped)'' | //required// | //none// | | | ''$sql'' | ''(untyped)'' | //required// | //none// | |
| |
| **Returns:** ''(none declared)'' | **Returns:** ''(none declared)'' |
| mysqli prepared statement | mysqli prepared statement |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$sql'' | ''(untyped)'' | //required// | //none// | | | ''$sql'' | ''(untyped)'' | //required// | //none// | |
| | ''$params'' | ''(untyped)'' | //required// | //none// | | | ''$params'' | ''(untyped)'' | //required// | //none// | |
| | ''$types'' | ''(untyped)'' | ''""'' | //none// | | | ''$types'' | ''(untyped)'' | ''""'' | //none// | |
| |
| **Returns:** ''(none declared)'' — object | **Returns:** ''(none declared)'' — object |
| A helper function for SELECT queries | A helper function for SELECT queries |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$sql'' | ''(untyped)'' | //required// | //none// | | | ''$sql'' | ''(untyped)'' | //required// | //none// | |
| | ''$params'' | ''(untyped)'' | ''[]'' | //none// | | | ''$params'' | ''(untyped)'' | ''[]'' | //none// | |
| | ''$types'' | ''(untyped)'' | ''""'' | //none// | | | ''$types'' | ''(untyped)'' | ''""'' | //none// | |
| |
| **Returns:** ''(none declared)'' — object | **Returns:** ''(none declared)'' — object |
| INSERT query from an array | INSERT query from an array |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$table'' | ''(untyped)'' | //required// | //none// | | | ''$table'' | ''(untyped)'' | //required// | //none// | |
| | ''$data'' | ''(untyped)'' | //required// | //none// | | | ''$data'' | ''(untyped)'' | //required// | //none// | |
| |
| **Returns:** ''(none declared)'' — void | **Returns:** ''(none declared)'' — void |
| preparedUpdate | preparedUpdate |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$table'' | ''(untyped)'' | //required// | //none// | | | ''$table'' | ''(untyped)'' | //required// | //none// | |
| | ''$data'' | ''(untyped)'' | //required// | //none// | | | ''$data'' | ''(untyped)'' | //required// | //none// | |
| | ''$id'' | ''(untyped)'' | //required// | //none// | | | ''$id'' | ''(untyped)'' | //required// | //none// | |
| |
| **Returns:** ''(none declared)'' — void | **Returns:** ''(none declared)'' — void |
| //lines 283–287 (5)// | //lines 283–287 (5)// |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$field'' | ''(untyped)'' | //required// | //none// | | | ''$field'' | ''(untyped)'' | //required// | //none// | |
| |
| **Returns:** ''(none declared)'' — string | **Returns:** ''(none declared)'' — string |
| Filtering user data | Filtering user data |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$data'' | ''(untyped)'' | //required// | //none// | | | ''$data'' | ''(untyped)'' | //required// | //none// | |
| |
| **Returns:** ''(none declared)'' — mixed | **Returns:** ''(none declared)'' — mixed |
| cleanOutputDisplay() | cleanOutputDisplay() |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$data'' | ''(untyped)'' | //required// | //none// | | | ''$data'' | ''(untyped)'' | //required// | //none// | |
| |
| **Returns:** ''(none declared)'' — mixed | **Returns:** ''(none declared)'' — mixed |
| checking whether table name exists on database | checking whether table name exists on database |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$table_name'' | ''(untyped)'' | //required// | //none// | | | ''$table_name'' | ''(untyped)'' | //required// | //none// | |
| |
| **Returns:** ''(none declared)'' — boolean | **Returns:** ''(none declared)'' — boolean |
| getNumRows | getNumRows |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$results'' | ''(untyped)'' | //required// | //none// | | | ''$results'' | ''(untyped)'' | //required// | //none// | |
| |
| **Returns:** ''(none declared)'' — int|string | **Returns:** ''(none declared)'' — int|string |
| getResult | getResult |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$Statement'' | ''(untyped)'' | //required// | //none// | | | ''$Statement'' | ''(untyped)'' | //required// | //none// | |
| |
| **Returns:** ''(none declared)'' — array | **Returns:** ''(none declared)'' — array |
| caRootPath() | caRootPath() |
| |
| ^ Parameter ^ Type ^ Default ^ Description ^ | ^ Parameter ^ Type ^ Default ^ Description ^ |
| | ''$ca'' | ''(untyped)'' | ''false'' | //none// | | | ''$ca'' | ''(untyped)'' | ''false'' | //none// | |
| |
| **Returns:** ''(none declared)'' — string | **Returns:** ''(none declared)'' — string |