image does not get retrieved from database into html form using php

Question

Getimage.php

<?php
$hostname="localhost";
$username="root";
$password="tiger";

/* @var $dbhandle type */
 $dbhandle = \mysqli_connect($hostname, $username, $password) 
 or die("Unable to connect to MySQL");

/* @var $select type */
$select= \mysqli_select_db($dbhandle,"sample")
     or mysqli_error($dbhandle);
 /* @var $itemId type */
$itemId= (\filter_input(\INPUT_GET,'name'));
$sql="select img from starterveg where itemId=$itemId";
$res2=mysqli_query($dbhandle,$sql);
$row= mysqli_fetch_assoc($res2);
mysqli_close($dbhandle);
header("Content-type: image/jpeg");
echo $row['img'];
?>

<body>
<img src="Getimage.php?itemId=oepsv1086" alt="image" id="img1">
</body>

> I'm not able to display the image from database into the html for.Instead the alt message only appears inside the html form

mysqli connect also requires the database, else you cant read it out where you trying to pick it up from. You later open the db, but you can put that in one (I asume its sample) but you can better put that in your $dbhandle variable. — Dorvalla, Apr 07 '14 at 10:09

score 0 · Answer 1 · edited May 23 '17 at 12:05

0

Try in your getimage.php

    header("Content-type:image/jpeg");
    stripslashes ($row['img']);

    echo $row['img'];

***storing image in DB is not recommended.*

Reference

EDIT 2 >>

$itemId= (\filter_input(\INPUT_GET,'name'));

this should be

$itemId= (\filter_input(\INPUT_GET,'itemId')); #as you are passing itemid in get

EDIT 3>>

You were missing single quotes (') in where query , that was causing errors

it should be

$sql="select img from starterveg where itemId='$itemId'";

edited May 23 '17 at 12:05

Community

1
1

answered Apr 07 '14 at 10:10

Dimag Kharab

4,439
1
24
45

Have you checked the reference ?? you can view my PHP class for doing this here http://www.phpclasses.org/package/6834-PHP-Validate-and-resize-uploaded-image-files.html – Dimag Kharab Apr 07 '14 at 10:17
I hope in getimage.php file you are not echoing any other thing before echoing Image ..! – Dimag Kharab Apr 07 '14 at 10:19
ya i echo only the image.. i tried the reference still does not work – user3436338 Apr 07 '14 at 10:25
this is how i changed my src tag..but no change.. – user3436338 Apr 07 '14 at 10:26
ya there are 30 jpeg images stored in the database in blob datatype in mysql database – user3436338 Apr 07 '14 at 10:27
<
----- **its in getimage .php ?????**
– Dimag Kharab Apr 07 '14 at 10:30
no it is in another page called customer .php where i need to display my images – user3436338 Apr 07 '14 at 10:32
so when you directly access the page with any image id in url param , what does it displays without header("Content-type:image/jpeg"); ?? – Dimag Kharab Apr 07 '14 at 10:34
do i have to add in customer.php page? Can u explain clearly what mistake i have done?? – user3436338 Apr 07 '14 at 10:36
see my 2nd edit , you are passing **itemId** but trying to fetch 'name' get request param in getimage.php page – Dimag Kharab Apr 07 '14 at 10:39
it is the typographical error.. i have changed that.. Sorry still not getting what im expecting.. – user3436338 Apr 07 '14 at 10:41
so you cahanged that $itemId= (\filter_input(\INPUT_GET,'name')); in your code ? – Dimag Kharab Apr 07 '14 at 10:43
yes i have changed as $itemId= (\filter_input(\INPUT_GET,'itemId')); – user3436338 Apr 07 '14 at 10:44
what is your primary key for table image ?? its itemid only I guess – Dimag Kharab Apr 07 '14 at 10:46
do one thing access getimage.php directly from browser with a valid itemid eg **Getimage.php?itemId=this_should_be_valid_id_fromDB** – Dimag Kharab Apr 07 '14 at 10:47
so do i have to give this inside src? – user3436338 Apr 07 '14 at 10:52
its online , can I access that uri ? – Dimag Kharab Apr 07 '14 at 10:58
actually in the img field the images are stored as [BLOB -16B] – user3436338 Apr 07 '14 at 10:59
ok thats fine , I need to see your complete code and DB structure – Dimag Kharab Apr 07 '14 at 11:01
this runs on a server ..i think without server it s not possible to access – user3436338 Apr 07 '14 at 11:02
I asked for web URL to access – Dimag Kharab Apr 07 '14 at 11:02
u need the Getimage file and the customer.php page file in the mail? – user3436338 Apr 07 '14 at 11:10
yes all the concerened code , plus the db table(image) structure – Dimag Kharab Apr 07 '14 at 11:11

image does not get retrieved from database into html form using php

1 Answers1