Advertisement
Guest User

Untitled

a guest
Jun 28th, 2016
176
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.75 KB | None | 0 0
  1. $file_name = (int)$routes[2];
  2. $file = '../../images/'.$file_name;
  3.  
  4. $sql = "SELECT i.image_filetype as filetype, i.image_type as type, i.image_key "
  5.         . "FROM images i "
  6.         . "WHERE i.image_deleted IS NULL "
  7.         . "AND i.image_id = :filename LIMIT 1";
  8. $results = $db_connect->prepare($sql);
  9. $results->bindParam(':filename', $file_name, PDO::PARAM_INT);
  10. $results->execute();
  11. $db_image = $results->fetchAll(PDO::FETCH_ASSOC);
  12. foreach($db_image as $output){
  13.     // PROFILE PICTURE
  14.     if($output['type'] === '1'){
  15.         if(file_exists($file.'.'.$output['filetype'])){
  16.             $image = file_get_contents($file.'.'.$output['filetype']);
  17.             header('Content-type: image/jpeg);
  18.             echo $image;
  19.         }else{$error_code = 4;}
  20.    }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement