Jump to content

Tags and Keywords


Goins

Recommended Posts

I think what you need to do is setup two mysql tables with this structure

table: image_keyword

image_name varchar(255) [indexed] [primary key]

keyword_id int(10) [indexed] [primary key]

 

table: keyword

id int(10) [primary key]

word varchar(50) [unique] [indexed]

 

If you upload any info about the image into a database, replace image_name with image_id where image_id is the id in the images table.

 

Then you can just add new keywords, or create a link in the linking table between the image and keyword.

 

Because the fields you might search by are indexed, you can very quickly search for all images with a set keyword, or all keywords for a set image :)

Link to comment
https://forums.phpfreaks.com/topic/95840-tags-and-keywords/#findComment-490886
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.