• 홈
• db

PHP 클래스 db, kirby

파일 보기 프로젝트 열기: bastianallgeier/kirby 1 사용 예제들

공개 프로퍼티들

프로퍼티	타입	설명
$trace	array	Traces all db queries

공개 메소드들

메소드	설명
affected ( ) : integer	Returns the number of affected rows for the last query
charset ( string $charset = 'utf8' ) : mixed	Sets the charset for all queries The default and recommended charset is utf8
column ( string $table, string $column, mixed $where = null, string $order = null, integer $page = null, integer $limit = null ) : mixed	Returns all values from single column of a table
connect ( ) : mixed	The core connection method Tries to connect to the server Selects the database and sets the charset
connection ( ) : mixed	Returns the current connection or false
count ( string $table, mixed $where = '' ) : integer	Counts a number of rows in a table
database ( string $database ) : mixed	Selects a database
delete ( string $table, mixed $where = '' ) : mixed	Runs a DELETE query
disconnect ( ) : boolean	Disconnects from the server
error ( string $msg = null, boolean $exit = false ) : mixed	An internal error handler
escape ( string $value ) : string	Escapes unwanted stuff in values like slashes, etc.
execute ( string $sql ) : mixed	Executes a MySQL query without result set.
fetch ( resource $result, const $type = MYSQL_ASSOC ) : array	Shortcut for mysql_fetch_array
field ( string $table, string $field, mixed $where = null, string $order = null ) : mixed	Returns a single field value from a table
fields ( string $table ) : array	Returns an array of fields in a given table
in ( array $array ) : string	A simplifier to build IN clauses
insert ( string $table, mixed $input, boolean $ignore = false ) : mixed	Runs a INSERT query
insert_all ( string $table, array $fields, array $values ) : mixed	Runs a INSERT query with values
join ( string $table_1, string $table_2, string $on, mixed $select, mixed $where = null, string $order = null, integer $page = null, integer $limit = null, string $type = "JOIN" ) : mixed	Joins two tables and returns data from them
last_id ( ) : integer	Returns the last returned insert id
left_join ( string $table_1, string $table_2, string $on, mixed $select, mixed $where = null, string $order = null, integer $page = null, integer $limit = null ) : mixed	Runs a LEFT JOIN
max ( string $table, string $column, mixed $where = null ) : mixed	Gets the maximum value in a column of a table
min ( string $table, string $column, mixed $where = null ) : mixed	Gets the minimum value in a column of a table
prefix ( string $table ) : string	Adds a prefix to a table name if set in c::set('db.prefix', 'myprefix_'); This makes it possible to use table names in all methods without prefix and it will still be applied automatically.
query ( string $sql, boolean $fetch = true ) : mixed	Runs a MySQL query.
replace ( string $table, mixed $input ) : mixed	Runs a REPLACE query
row ( string $table, mixed $select = '*', mixed $where = null, string $order = null ) : mixed	Returns a single row from a table
search_clause ( string $search, array $fields, string $mode = 'OR' ) : string	A simplifier to build search clauses
select ( string $table, mixed $select = '*', mixed $where = null, string $order = null, integer $page = null, integer $limit = null, boolean $fetch = true ) : mixed	Returns multiple rows from a table
select_clause ( $fields ) : string	Builds a select clause from a simple array
simple_fields ( array $array ) : array	Strips table specific column prefixes from the result array
sum ( string $table, string $column, mixed $where = null ) : mixed	Gets the sum of values in a column of a table
update ( string $table, mixed $input, mixed $where ) : mixed	Runs an UPDATE query
values ( array $input ) : string	Makes it possible to use arrays for inputs instead of MySQL strings
where ( array $array, string $method = 'AND' ) : string	A handler to convert key/value arrays to an where clause
with ( string $field, string $char ) : string	An easy method to build a part of the where clause to find stuff by its first character

메소드 상세

프로퍼티 상세