SEO

#1 (**permalink**) 02-27-2008, 09:32 PM

Hi

I want to store jpeg images in a mysql database from php in the form of 'blob' types.
Is this possible and can you detail for me the steps to achieve this?

Regards and thanks
Rodney Courtis

#2 (**permalink**) 02-27-2008, 09:32 PM

On 10/10/06, Rodney Courtis <rcourtis@ihug.co.nz> wrote:
> I want to store jpeg images in a mysql database from php in the form of 'blob' types.
> Is this possible and can you detail for me the steps to achieve this?

For a nice size performance hit, yup:

http://www.zend.com/zend/trick/trick...1&anc=0&view=1

--
Greg Donald
http://destiney.com/

#3 (**permalink**) 02-27-2008, 09:33 PM

I've stored millions of images/files in mysql with minimal performance
hit, performance loss is mostly based on your storage implementation.

Checkout this article:
http://www.dreamwerx.net/phpforum/?id=1

On 10/11/06, Greg Donald <gdonald@gmail.com> wrote:
> On 10/10/06, Rodney Courtis <rcourtis@ihug.co.nz> wrote:
> > I want to store jpeg images in a mysql database from php in the form of 'blob' types.
> > Is this possible and can you detail for me the steps to achieve this?
>
> For a nice size performance hit, yup:
>
> http://www.zend.com/zend/trick/trick...1&anc=0&view=1
>
>
> --
> Greg Donald
> http://destiney.com/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=dreamwerx@gmail.com
>
>

#4 (**permalink**) 02-28-2008, 05:08 AM

Hi,

In my honest opinion, uploading the image to a "preset" directory in the
code, and setting the code to submit the image name, extension, and if
needs be (it shouldnt, because you can set it in the HTML), the
directory. Google has a lot of useful resources on this.

But, if you are really "desperate" to do it using the BLOB type,
http://www.wellho.net/solutions/php-...-retreive.html
was a help to me when I first started learning.

Hope this helps,

r

#########################
Richard Harris
PHP, MYSQL, XHTML, CSS
rh@richardharris.eu
richard@theharris.name
#########################
Rodney Courtis wrote:
> Hi
>
> I want to store jpeg images in a mysql database from php in the form of 'blob' types.
> Is this possible and can you detail for me the steps to achieve this?
>
> Regards and thanks
> Rodney Courtis
>
>
>
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

storing images in the database