A simple way to use PDO in PHP5.2, a way to use php5.2pdo

The example in this article describes the simple way to use PDO in PHP5.2. Share it with everyone for your reference, the details are as follows:

1. PDO configuration

1. Make sure the PHP version is 5.2.5 or above
2. Find the Dynamic Extensions extension section in php.ini and remove the semicolon
in front of extension=php_pdo.dll 3. Remove the semicolon in front of the corresponding database PDO extension, such as: extension=php_pdo_mysql.dll

2. Database in the example

CREATE TABLE tablename (
  id mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  str varchar(50) NOT NULL DEFAULT '''',
  PRIMARY KEY (id)
);

3. Program Example

<&#63;php
$dsn = "mysql:host=localhost;dbname=test";
$user = ''root'';
$passwd = ''123456'';
try{
    $db = new PDO($dsn, $user, $passwd);
}catch (PDOException $e)
{
    echo "鏈接數(shù)據(jù)庫失??！";
    print "異常信息: ". $e->getMessage() . "<br/>";
    print "異常文件: " . $e->getFile() . "<br/>";
    print "異常行號: " . $e->getLine() . "<br/>";
    exit();
}
//$sql = "INSERT INTO tablename SET str = ''Hello''";
//$count = $db->exec($sql); //返回值為影響的行數(shù)
//$sql = "DELETE FROM tablename WHERE str = ''Hello'' LIMIT 1";
//$count = $db->exec($sql); //返回值為影響的行數(shù)
//預(yù)處理需要查詢的SQL語句
//$db->setAttribute(PDO::ATTR_CASE, PDO::CASE_NATURAL); //列名按照原始的方式（字段）
$sql = "SELECT * FROM tablename WHERE id < :id AND str = :string"; //sql語句（參數(shù)綁定方式）
$query = $db->prepare($sql); //預(yù)處理
//用一組綁定參數(shù)執(zhí)行一遍查詢
$query->execute(array('':id''=>1, '':string''=>''Hello'')); //處理語句（參數(shù)綁定方式）
//$query->setFetchMode(PDO::FETCH_ASSOC); 關(guān)聯(lián)數(shù)組形式（只通過字段名下標(biāo)訪問數(shù)組內(nèi)容）
while($item = $query->fetch(PDO::FETCH_ASSOC)) //循環(huán)獲取數(shù)據(jù)
{
    echo $item[''id''].":".$item[''str'']."<br/>";
    //print_r ($item);
}
//用另一組綁定參數(shù)，再執(zhí)行一遍查詢
$query->execute(array('':id''<=10, '':string''=>''HelloWorld'')); //處理語句（參數(shù)綁定方式）
//$query->setFetchMode(PDO::FETCH_ASSOC); 關(guān)聯(lián)數(shù)組形式（只通過字段名下標(biāo)訪問數(shù)組內(nèi)容）
while($item = $query->fetch(PDO::FETCH_ASSOC)) //循環(huán)獲取數(shù)據(jù)
{
    echo $item[''id''].":".$item[''str'']."<br/>";
    //print_r ($item);
}
$db = null; //釋放數(shù)據(jù)庫鏈接
&#63;>

Readers who are interested in more PHP-related content can check out the special topics of this site: "Summary of PHP office document operation skills (including word, excel, access, ppt)", "Summary of PHP date and time usage", "php-oriented "Introduction Tutorial on Object Programming", "Summary of PHP String Usage", "Introduction Tutorial on PHP MySQL Database Operation" and "Summary of Common PHP Database Operation Skills"

I hope this article will be helpful to everyone in PHP programming.

Articles you may be interested in:

• How to simply use PDO in the database abstraction layer in php
• Detailed explanation of the PDO class in PHP
• PDO in php Methods to implement database additions, deletions, modifications and queries
• PHP uses PDO to connect to the ACCESS database
• Detailed explanation of the use of PDO, the mysql connection method in php
• Comparative analysis of pdo and mysqli database connection methods in php
• Summary of some understanding of PHP PDO
• Detailed explanation of how php uses PDO
• How php uses pdo to connect and query sql database
• php uses pdo to connect and report errors Solution to Connection failed SQLSTATE
• PHP implements mysql database operation class of PDO
• The difference between PHP PDOStatement object bindpram(), bindvalue() and bindcolumn
• PHP PDO Operation summary
• How to install PhpDocumentor 2 and generate API documentation