Scriptlog Docs

Scriptlog Documentation

Code reference for the Scriptlog codebase

User Tools

Site Tools


scriptlog:lib:core:dbmysqli

This is an old revision of the document!


DbMySQLi

Layer: Core · Source: lib/core/DbMySQLi.php:17 (lines 17–489)


class DbMySQLi

Docblock Metadata

^ Tag ^ Value ^
| ''@category'' | Core Class |
| ''@author'' | M.Noermoehammad |
| ''@license'' | MIT |
| ''@version'' | 1.0 |

Inheritance

No parent, interface or trait. This is a root type.

Constants (0)

None.

Properties (4)

^ Visibility ^ Type ^ Name ^ Default ^ Line ^
| ''private'' | ''(untyped)'' | ''$ca'' | ''false;'' | 31 |
| ''private static'' | ''static'' | ''$config'' | ''[];'' | 35 |
| ''public static'' | ''static'' | ''$inst'' | ''null;'' | 39 |
| ''public static'' | ''static'' | ''$counter'' | ''0;'' | 41 |

Methods (22)

^ Visibility ^ Method ^ Summary ^ Line ^
| public | ''__construct()'' | (undocumented) | 43 |
| public | ''__destruct()'' | (undocumented) | 61 |
| public static | ''activateReportMode()'' | activate report mode on MySQLi Driver | 75 |
| public static | ''getInstance()'' | getInstance | 90 |
| public | ''dbMySQLTransaction()'' | dbMySQLiTransaction() | 106 |
| public | ''dbMySQLCommit()'' | dbMySQLiCommit() | 116 |
| public | ''dbMySQLInsertId()'' | dbMySQLiLastInsertId | 125 |
| public | ''disconnect()'' | disconnect() | 134 |
| public | ''simpleQuery()'' | simpleQuery | 145 |
| public | ''preparedQuery()'' | preparedQuery | 185 |
| public | ''preparedSelect()'' | A helper function for SELECT queries | 220 |
| public | ''preparedInsert()'' | INSERT query from an array | 234 |
| public | ''preparedUpdate()'' | preparedUpdate | 256 |
| public | ''escape_string()'' | escape_string | 283 |
| public | ''filterData()'' | Filtering user data | 303 |
| public | ''cleanOutputDisplay()'' | cleanOutputDisplay() | 323 |
| public | ''isTableExists()'' | isTableExists | 341 |
| public | ''getNumRows()'' | getNumRows | 362 |
| public | ''getResult()'' | getResult | 386 |
| protected | ''setDbRealConnection()'' | setDbRealConnection() | 417 |
| private | ''getConfiguration()'' | getConfiguration | 470 |
| private | ''caRootPath()'' | caRootPath() | 482 |

__construct()

public function __construct()

lines 43–59 (17)

Takes no parameters.

__destruct()

public function __destruct()

lines 61–67 (7)

Takes no parameters.

Returns: (none declared)

activateReportMode()

public static function activateReportMode()

lines 75–82 (8)

activate report mode on MySQLi Driver

Takes no parameters.

Returns: (none declared) — void

getInstance()

public static function getInstance()

lines 90–98 (9)

getInstance

Takes no parameters.

Returns: (none declared) — object

dbMySQLTransaction()

public function dbMySQLTransaction()

lines 106–110 (5)

dbMySQLiTransaction()

Takes no parameters.

Returns: (none declared) — bol

dbMySQLCommit()

public function dbMySQLCommit()

lines 116–119 (4)

dbMySQLiCommit()

Takes no parameters.

Returns: (none declared)

dbMySQLInsertId()

public function dbMySQLInsertId()

lines 125–128 (4)

dbMySQLiLastInsertId

Takes no parameters.

Returns: (none declared)

disconnect()

public function disconnect()

lines 134–137 (4)

disconnect()

Takes no parameters.

Returns: (none declared)

simpleQuery()

public function simpleQuery($sql)

lines 145–156 (12)

simpleQuery

^ Parameter ^ Type ^ Default ^ Description ^
| ''$sql'' | ''(untyped)'' | //required// | //none// |

Returns: (none declared)

preparedQuery()

public function preparedQuery($sql, $params, $types = "")

lines 185–203 (19)

preparedQuery

mysqli prepared statement

^ Parameter ^ Type ^ Default ^ Description ^
| ''$sql'' | ''(untyped)'' | //required// | //none// |
| ''$params'' | ''(untyped)'' | //required// | //none// |
| ''$types'' | ''(untyped)'' | ''""'' | //none// |

Returns: (none declared) — object

preparedSelect()

public function preparedSelect($sql, $params = [], $types = "")

lines 220–224 (5)

A helper function for SELECT queries

^ Parameter ^ Type ^ Default ^ Description ^
| ''$sql'' | ''(untyped)'' | //required// | //none// |
| ''$params'' | ''(untyped)'' | ''[]'' | //none// |
| ''$types'' | ''(untyped)'' | ''""'' | //none// |

Returns: (none declared) — object

preparedInsert()

public function preparedInsert($table, $data)

lines 234–245 (12)

INSERT query from an array

^ Parameter ^ Type ^ Default ^ Description ^
| ''$table'' | ''(untyped)'' | //required// | //none// |
| ''$data'' | ''(untyped)'' | //required// | //none// |

Returns: (none declared) — void

preparedUpdate()

public function preparedUpdate($table, $data, $id)

lines 256–274 (19)

preparedUpdate

^ Parameter ^ Type ^ Default ^ Description ^
| ''$table'' | ''(untyped)'' | //required// | //none// |
| ''$data'' | ''(untyped)'' | //required// | //none// |
| ''$id'' | ''(untyped)'' | //required// | //none// |

Returns: (none declared) — void

escape_string()

public function escape_string($field)

lines 283–287 (5)

^ Parameter ^ Type ^ Default ^ Description ^
| ''$field'' | ''(untyped)'' | //required// | //none// |

Returns: (none declared) — string

filterData()

public function filterData($data)

lines 303–314 (12)

Filtering user data

^ Parameter ^ Type ^ Default ^ Description ^
| ''$data'' | ''(untyped)'' | //required// | //none// |

Returns: (none declared) — mixed

cleanOutputDisplay()

public function cleanOutputDisplay($data)

lines 323–331 (9)

cleanOutputDisplay()

^ Parameter ^ Type ^ Default ^ Description ^
| ''$data'' | ''(untyped)'' | //required// | //none// |

Returns: (none declared) — mixed

isTableExists()

public function isTableExists($table_name)

lines 341–354 (14)

isTableExists

checking whether table name exists on database

^ Parameter ^ Type ^ Default ^ Description ^
| ''$table_name'' | ''(untyped)'' | //required// | //none// |

Returns: (none declared) — boolean

getNumRows()

public function getNumRows($results)

lines 362–376 (15)

getNumRows

^ Parameter ^ Type ^ Default ^ Description ^
| ''$results'' | ''(untyped)'' | //required// | //none// |

Returns: (none declared) — int|string

getResult()

public function getResult($Statement)

lines 386–408 (23)

getResult

^ Parameter ^ Type ^ Default ^ Description ^
| ''$Statement'' | ''(untyped)'' | //required// | //none// |

Returns: (none declared) — array

setDbRealConnection()

protected function setDbRealConnection()

lines 417–462 (46)

setDbRealConnection()

Takes no parameters.

Returns: (none declared) — bool

getConfiguration()

private function getConfiguration()

lines 470–473 (4)

getConfiguration

Takes no parameters.

Returns: (none declared) — array

caRootPath()

private function caRootPath($ca = false)

lines 482–488 (7)

caRootPath()

^ Parameter ^ Type ^ Default ^ Description ^
| ''$ca'' | ''(untyped)'' | ''false'' | //none// |

Returns: (none declared) — string


This page is generated from source by 'tools/gendoc'. Edits will be overwritten.

scriptlog/lib/core/dbmysqli.1790413761.txt.gz · Last modified: by admin