Dispalying image from mysql database

Dispalying image from mysql database using php

[okonjiaustin]

I want to specifically direct this problem to 'Jatar'

I have successfully insert image and other row data into mysql database.
The code is below:

<?php
$errmsg = "";
if (! @mysql_connect("localhost","root","")) {
$errmsg = "Cannot connect to database";
}
@mysql_select_db("adim");

if(isset($_REQUEST['submit']))
{

$imgtype=$_FILES['uploadfile']['type'];
$name=$_REQUEST['name'];
$address=$_REQUEST['address'];
$dateofbirth=$_REQUEST['dateofbirth'];

if($imgtype=="image/jpeg" �� $imgtype=="image/jpg" �� $imgtype=="image/pjpeg" �� $imgtype=="image/gif" �� $imgtype=="image/x-png" �� $imgtype=="image/bmp")
{

$image=$_FILES['uploadfile']['tmp_name'];
$fp = fopen($image, 'r');
$content = fread($fp, filesize($image));
$content = addslashes($content);
fclose($fp);
$sql="insert into img_tab1 (name,image,address,dateofbirth) values ('$name','$content','$address','$dateofbirth')";
$res=mysql_query($sql) or die (mysql_error());
}
}
?>
Now I want to retrieve the row data into an html page including the image, but after using the code below the row data failed to be displayed in an html page. Please I want you to look at this code and tell me what I have done wrong. This problem has been on for quite sometime now.
Thanks. This is the display code below:

<?php
$errmsg = "";
if (! @mysql_connect("localhost","root","")) {
$errmsg = "Cannot connect to database";
}
@mysql_select_db("adim");

$query = "SELECT image, image_type from img_tab1 where id=$id";
$result = @mysql_QUERY($query);

$data = @mysql_RESULT($result,0,"image");
$type = @mysql_RESULT($result,0,"image_type");

header( "Content-type: $type");
echo $data;

?>
Please go through and let me know where I went wrong.

Thanks

Austin

[phparion]

while you're programming you should not use @, let the function break to see any error thrown from the compiler.. e.g

$result = @mysql_QUERY($query);

$data = @mysql_RESULT($result,0,"image");
$type = @mysql_RESULT($result,0,"image_type");

convert the second part of the functions to the lower case i.e mysql_query() and mysql_result, additionally use

mysql_query() or die(mysql_error())

to see if any problem occurs with your query itself. At least when you are developing...

[okonjiaustin]

Hello phparion,
Thanks for your reply. I have made the corrections you suggested and this is the corrected version of the code:

<?php
$db = mysql_connect("localhost", "root", "");
mysql_select_db("adim",$db);

$query = "SELECT image, image_type from img_tab1 where id=$id";
$result = mysql_query($query) or die('Error, query failed');

$data = @mysql_result($result,0,"image");
$type = @mysql_result($result,0,"image_type");

echo ($data);

?>
And this is the result:
Error, query failed

So, where do I go from here? Hoping to hear from you.

Austin

[phparion]

change this

$query = "SELECT image, image_type from img_tab1 where id=$id";
$result = mysql_query($query) or die('Error, query failed');

to this

$query = "SELECT image, image_type from img_tab1 where id=$id";
echo $query ."<br>";
$result = mysql_query($query) or die(mysql_error());

check your query shape i.e if $id exists in the query then check the mysql error. show me that.. btw i guess you are either giving wrong column name or $id is not put in the query.. but lets see what error do you get...

[okonjiaustin]

Thanks phparion for your concern.

I have actually made the corrections and included the real column names in the database, the code is below:

<?php
$db = mysql_connect("localhost", "root", "");
mysql_select_db("adim",$db);

$query = "SELECT name,image,address,dateofbirth from img_tab1 where id=1";
echo $query ."<br>";
$result = mysql_query($query) or die(mysql_error());

$data = @mysql_result($result,0,"image");
$type = @mysql_result($result,0,"image_type");

echo ($data);

?>

When I executed the query the result was an unbelievable junk that filled all the page; see a sample below:

SELECT name,image,address,dateofbirth from img_tab1 where id=1
����JFIF
dd��Ducky
P��&Adobed�
 Z&�06�ۄ
     ��^
,


���




 





6547 3�@!#$%
  
!1AQaq"����2r��t�BR#3s�uт��S��6 b�c���$@���C4T5�%E
�





!1AQaq� �0�����@�� 

 st�f*�O�a���1Xq$R^�K���W�rd�a�a�a�a��w'�~,���s M��X+$�K�0�p�? �-p�%@b4�h�g,0�
W-�*�q�P�$�h�e��+$�K�0�p�J�L'�� +�W�;h� ��>[�Ef �) `�o�I`�w�É"���*\5yLj0�<�h���7AA/�:@�Кr�����fO�
�!dU`�8�)/x¥Á`E{0�<�h� ł�Y
��,ĵ��5H���Y�X�U� ���+$�K�0�p�X^¸(���3�p� "p2���=@(� %› z +��KpA�� 2*ܓ���K,5 ��D�oEy!\J�¦�� 2� n��9��? u���7�qb\3��6Q����%��H��w����h�_�`+��R�X�1ސ��#��H�k��DM��2�j IȈ��� 0�+��(�a�P@�n�`RL�~Bb��A � cti�9�¦5��춻�0�a_U�'��GG���x�Y�-\�j" ����"61V]���ʼK�[>� �-���nt�nyۛ+� j����-��3�Տ��/�~S*S ��n�;�O��-�����+�}W,���\{�0���D���V\��j�vn.>s¦,�� ��_�rI~9���c��[.������H5]V8>m_�U��;u���}W�mwD����\(`���FN k��mdE-)�%�R@9$�Ej�9�y�͡�#4�e7���F �"���e6

Thanks.

Austin