芝麻web文件管理V1.00
编辑当前文件:/home2/sdektunc/.trash/libraries.8/vendor/joomla/database/src/DatabaseInterface.php
'row_value']. * * @return mixed The return value or null if the query failed. * * @since 2.0.0 * @throws \RuntimeException */ public function loadAssoc(); /** * Method to get an array of the result set rows from the database query where each row is an associative array * of ['field_name' => 'row_value']. The array of rows can optionally be keyed by a field name, but defaults to * a sequential numeric array. * * NOTE: Choosing to key the result array by a non-unique field name can result in unwanted * behavior and should be avoided. * * @param string $key The name of a field on which to key the result array. * @param string $column An optional column name. Instead of the whole row, only this column value will be in the result array. * * @return mixed The return value or null if the query failed. * * @since 2.0.0 * @throws \RuntimeException */ public function loadAssocList($key = null, $column = null); /** * Method to get an array of values from the
$offset
field in each row of the result set from the database query. * * @param integer $offset The row offset to use to build the result array. * * @return mixed The return value or null if the query failed. * * @since 2.0.0 * @throws \RuntimeException */ public function loadColumn($offset = 0); /** * Method to get the first row of the result set from the database query as an object. * * @param string $class The class name to use for the returned row object. * * @return mixed The return value or null if the query failed. * * @since 2.0.0 * @throws \RuntimeException */ public function loadObject($class = \stdClass::class); /** * Method to get an array of the result set rows from the database query where each row is an object. The array * of objects can optionally be keyed by a field name, but defaults to a sequential numeric array. * * NOTE: Choosing to key the result array by a non-unique field name can result in unwanted behavior and should be avoided. * * @param string $key The name of a field on which to key the result array. * @param string $class The class name to use for the returned row objects. * * @return mixed The return value or null if the query failed. * * @since 2.0.0 * @throws \RuntimeException */ public function loadObjectList($key = '', $class = \stdClass::class); /** * Method to get the first field of the first row of the result set from the database query. * * @return mixed The return value or null if the query failed. * * @since 2.0.0 * @throws \RuntimeException */ public function loadResult(); /** * Method to get the first row of the result set from the database query as an array. * * Columns are indexed numerically so the first column in the result set would be accessible via
$row[0]
, etc. * * @return mixed The return value or null if the query failed. * * @since 2.0.0 * @throws \RuntimeException */ public function loadRow(); /** * Method to get an array of the result set rows from the database query where each row is an array. The array * of objects can optionally be keyed by a field offset, but defaults to a sequential numeric array. * * NOTE: Choosing to key the result array by a non-unique field can result in unwanted behavior and should be avoided. * * @param string $key The name of a field on which to key the result array. * * @return mixed The return value or null if the query failed. * * @since 2.0.0 * @throws \RuntimeException */ public function loadRowList($key = null); /** * Locks a table in the database. * * @param string $tableName The name of the table to unlock. * * @return $this * * @since 2.0.0 * @throws \RuntimeException */ public function lockTable($tableName); /** * Quotes and optionally escapes a string to database requirements for use in database queries. * * @param array|string $text A string or an array of strings to quote. * @param boolean $escape True (default) to escape the string, false to leave it unchanged. * * @return string * * @since 2.0.0 */ public function quote($text, $escape = true); /** * Quotes a binary string to database requirements for use in database queries. * * @param string $data A binary string to quote. * * @return string The binary quoted input string. * * @since 1.7.0 */ public function quoteBinary($data); /** * Wrap an SQL statement identifier name such as column, table or database names in quotes to prevent injection * risks and reserved word conflicts. * * @param array|string $name The identifier name to wrap in quotes, or an array of identifier names to wrap in quotes. * Each type supports dot-notation name. * @param array|string $as The AS query part associated to $name. It can be string or array, in latter case it has to be * same length of $name; if is null there will not be any AS part for string or array element. * * @return array|string The quote wrapped name, same type of $name. * * @since 2.0.0 */ public function quoteName($name, $as = null); /** * Renames a table in the database. * * @param string $oldTable The name of the table to be renamed * @param string $newTable The new name for the table. * @param string $backup Table prefix * @param string $prefix For the table - used to rename constraints in non-mysql databases * * @return $this * * @since 2.0.0 * @throws \RuntimeException */ public function renameTable($oldTable, $newTable, $backup = null, $prefix = null); /** * This function replaces a string identifier with the configured table prefix. * * @param string $sql The SQL statement to prepare. * @param string $prefix The table prefix. * * @return string The processed SQL statement. * * @since 2.0.0 */ public function replacePrefix($sql, $prefix = '#__'); /** * Select a database for use. * * @param string $database The name of the database to select for use. * * @return boolean * * @since 2.0.0 * @throws \RuntimeException */ public function select($database); /** * Sets the SQL statement string for later execution. * * @param mixed $query The SQL statement to set either as a Query object or a string. * @param integer $offset The affected row offset to set. {@deprecated 3.0 Use LimitableInterface::setLimit() instead} * @param integer $limit The maximum affected rows to set. {@deprecated 3.0 Use LimitableInterface::setLimit() instead} * * @return $this * * @since 2.0.0 */ public function setQuery($query, $offset = 0, $limit = 0); /** * Method to commit a transaction. * * @param boolean $toSavepoint If true, commit to the last savepoint. * * @return void * * @since 2.0.0 * @throws \RuntimeException */ public function transactionCommit($toSavepoint = false); /** * Method to roll back a transaction. * * @param boolean $toSavepoint If true, rollback to the last savepoint. * * @return void * * @since 2.0.0 * @throws \RuntimeException */ public function transactionRollback($toSavepoint = false); /** * Method to initialize a transaction. * * @param boolean $asSavepoint If true and a transaction is already active, a savepoint will be created. * * @return void * * @since 2.0.0 * @throws \RuntimeException */ public function transactionStart($asSavepoint = false); /** * Method to truncate a table. * * @param string $table The table to truncate * * @return void * * @since 2.0.0 * @throws \RuntimeException */ public function truncateTable($table); /** * Unlocks tables in the database. * * @return $this * * @since 2.0.0 * @throws \RuntimeException */ public function unlockTables(); /** * Updates a row in a table based on an object's properties. * * @param string $table The name of the database table to update. * @param object $object A reference to an object whose public properties match the table fields. * @param array|string $key The name of the primary key. * @param boolean $nulls True to update null fields or false to ignore them. * * @return boolean * * @since 2.0.0 * @throws \RuntimeException */ public function updateObject($table, &$object, $key, $nulls = false); }