mint/app/media/get.php

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

    if(isset($_GET["id"])){
        $query = "SELECT * FROM media WHERE id = ? limit 0 , 1";
        $stmt = $dbh->prepare($query);
        $stmt->execute(array($_GET["id"]));
        $fMedia = $stmt->fetchAll(PDO::FETCH_ASSOC);
        $dbh=null;
        if(count($fMedia)>0){
            $imgLink = $fMedia[0]["link"];
            if(substr($imgLink,0,6)=="media:"){
                echo _DIR_USER_IMG_.'/'.substr($imgLink,6);
            }
            else{
                echo $imgLink;
            }
        }
        else{
            echo "";
        }        
    }
    else{
        $query = "SELECT id , link  FROM media WHERE type = '3' order by create_time DESC limit 0 , 10 ";
        $stmt = $dbh->prepare($query);
        $stmt->execute(array());
        $fMedia = $stmt->fetchAll(PDO::FETCH_ASSOC);
        $dbh=null;
        if(count($fMedia)>0){
            
            $imgLink = $fMedia[0]["link"];
            if(substr($imgLink,0,6)=="media:"){
                echo _DIR_USER_IMG_.'/'.substr($imgLink,6);
            }
            else{
                echo $imgLink;
            }
        }
        else{
            echo "";
        }         
    }

    

?>