• Properties (43)
• Available methods (74)

• ⇄⧉public connID -> mysqli#105 (0)

  $this->db->getLastQuery()->db->connID

  • Available methods (43)

  • ⇄public __construct(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null)

    new \mysqli(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null)

    ⇄public autocommit(bool $enable)

    $this->db->getLastQuery()->db->connID->autocommit(bool $enable)

    ⇄public begin_transaction(int $flags0, ?string $name = null)

    $this->db->getLastQuery()->db->connID->begin_transaction(int $flags0, ?string $name = null)

    ⇄public change_user(string $username, string $password, ?string $database)

    $this->db->getLastQuery()->db->connID->change_user(string $username, string $password, ?string $database)

    ⇄public character_set_name()

    $this->db->getLastQuery()->db->connID->character_set_name()

    ⇄public close()

    $this->db->getLastQuery()->db->connID->close()

    ⇄public commit(int $flags0, ?string $name = null)

    $this->db->getLastQuery()->db->connID->commit(int $flags0, ?string $name = null)

    ⇄public connect(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null)

    $this->db->getLastQuery()->db->connID->connect(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null)

    ⇄public dump_debug_info()

    $this->db->getLastQuery()->db->connID->dump_debug_info()

    ⇄public debug(string $options)

    $this->db->getLastQuery()->db->connID->debug(string $options)

    ⇄public get_charset()

    $this->db->getLastQuery()->db->connID->get_charset()

    ⇄public get_client_info()

    $this->db->getLastQuery()->db->connID->get_client_info()

    ⇄public get_connection_stats()

    $this->db->getLastQuery()->db->connID->get_connection_stats()

    ⇄public get_server_info()

    $this->db->getLastQuery()->db->connID->get_server_info()

    ⇄public get_warnings()

    $this->db->getLastQuery()->db->connID->get_warnings()

    ⇄public init()

    $this->db->getLastQuery()->db->connID->init()

    ⇄public kill(int $process_id)

    $this->db->getLastQuery()->db->connID->kill(int $process_id)

    ⇄public multi_query(string $query)

    $this->db->getLastQuery()->db->connID->multi_query(string $query)

    ⇄public more_results()

    $this->db->getLastQuery()->db->connID->more_results()

    ⇄public next_result()

    $this->db->getLastQuery()->db->connID->next_result()

    ⇄public ping()

    $this->db->getLastQuery()->db->connID->ping()

    ⇄public prepare(string $query)

    $this->db->getLastQuery()->db->connID->prepare(string $query)

    ⇄public query(string $query, int $result_mode0)

    $this->db->getLastQuery()->db->connID->query(string $query, int $result_mode0)

    ⇄public real_connect(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null, int $flags0)

    $this->db->getLastQuery()->db->connID->real_connect(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null, int $flags0)

    ⇄public real_escape_string(string $string)

    $this->db->getLastQuery()->db->connID->real_escape_string(string $string)

    ⇄public reap_async_query()

    $this->db->getLastQuery()->db->connID->reap_async_query()

    ⇄public escape_string(string $string)

    $this->db->getLastQuery()->db->connID->escape_string(string $string)

    ⇄public real_query(string $query)

    $this->db->getLastQuery()->db->connID->real_query(string $query)

    ⇄public release_savepoint(string $name)

    $this->db->getLastQuery()->db->connID->release_savepoint(string $name)

    ⇄public rollback(int $flags0, ?string $name = null)

    $this->db->getLastQuery()->db->connID->rollback(int $flags0, ?string $name = null)

    ⇄public savepoint(string $name)

    $this->db->getLastQuery()->db->connID->savepoint(string $name)

    ⇄public select_db(string $database)

    $this->db->getLastQuery()->db->connID->select_db(string $database)

    ⇄public set_charset(string $charset)

    $this->db->getLastQuery()->db->connID->set_charset(string $charset)

    ⇄public options(int $option, $value)

    $this->db->getLastQuery()->db->connID->options(int $option, $value)

    ⇄public set_opt(int $option, $value)

    $this->db->getLastQuery()->db->connID->set_opt(int $option, $value)

    ⇄public ssl_set(?string $key, ?string $certificate, ?string $ca_certificate, ?string $ca_path, ?string $cipher_algos)

    $this->db->getLastQuery()->db->connID->ssl_set(?string $key, ?string $certificate, ?string $ca_certificate, ?string $ca_path, ?string $cipher_algos)

    ⇄public stat()

    $this->db->getLastQuery()->db->connID->stat()

    ⇄public stmt_init()

    $this->db->getLastQuery()->db->connID->stmt_init()

    ⇄public store_result(int $mode0)

    $this->db->getLastQuery()->db->connID->store_result(int $mode0)

    ⇄public thread_safe()

    $this->db->getLastQuery()->db->connID->thread_safe()

    ⇄public use_result()

    $this->db->getLastQuery()->db->connID->use_result()

    ⇄public refresh(int $flags)

    $this->db->getLastQuery()->db->connID->refresh(int $flags)

    ⇄public static poll(?array &$read, ?array &$error, array &$reject, int $seconds, int $microseconds0)

    \mysqli::poll(?array &$read, ?array &$error, array &$reject, int $seconds, int $microseconds0)

  ⇄public dataCache -> array (0)

  $this->db->getLastQuery()->db->dataCache

  ⇄public DBDriver -> string (6) "MySQLi"

  $this->db->getLastQuery()->db->DBDriver

  ⇄public deleteHack -> boolean true

  $this->db->getLastQuery()->db->deleteHack

  ⇄public escapeChar -> string (1) "`"

  $this->db->getLastQuery()->db->escapeChar

  ⇄public likeEscapeChar -> string (1) "!"

  $this->db->getLastQuery()->db->likeEscapeChar

  ⇄public likeEscapeStr -> string (13) " ESCAPE '%s' "

  $this->db->getLastQuery()->db->likeEscapeStr

  ⇄⧉public mysqli -> mysqli#105 (0)

  $this->db->getLastQuery()->db->mysqli

  • Available methods (43)

  • ⇄public __construct(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null)

    new \mysqli(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null)

    ⇄public autocommit(bool $enable)

    $this->db->getLastQuery()->db->mysqli->autocommit(bool $enable)

    ⇄public begin_transaction(int $flags0, ?string $name = null)

    $this->db->getLastQuery()->db->mysqli->begin_transaction(int $flags0, ?string $name = null)

    ⇄public change_user(string $username, string $password, ?string $database)

    $this->db->getLastQuery()->db->mysqli->change_user(string $username, string $password, ?string $database)

    ⇄public character_set_name()

    $this->db->getLastQuery()->db->mysqli->character_set_name()

    ⇄public close()

    $this->db->getLastQuery()->db->mysqli->close()

    ⇄public commit(int $flags0, ?string $name = null)

    $this->db->getLastQuery()->db->mysqli->commit(int $flags0, ?string $name = null)

    ⇄public connect(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null)

    $this->db->getLastQuery()->db->mysqli->connect(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null)

    ⇄public dump_debug_info()

    $this->db->getLastQuery()->db->mysqli->dump_debug_info()

    ⇄public debug(string $options)

    $this->db->getLastQuery()->db->mysqli->debug(string $options)

    ⇄public get_charset()

    $this->db->getLastQuery()->db->mysqli->get_charset()

    ⇄public get_client_info()

    $this->db->getLastQuery()->db->mysqli->get_client_info()

    ⇄public get_connection_stats()

    $this->db->getLastQuery()->db->mysqli->get_connection_stats()

    ⇄public get_server_info()

    $this->db->getLastQuery()->db->mysqli->get_server_info()

    ⇄public get_warnings()

    $this->db->getLastQuery()->db->mysqli->get_warnings()

    ⇄public init()

    $this->db->getLastQuery()->db->mysqli->init()

    ⇄public kill(int $process_id)

    $this->db->getLastQuery()->db->mysqli->kill(int $process_id)

    ⇄public multi_query(string $query)

    $this->db->getLastQuery()->db->mysqli->multi_query(string $query)

    ⇄public more_results()

    $this->db->getLastQuery()->db->mysqli->more_results()

    ⇄public next_result()

    $this->db->getLastQuery()->db->mysqli->next_result()

    ⇄public ping()

    $this->db->getLastQuery()->db->mysqli->ping()

    ⇄public prepare(string $query)

    $this->db->getLastQuery()->db->mysqli->prepare(string $query)

    ⇄public query(string $query, int $result_mode0)

    $this->db->getLastQuery()->db->mysqli->query(string $query, int $result_mode0)

    ⇄public real_connect(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null, int $flags0)

    $this->db->getLastQuery()->db->mysqli->real_connect(?string $hostname = null, ?string $username = null, ?string $password = null, ?string $database = null, ?int $port = null, ?string $socket = null, int $flags0)

    ⇄public real_escape_string(string $string)

    $this->db->getLastQuery()->db->mysqli->real_escape_string(string $string)

    ⇄public reap_async_query()

    $this->db->getLastQuery()->db->mysqli->reap_async_query()

    ⇄public escape_string(string $string)

    $this->db->getLastQuery()->db->mysqli->escape_string(string $string)

    ⇄public real_query(string $query)

    $this->db->getLastQuery()->db->mysqli->real_query(string $query)

    ⇄public release_savepoint(string $name)

    $this->db->getLastQuery()->db->mysqli->release_savepoint(string $name)

    ⇄public rollback(int $flags0, ?string $name = null)

    $this->db->getLastQuery()->db->mysqli->rollback(int $flags0, ?string $name = null)

    ⇄public savepoint(string $name)

    $this->db->getLastQuery()->db->mysqli->savepoint(string $name)

    ⇄public select_db(string $database)

    $this->db->getLastQuery()->db->mysqli->select_db(string $database)

    ⇄public set_charset(string $charset)

    $this->db->getLastQuery()->db->mysqli->set_charset(string $charset)

    ⇄public options(int $option, $value)

    $this->db->getLastQuery()->db->mysqli->options(int $option, $value)

    ⇄public set_opt(int $option, $value)

    $this->db->getLastQuery()->db->mysqli->set_opt(int $option, $value)

    ⇄public ssl_set(?string $key, ?string $certificate, ?string $ca_certificate, ?string $ca_path, ?string $cipher_algos)

    $this->db->getLastQuery()->db->mysqli->ssl_set(?string $key, ?string $certificate, ?string $ca_certificate, ?string $ca_path, ?string $cipher_algos)

    ⇄public stat()

    $this->db->getLastQuery()->db->mysqli->stat()

    ⇄public stmt_init()

    $this->db->getLastQuery()->db->mysqli->stmt_init()

    ⇄public store_result(int $mode0)

    $this->db->getLastQuery()->db->mysqli->store_result(int $mode0)

    ⇄public thread_safe()

    $this->db->getLastQuery()->db->mysqli->thread_safe()

    ⇄public use_result()

    $this->db->getLastQuery()->db->mysqli->use_result()

    ⇄public refresh(int $flags)

    $this->db->getLastQuery()->db->mysqli->refresh(int $flags)

    ⇄public static poll(?array &$read, ?array &$error, array &$reject, int $seconds, int $microseconds0)

    \mysqli::poll(?array &$read, ?array &$error, array &$reject, int $seconds, int $microseconds0)

  ⇄public numberNative -> boolean false

  $this->db->getLastQuery()->db->numberNative

  ⇄public protectIdentifiers -> boolean true

  $this->db->getLastQuery()->db->protectIdentifiers

  ⇄⧉public resultID -> mysqli_result#107 (0)

  $this->db->getLastQuery()->db->resultID

  • Available methods (16)
  • Iterator

  • ⇄public __construct(mysqli $mysql, int $result_mode0)

    new \mysqli_result(mysqli $mysql, int $result_mode0)

    ⇄public close()

    $this->db->getLastQuery()->db->resultID->close()

    ⇄public free()

    $this->db->getLastQuery()->db->resultID->free()

    ⇄public data_seek(int $offset)

    $this->db->getLastQuery()->db->resultID->data_seek(int $offset)

    ⇄public fetch_field()

    $this->db->getLastQuery()->db->resultID->fetch_field()

    ⇄public fetch_fields()

    $this->db->getLastQuery()->db->resultID->fetch_fields()

    ⇄public fetch_field_direct(int $index)

    $this->db->getLastQuery()->db->resultID->fetch_field_direct(int $index)

    ⇄public fetch_all(int $mode = 2)

    $this->db->getLastQuery()->db->resultID->fetch_all(int $mode = 2)

    ⇄public fetch_array(int $mode = 3)

    $this->db->getLastQuery()->db->resultID->fetch_array(int $mode = 3)

    ⇄public fetch_assoc()

    $this->db->getLastQuery()->db->resultID->fetch_assoc()

    ⇄public fetch_object(string $class = 'stdClass', array $constructor_args = array())

    $this->db->getLastQuery()->db->resultID->fetch_object(string $class = 'stdClass', array $constructor_args = array())

    ⇄public fetch_row()

    $this->db->getLastQuery()->db->resultID->fetch_row()

    ⇄public fetch_column(int $column0): string|int|float|false|null

    $this->db->getLastQuery()->db->resultID->fetch_column(int $column0)

    ⇄public field_seek(int $index)

    $this->db->getLastQuery()->db->resultID->field_seek(int $index)

    ⇄public free_result()

    $this->db->getLastQuery()->db->resultID->free_result()

    ⇄public getIterator(): Iterator

    $this->db->getLastQuery()->db->resultID->getIterator()

  • ⇄⧉mysqli_result Iterator Contents Blacklisted

    iterator_to_array($this->db->getLastQuery()->db->resultID, true)

  ⇄public resultMode -> integer 0

  $this->db->getLastQuery()->db->resultMode

  ⇄public transEnabled -> boolean true

  $this->db->getLastQuery()->db->transEnabled

  ⇄public transStrict -> boolean true

  $this->db->getLastQuery()->db->transStrict

  protected aliasedTables -> array (0)

  protected charset -> string (4) "utf8"

  protected compress -> boolean false

  protected connectDuration -> double 0.00072407722473145

  protected connectTime -> double 1784182971.7983

  protected database -> string (18) "ivetsystem_ssghana"

  protected DBCollat -> string (15) "utf8_general_ci"

  protected DBDebug -> boolean true

  protected DBPrefix -> string (0) ""

  protected DSN -> string (0) ""

  protected encrypt -> boolean false

  protected failover -> array (0)

  protected hostname -> string (9) "localhost"

  ⧉protected lastQuery -> CodeIgniter\Database\Query#106 (9) Recursion

  protected password -> string (12) "81&JSjX(3p@d"

  protected pConnect -> boolean false

  protected port -> integer 3306

  ⧉protected pregEscapeChar -> array (4)

  1 => string (1) "`"

  0 => string (1) "`"

  3 => string (1) "`"

  2 => string (1) "`"

  protected pretend -> boolean false

  protected queryClass -> string (26) "CodeIgniter\Database\Query"

  ⧉protected reservedIdentifiers -> array (1)

  0 => string (1) "*"

  protected strictOn -> boolean false

  protected subdriver -> null

  protected swapPre -> string (0) ""

  protected transDepth -> integer 0

  protected transException -> boolean false

  protected transFailure -> boolean false

  protected transStatus -> boolean true

  protected username -> string (13) "ivetsyst_main"

• ⇄⧉public connect(bool $persistent = false): false|mysqli Connect to the database.

  $this->db->getLastQuery()->db->connect(bool $persistent = false)

  /**
  * Connect to the database.
  *
  * @return false|mysqli
  *
  * @throws DatabaseException
  */
  
  Defined in .../Database/MySQLi/Connection.php:89

  ⇄⧉public reconnect() Keep or establish the connection if no queries have been sent for a length of...

  $this->db->getLastQuery()->db->reconnect()

  /**
  * Keep or establish the connection if no queries have been sent for
  * a length of time exceeding the server's idle timeout.
  */
  
  Defined in .../Database/MySQLi/Connection.php:239

  ⇄⧉public setDatabase(string $databaseName): bool Select a specific database table to use.

  $this->db->getLastQuery()->db->setDatabase(string $databaseName)

  /**
  * Select a specific database table to use.
  */
  
  Defined in .../Database/MySQLi/Connection.php:256

  ⇄⧉public getVersion(): string Returns a string containing the version of the database being used.

  $this->db->getLastQuery()->db->getVersion()

  /**
  * Returns a string containing the version of the database being used.
  */
  
  Defined in .../Database/MySQLi/Connection.php:278

  ⇄⧉public affectedRows(): int Returns the total number of rows affected by this query.

  $this->db->getLastQuery()->db->affectedRows()

  /**
  * Returns the total number of rows affected by this query.
  */
  
  Defined in .../Database/MySQLi/Connection.php:335

  ⇄⧉public escapeLikeStringDirect($str): string|string[] Escape Like String Direct There are a few instances where MySQLi queries cann...

  $this->db->getLastQuery()->db->escapeLikeStringDirect($str)

  /**
  * Escape Like String Direct
  * There are a few instances where MySQLi queries cannot take the
  * additional "ESCAPE x" parameter for specifying the escape character
  * in "LIKE" strings, and this handles those directly with a backslash.
  *
  * @param string|string[] $str Input string
  *
  * @return string|string[]
  */
  
  Defined in .../Database/MySQLi/Connection.php:362

  ⇄⧉public error(): array Returns the last error code and message. Must return this format: ['code' => ...

  $this->db->getLastQuery()->db->error()

  /**
  * Returns the last error code and message.
  * Must return this format: ['code' => string|int, 'message' => string]
  * intval(code) === 0 means "no error".
  *
  * @return array<string, int|string>
  */
  
  Defined in .../Database/MySQLi/Connection.php:568

  ⇄⧉public insertID(): int Insert ID

  $this->db->getLastQuery()->db->insertID()

  /**
  * Insert ID
  */
  
  Defined in .../Database/MySQLi/Connection.php:586

  ⇄⧉public __construct(array $params) Saves our connection settings.

  new \CodeIgniter\Database\MySQLi\Connection(array $params)

  /**
  * Saves our connection settings.
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:346

  ⇄⧉public initialize(): void Initializes the database connection/settings.

  $this->db->getLastQuery()->db->initialize()

  /**
  * Initializes the database connection/settings.
  *
  * @return void
  *
  * @throws DatabaseException
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:375

  ⇄⧉public close() Close the database connection.

  $this->db->getLastQuery()->db->close()

  /**
  * Close the database connection.
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:442

  ⇄⧉public persistentConnect(): false|object|resource Create a persistent database connection.

  $this->db->getLastQuery()->db->persistentConnect()

  /**
  * Create a persistent database connection.
  *
  * @return         false|object|resource
  * @phpstan-return false|TConnection
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:463

  ⇄⧉public getConnection(?string $alias = null): false|object|resource Returns the actual connection object. If both a 'read' and 'write' connection...

  $this->db->getLastQuery()->db->getConnection(?string $alias = null)

  /**
  * Returns the actual connection object. If both a 'read' and 'write'
  * connection has been specified, you can pass either term in to
  * get that connection. If you pass either alias in and only a single
  * connection is present, it must return the sole connection.
  *
  * @return         false|object|resource
  * @phpstan-return TConnection
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:477

  ⇄⧉public getDatabase(): string Returns the name of the current database being used.

  $this->db->getLastQuery()->db->getDatabase()

  /**
  * Returns the name of the current database being used.
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:486

  ⇄⧉public setPrefix(string $prefix = ''): string Set DB Prefix

  $this->db->getLastQuery()->db->setPrefix(string $prefix = '')

  /**
  * Set DB Prefix
  *
  * Set's the DB Prefix to something new without needing to reconnect
  *
  * @param string $prefix The prefix
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:498

  ⇄⧉public getPrefix(): string Returns the database prefix.

  $this->db->getLastQuery()->db->getPrefix()

  /**
  * Returns the database prefix.
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:506

  ⇄⧉public getPlatform(): string The name of the platform in use (MySQLi, Postgre, SQLite3, OCI8, etc)

  $this->db->getLastQuery()->db->getPlatform()

  /**
  * The name of the platform in use (MySQLi, Postgre, SQLite3, OCI8, etc)
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:514

  ⇄⧉public setAliasedTables(array $aliases): $this Sets the Table Aliases to use. These are typically collected during use of th...

  $this->db->getLastQuery()->db->setAliasedTables(array $aliases)

  /**
  * Sets the Table Aliases to use. These are typically
  * collected during use of the Builder, and set here
  * so queries are built correctly.
  *
  * @return $this
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:526

  ⇄⧉public addTableAlias(string $table): $this Add a table alias to our list.

  $this->db->getLastQuery()->db->addTableAlias(string $table)

  /**
  * Add a table alias to our list.
  *
  * @return $this
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:538

  ⇄⧉public query(string $sql, $binds = null, bool $setEscapeFlags = true, string $queryClass = ''): BaseResult|bool|Query BaseResult when “read” type query, bool when “write” type query, Query when prepared query Orchestrates a query against the database. Queries must use Database\Statemen...

  $this->db->getLastQuery()->db->query(string $sql, $binds = null, bool $setEscapeFlags = true, string $queryClass = '')

  /**
  * Orchestrates a query against the database. Queries must use
  * Database\Statement objects to store the query and build it.
  * This method works with the cache.
  *
  * Should automatically handle different connections for read/write
  * queries if needed.
  *
  * @param array|string|null $binds
  *
  * @return         BaseResult|bool|Query                       BaseResult when “read” type query, bool when “write” type query, Query when prepared query
  * @phpstan-return BaseResult<TConnection, TResult>|bool|Query
  *
  * @todo BC set $queryClass default as null in 4.1
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:570

  ⇄⧉public simpleQuery(string $sql): false|object|resource Performs a basic query against the database. No binding or caching is perform...

  $this->db->getLastQuery()->db->simpleQuery(string $sql)

  /**
  * Performs a basic query against the database. No binding or caching
  * is performed, nor are transactions handled. Simply takes a raw
  * query string and returns the database-specific result id.
  *
  * @return         false|object|resource
  * @phpstan-return false|TResult
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:687

  ⇄⧉public transOff() Disable Transactions

  $this->db->getLastQuery()->db->transOff()

  /**
  * Disable Transactions
  *
  * This permits transactions to be disabled at run-time.
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:701

  ⇄⧉public transStrict(bool $mode = true): $this Enable/disable Transaction Strict Mode

  $this->db->getLastQuery()->db->transStrict(bool $mode = true)

  /**
  * Enable/disable Transaction Strict Mode
  *
  * When strict mode is enabled, if you are running multiple groups of
  * transactions, if one group fails all subsequent groups will be
  * rolled back.
  *
  * If strict mode is disabled, each group is treated autonomously,
  * meaning a failure of one group will not affect any others
  *
  * @param bool $mode = true
  *
  * @return $this
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:720

  ⇄⧉public transStart(bool $testMode = false): bool Start Transaction

  $this->db->getLastQuery()->db->transStart(bool $testMode = false)

  /**
  * Start Transaction
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:730

  ⇄⧉public transException(bool $transExcetion): $this If set to true, exceptions are thrown during transactions.

  $this->db->getLastQuery()->db->transException(bool $transExcetion)

  /**
  * If set to true, exceptions are thrown during transactions.
  *
  * @return $this
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:744

  ⇄⧉public transComplete(): bool Complete Transaction

  $this->db->getLastQuery()->db->transComplete()

  /**
  * Complete Transaction
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:754

  ⇄⧉public transStatus(): bool Lets you retrieve the transaction flag to determine if it has failed

  $this->db->getLastQuery()->db->transStatus()

  /**
  * Lets you retrieve the transaction flag to determine if it has failed
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:780

  ⇄⧉public transBegin(bool $testMode = false): bool Begin Transaction

  $this->db->getLastQuery()->db->transBegin(bool $testMode = false)

  /**
  * Begin Transaction
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:788

  ⇄⧉public transCommit(): bool Commit Transaction

  $this->db->getLastQuery()->db->transCommit()

  /**
  * Commit Transaction
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:822

  ⇄⧉public transRollback(): bool Rollback Transaction

  $this->db->getLastQuery()->db->transRollback()

  /**
  * Rollback Transaction
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:841

  ⇄⧉public table($tableName): BaseBuilder Returns a non-shared new instance of the query builder for this connection.

  $this->db->getLastQuery()->db->table($tableName)

  /**
  * Returns a non-shared new instance of the query builder for this connection.
  *
  * @param array|string $tableName
  *
  * @return BaseBuilder
  *
  * @throws DatabaseException
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:881

  ⇄⧉public newQuery(): CodeIgniter\Database\BaseBuilder Returns a new instance of the BaseBuilder class with a cleared FROM clause.

  $this->db->getLastQuery()->db->newQuery()

  /**
  * Returns a new instance of the BaseBuilder class with a cleared FROM clause.
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:895

  ⇄⧉public prepare(Closure $func, array $options = array()): BasePreparedQuery|null Creates a prepared statement with the database that can then be used to execu...

  $this->db->getLastQuery()->db->prepare(Closure $func, array $options = array())

  /**
  * Creates a prepared statement with the database that can then
  * be used to execute multiple statements against. Within the
  * closure, you would build the query in any normal way, though
  * the Query Builder is the expected manner.
  *
  * Example:
  *    $stmt = $db->prepare(function($db)
  *           {
  *             return $db->table('users')
  *                   ->where('id', 1)
  *                     ->get();
  *           })
  *
  * @return BasePreparedQuery|null
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:921

  ⇄⧉public getLastQuery(): Query Returns the last query's statement object.

  $this->db->getLastQuery()->db->getLastQuery()

  /**
  * Returns the last query's statement object.
  *
  * @return Query
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:949

  ⇄⧉public showLastQuery(): string Returns a string representation of the last query's statement object.

  $this->db->getLastQuery()->db->showLastQuery()

  /**
  * Returns a string representation of the last query's statement object.
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:957

  ⇄⧉public getConnectStart(): ?float Returns the time we started to connect to this database in seconds with micro...

  $this->db->getLastQuery()->db->getConnectStart()

  /**
  * Returns the time we started to connect to this database in
  * seconds with microseconds.
  *
  * Used by the Debug Toolbar's timeline.
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:968

  ⇄⧉public getConnectDuration(int $decimals = 6): string Returns the number of seconds with microseconds that it took to connect to th...

  $this->db->getLastQuery()->db->getConnectDuration(int $decimals = 6)

  /**
  * Returns the number of seconds with microseconds that it took
  * to connect to the database.
  *
  * Used by the Debug Toolbar's timeline.
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:979

  ⇄⧉public protectIdentifiers($item, bool $prefixSingle = false, ?bool $protectIdentifiers = null, bool $fieldExists = true): array|string Protect Identifiers

  $this->db->getLastQuery()->db->protectIdentifiers($item, bool $prefixSingle = false, ?bool $protectIdentifiers = null, bool $fieldExists = true)

  /**
  * Protect Identifiers
  *
  * This function is used extensively by the Query Builder class, and by
  * a couple functions in this class.
  * It takes a column or table name (optionally with an alias) and inserts
  * the table prefix onto it. Some logic is necessary in order to deal with
  * column names that include the path. Consider a query like this:
  *
  * SELECT hostname.database.table.column AS c FROM hostname.database.table
  *
  * Or a query with aliasing:
  *
  * SELECT m.member_id, m.member_name FROM members AS m
  *
  * Since the column name can include up to four segments (host, DB, table, column)
  * or also have an alias prefix, we need to do a bit of work to figure this out and
  * insert the table prefix (if it exists) in the proper position, and escape only
  * the correct identifiers.
  *
  * @param array|string $item
  * @param bool         $prefixSingle       Prefix a table name with no segments?
  * @param bool         $protectIdentifiers Protect table or column names?
  * @param bool         $fieldExists        Supplied $item contains a column name?
  *
  * @return         array|string
  * @phpstan-return ($item is array ? array : string)
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1012

  ⇄⧉public escapeIdentifiers($item): array|string Escape the SQL Identifiers

  $this->db->getLastQuery()->db->escapeIdentifiers($item)

  /**
  * Escape the SQL Identifiers
  *
  * This function escapes column and table names
  *
  * @param array|string $item
  *
  * @return         array|string
  * @phpstan-return ($item is array ? array : string)
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1172

  ⇄⧉public prefixTable(string $table = ''): string Prepends a database prefix if one exists in configuration

  $this->db->getLastQuery()->db->prefixTable(string $table = '')

  /**
  * Prepends a database prefix if one exists in configuration
  *
  * @throws DatabaseException
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1232

  ⇄⧉public escape($str): array|float|int|string "Smart" Escape String

  $this->db->getLastQuery()->db->escape($str)

  /**
  * "Smart" Escape String
  *
  * Escapes data based on type.
  * Sets boolean and null types
  *
  * @param array|bool|float|int|object|string|null $str
  *
  * @return         array|float|int|string
  * @phpstan-return ($str is array ? array : float|int|string)
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1257

  ⇄⧉public escapeString($str, bool $like = false): string|string[] Escape String

  $this->db->getLastQuery()->db->escapeString($str, bool $like = false)

  /**
  * Escape String
  *
  * @param string|string[] $str  Input string
  * @param bool            $like Whether or not the string will be used in a LIKE condition
  *
  * @return string|string[]
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1287

  ⇄⧉public escapeLikeString($str): string|string[] Escape LIKE String

  $this->db->getLastQuery()->db->escapeLikeString($str)

  /**
  * Escape LIKE String
  *
  * Calls the individual driver for platform
  * specific escaping for LIKE conditions
  *
  * @param string|string[] $str
  *
  * @return string|string[]
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1329

  ⇄⧉public callFunction(string $functionName, $params): bool This function enables you to call PHP database functions that are not nativel...

  $this->db->getLastQuery()->db->callFunction(string $functionName, $params)

  /**
  * This function enables you to call PHP database functions that are not natively included
  * in CodeIgniter, in a platform independent manner.
  *
  * @param array ...$params
  *
  * @throws DatabaseException
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1352

  ⇄⧉public listTables(bool $constrainByPrefix = false): array|false Returns an array of table names

  $this->db->getLastQuery()->db->listTables(bool $constrainByPrefix = false)

  /**
  * Returns an array of table names
  *
  * @return array|false
  *
  * @throws DatabaseException
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1390

  ⇄⧉public tableExists(string $tableName, bool $cached = true): bool Determine if a particular table exists

  $this->db->getLastQuery()->db->tableExists(string $tableName, bool $cached = true)

  /**
  * Determine if a particular table exists
  *
  * @param bool $cached Whether to use data cache
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1426

  ⇄⧉public getFieldNames(string $table): array|false Fetch Field Names

  $this->db->getLastQuery()->db->getFieldNames(string $table)

  /**
  * Fetch Field Names
  *
  * @return array|false
  *
  * @throws DatabaseException
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1467

  ⇄⧉public fieldExists(string $fieldName, string $tableName): bool Determine if a particular field exists

  $this->db->getLastQuery()->db->fieldExists(string $fieldName, string $tableName)

  /**
  * Determine if a particular field exists
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1512

  ⇄⧉public getFieldData(string $table): stdClass[] Returns an object with field data

  $this->db->getLastQuery()->db->getFieldData(string $table)

  /**
  * Returns an object with field data
  *
  * @return stdClass[]
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1522

  ⇄⧉public getIndexData(string $table): array Returns an object with key data

  $this->db->getLastQuery()->db->getIndexData(string $table)

  /**
  * Returns an object with key data
  *
  * @return array
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1532

  ⇄⧉public getForeignKeyData(string $table): array Returns an object with foreign key data

  $this->db->getLastQuery()->db->getForeignKeyData(string $table)

  /**
  * Returns an object with foreign key data
  *
  * @return array
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1542

  ⇄⧉public disableForeignKeyChecks(): bool Disables foreign key checks temporarily.

  $this->db->getLastQuery()->db->disableForeignKeyChecks()

  /**
  * Disables foreign key checks temporarily.
  *
  * @return bool
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1597

  ⇄⧉public enableForeignKeyChecks(): bool Enables foreign key checks temporarily.

  $this->db->getLastQuery()->db->enableForeignKeyChecks()

  /**
  * Enables foreign key checks temporarily.
  *
  * @return bool
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1614

  ⇄⧉public pretend(bool $pretend = true): $this Allows the engine to be set into a mode where queries are not actually execut...

  $this->db->getLastQuery()->db->pretend(bool $pretend = true)

  /**
  * Allows the engine to be set into a mode where queries are not
  * actually executed, but they are still generated, timed, etc.
  *
  * This is primarily used by the prepared query functionality.
  *
  * @return $this
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1634

  ⇄⧉public resetDataCache(): $this Empties our data cache. Especially helpful during testing.

  $this->db->getLastQuery()->db->resetDataCache()

  /**
  * Empties our data cache. Especially helpful during testing.
  *
  * @return $this
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1646

  ⇄⧉public isWriteType($sql): bool Determines if the statement is a write-type query or not.

  $this->db->getLastQuery()->db->isWriteType($sql)

  /**
  * Determines if the statement is a write-type query or not.
  *
  * @param string $sql
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1658

  ⧉public __get(string $key): array|bool|float|int|object|resource|string|null Accessor for properties if they exist.

  /**
  * Accessor for properties if they exist.
  *
  * @return array|bool|float|int|object|resource|string|null
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1754

  ⧉public __isset(string $key): bool Checker for properties existence.

  /**
  * Checker for properties existence.
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1766

  ⧉protected _close() Close the database connection.

  /**
  * Close the database connection.
  */
  
  Defined in .../Database/MySQLi/Connection.php:248

  ⧉protected execute(string $sql): false|mysqli_result; Executes the query against the database.

  /**
  * Executes the query against the database.
  *
  * @return false|mysqli_result;
  */
  
  Defined in .../Database/MySQLi/Connection.php:296

  ⧉protected prepQuery(string $sql): string Prep the query. If needed, each database adapter can prep the query string

  /**
  * Prep the query. If needed, each database adapter can prep the query string
  */
  
  Defined in .../Database/MySQLi/Connection.php:321

  ⧉protected _escapeString(string $str): string Platform-dependant string escape

  /**
  * Platform-dependant string escape
  */
  
  Defined in .../Database/MySQLi/Connection.php:343

  ⧉protected _listTables(bool $prefixLimit = false, ?string $tableName = null): string Generates the SQL for listing tables in a platform-dependent manner. Uses esc...

  /**
  * Generates the SQL for listing tables in a platform-dependent manner.
  * Uses escapeLikeStringDirect().
  *
  * @param string|null $tableName If $tableName is provided will return only this table if exists.
  */
  
  Defined in .../Database/MySQLi/Connection.php:388

  ⧉protected _listColumns(string $table = ''): string Generates a platform-specific query string so that the column names can be fe...

  /**
  * Generates a platform-specific query string so that the column names can be fetched.
  */
  
  Defined in .../Database/MySQLi/Connection.php:406

  ⧉protected _fieldData(string $table): array Returns an array of objects with field data

  /**
  * Returns an array of objects with field data
  *
  * @return stdClass[]
  *
  * @throws DatabaseException
  */
  
  Defined in .../Database/MySQLi/Connection.php:418

  ⧉protected _indexData(string $table): array Returns an array of objects with index data

  /**
  * Returns an array of objects with index data
  *
  * @return stdClass[]
  *
  * @throws DatabaseException
  * @throws LogicException
  */
  
  Defined in .../Database/MySQLi/Connection.php:451

  ⧉protected _foreignKeyData(string $table): array Returns an array of objects with Foreign key data

  /**
  * Returns an array of objects with Foreign key data
  *
  * @return stdClass[]
  *
  * @throws DatabaseException
  */
  
  Defined in .../Database/MySQLi/Connection.php:496

  ⧉protected _disableForeignKeyChecks(): string Returns platform-specific SQL to disable foreign key checks.

  /**
  * Returns platform-specific SQL to disable foreign key checks.
  *
  * @return string
  */
  
  Defined in .../Database/MySQLi/Connection.php:546

  ⧉protected _enableForeignKeyChecks(): string Returns platform-specific SQL to enable foreign key checks.

  /**
  * Returns platform-specific SQL to enable foreign key checks.
  *
  * @return string
  */
  
  Defined in .../Database/MySQLi/Connection.php:556

  ⧉protected _transBegin(): bool Begin Transaction

  /**
  * Begin Transaction
  */
  
  Defined in .../Database/MySQLi/Connection.php:594

  ⧉protected _transCommit(): bool Commit Transaction

  /**
  * Commit Transaction
  */
  
  Defined in .../Database/MySQLi/Connection.php:604

  ⧉protected _transRollback(): bool Rollback Transaction

  /**
  * Rollback Transaction
  */
  
  Defined in .../Database/MySQLi/Connection.php:618

  ⧉protected getDriverFunctionPrefix(): string Get the prefix of the function to access the DB.

  /**
  * Get the prefix of the function to access the DB.
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1374

  ⧉protected foreignKeyDataToObjects(array $data): array[ Converts array of arrays generated by _foreignKeyData() to array of objects

  /**
  * Converts array of arrays generated by _foreignKeyData() to array of objects
  *
  * @return array[
  *    {constraint_name} =>
  *        stdClass[
  *            'constraint_name'     => string,
  *            'table_name'          => string,
  *            'column_name'         => string[],
  *            'foreign_table_name'  => string,
  *            'foreign_column_name' => string[],
  *            'on_delete'           => string,
  *            'on_update'           => string,
  *            'match'               => string
  *        ]
  * ]
  */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in .../Database/BaseConnection.php:1564

⧉mac_address => array (2)

0 => string (9) "webadqr02"

1 => boolean true

SELECT *
FROM `vw_qr_devices`
WHERE `mac_address` = 'webadqr02'

SELECT *
FROM `vw_qr_devices`
WHERE `mac_address` = :mac_address: