jake_ali Posted July 8, 2006 Share Posted July 8, 2006 Hi, Just wondering if anyone can give me some pointer on how to delete/update BLOB properly. My app stores articles/documents/images in mysql. Inserting files works great, but if I delete a row which has, say a 2mb pdf file, the mysql table size does not decrease (table.MYD). What would be the proper way to delete/update blob column? Is there specific functions that I use? I searched extensively on search engine but no luck finding anything.Thanks in advance for you help.-Jake Quote Link to comment https://forums.phpfreaks.com/topic/14038-updatedelete-blob-how-to/ Share on other sites More sharing options...
jake_ali Posted July 8, 2006 Author Share Posted July 8, 2006 Another question: I have a lot of php scripts, getting kinda troublesome to manage. So I am storing those scripts in mysql and retrieving by id, so the link would look like http://localhost/controller.php?id=pageid ..............what should be header() for content-type for these scripts to execute? my browser is interpreting as application/octet-stream and prompting to save the file rather than executing as a regular php page.Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/14038-updatedelete-blob-how-to/#findComment-54868 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.