Retrieve Image from script

golfinggod

Posted earlier but i thought id try and add a little more detail.

Question - Im looking to get the script image.php to return an image (i.e. banner) to the clients site.

Step one:

The client places the image llink code on his .html page

<img src="www.mysite.com/image.php=$username"

Step 2:

when the clients browser is opened it then goes to www.mysite.com/image.php and uses the username to retrieve the image from the mysql databse and it is then stored in the variable $clientsimage

Step3:

The problem is I dont know how to write the php code that will then send the image in $clientsimage back to the browser that requested it.

Help would be great thanks.

OLY

Step 3

davieboy

your link for the image would have the vaiable in it:
ie

<?php echo "<a href=\"image.php?pic=$username\">images</a>"?>

in the image ppage you would need a $_GET['username'];
with the code

<?php 
$image = $_GET['username'];
echo"<img src=\"/images/$image.jpg\" align=\"centre\" width=\"230\" height=\"250\">";
echo "<br><td align=centre>Image of: $image</td>";?>

does that help?

AstroTeg

I'm not a big fan of storing images in databases. You're chewing up database resources to store a somewhat large collection of data that you have no intention of manipulating (such as searching, adding, indexing, ordering, etc). Wouldn't it make sense to just store the image name? Then have PHP just point directly to the file, or if you want to keep it secure, place the images in a non-web accessible directory and have PHP read the file back to the user (which is what you would be doing anyways if you had stored the image in the database).

As for sending the image back, its a matter of getting the data (either from the DB which I don't recommend or from a file which I recommend). Once you have the data, you send the proper content-type header back to the browser (usually image/jpeg or image/gif, etc). Then send the image data. And then you're done with sending the image.

As for step 2, you'll just need to create a query to get the info out of the database. It could be as simple as:

SELECT imagegoodies, usergoodies, paths, etc FROM mytable WHERE username = '[username given]'

Of course, swapping the silly field names, table name, and where clause with your database info.

golfinggod

thanks for the reply.

But how would it work for a page that only uses a .html extension.

I am building a banner exchange and I cant rely expect the clients to change there pages from .html to .php to recognize the script. At the minute each example uses php so i am not sure if it will work. I could rely do with an idea on how to get a regular html image link interact and fetch the data. I am only just learning php so youve got to bear with me.

Any ideas

Thanks🙂