blog_id
title
tag
slug
description
more_sections
discription_mage
bodyimage
category
country
altone
alttwo
created_at
updated_at
deleted_at
datetime
0
35
what color to avoid on Tanzania safari 
Miscelanious
what-color-to-avoid-on-tanzania-safari
<p>  When going on a Tanzania safari, it is generally recommended to avoid UTF-8
null
1680272931_18fb5eb5ec8a215fca19.webp
1680272931_498654658e49b89a29c3.webp
null
null
what not to wear on tanzania safari 
what to wear on tanzania safari 
2023-03-31 10:28:51
2023-03-31 10:28:51
2023-03-31 10:28:51
2023-03-31 10:28:51
1
57
Do you Know Stone Town 
History
do-you-know-stone-town
<p>  Stone Town is the historic center of Zanzibar City, which is the capitUTF-8
null
1680524972_c256b91ae0a266a430f5.webp
1680524972_5953e89f4b1f7ae95514.webp
null
null
Stone town 
Stone town 
2023-04-03 08:29:33
2023-04-03 08:29:33
2023-04-03 08:29:33
2023-04-03 08:29:33
2
69
How much  is a walking safari in Tanzania 
WildLife
how-much-is-a-walking-safari-in-tanzania
<p>  The cost of a walking safari in Tanzania can vary depending on severalUTF-8
null
1680600684_8bdece57fc229f7b2022.webp
1680600684_0768095e92b94fe457c9.webp
null
null
Walking safari in Tanzania 
Walking safari in Tanzania 
2023-04-04 05:31:25
2023-04-04 05:31:25
2023-04-04 05:31:25
2023-04-04 05:31:25
3
34
Can you wear short on safari 
Miscelanious
can-you-wear-short-on-safari
<p>  While you can wear shorts on safari in Tanzania, it is not the most reUTF-8
null
1680272537_f571c111be998bf1f3f6.webp
1680272536_a850909092265dcb3706.webp
null
null
Can you wear short on safari 
Can you wear short on safari 
2023-03-31 10:22:17
2023-03-31 10:22:17
2023-03-31 10:22:17
2023-03-31 10:22:17
4
16
Are Zanzibar beaches Wonderful for Vacation 
Miscelanious
are-zanzibar-beaches-wonderful-for-vacation
<p>  Yes, Zanzibar is a wonderful place to enjoy a vacation, especially if UTF-8
null
1680250512_3011de9f0cf39a01a9a2.webp
1680250512_99d08ccd0e1826fde761.webp
null
null
Zanzibar beach
Nungwi beach
2023-03-31 04:15:12
2023-03-31 04:15:12
2023-03-31 04:15:12
2023-03-31 04:15:12
5
33
Tipping Guide in Tanzania safari 
Miscelanious
tipping-guide-in-tanzania-safari
<p>  Tipping is a common practice in Tanzania, including on safari tours. WUTF-8
null
1680272156_9d56ee92c41c1dcc1efc.webp
1680272156_7521838804c04aef1778.webp
null
null
Tipping guide in Tanzania 
Tipping guide in Tanzani a
2023-03-31 10:15:56
2023-03-31 10:15:56
2023-03-31 10:15:56
2023-03-31 10:15:56
6
25
What is the best time of year to see wildlife in Tanzania 
Miscelanious
what-is-the-best-time-of-year-to-see-wildlife-in-tanzania
<p>  The best time to see wildlife in Tanzania depends on several factors, UTF-8
null
1680258118_f10e52cb761442be30d5.webp
1680258117_f2bdefb0c4c92c2a661c.webp
null
null
The best time to wildlife in Tanzania 
The best time to see wildlife in Tanzania 
2023-03-31 06:21:58
2023-03-31 06:21:58
2023-03-31 06:21:58
2023-03-31 06:21:58
7
85
Things to do in Arusha
About us
things-to-do-in-arusha
<p>  Arusha is a vibrant city in northern Tanzania that serves as the gatewUTF-8
null
1680683991_e9ecdf77ad2cf225e5bf.webp
1680683991_6ceaac9e551c1e1a0b09.webp
null
null
Things to do in Arusha 
Things to do In Arusha 
2023-04-05 04:39:52
2023-04-05 04:39:52
2023-04-05 04:39:52
2023-04-05 04:39:52
8
43
Where is Current wildebeest Migration 
WildLife
where-is-current-wildebeest-migration
<p>the wildebeest migration is taking place in the Serengeti ecosystem in TUTF-8
null
1680334823_3e397386711c02a1649b.webp
1680334822_8fc0474dfdd487dd175f.webp
null
null
Wildebeest migration River crossing 
Wildebeest migration River crossing 
2023-04-01 03:40:23
2023-04-01 03:40:23
2023-04-01 03:40:23
2023-04-01 03:40:23
9
61
Do you know selous game reserve is biggest one  in africa 
History
do-you-know-selous-game-reserve-is-biggest-one-in-africa
<p>  Yes, Selous Game Reserve is indeed the largest game reserve in Africa,UTF-8
null
1680525984_fa0ae22c54940358370f.webp
1680525984_d0971ebe9e13551cd70b.webp
null
null
selous game reserve
selous game reserve
2023-04-03 08:46:25
2023-04-03 08:46:25
2023-04-03 08:46:25
2023-04-03 08:46:25
10
58
Is mikumi worth visiting 
WildLife
is-mikumi-worth-visiting
<p>  Mikumi National Park is one of the most popular national parks in TanzUTF-8
null
1680525239_7bac648003583f0c7dc3.webp
1680525239_01ac6dbc7d7489cee9a9.webp
null
null
Mikumi National park 
Mikumi national park 
2023-04-03 08:33:59
2023-04-03 08:33:59
2023-04-03 08:33:59
2023-04-03 08:33:59
11
70
Where is the best place for walking safari 
Safaris
where-is-the-best-place-for-walking-safari
<p>  Tanzania is a popular destination for walking safaris and there are seUTF-8
null
1680601110_b53fd1ec24633ea80211.webp
1680601109_2f60fcdad58196383dc1.webp
null
null
Walking safari Tanzania
Walking safari  in Tanzania 
2023-04-04 05:38:30
2023-04-04 05:38:30
2023-04-04 05:38:30
2023-04-04 05:38:30

public pager -> null

$value->pager

protected db -> CodeIgniter\Database\MySQLi\Connection#94 (45)

• Properties (45)
• Methods (78)

• protected DSN -> string (0) ""

  protected port -> integer 3306

  protected hostname -> string (9) "localhost"

  protected username -> string (21) "dancingsimbas_safaris"

  protected password -> string (12) "$uV[9XmL0bKK"

  protected database -> string (21) "dancingsimbas_safaris"

  public DBDriver -> string (6) "MySQLi"

  protected subdriver -> null

  protected DBPrefix -> string (14) "dancing_simba_"

  protected pConnect -> boolean false

  protected DBDebug -> boolean true

  protected charset -> string (7) "utf8mb4"

  protected DBCollat -> string (18) "utf8mb4_general_ci"

  protected swapPre -> string (0) ""

  protected encrypt -> boolean false

  protected compress -> boolean false

  protected strictOn -> boolean false

  protected failover -> array (0)

  protected lastQuery -> CodeIgniter\Database\Query#206 (10)

  • Properties (10)
  • Methods (19)
  • toString

  • protected originalQueryString -> string (55) "SELECT * FROM `dancing_simba_destinationtable` LIMIT 6"

    SELECT *
    FROM `dancing_simba_destinationtable`
     LIMIT 6
    

    protected swappedQueryString -> uninitialized

    protected finalQueryString -> string (55) "SELECT * FROM `dancing_simba_destinationtable` LIMIT 6"

    SELECT *
    FROM `dancing_simba_destinationtable`
     LIMIT 6
    

    protected binds -> array (0)

    protected bindMarker -> string (1) "?"

    protected startTime -> double 1747723365.2451

    protected endTime -> double 1747723365.2459

    protected errorCode -> null

    protected errorString -> null

    public db -> CodeIgniter\Database\MySQLi\Connection#94 Recursion

  • public __construct(CodeIgniter\Database\ConnectionInterface $db)

    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:98

    public setQuery(string $sql, $binds = null, bool $setEscape = true): $this Sets the raw query string to use for this statement.

    /**
     * Sets the raw query string to use for this statement.
     *
     * @param mixed $binds
     *
     * @return $this
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:110

    public setBinds(array $binds, bool $setEscape = true): $this Will store the variables to bind into the query later.

    /**
     * Will store the variables to bind into the query later.
     *
     * @return $this
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:141

    public getQuery(): string Returns the final, processed query string after binding, etal has been perfor...

    /**
     * Returns the final, processed query string after binding, etal
     * has been performed.
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:160

    public setDuration(float $start, ?float $end = null): $this Records the execution time of the statement using microtime(true) for it's st...

    /**
     * Records the execution time of the statement using microtime(true)
     * for it's start and end values. If no end value is present, will
     * use the current time to determine total duration.
     *
     * @return $this
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:176

    public getStartTime(bool $returnRaw = false, int $decimals = 6): float|string Returns the start time in seconds with microseconds.

    /**
     * Returns the start time in seconds with microseconds.
     *
     * @return float|string
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:194

    public getDuration(int $decimals = 6): string Returns the duration of this query during execution, or null if the query has...

    /**
     * Returns the duration of this query during execution, or null if
     * the query has not been executed yet.
     *
     * @param int $decimals The accuracy of the returned time.
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:209

    public setError(int $code, string $error): $this Stores the error description that happened for this query.

    /**
     * Stores the error description that happened for this query.
     *
     * @return $this
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:219

    public hasError(): bool Reports whether this statement created an error not.

    /**
     * Reports whether this statement created an error not.
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:230

    public getErrorCode(): int Returns the error code created while executing this statement.

    /**
     * Returns the error code created while executing this statement.
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:238

    public getErrorMessage(): string Returns the error message created while executing this statement.

    /**
     * Returns the error message created while executing this statement.
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:246

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

    /**
     * Determines if the statement is a write-type query or not.
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:254

    public swapPrefix(string $orig, string $swap): $this Swaps out one table prefix for a new one.

    /**
     * Swaps out one table prefix for a new one.
     *
     * @return $this
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:264

    public getOriginalQuery(): string Returns the original SQL that was passed into the system.

    /**
     * Returns the original SQL that was passed into the system.
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:281

    protected compileBinds() Escapes and inserts any binds into the finalQueryString property.

    /**
     * Escapes and inserts any binds into the finalQueryString property.
     *
     * @see https://regex101.com/r/EUEhay/5
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:291

    protected matchNamedBinds(string $sql, array $binds): string Match bindings

    /**
     * Match bindings
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:319

    protected matchSimpleBinds(string $sql, array $binds, int $bindCount, int $ml): string Match bindings

    /**
     * Match bindings
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:343

    public debugToolbarDisplay(): string Returns string to display in debug toolbar

    /**
     * Returns string to display in debug toolbar
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:373

    public __toString(): string Return text representation of the query

    /**
     * Return text representation of the query
     */
    
    Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/Query.php:427

  • lastQuery string (55) "SELECT * FROM `dancing_simba_destinationtable` LIMIT 6"

    SELECT *
    FROM `dancing_simba_destinationtable`
     LIMIT 6
    

  public connID -> mysqli#103 (18)

  • Properties (18)
  • Methods (43)
  • Static methods (1)

  • public readonly affected_rows -> integer 6

    public readonly client_info -> string (14) "mysqlnd 8.2.28"

    public readonly client_version -> integer 80228

    public readonly connect_errno -> integer 0

    public readonly connect_error -> null

    public readonly errno -> integer 0

    public readonly error -> string (0) ""

    public readonly error_list -> array (0)

    public readonly field_count -> integer 15

    public readonly host_info -> string (25) "Localhost via UNIX socket"

    public readonly info -> null

    public readonly insert_id -> integer 0

    public readonly server_info -> string (15) "10.6.22-MariaDB"

    public readonly server_version -> integer 100622

    public readonly sqlstate -> string (5) "00000"

    public readonly protocol_version -> integer 10

    public readonly thread_id -> integer 93902

    public readonly warning_count -> integer 0

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

    public autocommit(bool $enable)

    public begin_transaction(int $flags = 0, ?string $name = null)

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

    public character_set_name()

    public close()

    public commit(int $flags = 0, ?string $name = null)

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

    public dump_debug_info()

    public debug(string $options)

    public get_charset()

    public execute_query(string $query, ?array $params = null): mysqli_result|bool

    public get_client_info()

    public get_connection_stats()

    public get_server_info()

    public get_warnings()

    public init()

    public kill(int $process_id)

    public multi_query(string $query)

    public more_results()

    public next_result()

    public ping()

    public prepare(string $query)

    public query(string $query, int $result_mode = 0)

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

    public real_escape_string(string $string)

    public reap_async_query()

    public escape_string(string $string)

    public real_query(string $query)

    public release_savepoint(string $name)

    public rollback(int $flags = 0, ?string $name = null)

    public savepoint(string $name)

    public select_db(string $database)

    public set_charset(string $charset)

    public options(int $option, $value)

    public set_opt(int $option, $value)

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

    public stat()

    public stmt_init()

    public store_result(int $mode = 0)

    public thread_safe()

    public use_result()

    public refresh(int $flags)

  • public static mysqli::poll(?array &$read, ?array &$error, array &$reject, int $seconds, int $microseconds = 0)

  public resultID -> mysqli_result#202 (5)

  • Properties (5)
  • Methods (16)
  • Iterator

  • public current_field -> uninitialized

    public field_count -> uninitialized

    public lengths -> uninitialized

    public num_rows -> uninitialized

    public type -> uninitialized

  • public __construct(mysqli $mysql, int $result_mode = 0)

    public close()

    public free()

    public data_seek(int $offset)

    public fetch_field()

    public fetch_fields()

    public fetch_field_direct(int $index)

    public fetch_all(int $mode = 2)

    public fetch_array(int $mode = 3)

    public fetch_assoc()

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

    public fetch_row()

    public fetch_column(int $column = 0): string|int|float|false|null

    public field_seek(int $index)

    public free_result()

    public getIterator(): Iterator

  • mysqli_result Iterator Contents uninitialized Blacklisted

  public protectIdentifiers -> boolean true

  protected reservedIdentifiers -> array (1)

  0 => string (1) "*"

  public escapeChar -> string (1) "`"

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

  public likeEscapeChar -> string (1) "!"

  protected pregEscapeChar -> array (4)

  1 => string (1) "`"

  0 => string (1) "`"

  3 => string (1) "`"

  2 => string (1) "`"

  public dataCache -> array (0)

  protected connectTime -> double 1747723365.1938

  protected connectDuration -> double 0.0013790130615234

  protected pretend -> boolean false

  public transEnabled -> boolean true

  public transStrict -> boolean true

  protected transDepth -> integer 0

  protected transStatus -> boolean true

  protected transFailure -> boolean false

  protected transException -> boolean false

  protected aliasedTables -> array (0)

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

  protected dateFormat -> array (5)

  date => string (5) "Y-m-d"

  datetime => string (11) "Y-m-d H:i:s"

  datetime-ms => string (13) "Y-m-d H:i:s.v"

  datetime-us => string (13) "Y-m-d H:i:s.u"

  time => string (5) "H:i:s"

  public deleteHack -> boolean true

  public mysqli -> mysqli#103 (18)

  • Properties (18)
  • Methods (43)
  • Static methods (1)

  • public readonly affected_rows -> integer 6

    public readonly client_info -> string (14) "mysqlnd 8.2.28"

    public readonly client_version -> integer 80228

    public readonly connect_errno -> integer 0

    public readonly connect_error -> null

    public readonly errno -> integer 0

    public readonly error -> string (0) ""

    public readonly error_list -> array (0)

    public readonly field_count -> integer 15

    public readonly host_info -> string (25) "Localhost via UNIX socket"

    public readonly info -> null

    public readonly insert_id -> integer 0

    public readonly server_info -> string (15) "10.6.22-MariaDB"

    public readonly server_version -> integer 100622

    public readonly sqlstate -> string (5) "00000"

    public readonly protocol_version -> integer 10

    public readonly thread_id -> integer 93902

    public readonly warning_count -> integer 0

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

    public autocommit(bool $enable)

    public begin_transaction(int $flags = 0, ?string $name = null)

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

    public character_set_name()

    public close()

    public commit(int $flags = 0, ?string $name = null)

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

    public dump_debug_info()

    public debug(string $options)

    public get_charset()

    public execute_query(string $query, ?array $params = null): mysqli_result|bool

    public get_client_info()

    public get_connection_stats()

    public get_server_info()

    public get_warnings()

    public init()

    public kill(int $process_id)

    public multi_query(string $query)

    public more_results()

    public next_result()

    public ping()

    public prepare(string $query)

    public query(string $query, int $result_mode = 0)

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

    public real_escape_string(string $string)

    public reap_async_query()

    public escape_string(string $string)

    public real_query(string $query)

    public release_savepoint(string $name)

    public rollback(int $flags = 0, ?string $name = null)

    public savepoint(string $name)

    public select_db(string $database)

    public set_charset(string $charset)

    public options(int $option, $value)

    public set_opt(int $option, $value)

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

    public stat()

    public stmt_init()

    public store_result(int $mode = 0)

    public thread_safe()

    public use_result()

    public refresh(int $flags)

  • public static mysqli::poll(?array &$read, ?array &$error, array &$reject, int $seconds, int $microseconds = 0)

  public resultMode -> integer 0

  public numberNative -> boolean false

  public foundRows -> boolean false

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

  /**
   * Connect to the database.
   *
   * @return false|mysqli
   *
   * @throws DatabaseException
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:102

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

  /**
   * Keep or establish the connection if no queries have been sent for
   * a length of time exceeding the server's idle timeout.
   *
   * @return void
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:258

  protected _close(): void Close the database connection.

  /**
   * Close the database connection.
   *
   * @return void
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:269

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

  /**
   * Select a specific database table to use.
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:277

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

  /**
   * Returns a string containing the version of the database being used.
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:299

  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 <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:317

  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 <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:342

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

  /**
   * Returns the total number of rows affected by this query.
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:356

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

  /**
   * Platform-dependant string escape
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:364

  public escapeLikeStringDirect($str): list<string>|string Escape Like String Direct There are a few instances where MySQLi queries cann...

  /**
   * 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 list<string>|string $str Input string
   *
   * @return list<string>|string
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:383

  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 <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:409

  protected _listColumns($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.
   *
   * @param string|TableName $table
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:429

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

  /**
   * Returns an array of objects with field data
   *
   * @return list<stdClass>
   *
   * @throws DatabaseException
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:448

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

  /**
   * Returns an array of objects with index data
   *
   * @return array<string, stdClass>
   *
   * @throws DatabaseException
   * @throws LogicException
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:481

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

  /**
   * Returns an array of objects with Foreign key data
   *
   * @return array<string, stdClass>
   *
   * @throws DatabaseException
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:528

  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 <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:578

  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 <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:588

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

  /**
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:600

  public insertID(): int Insert ID

  /**
   * Insert ID
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:618

  protected _transBegin(): bool Begin Transaction

  /**
   * Begin Transaction
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:626

  protected _transCommit(): bool Commit Transaction

  /**
   * Commit Transaction
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:636

  protected _transRollback(): bool Rollback Transaction

  /**
   * Rollback Transaction
   */
  
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:650

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

  /**
   * Saves our connection settings.
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:370

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

  /**
   * Initializes the database connection/settings.
   *
   * @return void
   *
   * @throws DatabaseException
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:404

  public close(): void Close the database connection.

  /**
   * Close the database connection.
   *
   * @return void
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:483

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

  /**
   * Create a persistent database connection.
   *
   * @return         false|object|resource
   * @phpstan-return false|TConnection
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:504

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

  /**
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:518

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

  /**
   * Returns the name of the current database being used.
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:527

  public setPrefix(string $prefix = ''): string Set DB 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:539

  public getPrefix(): string Returns the database prefix.

  /**
   * Returns the database prefix.
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:547

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

  /**
   * The name of the platform in use (MySQLi, Postgre, SQLite3, OCI8, etc)
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:555

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

  /**
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:567

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

  /**
   * Add a table alias to our list.
   *
   * @return $this
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:579

  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...

  /**
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:615

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

  /**
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:732

  public transOff(): void Disable Transactions

  /**
   * Disable Transactions
   *
   * This permits transactions to be disabled at run-time.
   *
   * @return void
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:748

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

  /**
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:767

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

  /**
   * Start Transaction
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:777

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

  /**
   * If set to true, exceptions are thrown during transactions.
   *
   * @return $this
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:791

  public transComplete(): bool Complete Transaction

  /**
   * Complete Transaction
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:801

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

  /**
   * Lets you retrieve the transaction flag to determine if it has failed
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:827

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

  /**
   * Begin Transaction
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:835

  public transCommit(): bool Commit Transaction

  /**
   * Commit Transaction
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:869

  public transRollback(): bool Rollback Transaction

  /**
   * Rollback Transaction
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:888

  public resetTransStatus(): static Reset transaction status - to restart transactions after strict mode failure

  /**
   * Reset transaction status - to restart transactions after strict mode failure
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:907

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

  /**
   * Returns a non-shared new instance of the query builder for this connection.
   *
   * @param array|string|TableName $tableName
   *
   * @return BaseBuilder
   *
   * @throws DatabaseException
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:938

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

  /**
   * Returns a new instance of the BaseBuilder class with a cleared FROM clause.
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:952

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

  /**
   * 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();
   *           })
   *
   * @param Closure(BaseConnection): mixed $func
   *
   * @return BasePreparedQuery|null
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:980

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

  /**
   * Returns the last query's statement object.
   *
   * @return Query
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1008

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

  /**
   * Returns a string representation of the last query's statement object.
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1016

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

  /**
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1027

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

  /**
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1038

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

  /**
   * 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|int|string|TableName $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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1071

  public escapeIdentifier($item): string Escape the SQL Identifier

  /**
   * Escape the SQL Identifier
   *
   * This function escapes single identifier.
   *
   * @param non-empty-string|TableName $item
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1236

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

  /**
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1276

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

  /**
   * Prepends a database prefix if one exists in configuration
   *
   * @throws DatabaseException
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1336

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

  /**
   * "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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1361

  public escapeString($str, bool $like = false): list<string>|string Escape String

  /**
   * Escape String
   *
   * @param list<string|Stringable>|string|Stringable $str  Input string
   * @param bool                                      $like Whether the string will be used in a LIKE condition
   *
   * @return list<string>|string
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1394

  public escapeLikeString($str): list<string>|string Escape LIKE String

  /**
   * Escape LIKE String
   *
   * Calls the individual driver for platform
   * specific escaping for LIKE conditions
   *
   * @param list<string|Stringable>|string|Stringable $str
   *
   * @return list<string>|string
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1444

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

  /**
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1467

  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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1489

  public listTables(bool $constrainByPrefix = false): false|list<string> Returns an array of table names

  /**
   * Returns an array of table names
   *
   * @return false|list<string>
   *
   * @throws DatabaseException
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1505

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

  /**
   * Determine if a particular table exists
   *
   * @param bool $cached Whether to use data cache
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1542

  public getFieldNames($tableName): false|list<string> Fetch Field Names

  /**
   * Fetch Field Names
   *
   * @param string|TableName $tableName
   *
   * @return false|list<string>
   *
   * @throws DatabaseException
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1585

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

  /**
   * Determine if a particular field exists
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1632

  public getFieldData(string $table): list<stdClass> Returns an object with field data

  /**
   * Returns an object with field data
   *
   * @return list<stdClass>
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1642

  public getIndexData(string $table): array<string, stdClass> Returns an object with key data

  /**
   * Returns an object with key data
   *
   * @return array<string, stdClass>
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1652

  public getForeignKeyData(string $table): array<string, stdClass> Returns an object with foreign key data

  /**
   * Returns an object with foreign key data
   *
   * @return array<string, stdClass>
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1662

  protected foreignKeyDataToObjects(array $data): array<string, stdClass> Converts array of arrays generated by _foreignKeyData() to array of objects

  /**
   * Converts array of arrays generated by _foreignKeyData() to array of objects
   *
   * @return array<string, stdClass>
   *
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1686

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

  /**
   * Disables foreign key checks temporarily.
   *
   * @return bool
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1719

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

  /**
   * Enables foreign key checks temporarily.
   *
   * @return bool
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1736

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

  /**
   * 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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1756

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

  /**
   * Empties our data cache. Especially helpful during testing.
   *
   * @return $this
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1768

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

  /**
   * Determines if the statement is a write-type query or not.
   *
   * @param string $sql
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1780

  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 <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1884

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

  /**
   * Checker for properties existence.
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1896

  private CodeIgniter\Database\BaseConnection::protectDotItem(string $item, string $alias, bool $protectIdentifiers, bool $fieldExists): string

  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1160

  private CodeIgniter\Database\BaseConnection::escapeTableName(CodeIgniter\Database\TableName $tableName): string Returns escaped table name with alias.

  /**
   * Returns escaped table name with alias.
   */
  
  Inherited from CodeIgniter\Database\BaseConnection
  Defined in <ROOT>/vendor/codeigniter4/framework/system/Database/BaseConnection.php:1258