Get Image url from database

Question

How to get image from database and display it in magento?

my imgs.php is:

  $a = $_SESSION['id'];
  $ob = Mage::getModel('management/file')->getCollection();
        $res = $ob->addFieldToFilter('task_id',$a);
    //  $res = $ob->addFieldToFilter('comment_id',$id); 
        //$img = "";
        foreach($res as $val)
        {
            $img = $val->getFile();
            //$name = $val->getfilename();
            $Type = $val->getType();
            $type = "Content-type: ".$Type;
            header($type);
            print_r($img);
        }

in phtml:

    <img height="30px" width="30px" src="imgs.php?Id=<?php print_r($id);?>"/>

save image:

   $targetDir = Mage::getBaseDir('media') . DS . 'plupload' ;
   if (!file_exists($targetDir)) {
        @mkdir($targetDir);
    }       

    if (isset($_REQUEST["name"])) {
    $fileName = $_REQUEST["name"];
    } elseif (!empty($_FILES)) {
    $fileName = $_FILES["file"]["name"];
    } else {
    $fileName = uniqid("file_");
    }
    $filePath = $targetDir . DS . $fileName;

in custom module i store image in database that image i want to fetch — Mahi, Dec 19 '14 at 08:51
Which location you save this images.You have not specify that yet. — Manikandan Arunachalam, Dec 19 '14 at 10:06

score 0 · Accepted Answer · answered Dec 19 '14 at 09:06

0

Assuming you added images into a folder in

your_root_folder/media/your_custom_module/images Then fetch images adding this in your .phtml file.

<?php echo Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA).'your_custom_module/images/'.$val->getFile() ?>"

answered Dec 19 '14 at 09:06

dh47

1,726
1
18
31

o/p display like this ��\0JFIF\0\0\0\0\0\0��\0Ocad$Rev: 14797 $\0\0\0\0\0\0\0\0P��\0�\0 %# , #&')*)-0-(0%()( @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@��\0 – Mahi Dec 19 '14 at 10:29
first thing did your images being saved in the folder?? – dh47 Dec 19 '14 at 10:31
yupp it is saved – Mahi Dec 19 '14 at 10:33
where did you save the images?? – dh47 Dec 19 '14 at 10:35
magento/media/plupload/ – Mahi Dec 19 '14 at 10:36
does this worked at last?? @Mahi – dh47 Dec 19 '14 at 11:34

Manikandan Arunachalam · Answer 2 · 2014-12-19T11:13:09.960

0

From your code, i cant get that where your file is stored, but if you store it in a directory, and you want to get all of that, then use below code to get all file list.

$datas = Mage::getModel('management/file')->getCollection();

foreach($datas as $data)
{
    Mage::log($data->getFile().'');//log this to find the location where you save file
}

So, the above code returns all files you have uploaded, again i dont know the directory where you save the images, so log this file location to find the directory you are using for store image.

Edit

$ob = Mage::getModel('management/file')->getCollection();
$res = $ob->addFieldToFilter('task_id',$a);
foreach($res as $val)
{
     <img src="<?php echo Mage::getBaseUrl()."media/plupload/".$val->getFilename(); ?>" />
}

Edit2 Change permission to your directory to 777.This will make your directory accessible if your url is correct and image is exist there.

edited Dec 19 '14 at 11:13

answered Dec 19 '14 at 10:09

Manikandan Arunachalam

787
8
24

not working.... – Mahi Dec 19 '14 at 10:30
@Mahi this is used to get the location where your images is stored. so just see the updated code and see the log.. – Manikandan Arunachalam Dec 19 '14 at 10:48
update the image url it shows on backend use firebug or something. – Manikandan Arunachalam Dec 19 '14 at 11:03
i want image in backend – Mahi Dec 19 '14 at 11:04
then what is the url in backend? – Manikandan Arunachalam Dec 19 '14 at 11:05
same url i m used – Mahi Dec 19 '14 at 11:11
@Mahi Try Edit2.. – Manikandan Arunachalam Dec 19 '14 at 11:13

Get Image url from database

2 Answers2

Linked