View Full Version : Database via clickable picture!!
Ammit
1st August 2014, 11:56
Hi all
A shot in the dark here.
I am looking for a program that uses a main picture which you can click on individual parts to access a database for part numbers etc.
Any ideas appreciated
Thanks
wnlight
1st August 2014, 13:40
Ammit, you are looking for image mapping technique. Here is one of very many sources. stackoverflow.com/.../what-is-the-best-tool-to-create-an-image-map
Ammit
1st August 2014, 13:55
Thanks WNLight.
I do not want to use the picture for html mapping though. It is probably a big ask but for E.G. I would like a picture of a car with a map so as i click on various parts then it can jump to a txt list or word document on my pc containing part number, supplier, cost etc.
Thanks
Operator
1st August 2014, 13:59
Ammit, you are looking for image mapping technique. Here is one of very many sources. stackoverflow.com/.../what-is-the-best-tool-to-create-an-image-map
Your post does not contain the live url unfortunately:
http://stackoverflow.com/questions/8971815/what-is-the-best-tool-to-create-an-image-map
By the way there are several image mapping techniques in html which in combination with php
can of course access a mysql or postgres database. The advantage I see is that it is immediately
available on the internet. Using e.g. an image as submit button will result in getting the x and y
coordinates where you clicked the image. But there are more sophisticated techniques also.
Ammit
1st August 2014, 15:56
All I can find so far is html based for the net, not actual program based.....
wnlight
2nd August 2014, 01:15
Ammit, The history of image mapping is closely entwined with HTML and the Web. I did spend some fifteen minutes looking in vain for what you ask. If I find anything useful for you, I'll send it to you. What coding platform(s) do you use?
Ammit
2nd August 2014, 11:08
Hi WNLight
Erm platform?? Not sure what you mean here my friend, win 7 and Firefox??
Shamz
2nd August 2014, 15:17
Hello All !
I think what Ammit is asking -- he has files on his local computer - he wants to link them with some picture - like he mentioned - on a picture of car - when he clicks on some part - say Tires - it should open corresponding text/xls/word doc - which has details about the tires or part he clicked on.
Ammit - that sounds like a custom solution - and its very much doable but can't think of any ready made software available - will let you know if I find something
Mike Gorman
2nd August 2014, 15:35
You should be able to set that up with Word, using visual Basic - or even a PDF with links - PDF's are sometimes called searchable data bases
Have the picture loaded with VB embedded links to your text - OLE object linked embedment
wnlight
3rd August 2014, 03:07
Yes, Ammit, conceivably, you could find an app already written that does what you wish. I truly wish you the best in finding it. Only read the following if you decide to roll your own.
By platform, I mean what type of hardware being PC, Mac, Android, etc and what coding language being visual Basic, PHP, Pearl, javascript, C#, etc. You could use visual Basic, or PHP or Pearl to write a native app (no HTML, no WEB) to link from clicks on areas of an image to different other images. If you were to desire platform independence, you would be limited to javascript or Web-type non-native apps.
My immediate assumption reading your original post was that you would write an app (or pay someone else to write it). You will be really lucky to find it already available. I used to do that stuff and specialised in database apps so i don’t mind giving you some advice. I retired eight years ago so am not interested in coding for hire, so my advice is unbiased.
BTW, what is wrong with an HTML-based web-type app that runs on your PC? I have two such apps that run on my Mac, but are totally platform independent. One uses a json file database. There are free apps out there that will build your image mapping file to link to local web pages that can display whatever you wish from either static or dynamic database.
Powered by vBulletin™ Version 4.1.1 Copyright © 2026 vBulletin Solutions, Inc. All rights reserved.