/PHP/Download image from mysql using php

Download image from mysql using php

//You can save this to test.php and call it with test.php?id=1 for example
<?php

//Database class with PDO (MySQL/MariaDB)
require_once("database.php"); //If you need this, write to office@predl.cc i'll send you the db class

//Connect to database
$database = new Database();
$pdo = $database->dbConnection();

//Get ID from GET (better POST but for easy debug...)
if (isset($_GET["id"])) {
	$id=(int)$_GET["id"];
} else {
  echo "Wrong input";
  exit;
}

//Prepare PDO SQL
$q = $pdo->prepare("SELECT * FROM `table_with_image` WHERE `id`=:p_id");

//Add some data
$q->bindparam(":p_id", $id); //Filter user input, no sanitize necessary here

//Do the db query
$q->execute();

//If something found (always only 1 record!)
if ($q->rowCount() == 1) {
  
  	//Get the content of the record into $row
	$row = $q->fetch(PDO::FETCH_ASSOC); //Everything with id=$id should be in record buffer
  	
  	//This is the image blob mysql item  
  	$image = $row['image'];
  	
  	//Clean disconnect
  	$database->disconnect();
    
  	//Now start the header, caution: do not output any other header or other data!
  	header("Content-type: image/jpeg");
    header('Content-Disposition: attachment; filename="table_with_image_image'.$id.'.jpg"');
    header("Content-Transfer-Encoding: binary"); 
    header('Expires: 0');
    header('Pragma: no-cache');
    header("Content-Length: ".strlen($image));
    //Output plain image from db
	echo $image;
} else {
  //Nothing found with that id, output some error
  $database->disconnect();
  echo "No image found";
}

//No output and exceution further this point
exit();

Source: stackoverflow.com

Similar codes

0 vote180 views1 answer
Placeholder for select php
PHP
-1 vote221 views1 answer
Laravel carbon y-m-d
PHP Laravel
0 vote313 views1 answer
How to use “find_in_set” in cakephp 3 find method
PHP CakePHP
-1 vote203 views3 answers
Grouping route in laravel
PHP Laravel
1 vote231 views2 answers
Php example
PHP
4 votes180 views2 answers
Php convert words with spaces to camelcase
PHP
0 vote179 views1 answer
Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
PHP
0 vote212 views1 answer
->store() laravel change name
PHP Laravel
0 vote175 views1 answer
Php location same page
PHP
0 vote201 views1 answer
Laravel add many to many
PHP Laravel