Re: Image storing

On Mon, 2007-03-05 at 20:55 +0100, Børge Holen wrote: > This dude is just trying to start another skirmishand probably a riot. Well he didn't ask about filesystems, so if everyone keeps it on topic there shouldn't be an issue ;) On Monday 05 March 2007 19:50, Jay Blanchard wrote: > > [snip] > > Can you recommend the best way to store an image into the MySQL database > > > > and optimze it. > > > > And display and manipulate that image in PHP. > > [/snip] > > > > There are many tutorials; > > > > > > http://www.google.com/search?hl=en&q=store+image+in+database+PHP > Personally, I've always found INSERT works well for storing pretty much any kind of data into a MySQL database. It also helps to properly quote the data. I've heard tell of a non standard keyword called REPLACE that can store the information also regardless of whether an existing entry exists for any defined primary key. f an entry already exists within a table having a defined primary key, then I'd strongly favour the UPDATE syntax. >:) Cheers, Rob. -- .------------------------------------------------------------. | InterJinn Application Framework - http://www.interjinn.com | :------------------------------------------------------------: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `------------------------------------------------------------'