Draw dots in images using PHP, XMLHttp, Mysql.
A family member asked me if it was possible to use html, php, mysql to mark spots in an image of the human skeleton during an medical anamnesis collection. He wanted this to easily mark the complaint spots of his patients. He also needed to be able to remove marks when they where faulty and wanted this all to be stored in a database for easy reference and backup.
Seeing the complexity of it, I accepted the challenge he laid out for me.
The most complex part of this was the ‘how to remove’ spots from an image without deleting the actual fixed image of the skeleton. The solution I came up with was using an Fixed background image in HTML and use a transparent overlay that I will be updating using PHP and XMLHttp request headers.
All that needs to be done during reporting is merging both images together, which is fairly easy using php.
But because I though someone else might use this script as well, I thought sharing it here with the world was a nice option. The application is endless, from damage reporting to Location reporting, and in the finished from its fairly easy to understand and adjust to your needs.
I added the sourcecode for this script to this post. You need to have a mysql database, php with GD enabled, browser that supports XHTMLRequest (all modern browsers). Simply dump the files into the a php html enabled location and make sure you create the required SQL table (usign the .sql script inside the archive) and have a go with it (you might need to alter the mysql user/pass inside the PHP script)….
Use the “save as” option to grab the file from this site. Rename the file to something.zip, unpack and access the srcfiles inside the rar archive… use winrar to unpack.
Let me know what you think, or if you found it usefull 🙂
p.s. I wasnt able to verify the author of the used skeleton image. If you are/know him, let me know if this application is allowed, and how to publish the credits.
Posted on June 8, 2011, in PHP, Tooling and tagged anamnese, anamnesis, blob, create, Database, Draw, eclipse, for, HTML, image, images, In, into, later, long, mark, Mysql, PHP, png, point, points, reference, Script, Simple, Simple Draw script PHP HTML MYSQL, stored, transparent. Bookmark the permalink. 1 Comment.