PHP中的PDO函數(shù)庫

PHP中的PDO函數(shù)庫

PDO->beginTransaction() — 標(biāo)明回滾起始點(diǎn)

PDO->commit() — 標(biāo)明回滾結(jié)束點(diǎn)，并執(zhí)行SQL

PDO->__construct() — 建立一個(gè)PDO鏈接數(shù)據(jù)庫的實(shí)例

PDO->errorCode() — 獲取錯(cuò)誤碼

PDO->errorInfo() — 獲取錯(cuò)誤的信息

PDO->exec() — 處理一條SQL語句，并返回所影響的條目數(shù)

PDO->getAttribute() — 獲取一個(gè)“數(shù)據(jù)庫連接對象”的屬性

PDO->getAvailableDrivers() — 獲取有效的PDO驅(qū)動器名稱

PDO->lastInsertId() — 獲取寫入的最后一條數(shù)據(jù)的主鍵值

PDO->prepare() — 生成一個(gè)“查詢對象”

PDO->query() — 處理一條SQL語句，并返回一個(gè)“PDOStatement”

PDO->quote() — 為某個(gè)SQL中的字符串添加引號

PDO->rollBack() — 執(zhí)行回滾

PDO->setAttribute() — 為一個(gè)“數(shù)據(jù)庫連接對象”設(shè)定屬性

PDOStatement->bindColumn() — Bind a column to a PHP variable

PDOStatement->bindParam() — Binds a parameter to the specified variable name

PDOStatement->bindValue() — Binds a value to a parameter

PDOStatement->closeCursor() — Closes the cursor, enabling the statement to be executed again.

PDOStatement->columnCount() — Returns the number of columns in the result set

PDOStatement->errorCode() — Fetch the SQLSTATE associated with the last operation on the statement handle

PDOStatement->errorInfo() — Fetch extended error information associated with the last operation on the statement handle

PDOStatement->execute() — Executes a prepared statement

PDOStatement->fetch() — Fetches the next row from a result set

PDOStatement->fetchAll() — Returns an array containing all of the result set rows

PDOStatement->fetchColumn() — Returns a single column from the next row of a result set

PDOStatement->fetchObject() — Fetches the next row and returns it as an object.

PDOStatement->getAttribute() — Retrieve a statement attribute

PDOStatement->getColumnMeta() — Returns metadata for a column in a result set

PDOStatement->nextRowset() — Advances to the next rowset in a multi-rowset statement handle

PDOStatement->rowCount() — Returns the number of rows affected by the last SQL statement

PDOStatement->setAttribute() — Set a statement attribute

PDOStatement->setFetchMode() — Set the default fetch mode for this statement