php pdo函數庫用法詳解

pdo->begintransaction() — 標示回滾起始點
pdo->commit() — 標示回滾結束點，並執行sql
pdo ->__construct() — 建立一個pdo連結資料庫的實例
pdo->errorcode() — 取得錯誤碼
pdo->errorinfo() — 取得錯誤的資訊
pdo->exec() —處理一條sql語句，並傳回所影響的條目數
pdo->getattribute() — 取得一個「資料庫連線物件」的屬性
pdo->getavailabledrivers() — 取得有效的pdo磁碟機名稱
 pdo->lastinsertid() — 取得寫入的最後一條資料的主鍵值
pdo->prepare() — 產生一個「查詢物件」
pdo->query() — 處理一sql語句，並傳回一個「pdostatement」
pdo->quote() — 為某個sql中的字串加上引號
pdo->rollback() — 執行回滾
pdo->setattribute() — 為一個「資料庫連線物件」設定屬性

二、pdostatement

pdostatement->bindcolumn() — bind a column to a php variable
pdostatement->bindparam() — bind ifiedmeter
pdostatement->bindvalue() — binds a value to a parameter
pdostatement->closecursor() — closes the cursor, enabling the statement to be executed again.
pdostatement-co. 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 assocation the lastorinfo() — fetch extended error information assocation the statement handle
pdostatement->execute() — executes a prepared statement
pdostatement->fetch() — fetches the next row from a result set
pdostatement->fetchall() — returnsan an 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 pdostatement->getattribute() — retrieve a statement attribute
pdostatement->getcolumnmeta() — returns metadata for a column in a result set
pdostatement->nextrowset() — adces in the next statement handle
pdostatement->rowcount() — returns the number of rows affected by the last sql statement
pdostatement->setattribute() — set a statement attribute
pdostatement-> statement attribute

詳解1) pdo中的資料庫連接

$dsn = 'mysql:dbname=ent;host=127.0.0.1′;
$user = 'root';try {
$dbh = new pdo($dsn, $user, $password, array(pdo::attr_persistent => true));
$dbh->query(' set names utf8;');
foreach ($dbh->query('select * from tpm_juese') as $row) {
print_r($row);
}
} catch (pdoexception $e) {
echo 'connection failed: ' . $e->getmessage();
}