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));