Search found 9 matches

by WelshApple
Fri Jul 02, 2004 7:46 pm
Forum: Databases
Topic: Retrieving Binary Data and Displaying
Replies: 17
Views: 1172

Now it must be working. <?php $link = mysql_connect('localhost', 'USERNAME', 'PASSWORD'); mysql_select_db('DATABASE'); $query = "SELECT image FROM test WHERE id='1'"; $result = mysql_query($query); // removed $link header('Content-type: image/jpeg'); list($data) = mysql_fetch_row($result)...
by WelshApple
Fri Jul 02, 2004 7:40 pm
Forum: Databases
Topic: Retrieving Binary Data and Displaying
Replies: 17
Views: 1172

so how would i go about turning magic quotes off to try?

thanks
by WelshApple
Fri Jul 02, 2004 7:27 pm
Forum: Databases
Topic: Retrieving Binary Data and Displaying
Replies: 17
Views: 1172

hmmmmm, interesting........

Connection is ok. mysql_num_rows() is 1. The window title is image.jpg. I can right-click mouse and download image.jpg but the downloaded file is not recognisable???
by WelshApple
Fri Jul 02, 2004 7:12 pm
Forum: Databases
Topic: Retrieving Binary Data and Displaying
Replies: 17
Views: 1172

This is what I just wrote and tested, but output was nothing :-( <?php $link = mysql_connect('localhost', 'USERNAME', 'PASSWORD'); mysql_select_db('DATABASE'); $query = "SELECT image FROM test WHERE id='1'"; $result = mysql_query($query, $link); header('Content-type: image/jpeg'); list($da...
by WelshApple
Fri Jul 02, 2004 7:00 pm
Forum: Databases
Topic: Retrieving Binary Data and Displaying
Replies: 17
Views: 1172

Ok, so what code would I use supposing the image file stored is a normal .jpg?
by WelshApple
Fri Jul 02, 2004 6:51 pm
Forum: Databases
Topic: Retrieving Binary Data and Displaying
Replies: 17
Views: 1172

So there's no simple way of retrieving an image file and using it to display it's image data?
by WelshApple
Fri Jul 02, 2004 6:44 pm
Forum: Databases
Topic: Retrieving Binary Data and Displaying
Replies: 17
Views: 1172

Not sure

Thank for replying.....

I'm not sure where I would be using the headers e.g.

Code: Select all

<?php
$result = mysql_query($query, $link);
$image = mysql_fetch_object($result, $headers);
?>
Sorry for sounding dumb.
by WelshApple
Fri Jul 02, 2004 6:38 pm
Forum: Databases
Topic: Retrieving Binary Data and Displaying
Replies: 17
Views: 1172

Retrieving Binary Data and Displaying

Hi I can put image files into the MySQL database, but I'm stuck on retrieving the image and displaying it with PHP. I get this far......... <?php $link = mysql_connect('localhost', USERNAME, PASSWORD); mysql_select_db('DB'); $query = "SELECT image FROM table WHERE id='1'"; $result = mysql_...
by WelshApple
Fri May 21, 2004 12:07 pm
Forum: PHP - Code
Topic: Session Id problem...
Replies: 5
Views: 712

You may want to try session_unregister().