从DB中的列表中搜索颜色，具有托盘

Question

I have a list of color in database (MySQL)from generated from http://www.coolphptools.com/color_extract , is possible to search , from a pallet of color like in this image

what will be the query , and how should i keep the list in DB , I'm sorry but actually i have no idea how to manage , to make a list for every image manually is to much job , and it takes time , and is not logical , maybe exist a better way ,

I have a list of templates , and i need to create a search of colors like http://www.templatemonster.com/templates.php , i need just an idea how to start

THANK YOU A LOT !!!!

Answer 1

Storing it in a database, you could store red green and blue values seperatley with maybe a hex value as a key (or even the rgb values as a composite key)

Then it's up to you to decide what you define as 'close to another colour' If you mean the average difference in colour in all three colour channels then you will need to construct an sql statement that does precisley that, however there are many definitions of whats 'closest' so it depends very much on your exact situation.