PDO预处理查询，插入

查询

$sql = 'select * from landlord where landlord_name=:landlord_name';$stmt = $pdo->prepare($sql);$param=array(    ':landlord_name'=>$landlord_name);$stmt->execute($param);$row=$stmt->fetch(PDO::FETCH_ASSOC);

插入

$query = "insert into landlord (landlord_name,landlord_pwd,token) values(?,?,?)";$stmt = $pdo->prepare($query);$arr = $stmt->execute(array($landlord_name,$landlord_pwd,$token));