PHP PDO 示例

$pdo = new PDO("mysql:host={$DB_Host};dbname={$DB_Database}", $DB_User, $DB_Password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query= 'select movie_douban_id from yp_movie where movie_id > 142432';
$res = $pdo->prepare($query);
$res->execute();
while($row = $res->fetch(PDO::FETCH_ASSOC)){
$boolen = updateMovieInfo($row['movie_douban_id']);
}

$tmp = $pdo->query('select bd_title from yp_ranklist where bd_type = '.$k.' order by bd_sort asc')->fetchAll(PDO::FETCH_ASSOC);
$tmp = array_column($tmp,'bd_title');

$stmt = $pdo->prepare("select * from yp_douban_top order by top_sort asc;");
$stmt->execute();
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);