CodeIgniter Forums
Problem in displaying BLOB image from MySQL database in a webpage - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forum-22.html)
+--- Thread: Problem in displaying BLOB image from MySQL database in a webpage (/thread-47965.html)



Problem in displaying BLOB image from MySQL database in a webpage - El Forum - 12-29-2011

[eluser]Unknown[/eluser]
To display an image stored in MySQL database I am using the following code in my controller
Code:
function display_image($id){
  
        $user='root'; $password='Passw0rd'; $db='pppmis';
        mysql_connect('localhost', $user, $password) or die('I cannot connect to db: ' .  
        mysql_error());
        mysql_select_db('pppmis');

        $query = mysql_query("SELECT * FROM project_image WHERE projectid = ".$id);
        $row = mysql_fetch_array($query);
        $content = $row['image'];

        header("Content-type: ".$row['mime']);
        echo $content;
}

which is not working, all that I am getting is a string as output as below
Quote:http://localhost/application/index.php/manage_project/display_image/1

but at the same time if I use this function in a simple php file and directly call the function in that file it works and outputs the image as desired.

I have also tried using
Code:
$this->output->set_header('Content-type: image/jpg');
        $this->output->set_output($content);
without any luck.

Any help here would be of much appreciation.

Thanks and happy new year.