not able show the image from mysql to php

Question

I am unable to show the image in PHP from MySQL blob showing a lot question marks.

below is my code.

if(isset($_GET['edituname']))
{
    $id='<input type="hidden" name="txtuname" value="' . $_GET['edituname'] . '">';
    $sql = "SELECT * FROM andhra WHERE id='" . $_GET['edituname'] ."';";
    $result = mysql_query($sql);
    $row = mysql_fetch_array($result);
    $COL_1 = $row['COL_1'];
    $COL_2 = $row['COL_2'];
    $COL_8 = $row['COL_8'];

HTML code is

    <td><img src="data:images\jpg;base64,'.$COL_8.'" /></td>

my workarounds are

if we put header('Content-Type: image/jpeg'); not able to display the URL just two rectangle boxes in left hand corner in browser.

if we change HTML code like below getting some unexpected error.

<td><img src="data:images\jpg;base64,'.($row['COL_8']).'" /></td>

one of the reasons no one recommends storing images in the database — , Apr 04 '16 at 04:46
so how we need to display images dynamically as per the query any other way — Hanumaiah T, Apr 04 '16 at 04:51
@HanumaiahT try with `$sql = "SELECT * FROM andhra WHERE id=" . $_GET['edituname'] ;` — Praveen Kumar, Apr 04 '16 at 04:54
`''`-> not a good idea, XSS prone, `"SELECT * FROM andhra WHERE id='" . $_GET['edituname'] ."'"` -> not a good idea, SQL injection-prone. `mysql_*` functions -> not a good idea, functions removed as of PHPv7 — Rasclatt, Apr 04 '16 at 05:02
Is COL_8 a Base64-encoded binary value? If not, you can't use it directly as a data URI. — Tieson T., Apr 04 '16 at 05:12
store the files in the file system( hint in its name) and the filename\path in the database. — , Apr 04 '16 at 05:13
Dagon am newbie to this code is it possible to give any example am also looking for this type of solution only — Hanumaiah T, Apr 04 '16 at 05:15
@HanumaiahT [base64_encode](http://php.net/manual/en/function.base64-encode.php) — Tieson T., Apr 04 '16 at 05:18
Also: http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php — Tieson T., Apr 04 '16 at 05:20
@HanumaiahT Obviously. But what is the column *type*? You can't just dump binary data at a data URI and expect magic to happen. — Tieson T., Apr 04 '16 at 05:33

BlueAries · Answer 1 · 2016-04-04T05:05:24.227

-1

try this

 $img = $row['COL_8'];
echo '<td><img src="data:image/jpg;base64,'. $img .'"/></td>';

edited Apr 04 '16 at 05:05

answered Apr 04 '16 at 05:00

BlueAries

31
1
8

getting this error "Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in E:\xampp\htdocs\db\finals\users.php on line 188 " – Hanumaiah T Apr 04 '16 at 05:01
I modify my answer – BlueAries Apr 04 '16 at 05:05
after change also same – Hanumaiah T Apr 04 '16 at 05:08
' $img = $row['COL_8']; echo '';' – BlueAries Apr 04 '16 at 05:11
now able to open the URL but getting "echo '';: ��G��C��o�6" – Hanumaiah T Apr 04 '16 at 05:12
$img = $row['COL_8']; echo ''; you try that now – BlueAries Apr 04 '16 at 05:19
after change also same – Hanumaiah T Apr 04 '16 at 05:26
nice.... giving me some negative point on my answer........... Anyways, change your data type into LongBlob instead of Blob.. size matter.. this is what I am using so it useful. .. – BlueAries Apr 04 '16 at 05:28
Sorry BlueAries, am just saying the result not negative try to understand my data type is LongBlob – Hanumaiah T Apr 04 '16 at 05:34

not able show the image from mysql to php

1 Answers1