Can Some one correct this where i am wrong?

Question

Description --> I just want to fetch image in my web page from data base i had given BLOB type to database where i am storing image , how do i fetch that image , in this code i am getting small icon of image with corrupted format .

<?php

 $connection = mysqli_connect("localhost", "****",  "******","****");
 $find_data =mysqli_query($connection,"SELECT * FROM ashish " );
 while($row = mysqli_fetch_assoc($find_data)){

 $current=$row['weblink'];$asdf=$row['webrate'];$imag =$row['weblogo'];

 $ima =$row['weblogo'];

 }

 ?>
 <form action="ashishdb" method="post" enctype="multipart/form-data">
 <div><p>WebSite Link :<input type="text" name="weblink">    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     Websites Rating : <input type="text" name="webrate">   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Website Logo : <input type="file"   name="weblogo"></p>

  <p align="center"><input type="submit" value="Submit" name="btn_file"></p>

  </div>
   <table style="width:100%">
   <tr>
   <th>A</th>
   <th>A</th>
   <th>A</th>
   </tr>
   <tr>
   <td><?php echo $current ?></td>
    <td><?php echo $asdf  ?></td>

     <td><img src=<?php echo $ima ?> ></td> 


        </tr>
       </table>
     </form>
     </body></html>

this will `` give u only last image from while, secondly u are missing the quotes, this ` >` should be `` if `$ima` contains full image path — devpro, Sep 23 '16 at 11:39
Duplicate: http://stackoverflow.com/questions/7793009/how-to-retrieve-images-from-mysql-database-and-display-in-an-html-tag — M. Eriksson, Sep 23 '16 at 11:40
img src takes a URL, not raw image data (except under certain cases, but dumping the raw binary output of a table blob isn't one of them) — GordonM, Sep 23 '16 at 11:41
it is on joomla , dont know the exact path of folder , but i can store image in its media folder ? how to retrieve it from there , can any one help ? — Ashish Tripathi, Sep 23 '16 at 11:43
what is the path of folder? add it before `$img`, if `$img` only contains the image name — devpro, Sep 23 '16 at 11:44
Do you mean BLOB? If so, are you storing the raw image data in your database? Something like this will work for you `` — Steve, Sep 23 '16 at 11:46
@AshishTripathi: for u https://docs.joomla.org/Understanding_Joomla!_templates — devpro, Sep 23 '16 at 11:56
Thanks for the link , but i havn't found any image path related things — Ashish Tripathi, Sep 23 '16 at 12:02

Yavuz YILDIZ · Answer 1 · 2016-09-23T11:54:29.747

-2

if your "ashish" table "weblogo" column contains the image's path or url, you can try :

<img src="<?php echo $ima; ?>" >

or

<img src="<?=$ima?>" >

edited Sep 23 '16 at 11:54

answered Sep 23 '16 at 11:40

Yavuz YILDIZ

36
5

That's just markup fix, not an answer to his real question. You can't show blob data like that. – M. Eriksson Sep 23 '16 at 11:41
maybe he stored the image's url in his database. Isn't it? – Yavuz YILDIZ Sep 23 '16 at 11:44
His first sentence in the question says: _"from data base i had given BLOG type to database where i am storing image..."_. I would rather think that "BLOG" is a typo for BLOB and not URL. – M. Eriksson Sep 23 '16 at 11:46
1

He tagget joomla Sir Magnus Eriksson. In Joomla, I would rather know images don't stored as BLOB, the stored thing is image url. – Yavuz YILDIZ Sep 23 '16 at 11:48
@YavuzYILDIZ: u r right, but still it will only display the last record not all – devpro Sep 23 '16 at 11:49
BLOB is only a type for a colum where i am storing the name of image , – Ashish Tripathi Sep 23 '16 at 12:12

Can Some one correct this where i am wrong?

1 Answers1