Find visually similar images by image upload with PHP and MYSQL

Status: Closed
Hadiah: $100
Entri Diterima: 6
Pemenang: Serge755

Winner

Deskripsi Kontes

Hello everyone!
I need a code that will allow searching image database by uploading an image.
Attached is a zipped folder of about 2,000 stone images that you can use for testing.
I'm thinking about this approach:
1. Hash the image data for each file and store it in the database.
2. Once the image is uploaded (for searching), the hash will be created.
3. Run MYSQL query to find the closest matches.
If you have a different approach in mind, please feel free to try.

Please note that some of the images will have a partially white background, we need to disregard (ignore) that. Possibly crop the white background out.
The images provided are all square, the images that will be uploaded for search may have different aspect ratios.
Also, the SQL query for searching similar images is very important as we may have over 100,000 images in the database at some point.

I'm hoping to have it done with no external libraries (GD and ImageMagic is fine)
I also need to have a variable accuracy setting so I can adjust for best results.

I don't really need any UI at this point, as long as we can test the code.

Once at least one working solution will be submitted, I will set this contest as Guaranteed.
Good luck, please feel free to message me with any questions.

*********UPDATE************
I have attached a zipped folder with a few images that can be used for performing the test search.
Please note that we would need to disregard the aspect raion of the images.
What I'm really after is the matches with the similar color and texture pattern.

Keahlian yang Disarankan

MySQL
PHP

Winner

Buat Kontes Seperti Ini

Umpan balik Pemberi kerja

“Sergey have done a great work on the project. Very happy with the resullts.”

ashevillemnt, United States.

Entri teratas dari kontes ini

Serge755 Ukraine

0
kamransiyal9 Pakistan

0
kamransiyal9 Pakistan

0
cestis Poland

0
kamransiyal9 Pakistan

0
TanjimRahatBD Bangladesh

0

Tampilkan Entri Lainnya

Papan Klarifikasi Publik

Penyelenggara Kontes
- 3 tahun yang lalu
Congratulations Sergey!
Thanks, everyone for your effort, I really appreciate it!
While there is still room for improvement, Sergey's solution produces the most accurate results!
- 3 tahun yang lalu
cram3632
- 3 tahun yang lalu
can I use GD or ImageMagic
- 3 tahun yang lalu
1. Penyelenggara Kontes
  - 3 tahun yang lalu
  sure, either one would be fine.
  - 3 tahun yang lalu
daniyalhussain96
- 3 tahun yang lalu
Can we use md5 algorithm for hashing?
- 3 tahun yang lalu
1. Penyelenggara Kontes
  - 3 tahun yang lalu
  Sure, as long as we can store it in the database and search it.
  - 3 tahun yang lalu
2. daniyalhussain96
  - 3 tahun yang lalu
  Okay, will upload it and let you know.
  - 3 tahun yang lalu
ceinj
- 3 tahun yang lalu
Do these images represent different angles and sizes?
- 3 tahun yang lalu
1. Penyelenggara Kontes
  - 3 tahun yang lalu
  These images are center crops from bigger images. We can disregard angles and sizes, what is important is that we match texture and color.
  - 3 tahun yang lalu