[Wolves] phone cam > mysql database

[Andy D'Arcy Jewell]

On 22/01/13 03:23, Wayne Morris wrote:
> Ok, today's "omg, three hours googling and no further forward " is:
>
> Surveyor is wandering around house and need to take a picture(s) of 
> the house he is looking at.
> He already has the details called up on tablet and is editing the 
> database as he trawls around so point/click add to db should be 
> trivial...
>
> So is it an app or a webpage ...
> if a webpage, ive got a snippet that gets the user camera open, but 
> then only saves it locally
> http://html5photos.appspot.com/
>
>  NEXT? How to get it uploaded?
>
> app approach for take pic and upload?
> plenty of apps out there, but they all want to save to fb, dropbox or 
> the like - without the db tie in.
>
> Anyone done/seen something suitable?
>
It's a REALLY BAD idea to put photo's in a SQL database (particularly 
MySQL). I'd suggest storing in the file-system with an index in a table.

For taking a photo, I found a jQuery project that does this: 
http://www.xarg.org/project/jquery-webcam-plugin/

Good luck!

-- 
Andy D'Arcy Jewell

SysMicro Limited
Linux Support
T:  0844 9918804
M:  07961605631
E:  andy.jewell at sysmicro.co.uk
W:  www.sysmicro.co.uk