Nodral Posted December 2, 2011 Share Posted December 2, 2011 Hi All I've got a DB with approx 3 thousand users and a weekly graph is created using php for each users usage. This is processed by a cron job. The issue I have is storing the graph images. I've googled the situation and I'm getting a large difference of opinions about which is the best way to do it. almost a 50 / 50 split Blobs or files. I'd like to do it as blobs as I have issues with file permissions on my hosting server (ie I can write an image file, but then if it needs overwriting or deleting I can't do it dynamically, even when I set the file permissions to 777) My question is, how do I insert an image into a DB? If for example my image was user1.jpg, what would the process be from a SQL statement? Quote Link to comment Share on other sites More sharing options...
fenway Posted December 3, 2011 Share Posted December 3, 2011 I'd strongly suggest using the file system -- you can dodge your system permissions with other cron jobs and file renames. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.