mint/app/media/function.php

<?php
require_once '../path.php';
function media_get($idlist){
    //打开数据库
    $dns = "sqlite:"._FILE_DB_MEDIA_;
    $dbh = new PDO($dns, "", "",array(PDO::ATTR_PERSISTENT=>true));
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);  

    /*  使用一个数组的值执行一条含有 IN 子句的预处理语句 */
    /*  创建一个填充了和params相同数量占位符的字符串 */
    $place_holders = implode(',', array_fill(0, count($idlist), '?'));

    $query = "SELECT * FROM media WHERE id IN ($place_holders) ";
    $stmt = $dbh->prepare($query);
    $stmt->execute($idlist);
    $fMedia = $stmt->fetchAll(PDO::FETCH_ASSOC);
    $dbh=null;
    return($fMedia);

}

?>