freelanceprogrammers.org Forum Index » PHP

Re: How to store and retereive image in database?


View user's profile Post To page top
JBennett@... Posted: Thu Jun 02, 2005 9:28 pm


Joined: 08 Apr 2005

Posts: 10
Re: How to store and retereive image in database?
So out of curiosity, when would any of you suggest storing image data in
the database as opposed to image links?

-jmb

Azan wrote:

>I`m totally agree with that...
>so... decide which way to go based on your project..
>
>
>On 6/2/05, Mark Groen <markgroen@...> wrote:
>
>
>> ----- Original Message -----
>> From: "Eric Kandja" <>
>> To: <php-objects@yahoogroups.com>
>> Sent: Thursday, June 02, 2005 2:15 PM
>> Subject: Re: [php-objects] How to store and retereive image in database?
>>
>>
>> > In your Mysql database you can insert only the name of your image files
>> as
>> > you know which directory are your images.
>> > You will use this name in your webpage.
>>
>> That is the preferred method of course, but you can certainly store the
>> image as a binary object (blob) in your database without any problems.
>>
>> If your mysql server runs hard, storing the name of the image, (you only
>> need to store the name, the directory location can be coded in your php if
>> you save them in the same place), instead of the actual image will have a
>> smaller output using a bit of text compared to a large blob.
>>
>> Either way, the same amount of data has to be served up if we`re talking
>> about a web page, but it`s less juice to use the web server (like Apache)
>>to
>> store/retrieve images than a database.
>>
>> hope that makes sense, do a Google for the type of image uploader tutorial
>> you want. Try this:
>>
>>http://www.google.ca/search?hl=en&q=php+mysql+image+uploader&btnG=Google+Searc
h&meta=
>>
>> the tutes at phpfreaks.com are pretty good, (about the sixth link down),
>>and
>> they have a nice assortment of ready to use classes.
>>
>> cheers,
>>
>> Mark
>>
>> > > > How to store and retrieve image in mysql database.plz give example.
>> > > > Thnx in Advance
>> > >
>> > > code from link below, tutorial for it at phpbuilder.com:
>> > >
>> > >
>>http://lists.evolt.org/archive/Week-of-Mon-20020304/105637.html
>> > >
>> > > Warm Regards,
>> > >
>> > > Mark Groen
>> > >
>> > > MG Web Services
>> > > Web Site Hosting and Development
>> > > www.markgroen.com
>> > > 604-780-6917
>> > > Bowen Island, B.C., Canada
>> > >
>> > >
>> > > PHP Data object relational mapping generator -
>> > http://www.meta-language.net/
>> > > Yahoo! Groups Links
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> >
>> >
>> >
>> > PHP Data object relational mapping generator -
>> http://www.meta-language.net/
>> > Yahoo! Groups Links
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>>
>>
>>
>> PHP Data object relational mapping generator -
>>http://www.meta-language.net/
>>
>>
>> ________________________________
>> Yahoo! Groups Links
>>
>>
>>To visit your group on the web, go to:
>>http://groups.yahoo.com/group/php-objects/
>>
>>To unsubscribe from this group, send an email to:
>>php-objects-unsubscribe@yahoogroups.com
>>
>>Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>>
>>
>
>
>
>
>PHP Data object relational mapping generator - http://www.meta-language.net/
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
Reply with quote
Send private message
View user's profile Post To page top
soha_gg Posted: Fri Jun 03, 2005 9:51 am


Joined: 09 Mar 2005

Posts: 8
Re: How to store and retereive image in database?
Dear Sir,
Can u give me an example hot store the name and path of the image and then how
to retrieve.

Regards.
Muhammad Sohail Khan

Eric Kandja <erickandja@...> wrote:
In your Mysql database you can insert only the name of your image files as
you know which directory are your images.
You will use this name in your webpage.

Kind regards.

Eric


----- Original Message -----
From: "Mark Groen" <markgroen@...>
To: <php-objects@yahoogroups.com>
Sent: Thursday, June 02, 2005 7:43 AM
Subject: Re: [php-objects] How to store and retereive image in database?


> ----- Original Message -----
> From: "Muhammad Sohail Khan" <>
> To: <php-objects@yahoogroups.com>
> Sent: Thursday, June 02, 2005 6:28 AM
> Subject: [php-objects] How to store and retereive image in database?
>
>
> > How to store and retrieve image in mysql database.plz give example.
> > Thnx in Advance
>
> code from link below, tutorial for it at phpbuilder.com:
>
> http://lists.evolt.org/archive/Week-of-Mon-20020304/105637.html
>
> Warm Regards,
>
> Mark Groen
>
> MG Web Services
> Web Site Hosting and Development
> www.markgroen.com
> 604-780-6917
> Bowen Island, B.C., Canada
>
>
> PHP Data object relational mapping generator -
http://www.meta-language.net/
> Yahoo! Groups Links
>
>
>
>
>
>
>



PHP Data object relational mapping generator - http://www.meta-language.net/



---------------------------------
Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/

To unsubscribe from this group, send an email to:
php-objects-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]
Reply with quote
Send private message
Post new topic Reply to topic
Display posts from previous:   
 

All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help