Storing images in mySQL

[Ash Christopher]

Is there a way to store images in a mySQL database? I was hoping to store
them in a table, then use php to call them from the database and display the
picture on a webpage.

Any help would be appreciated.

[Vincent Bouret]

Put the binary raw content of the image in a BLOB (or MEDIUMBLOB) field.
Then do a select to get the content of that field. Put that content in a
temporary file with a random filename. In the PHP page, make a reference to
this temporary image by outputting the HTML.

<img src="<?php echo $temporary_filename; ?>">

I think there are more fancy ways of doing this, but that should be working.

Good luck

Vincent Bouret

"Ash Christopher" <as************@newthink.net> wrote in message
news:UI***********************@news1.calgary.shaw. ca...

Is there a way to store images in a mySQL database? I was hoping to store
them in a table, then use php to call them from the database and display the picture on a webpage.

Any help would be appreciated.

[Vincent Bouret]

Put the binary raw content of the image in a BLOB (or MEDIUMBLOB) field.
Then do a select to get the content of that field. Put that content in a
temporary file with a random filename. In the PHP page, make a reference to
this temporary image by outputting the HTML.

<img src="<?php echo $temporary_filename; ?>">

I think there are more fancy ways of doing this, but that should be working.

Good luck

Vincent Bouret

"Ash Christopher" <as************@newthink.net> wrote in message
news:UI***********************@news1.calgary.shaw. ca...

Is there a way to store images in a mySQL database? I was hoping to store
them in a table, then use php to call them from the database and display the picture on a webpage.

Any help would be appreciated.

[Vincent Bouret]

Put the binary raw content of the image in a BLOB (or MEDIUMBLOB) field.
Then do a select to get the content of that field. Put that content in a
temporary file with a random filename. In the PHP page, make a reference to
this temporary image by outputting the HTML.

<img src="<?php echo $temporary_filename; ?>">

I think there are more fancy ways of doing this, but that should be working.

Good luck

Vincent Bouret

"Ash Christopher" <as************@newthink.net> wrote in message
news:UI***********************@news1.calgary.shaw. ca...

Is there a way to store images in a mySQL database? I was hoping to store
them in a table, then use php to call them from the database and display the picture on a webpage.

Any help would be appreciated.

[Jamie Davison]

There's a good tutorial at: http://codewalkers.com/tutorials/35/1.html

-JD
"Ash Christopher" <as************@newthink.net> wrote in message
news:UI***********************@news1.calgary.shaw. ca...

Is there a way to store images in a mySQL database? I was hoping to store
them in a table, then use php to call them from the database and display the picture on a webpage.

Any help would be appreciated.

[Jamie Davison]

There's a good tutorial at: http://codewalkers.com/tutorials/35/1.html

-JD
"Ash Christopher" <as************@newthink.net> wrote in message
news:UI***********************@news1.calgary.shaw. ca...

Is there a way to store images in a mySQL database? I was hoping to store
them in a table, then use php to call them from the database and display the picture on a webpage.

Any help would be appreciated.

[Jamie Davison]

There's a good tutorial at: http://codewalkers.com/tutorials/35/1.html

-JD
"Ash Christopher" <as************@newthink.net> wrote in message
news:UI***********************@news1.calgary.shaw. ca...

Is there a way to store images in a mySQL database? I was hoping to store
them in a table, then use php to call them from the database and display the picture on a webpage.

Any help would be appreciated.

[Ralph Freshour]

I read that tutorial - I'm only getting the filename stored in the
table, not the actual image -

$php_SQL = "UPDATE photos SET photo1 = '".$php_image."'"." WHERE
member_name = '".$php_member_name)."'";

Is this correct or am I missing something???

Raph

On Sun, 17 Aug 2003 17:04:11 GMT, "Jamie Davison" <ja***@bardavon.org>
wrote:

There's a good tutorial at: http://codewalkers.com/tutorials/35/1.html

-JD
"Ash Christopher" <as************@newthink.net> wrote in message
news:UI***********************@news1.calgary.shaw .ca...

Is there a way to store images in a mySQL database? I was hoping to store
them in a table, then use php to call them from the database and display

the

picture on a webpage.

Any help would be appreciated.

[Ralph Freshour]

I read that tutorial - I'm only getting the filename stored in the
table, not the actual image -

$php_SQL = "UPDATE photos SET photo1 = '".$php_image."'"." WHERE
member_name = '".$php_member_name)."'";

Is this correct or am I missing something???

Raph

On Sun, 17 Aug 2003 17:04:11 GMT, "Jamie Davison" <ja***@bardavon.org>
wrote:

There's a good tutorial at: http://codewalkers.com/tutorials/35/1.html

-JD
"Ash Christopher" <as************@newthink.net> wrote in message
news:UI***********************@news1.calgary.shaw .ca...

Is there a way to store images in a mySQL database? I was hoping to store
them in a table, then use php to call them from the database and display

the

picture on a webpage.

Any help would be appreciated.

[Ralph Freshour]

I read that tutorial - I'm only getting the filename stored in the
table, not the actual image -

$php_SQL = "UPDATE photos SET photo1 = '".$php_image."'"." WHERE
member_name = '".$php_member_name)."'";

Is this correct or am I missing something???

Raph

On Sun, 17 Aug 2003 17:04:11 GMT, "Jamie Davison" <ja***@bardavon.org>
wrote:

There's a good tutorial at: http://codewalkers.com/tutorials/35/1.html

-JD
"Ash Christopher" <as************@newthink.net> wrote in message
news:UI***********************@news1.calgary.shaw .ca...

Is there a way to store images in a mySQL database? I was hoping to store
them in a table, then use php to call them from the database and display

the

picture on a webpage.

Any help would be appreciated.