Problem in displaying BLOB image from MySQL database in a webpage

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.