benzeina Posted September 19, 2006 Share Posted September 19, 2006 Hi everyone,I've been trying this for two days. I feel hopeless :(. Basically I managed to load an image to my mysql. the problem is when displaying the image. It returns about 400 lines of this ---> "x���yr��{�ΐN����E<�l>A�fLF������". here is my image insertion: if ($_POST['Submit']) {if ($_POST['MAX_FILE_SIZE'] >= $_FILES['file']['size']) {//print_r($_FILES);mysql_connect("localhost", "username", "password") or die(mysql_error());mysql_select_db("Vehicles");$photo = addslashes(fread(fopen($_FILES['file']['tmp_name'], "r"), $_FILES['file']['size']));$query = sprintf("INSERT INTO Cars(Picture, FileType) VALUES ('%s', '%s')", $photo, $_FILES['file']['type']);Is there something missing. I do have the 'Picture' field of type BLOB !and i use this to retrieve it:<img src="<?php echo $result_ar['Picture']; ?>" width="144" height="108" border="0" id="Image1" /></a></a></td>I would really appreciate your help. Thank you so much in advance.Ben Quote Link to comment Share on other sites More sharing options...
btherl Posted September 19, 2006 Share Posted September 19, 2006 You can't just put an image into the src attribute. The script that displays the picture needs to do nothing else but display that picture.. then another script needs to call that one.Script 1:[code]Get picture from databaseheader('Content-type: image/gif'); or whatever the image isprint $result_ar['Picture'];[/code]Script 2:[code]<img src="/script1?img=Image1" width="144" height="108" border="0" id="Image1" />[/url][/url]</td>[/code]Does that makes sense? The HTML in script 2 says to call script1 to get the image for display. It can't be done in a single script (not any way I know of) Quote Link to comment Share on other sites More sharing options...
benzeina Posted September 19, 2006 Author Share Posted September 19, 2006 great i will give this a try. I asked few people about this. There is one way you can do this in one script which is using base64 encoding the displaying it. or something like that. but its not supported by all browsers. Not trying to be an expert, just wanted to share as you just did. Thank you :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.