Phycocyanine
La Solution Naturelle et Puissante à l’Oxydation Cellulaire
Voici une présentation de la séduisante substance bleue.
SELECT * FROM `content_owner` WHERE `owner_name` = :owner_name: AND `owner_id` = :owner_id: LIMIT 1
SELECT * FROM `content_owner` WHERE `owner_name` = 'Information' AND `owner_id` = 18 LIMIT 1
| 0 | 1 | |
|---|---|---|
| owner_name | Information | true |
| owner_id | 18 | true |
Defined in .../system/Database/Query.php:98
/** * Sets the raw query string to use for this statement. * * @param mixed $binds * * @return $this */ Defined in .../system/Database/Query.php:110
/** * Will store the variables to bind into the query later. * * @return $this */ Defined in .../system/Database/Query.php:141
/** * Returns the final, processed query string after binding, etal * has been performed. */ Defined in .../system/Database/Query.php:160
/** * 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 .../system/Database/Query.php:176
/** * Returns the start time in seconds with microseconds. * * @return float|string */ Defined in .../system/Database/Query.php:194
/** * 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 .../system/Database/Query.php:209
/** * Stores the error description that happened for this query. * * @return $this */ Defined in .../system/Database/Query.php:219
/** * Reports whether this statement created an error not. */ Defined in .../system/Database/Query.php:230
/** * Returns the error code created while executing this statement. */ Defined in .../system/Database/Query.php:238
/** * Returns the error message created while executing this statement. */ Defined in .../system/Database/Query.php:246
/** * Determines if the statement is a write-type query or not. */ Defined in .../system/Database/Query.php:254
/** * Swaps out one table prefix for a new one. * * @return $this */ Defined in .../system/Database/Query.php:264
/** * Returns the original SQL that was passed into the system. */ Defined in .../system/Database/Query.php:281
/** * Escapes and inserts any binds into the finalQueryString property. * * @see https://regex101.com/r/EUEhay/5 */ Defined in .../system/Database/Query.php:291
/** * Match bindings */ Defined in .../system/Database/Query.php:319
/** * Match bindings */ Defined in .../system/Database/Query.php:343
/** * Returns string to display in debug toolbar */ Defined in .../system/Database/Query.php:373
/** * Return text representation of the query */ Defined in .../system/Database/Query.php:427
SELECT * FROM `content_owner` WHERE `owner_name` = 'Information' AND `owner_id` = 18 LIMIT 1
/** * Connect to the database. * * @return false|mysqli * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:102
/** * 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 .../system/Database/MySQLi/Connection.php:258
/** * Close the database connection. * * @return void */ Defined in .../system/Database/MySQLi/Connection.php:269
/** * Select a specific database table to use. */ Defined in .../system/Database/MySQLi/Connection.php:277
/** * Returns a string containing the version of the database being used. */ Defined in .../system/Database/MySQLi/Connection.php:299
/** * Executes the query against the database. * * @return false|mysqli_result */ Defined in .../system/Database/MySQLi/Connection.php:317
/** * Prep the query. If needed, each database adapter can prep the query string */ Defined in .../system/Database/MySQLi/Connection.php:342
/** * Returns the total number of rows affected by this query. */ Defined in .../system/Database/MySQLi/Connection.php:356
/** * Platform-dependant string escape */ Defined in .../system/Database/MySQLi/Connection.php:364
/** * 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 .../system/Database/MySQLi/Connection.php:383
/** * 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 .../system/Database/MySQLi/Connection.php:409
/** * Generates a platform-specific query string so that the column names can be fetched. * * @param string|TableName $table */ Defined in .../system/Database/MySQLi/Connection.php:429
/** * Returns an array of objects with field data * * @return list<stdClass> * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:448
/** * Returns an array of objects with index data * * @return array<string, stdClass> * * @throws DatabaseException * @throws LogicException */ Defined in .../system/Database/MySQLi/Connection.php:481
/** * Returns an array of objects with Foreign key data * * @return array<string, stdClass> * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:528
/** * Returns platform-specific SQL to disable foreign key checks. * * @return string */ Defined in .../system/Database/MySQLi/Connection.php:578
/** * Returns platform-specific SQL to enable foreign key checks. * * @return string */ Defined in .../system/Database/MySQLi/Connection.php:588
/** * 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 .../system/Database/MySQLi/Connection.php:600
/** * Insert ID */ Defined in .../system/Database/MySQLi/Connection.php:618
/** * Begin Transaction */ Defined in .../system/Database/MySQLi/Connection.php:626
/** * Commit Transaction */ Defined in .../system/Database/MySQLi/Connection.php:636
/** * Rollback Transaction */ Defined in .../system/Database/MySQLi/Connection.php:650
/** * Saves our connection settings. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:370
/** * Initializes the database connection/settings. * * @return void * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:404
/** * Close the database connection. * * @return void */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:483
/** * Create a persistent database connection. * * @return false|object|resource * @phpstan-return false|TConnection */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:504
/** * 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 .../system/Database/BaseConnection.php:518
/** * Returns the name of the current database being used. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:527
/** * 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 .../system/Database/BaseConnection.php:539
/** * Returns the database prefix. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:547
/** * The name of the platform in use (MySQLi, Postgre, SQLite3, OCI8, etc) */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:555
/** * 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 .../system/Database/BaseConnection.php:567
/** * Add a table alias to our list. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:579
/** * 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 .../system/Database/BaseConnection.php:615
/** * 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 .../system/Database/BaseConnection.php:732
/** * Disable Transactions * * This permits transactions to be disabled at run-time. * * @return void */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:748
/** * 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 .../system/Database/BaseConnection.php:767
/** * Start Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:777
/** * If set to true, exceptions are thrown during transactions. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:791
/** * Complete Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:801
/** * Lets you retrieve the transaction flag to determine if it has failed */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:827
/** * Begin Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:835
/** * Commit Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:869
/** * Rollback Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:888
/** * Reset transaction status - to restart transactions after strict mode failure */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:907
/** * 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 .../system/Database/BaseConnection.php:938
/** * Returns a new instance of the BaseBuilder class with a cleared FROM clause. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:952
/**
* 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 .../system/Database/BaseConnection.php:980/** * Returns the last query's statement object. * * @return Query */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1008
/** * Returns a string representation of the last query's statement object. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1016
/** * 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 .../system/Database/BaseConnection.php:1027
/** * 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 .../system/Database/BaseConnection.php:1038
/** * 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 .../system/Database/BaseConnection.php:1071
/** * Escape the SQL Identifier * * This function escapes single identifier. * * @param non-empty-string|TableName $item */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1236
/** * 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 .../system/Database/BaseConnection.php:1276
/** * Prepends a database prefix if one exists in configuration * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1336
/** * "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 .../system/Database/BaseConnection.php:1361
/** * 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 .../system/Database/BaseConnection.php:1394
/** * 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 .../system/Database/BaseConnection.php:1444
/** * 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 .../system/Database/BaseConnection.php:1467
/** * Get the prefix of the function to access the DB. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1489
/** * Returns an array of table names * * @return false|list<string> * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1505
/** * Determine if a particular table exists * * @param bool $cached Whether to use data cache */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1542
/** * Fetch Field Names * * @param string|TableName $tableName * * @return false|list<string> * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1585
/** * Determine if a particular field exists */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1632
/** * Returns an object with field data * * @return list<stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1642
/** * Returns an object with key data * * @return array<string, stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1652
/** * Returns an object with foreign key data * * @return array<string, stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1662
/**
* 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 .../system/Database/BaseConnection.php:1686/** * Disables foreign key checks temporarily. * * @return bool */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1719
/** * Enables foreign key checks temporarily. * * @return bool */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1736
/** * 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 .../system/Database/BaseConnection.php:1756
/** * Empties our data cache. Especially helpful during testing. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1768
/** * Determines if the statement is a write-type query or not. * * @param string $sql */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1780
/** * Accessor for properties if they exist. * * @return array|bool|float|int|object|resource|string|null */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1884
/** * Checker for properties existence. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1896
Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1160
/** * Returns escaped table name with alias. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1258
SELECT * FROM `content_owner` WHERE `owner_name` = :owner_name: AND `owner_id` = :owner_id: LIMIT 1
SELECT * FROM `content_owner` WHERE `owner_name` = 'Information' AND `owner_id` = 18 LIMIT 1
| 0 | 1 | |
|---|---|---|
| owner_name | Information | true |
| owner_id | 18 | true |
Defined in .../system/Database/Query.php:98
/** * Sets the raw query string to use for this statement. * * @param mixed $binds * * @return $this */ Defined in .../system/Database/Query.php:110
/** * Will store the variables to bind into the query later. * * @return $this */ Defined in .../system/Database/Query.php:141
/** * Returns the final, processed query string after binding, etal * has been performed. */ Defined in .../system/Database/Query.php:160
/** * 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 .../system/Database/Query.php:176
/** * Returns the start time in seconds with microseconds. * * @return float|string */ Defined in .../system/Database/Query.php:194
/** * 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 .../system/Database/Query.php:209
/** * Stores the error description that happened for this query. * * @return $this */ Defined in .../system/Database/Query.php:219
/** * Reports whether this statement created an error not. */ Defined in .../system/Database/Query.php:230
/** * Returns the error code created while executing this statement. */ Defined in .../system/Database/Query.php:238
/** * Returns the error message created while executing this statement. */ Defined in .../system/Database/Query.php:246
/** * Determines if the statement is a write-type query or not. */ Defined in .../system/Database/Query.php:254
/** * Swaps out one table prefix for a new one. * * @return $this */ Defined in .../system/Database/Query.php:264
/** * Returns the original SQL that was passed into the system. */ Defined in .../system/Database/Query.php:281
/** * Escapes and inserts any binds into the finalQueryString property. * * @see https://regex101.com/r/EUEhay/5 */ Defined in .../system/Database/Query.php:291
/** * Match bindings */ Defined in .../system/Database/Query.php:319
/** * Match bindings */ Defined in .../system/Database/Query.php:343
/** * Returns string to display in debug toolbar */ Defined in .../system/Database/Query.php:373
/** * Return text representation of the query */ Defined in .../system/Database/Query.php:427
SELECT * FROM `content_owner` WHERE `owner_name` = 'Information' AND `owner_id` = 18 LIMIT 1
/** * Connect to the database. * * @return false|mysqli * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:102
/** * 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 .../system/Database/MySQLi/Connection.php:258
/** * Close the database connection. * * @return void */ Defined in .../system/Database/MySQLi/Connection.php:269
/** * Select a specific database table to use. */ Defined in .../system/Database/MySQLi/Connection.php:277
/** * Returns a string containing the version of the database being used. */ Defined in .../system/Database/MySQLi/Connection.php:299
/** * Executes the query against the database. * * @return false|mysqli_result */ Defined in .../system/Database/MySQLi/Connection.php:317
/** * Prep the query. If needed, each database adapter can prep the query string */ Defined in .../system/Database/MySQLi/Connection.php:342
/** * Returns the total number of rows affected by this query. */ Defined in .../system/Database/MySQLi/Connection.php:356
/** * Platform-dependant string escape */ Defined in .../system/Database/MySQLi/Connection.php:364
/** * 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 .../system/Database/MySQLi/Connection.php:383
/** * 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 .../system/Database/MySQLi/Connection.php:409
/** * Generates a platform-specific query string so that the column names can be fetched. * * @param string|TableName $table */ Defined in .../system/Database/MySQLi/Connection.php:429
/** * Returns an array of objects with field data * * @return list<stdClass> * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:448
/** * Returns an array of objects with index data * * @return array<string, stdClass> * * @throws DatabaseException * @throws LogicException */ Defined in .../system/Database/MySQLi/Connection.php:481
/** * Returns an array of objects with Foreign key data * * @return array<string, stdClass> * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:528
/** * Returns platform-specific SQL to disable foreign key checks. * * @return string */ Defined in .../system/Database/MySQLi/Connection.php:578
/** * Returns platform-specific SQL to enable foreign key checks. * * @return string */ Defined in .../system/Database/MySQLi/Connection.php:588
/** * 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 .../system/Database/MySQLi/Connection.php:600
/** * Insert ID */ Defined in .../system/Database/MySQLi/Connection.php:618
/** * Begin Transaction */ Defined in .../system/Database/MySQLi/Connection.php:626
/** * Commit Transaction */ Defined in .../system/Database/MySQLi/Connection.php:636
/** * Rollback Transaction */ Defined in .../system/Database/MySQLi/Connection.php:650
/** * Saves our connection settings. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:370
/** * Initializes the database connection/settings. * * @return void * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:404
/** * Close the database connection. * * @return void */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:483
/** * Create a persistent database connection. * * @return false|object|resource * @phpstan-return false|TConnection */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:504
/** * 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 .../system/Database/BaseConnection.php:518
/** * Returns the name of the current database being used. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:527
/** * 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 .../system/Database/BaseConnection.php:539
/** * Returns the database prefix. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:547
/** * The name of the platform in use (MySQLi, Postgre, SQLite3, OCI8, etc) */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:555
/** * 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 .../system/Database/BaseConnection.php:567
/** * Add a table alias to our list. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:579
/** * 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 .../system/Database/BaseConnection.php:615
/** * 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 .../system/Database/BaseConnection.php:732
/** * Disable Transactions * * This permits transactions to be disabled at run-time. * * @return void */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:748
/** * 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 .../system/Database/BaseConnection.php:767
/** * Start Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:777
/** * If set to true, exceptions are thrown during transactions. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:791
/** * Complete Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:801
/** * Lets you retrieve the transaction flag to determine if it has failed */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:827
/** * Begin Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:835
/** * Commit Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:869
/** * Rollback Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:888
/** * Reset transaction status - to restart transactions after strict mode failure */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:907
/** * 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 .../system/Database/BaseConnection.php:938
/** * Returns a new instance of the BaseBuilder class with a cleared FROM clause. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:952
/**
* 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 .../system/Database/BaseConnection.php:980/** * Returns the last query's statement object. * * @return Query */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1008
/** * Returns a string representation of the last query's statement object. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1016
/** * 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 .../system/Database/BaseConnection.php:1027
/** * 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 .../system/Database/BaseConnection.php:1038
/** * 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 .../system/Database/BaseConnection.php:1071
/** * Escape the SQL Identifier * * This function escapes single identifier. * * @param non-empty-string|TableName $item */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1236
/** * 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 .../system/Database/BaseConnection.php:1276
/** * Prepends a database prefix if one exists in configuration * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1336
/** * "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 .../system/Database/BaseConnection.php:1361
/** * 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 .../system/Database/BaseConnection.php:1394
/** * 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 .../system/Database/BaseConnection.php:1444
/** * 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 .../system/Database/BaseConnection.php:1467
/** * Get the prefix of the function to access the DB. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1489
/** * Returns an array of table names * * @return false|list<string> * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1505
/** * Determine if a particular table exists * * @param bool $cached Whether to use data cache */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1542
/** * Fetch Field Names * * @param string|TableName $tableName * * @return false|list<string> * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1585
/** * Determine if a particular field exists */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1632
/** * Returns an object with field data * * @return list<stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1642
/** * Returns an object with key data * * @return array<string, stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1652
/** * Returns an object with foreign key data * * @return array<string, stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1662
/**
* 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 .../system/Database/BaseConnection.php:1686/** * Disables foreign key checks temporarily. * * @return bool */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1719
/** * Enables foreign key checks temporarily. * * @return bool */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1736
/** * 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 .../system/Database/BaseConnection.php:1756
/** * Empties our data cache. Especially helpful during testing. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1768
/** * Determines if the statement is a write-type query or not. * * @param string $sql */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1780
/** * Accessor for properties if they exist. * * @return array|bool|float|int|object|resource|string|null */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1884
/** * Checker for properties existence. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1896
Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1160
/** * Returns escaped table name with alias. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1258
/** * FROM tables * * Groups tables in FROM clauses if needed, so there is no confusion * about operator precedence. * * Note: This is only used (and overridden) by MySQL. */ Defined in .../system/Database/MySQLi/Builder.php:52
/** * Generates a platform-specific batch update string from the supplied data */ Defined in .../system/Database/MySQLi/Builder.php:64
/** * Constructor * * @param array|string|TableName $tableName tablename or tablenames with or without aliases * * Examples of $tableName: `mytable`, `jobs j`, `jobs j, users u`, `['jobs j','users u']` * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:307
/** * Returns the current database connection * * @return BaseConnection */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:346
/** * Sets a test mode status. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:356
/** * Gets the name of the primary table. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:366
/** * Returns an array of bind values and their * named parameters for binding in the Query object later. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:375
/** * Ignore * * Set ignore Flag for next insert, * update or delete query. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:388
/** * Generates the SELECT portion of the query * * @param list<RawSql|string>|RawSql|string $select * @param bool|null $escape Whether to protect identifiers * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:403
/** * Generates a SELECT MAX(field) portion of a query * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:456
/** * Generates a SELECT MIN(field) portion of a query * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:466
/** * Generates a SELECT AVG(field) portion of a query * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:476
/** * Generates a SELECT SUM(field) portion of a query * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:486
/** * Generates a SELECT COUNT(field) portion of a query * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:496
/** * Adds a subquery to the selection */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:504
/** * SELECT [MAX|MIN|AVG|SUM|COUNT]() * * @used-by selectMax() * @used-by selectMin() * @used-by selectAvg() * @used-by selectSum() * * @return $this * * @throws DatabaseException * @throws DataException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:524
/** * Determines the alias name based on the table */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:555
/** * Sets a flag which tells the query string compiler to add DISTINCT * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:571
/** * Generates the FROM portion of the query * * @param array|string $from * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:585
/** * @param BaseBuilder $from Expected subquery * @param string $alias Subquery alias * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:616
/** * Generates the JOIN portion of the query * * @param RawSql|string $cond * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:633
/** * Generates the WHERE portion of the query. * Separates multiple calls with 'AND'. * * @param array|RawSql|string $key * @param mixed $value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:720
/** * OR WHERE * * Generates the WHERE portion of the query. * Separates multiple calls with 'OR'. * * @param array|RawSql|string $key * @param mixed $value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:736
/** * @used-by where() * @used-by orWhere() * @used-by having() * @used-by orHaving() * * @param array|RawSql|string $key * @param mixed $value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:752
/**
* Generates a WHERE field IN('item', 'item') SQL query,
* joined with 'AND' if appropriate.
*
* @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery
*
* @return $this
*/
Inherited from CodeIgniter\Database\BaseBuilder
Defined in .../system/Database/BaseBuilder.php:848/**
* Generates a WHERE field IN('item', 'item') SQL query,
* joined with 'OR' if appropriate.
*
* @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery
*
* @return $this
*/
Inherited from CodeIgniter\Database\BaseBuilder
Defined in .../system/Database/BaseBuilder.php:861/**
* Generates a WHERE field NOT IN('item', 'item') SQL query,
* joined with 'AND' if appropriate.
*
* @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery
*
* @return $this
*/
Inherited from CodeIgniter\Database\BaseBuilder
Defined in .../system/Database/BaseBuilder.php:874/**
* Generates a WHERE field NOT IN('item', 'item') SQL query,
* joined with 'OR' if appropriate.
*
* @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery
*
* @return $this
*/
Inherited from CodeIgniter\Database\BaseBuilder
Defined in .../system/Database/BaseBuilder.php:887/**
* Generates a HAVING field IN('item', 'item') SQL query,
* joined with 'AND' if appropriate.
*
* @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery
*
* @return $this
*/
Inherited from CodeIgniter\Database\BaseBuilder
Defined in .../system/Database/BaseBuilder.php:900/**
* Generates a HAVING field IN('item', 'item') SQL query,
* joined with 'OR' if appropriate.
*
* @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery
*
* @return $this
*/
Inherited from CodeIgniter\Database\BaseBuilder
Defined in .../system/Database/BaseBuilder.php:913/**
* Generates a HAVING field NOT IN('item', 'item') SQL query,
* joined with 'AND' if appropriate.
*
* @param array|BaseBuilder|(Closure(BaseBuilder):BaseBuilder)|null $values The values searched on, or anonymous function with subquery
*
* @return $this
*/
Inherited from CodeIgniter\Database\BaseBuilder
Defined in .../system/Database/BaseBuilder.php:926/**
* Generates a HAVING field NOT IN('item', 'item') SQL query,
* joined with 'OR' if appropriate.
*
* @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery
*
* @return $this
*/
Inherited from CodeIgniter\Database\BaseBuilder
Defined in .../system/Database/BaseBuilder.php:939/** * @used-by WhereIn() * @used-by orWhereIn() * @used-by whereNotIn() * @used-by orWhereNotIn() * * @param non-empty-string|null $key * @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery * * @return $this * * @throws InvalidArgumentException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:957
/** * Generates a %LIKE% portion of the query. * Separates multiple calls with 'AND'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1008
/** * Generates a NOT LIKE portion of the query. * Separates multiple calls with 'AND'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1021
/** * Generates a %LIKE% portion of the query. * Separates multiple calls with 'OR'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1034
/** * Generates a NOT LIKE portion of the query. * Separates multiple calls with 'OR'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1047
/** * Generates a %LIKE% portion of the query. * Separates multiple calls with 'AND'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1060
/** * Generates a NOT LIKE portion of the query. * Separates multiple calls with 'AND'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1073
/** * Generates a %LIKE% portion of the query. * Separates multiple calls with 'OR'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1086
/** * Generates a NOT LIKE portion of the query. * Separates multiple calls with 'OR'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1099
/** * @used-by like() * @used-by orLike() * @used-by notLike() * @used-by orNotLike() * @used-by havingLike() * @used-by orHavingLike() * @used-by notHavingLike() * @used-by orNotHavingLike() * * @param array<string, string>|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1118
/** * Platform independent LIKE statement builder. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1193
/** * Add UNION statement * * @param BaseBuilder|Closure(BaseBuilder): BaseBuilder $union * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1209
/** * Add UNION ALL statement * * @param BaseBuilder|Closure(BaseBuilder): BaseBuilder $union * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1221
/** * @used-by union() * @used-by unionAll() * * @param BaseBuilder|Closure(BaseBuilder): BaseBuilder $union * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1234
/** * Starts a query group. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1249
/** * Starts a query group, but ORs the group * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1259
/** * Starts a query group, but NOTs the group * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1269
/** * Starts a query group, but OR NOTs the group * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1279
/** * Ends a query group * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1289
/** * Starts a query group for HAVING clause. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1299
/** * Starts a query group for HAVING clause, but ORs the group. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1309
/** * Starts a query group for HAVING clause, but NOTs the group. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1319
/** * Starts a query group for HAVING clause, but OR NOTs the group. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1329
/** * Ends a query group for HAVING clause. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1339
/** * Prepate a query group start. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1349
/** * Prepate a query group end. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1370
/** * @used-by groupStart() * @used-by _like() * @used-by whereHaving() * @used-by _whereIn() * @used-by havingGroupStart() */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1390
/** * @param array|string $by * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1405
/** * Separates multiple calls with 'AND'. * * @param array|RawSql|string $key * @param mixed $value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1439
/** * Separates multiple calls with 'OR'. * * @param array|RawSql|string $key * @param mixed $value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1452
/** * @param string $direction ASC, DESC or RANDOM * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1462
/** * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1514
/** * Sets the OFFSET value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1537
/** * Generates a platform-specific LIMIT clause. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1549
/** * Allows key/value pairs to be set for insert(), update() or replace(). * * @param array|object|string $key Field name, or an array of field/value pairs, or an object * @param mixed $value Field value, if $key is a single field * @param bool|null $escape Whether to escape values * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1563
/** * Returns the previously set() data, alternatively resetting it if needed. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1589
/** * Compiles a SELECT query string and returns the sql. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1603
/** * Returns a finalized, compiled query string with the bindings * inserted and prefixes swapped out. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1618
/** * Compiles the select statement based on the other functions called * and runs the query * * @return false|ResultInterface */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1636
/** * Generates a platform-specific query string that counts all records in * the particular table * * @return int|string */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1667
/** * Generates a platform-specific query string that counts all records * returned by an Query Builder query. * * @return int|string */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1699
/** * Compiles the set conditions and returns the sql statement * * @return array */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1758
/** * Allows the where clause, limit and offset to be added directly * * @param array|string $where * * @return ResultInterface */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1770
/** * Compiles batch insert/update/upsert strings and runs the queries * * @param '_deleteBatch'|'_insertBatch'|'_updateBatch'|'_upsertBatch' $renderMethod * * @return false|int|list<string> Number of rows inserted or FALSE on failure, SQL array when testMode * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1808
/** * Allows a row or multiple rows to be set for batch inserts/upserts/updates * * @param array|object $set * @param string $alias alias for sql table * * @return $this|null */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1861
/** * Compiles an upsert query and returns the sql * * @return string * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1925
/** * Converts call to batchUpsert * * @param array|object|null $set * * @return false|int|list<string> Number of affected rows or FALSE on failure, SQL array when testMode * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1945
/** * Compiles batch upsert strings and runs the queries * * @param array|object|null $set a dataset * * @return false|int|list<string> Number of affected rows or FALSE on failure, SQL array when testMode * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1981
/** * Generates a platform-specific upsertBatch string from the supplied data * * @used-by batchExecute() * * @param string $table Protected table name * @param list<string> $keys QBKeys * @param list<list<int|string>> $values QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2015
/** * Sets update fields for upsert, update * * @param list<RawSql>|list<string>|string $set * @param bool $addToDefault adds update fields to the default ones * @param array|null $ignore ignores items in set * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2068
/** * Sets constraints for batch upsert, update * * @param array|RawSql|string $set a string of columns, key value pairs, or RawSql * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2110
/** * Sets data source as a query for insertBatch()/updateBatch()/upsertBatch()/deleteBatch() * * @param BaseBuilder|RawSql $query * @param array|string|null $columns an array or comma delimited string of columns */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2145
/** * Gets column names from a select query */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2188
/** * Converts value array of array to array of strings */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2196
/** * Compiles batch insert strings and runs the queries * * @param array|object|null $set a dataset * * @return false|int|list<string> Number of rows inserted or FALSE on no data to perform an insert operation, SQL array when testMode */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2208
/** * Generates a platform-specific insert string from the supplied data. * * @used-by batchExecute() * * @param string $table Protected table name * @param list<string> $keys QBKeys * @param list<list<int|string>> $values QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2242
/** * Allows key/value pairs to be set for batch inserts * * @param mixed $key * * @return $this|null * * @deprecated */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2272
/** * Compiles an insert query and returns the sql * * @return bool|string * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2288
/** * Compiles an insert string and runs the query * * @param array|object|null $set * * @return BaseResult|bool|Query * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2321
/** * @internal This is a temporary solution. * * @see https://github.com/codeigniter4/CodeIgniter4/pull/5376 * * @TODO Fix a root cause, and this method should be removed. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2363
/** * This method is used by both insert() and getCompiledInsert() to * validate that the there data is actually being set and that table * has been chosen to be inserted into. * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2383
/** * Generates a platform-specific insert string from the supplied data * * @param string $table Protected table name * @param list<string> $keys Keys of QBSet * @param list<int|string> $unescapedKeys Values of QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2403
/** * Compiles a replace into string and runs the query * * @return BaseResult|false|Query|string * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2415
/** * Generates a platform-specific replace string from the supplied data * * @param string $table Protected table name * @param list<string> $keys Keys of QBSet * @param list<int|string> $values Values of QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2445
/** * Compiles an update query and returns the sql * * @return bool|string */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2466
/** * Compiles an update string and runs the query. * * @param array|object|null $set * @param array|RawSql|string|null $where * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2489
/** * Generates a platform-specific update string from the supplied data * * @param string $table Protected table name * @param array<string, string> $values QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2542
/** * This method is used by both update() and getCompiledUpdate() to * validate that data is actually being set and that a table has been * chosen to be updated. * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2571
/** * Sets data and calls batchExecute to run queries * * @param array|object|null $set a dataset * @param array|RawSql|string|null $constraints * * @return false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2592
/** * Allows key/value pairs to be set for batch updating * * @param array|object $key * * @return $this * * @throws DatabaseException * * @deprecated */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2723
/** * Compiles a delete string and runs "DELETE FROM table" * * @return bool|string TRUE on success, FALSE on failure, string on testMode */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2739
/** * Compiles a truncate string and runs the query * If the database does not support the truncate() command * This function maps to "DELETE FROM table" * * @return bool|string TRUE on success, FALSE on failure, string on testMode */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2761
/** * Generates a platform-specific truncate string from the supplied data * * If the database does not support the truncate() command, * then this method maps to 'DELETE FROM table' * * @param string $table Protected table name */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2784
/** * Compiles a delete query string and returns the sql */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2792
/** * Compiles a delete string and runs the query * * @param array|RawSql|string $where * * @return bool|string Returns a SQL string if in test mode. * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2809
/** * Sets data and calls batchExecute to run queries * * @param array|object|null $set a dataset * @param array|RawSql|null $constraints * * @return false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2859
/** * Generates a platform-specific batch update string from the supplied data * * @used-by batchExecute() * * @param string $table Protected table name * @param list<string> $keys QBKeys * @param list<int|string> $values QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2895
/** * Increments a numeric column by the specified value. * * @return bool */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2972
/** * Decrements a numeric column by the specified value. * * @return bool */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2992
/** * Generates a platform-specific delete string from the supplied data * * @param string $table Protected table name */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3012
/** * Used to track SQL statements written with aliased tables. * * @param array|string $table The table to inspect * * @return string|null */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3024
/** * Compile the SELECT statement * * Generates a query string based on which functions were used. * Should not be called directly. * * @param mixed $selectOverride */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3063
/** * Checks if the ignore option is supported by * the Database Driver for the specific statement. * * @return string */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3120
/** * Escapes identifiers in WHERE and HAVING statements at execution time. * * Required so that aliases are tracked properly, regardless of whether * where(), orWhere(), having(), orHaving are called prior to from(), * join() and prefixTable is added only if needed. * * @param string $qbKey 'QBWhere' or 'QBHaving' * * @return string SQL statement */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3140
/** * Escapes identifiers in GROUP BY statements at execution time. * * Required so that aliases are tracked properly, regardless of whether * groupBy() is called prior to from(), join() and prefixTable is added * only if needed. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3229
/** * Escapes identifiers in ORDER BY statements at execution time. * * Required so that aliases are tracked properly, regardless of whether * orderBy() is called prior to from(), join() and prefixTable is added * only if needed. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3256
Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3277
/** * Takes an object as input and converts the class variables to array key/vals * * @param array|object $object * * @return array */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3295
/** * Takes an object as input and converts the class variables to array key/vals * * @param array|object $object * * @return array */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3323
/** * Determines if a string represents a literal value or a field name */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3347
/** * Publicly-visible method to reset the QB values. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3371
/** * Resets the query builder values. Called by the get() function * * @param array $qbResetItems An array of fields to reset */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3384
/** * Resets the query builder values. Called by the get() function */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3394
/** * Resets the query builder "write" values. * * Called by the insert() update() insertBatch() updateBatch() and delete() functions */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3425
/** * Tests whether the string has an SQL operator */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3442
/** * Returns the SQL string operator * * @return array|false|string */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3455
/** * Stores a bind value after ensuring that it's unique. * While it might be nicer to have named keys for our binds array * with PHP 7+ we get a huge memory/performance gain with indexed * arrays instead, so lets take advantage of that here. * * @param mixed $value */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3523
/** * Returns a clone of a Base Builder with reset query builder values. * * @return $this * * @deprecated */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3555
/** * @param mixed $value */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3563
/** * @param BaseBuilder|Closure(BaseBuilder): BaseBuilder $builder * @param bool $wrapped Wrap the subquery in brackets * @param string $alias Subquery alias */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3573
/** * Only runs the query when $condition evaluates to true * * @template TWhen of mixed * * @phpstan-param TWhen $condition * @phpstan-param callable(self, TWhen): mixed $callback * @phpstan-param (callable(self): mixed)|null $defaultCallback * @param array|bool|float|int|object|resource|string|null $condition * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Traits/ConditionalTrait.php:30
/** * Only runs the query when $condition evaluates to false * * @template TWhenNot of mixed * * @phpstan-param TWhenNot $condition * @phpstan-param callable(self, TWhenNot): mixed $callback * @phpstan-param (callable(self): mixed)|null $defaultCallback * @param array|bool|float|int|object|resource|string|null $condition * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Traits/ConditionalTrait.php:53
/** * Set table alias for dataset pseudo table. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2049
/** * Returns the SQL string operator from where key * * @return false|list<string> */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3489
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:21
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:44
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:55
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:66
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:94
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:114
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:127
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:133
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:138
/** * Specify the table associated with a model * * @param string $table Table * * @return $this */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:169
/** * Fetches the row(s) of database from $this->table with a primary key * matching $id. * This method works only with dbCalls. * * @param bool $singleton Single or multiple results * @param array|int|string|null $id One primary key or an array of primary keys * * @return array|object|null The resulting row of data, or null. * @phpstan-return ($singleton is true ? row_array|null|object : list<row_array|object>) */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:187
/** * Fetches the column of database from $this->table. * This method works only with dbCalls. * * @param string $columnName Column Name * * @return array|null The resulting row of data, or null if no data found. * @phpstan-return list<row_array>|null */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:250
/** * Works with the current Query Builder instance to return * all results, while optionally limiting them. * This method works only with dbCalls. * * @param int|null $limit Limit * @param int $offset Offset * * @return array * @phpstan-return list<row_array|object> */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:266
/** * Returns the first row of the result set. Will take any previous * Query Builder calls into account when determining the result set. * This method works only with dbCalls. * * @return array|object|null * @phpstan-return row_array|object|null */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:308
/** * Inserts data into the current table. * This method works only with dbCalls. * * @param array $row Row data * @phpstan-param row_array $row * * @return bool */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:350
/** * Compiles batch insert strings and runs the queries, validating each row prior. * This method works only with dbCalls. * * @param array|null $set An associative array of insert values * @param bool|null $escape Whether to escape values * @param int $batchSize The size of the batch to run * @param bool $testing True means only number of records is returned, false will execute the query * * @return bool|int Number of rows inserted or FALSE on failure */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:416
/** * Updates a single record in $this->table. * This method works only with dbCalls. * * @param array|int|string|null $id * @param array|null $row Row data * @phpstan-param row_array|null $row */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:439
/** * Compiles an update string and runs the query * This method works only with dbCalls. * * @param array|null $set An associative array of update values * @param string|null $index The where key * @param int $batchSize The size of the batch to run * @param bool $returnSQL True means SQL is returned, false will execute the query * * @return false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode * * @throws DatabaseException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:477
/** * Deletes a single record from $this->table where $id matches * the table's primaryKey * This method works only with dbCalls. * * @param array|int|string|null $id The rows primary key(s) * @param bool $purge Allows overriding the soft deletes setting. * * @return bool|string SQL string when testMode * * @throws DatabaseException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:494
/** * Permanently deletes all rows that have been marked as deleted * through soft deletes (deleted = 1) * This method works only with dbCalls. * * @return bool|string Returns a SQL string if in test mode. */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:531
/** * Works with the find* methods to return only the rows that * have been deleted. * This method works only with dbCalls. * * @return void */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:545
/** * Compiles a replace into string and runs the query * This method works only with dbCalls. * * @param array|null $row Data * @phpstan-param row_array|null $row * @param bool $returnSQL Set to true to return Query String * * @return BaseResult|false|Query|string */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:560
/** * Grabs the last error(s) that occurred from the Database connection. * The return array should be in the following format: * ['source' => 'message'] * This method works only with dbCalls. * * @return array<string, string> */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:573
/** * Returns the id value for the data array or object * * @param array|object $row Row data * @phpstan-param row_array|object $row * * @return array|int|string|null */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:593
/** * Loops over records in batches, allowing you to operate on them. * Works with $this->builder to get the Compiled select to * determine the rows to operate on. * This method works only with dbCalls. */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:629
/** * Override countAllResults to account for soft deleted accounts. * * @return int|string */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:663
/** * Provides a shared instance of the Query Builder. * * @param non-empty-string|null $table * * @return BaseBuilder * * @throws ModelException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:688
/** * Captures the builder's set() method so that we can validate the * data here. This allows it to be used with any of the other * builder methods and still get validated data, like replace. * * @param array|object|string $key Field name, or an array of field/value pairs, or an object * @param bool|float|int|object|string|null $value Field value, if $key is a single field * @param bool|null $escape Whether to escape values * * @return $this */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:735
/** * This method is called on save to determine if entry have to be updated * If this method return false insert operation will be executed * * @param array|object $row Data */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:758
/** * Inserts data into the database. If an object is provided, * it will attempt to convert it to an array. * * @param array|object|null $row * @phpstan-param row_array|object|null $row * @param bool $returnID Whether insert ID should be returned or not. * * @return bool|int|string * @phpstan-return ($returnID is true ? int|string|false : bool) * * @throws ReflectionException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:786
/** * Ensures that only the fields that are allowed to be inserted are in * the data array. * * @used-by insert() to protect against mass assignment vulnerabilities. * @used-by insertBatch() to protect against mass assignment vulnerabilities. * * @param array $row Row data * @phpstan-param row_array $row * * @throws DataException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:815
/** * Updates a single record in the database. If an object is provided, * it will attempt to convert it into an array. * * @param array|int|string|null $id * @param array|object|null $row * @phpstan-param row_array|object|null $row * * @throws ReflectionException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:849
/** * Takes a class and returns an array of its public and protected * properties as an array with raw values. * * @param object $object Object * @param bool $recursive If true, inner entities will be cast as array as well * * @return array<string, mixed> Array with raw values. * * @throws ReflectionException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:877
/** * Provides/instantiates the builder/db connection and model's table/primary key names and return type. * * @param string $name Name * * @return array|BaseBuilder|bool|float|int|object|string|null */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:889
/** * Checks for the existence of properties across this model, builder, and db connection. * * @param string $name Name */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:903
/** * Provides direct access to method in the builder (if available) * and the database connection. * * @return $this|array|BaseBuilder|bool|float|int|object|string|null */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:918
/** * Creates DataConverter instance. */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:376
/** * Are casts used? */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:390
/** * Initializes the instance with any additional steps. * Optionally implemented by child classes. * * @return void */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:401
/** * Fetches the row of database. * * @param array|int|string|null $id One primary key or an array of primary keys * * @return array|object|null The resulting row of data, or null. * @phpstan-return ($id is int|string ? row_array|object|null : list<row_array|object>) */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:590
/** * Fetches the column of database. * * @param string $columnName Column Name * * @return array|null The resulting row of data, or null if no data found. * * @throws DataException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:634
/** * Fetches all results, while optionally limiting them. * * @param int $limit Limit * @param int $offset Offset * * @return array */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:653
/** * Returns the first row of the result set. * * @return array|object|null */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:698
/** * A convenience method that will attempt to determine whether the * data should be inserted or updated. Will work with either * an array or object. When using with custom class objects, * you must ensure that the class will provide access to the class * variables, even if through a magic method. * * @param array|object $row Row data * @phpstan-param row_array|object $row * * @throws ReflectionException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:741
/** * Returns last insert ID or 0. * * @return int|string */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:779
/** * Set datetime to created field. * * @phpstan-param row_array $row * @param int|string $date timestamp or datetime string */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:869
/** * Set datetime to updated field. * * @phpstan-param row_array $row * @param int|string $date timestamp or datetime string */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:884
/** * Compiles batch insert runs the queries, validating each row prior. * * @param list<array|object>|null $set an associative array of insert values * @phpstan-param list<row_array|object>|null $set * @param bool|null $escape Whether to escape values * @param int $batchSize The size of the batch to run * @param bool $testing True means only number of records is returned, false will execute the query * * @return bool|int Number of rows inserted or FALSE on failure * * @throws ReflectionException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:906
/** * Compiles an update and runs the query. * * @param list<array|object>|null $set an associative array of insert values * @phpstan-param list<row_array|object>|null $set * @param string|null $index The where key * @param int $batchSize The size of the batch to run * @param bool $returnSQL True means SQL is returned, false will execute the query * * @return false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode * * @throws DatabaseException * @throws ReflectionException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1053
/** * Deletes a single record from the database where $id matches. * * @param array|int|string|null $id The rows primary key(s) * @param bool $purge Allows overriding the soft deletes setting. * * @return BaseResult|bool * * @throws DatabaseException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1134
/** * Permanently deletes all rows that have been marked as deleted * through soft deletes (deleted = 1). * * @return bool|string Returns a string if in test mode. */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1175
/** * Sets $useSoftDeletes value so that we can temporarily override * the soft deletes settings. Can be used for all find* methods. * * @param bool $val Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1192
/** * Works with the find* methods to return only the rows that * have been deleted. * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1205
/** * Compiles a replace and runs the query. * * @param array|null $row Row data * @phpstan-param row_array|null $row * @param bool $returnSQL Set to true to return Query String * * @return BaseResult|false|Query|string */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1222
/** * Grabs the last error(s) that occurred. If data was validated, * it will first check for errors there, otherwise will try to * grab the last error from the Database connection. * * The return array should be in the following format: * ['source' => 'message'] * * @param bool $forceDB Always grab the db error, not validation * * @return array<string, string> */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1246
/** * Works with Pager to get the size and offset parameters. * Expects a GET variable (?page=2) that specifies the page of results * to display. * * @param int|null $perPage Items per page * @param string $group Will be used by the pagination library to identify a unique pagination set. * @param int|null $page Optional page number (useful when the page number is provided in different way) * @param int $segment Optional URI segment number (if page number is provided by URI segment) * * @return array|null */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1272
/** * It could be used when you have to change default or override current allowed fields. * * @param array $allowedFields Array with names of fields * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1297
/** * Sets whether or not we should whitelist data set during * updates or inserts against $this->availableFields. * * @param bool $protect Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1312
/** * Ensures that only the fields that are allowed to be updated are * in the data array. * * @used-by update() to protect against mass assignment vulnerabilities. * @used-by updateBatch() to protect against mass assignment vulnerabilities. * * @param array $row Row data * @phpstan-param row_array $row * * @throws DataException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1331
/** * Sets the date or current date if null value is passed. * * @param int|null $userData An optional PHP timestamp to be converted. * * @return int|string * * @throws ModelException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1376
/** * A utility function to allow child models to use the type of * date/time format that they prefer. This is primarily used for * setting created_at, updated_at and deleted_at values, but can be * used by inheriting classes. * * The available time formats are: * - 'int' - Stores the date as an integer timestamp * - 'datetime' - Stores the data in the SQL datetime format * - 'date' - Stores the date (only) in the SQL date format. * * @param int $value value * * @return int|string * * @throws ModelException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1400
/** * Converts Time value to string using $this->dateFormat. * * The available time formats are: * - 'int' - Stores the date as an integer timestamp * - 'datetime' - Stores the data in the SQL datetime format * - 'date' - Stores the date (only) in the SQL date format. * * @param Time $value value * * @return int|string */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1422
/** * Set the value of the skipValidation flag. * * @param bool $skip Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1439
/** * Allows to set (and reset) validation messages. * It could be used when you have to change default or override current validate messages. * * @param array $validationMessages Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1454
/** * Allows to set field wise validation message. * It could be used when you have to change default or override current validate messages. * * @param string $field Field Name * @param array $fieldMessages Validation messages * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1470
/** * Allows to set (and reset) validation rules. * It could be used when you have to change default or override current validate rules. * * @param array<string, array<string, array<string, string>|string>|string> $validationRules Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1485
/** * Allows to set field wise validation rules. * It could be used when you have to change default or override current validate rules. * * @param string $field Field Name * @param array|string $fieldRules Validation rules * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1501
/** * Should validation rules be removed before saving? * Most handy when doing updates. * * @param bool $choice Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1529
/** * Validate the row data against the validation rules (or the validation group) * specified in the class property, $validationRules. * * @param array|object $row Row data * @phpstan-param row_array|object $row */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1543
/** * Returns the model's defined validation rules so that they * can be used elsewhere, if needed. * * @param array $options Options */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1585
Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1608
/** * Returns the model's validation messages, so they * can be used elsewhere, if needed. */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1619
/** * Removes any rules that apply to fields that have not been set * currently so that rules don't block updating when only updating * a partial row. * * @param array $rules Array containing field name and rule * @param array $row Row data (@TODO Remove null in param type) * @phpstan-param row_array $row */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1633
/** * Sets $tempAllowCallbacks value so that we can temporarily override * the setting. Resets after the next method that uses triggers. * * @param bool $val value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1656
/** * A simple event trigger for Model Events that allows additional * data manipulation within the model. Specifically intended for * usage by child models this can be used to format data, * save/load related classes, etc. * * It is the responsibility of the callback methods to return * the data itself. * * Each $eventData array MUST have a 'data' key with the relevant * data for callback methods (like an array of key/value pairs to insert * or update, an array of results, etc.) * * If callbacks are not allowed then returns $eventData immediately. * * @param string $event Event * @param array $eventData Event Data * * @return array * * @throws DataException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1685
/** * Sets the return type of the results to be as an associative array. * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1708
/** * Sets the return type to be of the specified type of object. * Defaults to a simple object, but can be any class that has * class vars with the same name as the collection columns, * or at least allows them to be created. * * @param 'object'|class-string $class Class Name * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1725
/** * Takes a class and returns an array of its public and protected * properties as an array suitable for use in creates and updates. * This method uses objectToRawArray() internally and does conversion * to string on all Time instances * * @param object $object Object * @param bool $onlyChanged Only Changed Property * @param bool $recursive If true, inner entities will be cast as array as well * * @return array<string, mixed> * * @throws ReflectionException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1746
/** * Convert any Time instances to appropriate $dateFormat. * * @param array<string, mixed> $properties * * @return array<string, mixed> */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1761
/** * Transform data to array. * * @param array|object|null $row Row data * @phpstan-param row_array|object|null $row * @param string $type Type of data (insert|update) * * @throws DataException * @throws InvalidArgumentException * @throws ReflectionException * * @used-by insert() * @used-by update() */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1823
/** * Sets $allowEmptyInserts. */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1925
/** * Converts database data array to return type value. * * @param array<string, mixed> $row Raw data from database * @param 'array'|'object'|class-string $returnType */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1938
/** * Recherche une classe dans les namespaces définis dans config/Autoload.php. * * @param string $className Nom de la classe à rechercher. * @param string $subNamespace Sous-namespace comme 'Entities', 'Models', etc. * @return string|false Nom complet de la classe si trouvée, sinon false. * @throws Exception Si le nom de la classe est vide. */ Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Traits/NamespaceResolverTrait.php:15
/** * Récupère le nom simple de la classe à partir de son nom complet avec namespace. * * @param string|object $className Nom complet de la classe. Si vide, utilise la classe courante. * @return string Nom simple de la classe. */ Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Traits/NamespaceResolverTrait.php:63
/** * Vérifie si une classe est namespacée selon la configuration PSR4. * * @param string $className Nom de la classe. * @return bool True si la classe est dans un namespace PSR4, False sinon. */ Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Traits/NamespaceResolverTrait.php:79
/** * Recherche une vue spécifique dans les namespaces définis dans config/Autoload.php. * Retourne le chemin complet de la vue trouvée ou false si non trouvée. * * @param string $viewPath Le chemin relatif ou namespacé de la vue (par exemple, 'cells/card/view' ou 'KoclikoDisplay\Views\my\path\test'). * @param string $type Le type de répertoire (par exemple, 'entities', 'cells'). * @param string $group Le groupe de vues, par exemple 'admin' (facultatif). * @return string|false Chemin complet de la vue ou false si non trouvée. */ Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Traits/NamespaceResolverTrait.php:103
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Traits/NamespaceResolverTrait.php:157
/** * Checks the Builder method name that should not be used in the Model. */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:943
Voici une présentation de la séduisante substance bleue.
La phycocyanine est à la fois une molécule, une protéine, un pigment, un antioxydant, un anti-inflammatoire et ces diverses facettes sèment une certaine confusion quand on essaie de la faire connaître.
A titre d’exemple, un zèbre est très facilement identifiable pour une seule de ses caractéristiques, tandis que d’autres espèces ne peuvent être défini que par un ensemble de spécificités.
Sur cet exercice, on pourrait présenter la phycocyanine comme une substance bleue composante de la spiruline avec des propriétés remarquables pour la santé. Détaillons maintenant les facettes.
Si la spiruline est un être microscopique (soit 50 micron), composée notamment de phycocyanine. C'est une protéine 1000 fois plus petite — tout en constituant jusqu’à 25% de la masse.
Pour rappel, une protéine est un grosse molécule complexe d'acides aminés, constituant essentiel des matières organiques et des êtres vivants..
Pour se la représenter, on pourrait imaginer la spiruline comme un grand arbre et chaque molécule de phycocyanine, serait une feuille.
Autre facette, il s’agit d’un pigment bleu particulièrement intense, assez captivant.
La phycocyanine intervient dans le processus de photosynthèse de la spiruline au même titre que la chlorophylle. Chaque pigment est spécialisée dans l'absorption d'une partie du spectre lumineux. Comme son nom l’indique, la photo synthèse est un procédé qui permet grâce à l'énergie solaire, de transformer la matière minérale en matière organique. La photosynthèse caractérise les êtres vivants autotrophes.
Enfin, la phycocyanine est dotée de puissantes propriétés antioxydantes et anti-inflammatoires. En concentrant cette molécule, nous permettons à ceux qui souhaitent bénéficier de ses bienfaits de manière plus ciblée et intense.
La phycocyanine est un antioxydant naturel puissant qui aide à protéger les cellules du corps contre les agressions liées à l’oxydation. Voici quelques-unes de ses applications :
• Renforcement de l’immunité : Elle stimule la production de globules blancs, aidant ainsi à renforcer les défenses naturelles.
• Récupération sportive : En favorisant l’oxygénation musculaire et en luttant contre l’inflammation, elle est parfaite pour les athlètes.
• Équilibre et vitalité : Elle aide à réduire la fatigue et à mieux gérer le stress quotidien.
Nous sommes des producteurs locaux, fiers de proposer une spiruline 100% française, certifiée AB Bio, et maintenant sa dérivée : la phycocyanine. Nous consommons nous-mêmes les produits que nous vendons. Nous connaissons la traçabilité de nos produits de bout en bout, du bassin à l’ampoule, et cela, pour nous, fait toute la différence.
Nous accordons une grande importance à la traçabilité. Savoir d’où vient ce que vous consommez, comment il est produit et avec quels standards est primordial pour votre santé.
Nos produits sont fabriqués dans nos propres bassins en France, avec des contrôles rigoureux à chaque étape du processus.
La phycocyanine très concentrée peut avoir un goût assez marqué, parfois décrit comme proche de l’eau de bassin. Pour rendre son utilisation plus agréable, nous avons ajouté un arôme naturel de pomme.
Ce dernier, tout en étant léger, améliore considérablement l’expérience gustative, tout en préservant la naturalité du produit.
Absolument ! La phycocyanine peut être prise en plus de la spiruline pour booster encore davantage les bienfaits.
Notons ici, que la phycocyanine est un complément alimentaire au sens strict du terme tandis que la spiruline est un aliment à part entière. Donc la combinaison des deux permet d’obtenir une synergie optimale. La spiruline, riche en protéines, vitamines, minéraux et acides gras essentiels, apporte un spectre nutritionnel large. En parallèle, la phycocyanine, avec ses puissantes propriétés antioxydantes et anti-inflammatoires, agit de manière ciblée sur des processus biologiques clés tels que la protection cellulaire et la réduction du stress oxydatif.
Nos ampoules de phycocyanine concentrée à 5g/litre sont idéales pour une cure. Ce format est extrêmement pratique, facile à utiliser au quotidien, et permet de suivre une cure précise sans avoir à doser soi-même.
Il suffit d’ouvrir une ampoule et de la prendre le matin dans un verre d’eau ou mélangée à une source de vitamine C pour une absorption optimale.
D'après les premiers retours clients, beaucoup de ceux qui n'aiment pas la spiruline en comprimés ou en paillettes, sont prêts à essayer la phycocyanine pour sa couleur attractive et la prise d'ampoules est agréable.
Les ampoules de phycocyanine sont également très adaptées pour les personnes souffrant d’hémochromatose qui ne peuvent pas consommer de la spiruline.
Voici les principaux facteurs qui peuvent différencier les phycocyanines :
1. Concentration en phycocyanine :
Les produits de phycocyanine peuvent varier selon la concentration en phycocyanine pure qu’ils contiennent. Par exemple, une phycocyanine peut être diluée ou concentrée, souvent exprimée en termes de grammes de phycocyanine par litre (g/L). Une concentration élevée, comme 5 g/L, est considérée comme “haute concentration”.
2. Méthode d’extraction :
La méthode utilisée pour extraire la phycocyanine de la spiruline influence la qualité du produit final. Des méthodes plus douces, comme l’extraction à froid, préservent mieux les propriétés de la phycocyanine, tandis que des méthodes plus agressives peuvent affecter la pureté et l’efficacité.
La phycocyanine de Solis Culturae est extraite à partir de spiruline fraîche, tandis que d'autres l'extraient à partir de spiruline sèche.
3. Qualité et pureté :
Plus la cellule (de spiruline) est intègre avant extraction, plus la phycocyanine sera qualitative. Il est ainsi préférable d'extraire la phyco à partir de spiruline fraîche, car les spirulines sèches issues du spray-drying : procédé violent qui ne respecte pas l'intégrité des cellules.
4. Origine de la spiruline :
La source de spiruline (culture biologique, conditions de culture) influence la composition des phycocyanines. Les fermes à taille humaine favorisent une spiruline de meilleure qualité et donc avec un taux de phycocyanine élevée.
5. Stabilité et conservation :
La stabilité de la phycocyanine peut varier. Certaines sont plus sensibles à la lumière et à la chaleur, ce qui peut affecter leur couleur et leurs propriétés. Les formules ajoutant des stabilisateurs peuvent également influencer la qualité du produit. Notre extraction haute qualité, sous-vide permet de la stabiliser sans additifs. Certains stabilisateurs sont polémiques : la glycérine, l'alcool, …etc.
Pour faire connaître la phyco, on la rapproche souvent de l’EPO qui est très connue. D’un côté ça donne un repère, mais de l’autre, l’ambiguïté avec le dopage a quelque chose de déplaisant. La phycocyanine et l’EPO (érythropoïétine) sont deux substances bien distinctes bien qu’elles aient des effets similaires en ce qui concerne la production de globules rouges.
Clarification sur la phycocyanine et l’EPO :
• L’EPO est une hormone produite par les reins qui stimule la production de globules rouges dans la moelle osseuse. Elle est souvent associée au dopage sportif depuis l’affaire de l’équipe cycliste Festina.
• La phycocyanine, quant à elle, est un pigment naturel présent dans la spiruline et d’autres algues. Elle n’est pas une hormone et n’a pas d’action directe similaire à l’EPO. Cependant, des études suggèrent que la phycocyanine peut favoriser la production endogène d’EPO (c’est-à-dire une EPO produite naturellement par le corps), ce qui peut indirectement soutenir la production de globules rouges.
Les différences clés :
• Nature chimique : L’EPO est une protéine hormonale complexe, tandis que la phycocyanine est une protéine pigmentaire.
• Mécanisme d’action : L’EPO agit directement sur la moelle osseuse pour augmenter la production de globules rouges. La phycocyanine, en revanche, agit plus largement comme un antioxydant et anti-inflammatoire.
En tant que producteur, on peut se demander pourquoi extraire cette protéine si précieuse soit-elle de sa cellule vivante, la spiruline ? Et ainsi se priver des nombreux bienfaits que les vitamines et minéraux apportent dans leur ensemble.
La réponse est pourtant simple : la phycocyanine convient à des personnes qui n’aiment pas la spiruline, ou ne peuvent pas la consommer pour diverses raisons (excès de fer, allergie à la vitamine K, rares cas de troubles digestifs).
Par comparaison, ça revient un peu comme séparer la vitamine C de son fruit. La spiruline, tout comme une orange, regorge de bienfaits, mais en extraire la phycocyanine, c’est comme isoler la vitamine C d'une orange.
Au final, la meilleure manière de savoir si un complément alimentaire vous convient est de l’essayer par vous-même. La phycocyanine peut offrir un soutien naturel et puissant, et nous sommes fiers de proposer une solution concentrée, issue de nos propres bassins, respectueuse de la nature et de votre santé.
15 oct.
La phycocyanine est à la fois une molécule, une protéine, un pigment, un antioxydant, un anti-inflammatoire et ces diverses facettes… Voir
25 sept.
Nous recherchions un partenaire capable de produire une spiruline française certifiée BIO, de qualité, et pouvant fournir de gros volumes… Voir
30 août
Nathalie de Poix (membre ADASMAE et EABA) s'indigne de ce coup dur porté à la filière de spiruline française explications. Voir