php PDO连接MySql

PDO连接MySql

<?php
try{
	$db_conn = new PDO('mysql:host=localhost;dbname=库名','root','密码');
}catch(PDOException $e){
	echo "Could not connect to database";
}
$query = $db_conn->query("SQL语句");
$row = $query->fetch();

?>

数据提取模式

PDO::FETCH_ASSOC 以数据库字段为键的方式返回结果      $row = $query->fetch(PDO::FETCH_ASSOC);

PDO::FETCH_NUM 以数字为键的方式 返回结果$row = $query->fetch(PDO::FETCH_NUM);

PDO预处理语句

$sql = "select * from Dingdantianjia where ID = :recipe_id order by ID desc limit 1";
$stmt = $db_conn->prepare($sql);
$stmt->execute(array('recipe_id' => 11185020));
$row = $stmt->fetch();

:recipe_id  为占位符   占位符不需要名字，也可以使用？符号为变量保留一个位置作为没有命名的占位符。

例：

$sql = "select name , description, chef from recipes where chef = ? and category_id = ?";
$stmt = $db_conn->prepare($sql);
$stmt->execute(array('lorna',3));
$recipe = $stmt->fetch();