DB
Prev
Next
DB
API dostępowe do baz danych SQL
Table of Contents
Introduction - DSN
— The Data Source Name
Wstęp - nawiązanie połączenia
— łączenie i rozłączanie z baza danych
Introduction - Query
— Performing queries
Introduction - Results
— Obtaining data from query results
Introduction - Prepare & Execute
— Prepare and execute SQL statements
Introduction - autoPrepare & autoExecute
— Automatically prepare and execute SQL statements
Introduction - Portability
— Database portability features
Introduction - Sequences
— Sequences and auto-incrementing
DB
— Klasa główna
DB::connect()
— Nawiązanie połączenia z bazą danych
DB::isError()
— Określa czy zmienna jest obiektem DB_Error
DB_common
— Intefejs dostępowy do bazy danych
DB_common::affectedRows()
— Finds number of rows affected by a data changing query
DB_common::autoCommit()
— Turns auto-commit on or off
DB_common::autoExecute()
— Prepares and runs an INSERT or UPDATE query based on variables you supply
DB_common::autoPrepare()
— Prepares an INSERT or UPDATE statement based on variables you supply
DB_common::commit()
— Commits the current transaction
DB_common::createSequence()
— Creates a new sequence
DB_common::disconnect()
— Disconnects from a database
DB_common::dropSequence()
— Deletes a sequence
DB_common::escapeSimple()
— Escapes a string according to the current DBMS's standards
DB_common::execute()
— Executes a prepared SQL statement
DB_common::executeMultiple()
— Runs a prepared SQL statement for each element of an array
DB_common::freePrepared()
— Releases resources associated with a prepared SQL statement
DB_common::getAll()
— Runs a query and returns all the data as an array
DB_common::getAssoc()
— Runs a query and returns the data as an array
DB_common::getCol()
— Runs a query and returns the data from a single column
DB_common::getListOf()
— Views database system information
DB_common::getOne()
— Runs a query and returns the first column of the first row
DB_common::getOption()
— Determines current state of a PEAR DB configuration option
DB_common::getRow()
— Runs a query and returns the first row
DB_common::limitQuery()
— Sends a LIMIT query to the database
DB_common::nextId()
— Returns the next number from a sequence
DB_common::nextQueryIsManip()
— Informs the DB driver that the next query is a manipulation query
DB_common::prepare()
— Prepares a SQL statement for later execution
DB_common::provides()
— Checks if the DBMS supports a particular feature
DB_common::query()
— Sends a query to the database
DB_common::quote()
— DEPRECATED: Quotes a string
DB_common::quoteIdentifier()
— Formats a string so it can be safely used as an identifier
DB_common::quoteSmart()
— Formats input so it can be safely used as a literal
DB_common::rollback()
— Rolls back the current transaction
DB_common::setFetchMode()
— Sets the default fetch mode
DB_common::setOption()
— Sets run-time configuration options for PEAR DB
DB_common::tableInfo()
— Gets info about columns in a table or a query result
DB_result
— Zestaw wyników DB
DB_result::fetchInto()
— Pobiera wiersz wyników do zmiennej
DB_result::fetchRow()
— Pobiera wiersz wyników zapytania
DB_result::free()
— Zwolnienie zestawu wyników
DB_result::nextResult()
— Pobiera zestaw wynikowy z wielu zapytań
DB_result::numCols()
— Pobiera ilość kolumn w zestawie wynikowym
DB_result::numRows()
— Pobiera ilość wierszy w zestawie wynikowym
DB_Error
— Obiekt błędu DB