zittCON
로그인 회원가입
클래스·함수 명세

DB

Zittme\Framework\DB 클래스의 공개 메서드 목록입니다. 이 문서는 Zittme 코어 소스에서 자동 생성되었습니다.

소스: common/framework/DB.php

공개 메서드

  • static function getInstance(string $type = 'master')
  • Get a singleton instance of the DB class.
  • function __construct(string $type, array $config)
  • Constructor.
  • function connect(array $config)
  • Connect to the database.
  • function disconnect()
  • Disconnect from the database.
  • function getHandle()
  • Get the PDO handle for direct manipulation.
  • function prepare(string $statement, array $driver_options = [])
  • Create a prepared statement.
  • function query(string $query_string, ...$args)
  • Execute a query string with or without parameters.
  • function executeQuery(string $query_id, $args = [], array $column_list = [], string $result_type = 'auto', string $result_class = '')
  • Execute an XML-defined query.
  • function fetch($stmt, int $last_index = 0, string $result_type = 'auto', string $result_class = '')
  • Fetch results from a query.
  • function beginTransaction()
  • Alias to begin().
  • function begin()
  • Begin a transaction.
  • function rollback()
  • Roll back a transaction.
  • function commit()
  • Commit a transaction.
  • function getTransactionLevel()
  • Get the current transaction level.
  • function getAffectedRows()
  • Get the number of rows affected by the last statement.
  • function getInsertID()
  • Get the auto-incremented ID generated by the last statement.
  • function getNextSequence()
  • Get the next global sequence value.
  • function isValidOldPassword(string $password, string $saved_password)
  • Check if a password is valid according to MySQL's old password hashing algorithm.
  • function isTableExists(string $table_name)
  • Check if a table exists.
  • function createTable(string $filename = '', string $content = '')
  • Create a table.
  • function dropTable(string $table_name)
  • Drop a table.
  • function isColumnExists(string $table_name, string $column_name)
  • Check if a column exists.
  • function addColumn(string $table_name, string $column_name, string $type = 'number', $size = null, $default = null, $notnull = false, $after_column = null)
  • Add a column.
  • function modifyColumn(string $table_name, string $column_name, string $type = 'number', $size = null, $default = null, $notnull = false, $after_column = null, $new_name = null, $new_charset = null)
  • Modify a column.
  • function dropColumn(string $table_name, string $column_name)
  • Drop a column.
  • function getColumnInfo(string $table_name, string $column_name)
  • Get column information.
  • function isIndexExists(string $table_name, string $index_name)
  • Check if an index exists.
  • function addIndex(string $table_name, string $index_name, $columns, $type = '', $options = '')
  • Add an index.
  • function dropIndex(string $table_name, string $index_name)
  • Drop an index.
  • function getIndexInfo(string $table_name, string $index_name)
  • Get index information.
  • function addPrefixes(string $query_string)
  • Add table prefixes to a query string.
  • function addQuotes($str)
  • Escape a string according to current DB settings.
  • function getBestSupportedCharset()
  • Find out the best supported character set.
  • function isError()
  • Check if the last statement produced an error.
  • function getError()
  • Get the last error information.
  • function setError(int $errno = 0, string $errstr = 'success')
  • Set error information to instance properties.
  • function clearError()
  • Clear error information.
  • function getQueryLog(string $query, float $elapsed_time)
  • Generate a query log entry.
  • function setQueryLog(array $log)
  • Send an entry to the query log for debugging.
  • function addElapsedTime(float $elapsed_time)
  • Add elapsed time.
  • function getQueryElapsedTime()
  • Get total time spent during queries.
  • function getTotalElapsedTime()
  • Get total time spent in this class.
  • function setDebugComment(bool $enabled)
  • Enable or disable debug comments.
  • function __get(string $key)
  • Magic method to support some read-only properties for backward compatibility.
  • function _query($query_string)
  • Execute a literal query string.
  • function _fetch($stmt, int $last_index = 0)
  • Fetch results from a query.
  • static function create()
  • Old alias to getInstance().
  • function db_fetch_object(\PDOStatement $stmt)
  • Old alias to $stmt->fetchObject().
  • function db_free_result(\PDOStatement $stmt)
  • Old alias to $stmt->closeCursor().
  • function db_insert_id()
  • Old alias to getInsertID().
  • static function getSupportedList()
  • Get the list of supported database drivers.
  • static function getEnableList()
  • Get the list of enabled database drivers.
  • static function getDisableList()
  • Get the list of disabled database drivers.
  • function isSupported()
  • Check if the current instance is supported.
  • function isConnected()
  • Check if the current instance is connected.
  • function close()
  • Close the DB connection.
  • function createTableByXmlFile($filename)
  • Methods related to table creation.
  • function createTableByXml($xml_doc)
  • function _createTable($xml_doc)
  • function getCountCache()
  • Methods related to the click count cache feature.
  • function putCountCache()
  • function resetCountCache()
  • function getParser()
  • Other deprecated methods.
  • function _getSlaveConnectionStringIndex()
  • function _getConnection()
  • function _dbInfoExists()