Storing image links in MYSQL

[kjspear]

Hello,

What is the simplest way to insert image links to the MYSQL database? Based on my research, it's not a good idea to save the actual BLOB images to the database but rather the link to it. What I would like to do is upload a small jpeg or gif file and have MYSQL retrieve it for viewing. The user may also click a next button to scroll to the next image. Most of the samples I've seen appear to be complicated. I just want something as simple as possible.

Any assistance would be gladly appreciated.

Thanks,
KJ

 

[sleipnir214]

Your table might look something like:

create table foo
(
ID int unsigned auto_increment primary key,
imagefilename varchard (30)
)

You store your image data in that table.

You then write a script (call it "foo.php&quotthat can take an optional input of a table ID value.

If foo.php does not get an ID when it is run, it fetches the first filename in the table, wraps HTML tags around it, then outputs that. It also fetches the ID of the next image in the table and output that as a link (something like <a href=&quot;foo.php?id=<idval>&quot;...>).

If it gets an ID, it does everything it did in the paragraph above, but also gets the ID of the previous image in the table and outputs that as an A tag.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!