/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

1 vote245 views2 answers
Find index of a character in a string php
PHP
4 votes218 views1 answer
Use str laravel
PHP Laravel
21 votes215 views3 answers
Brew version
PHP
18 votes249 views5 answers
If else statement in laravel blade
PHP Laravel
37 votes234 views3 answers
Character split php
PHP
0 vote262 views1 answer
Start day picker and end date picker in php
PHP
3 votes244 views4 answers
Class 'App\Http\Controllers\Response' not found
PHP
1 vote216 views2 answers
Download php7.4-mbstring ubuntu
PHP
1 vote240 views2 answers
Set nav link active on the basis of route laravel
PHP Laravel
1 vote216 views1 answer
Break and continue in laravel
PHP