Re: Storing pictures in mySQL

2001-04-05 Thread Peter Skipworth
> I am not sure what you explained. You mean that place PATH/filename.jpg to > picture field. isn't it? If yes, it is just a text. How can we explore that > picture thru web browser such as IE or Netscape? Thanks for the answer Your image would be in, say /usr/local/apache/htmldoc/images/simpleto

Re: Storing pictures in mySQL

2001-04-05 Thread alexander . skwar
On 05.04.2001 04:23:55 Taing Nguon wrote: > I am not sure what you explained. You mean that place PATH/filename.jpg to > picture field. isn't it? If yes, it is just a text. How can we explore that > picture thru web browser such as IE or Netscape? Thanks for the answer Well, he said that he ha

Re: Storing pictures in mySQL

2001-04-04 Thread Taing Nguon
>I would rather store the files on disk and the filenames in the database for more speed. >I'm a developer on a website which members have an uploaded image of theirself.. >We just have a image directory with filenames as [username].jpg >This dir is therefore easily mapped to the web with an Ali

Re: Antwort: Storing pictures in mySQL

2001-04-04 Thread alexander . skwar
On 04.04.2001 11:21:46 Peter Skipworth wrote: > Ouch! I don't know if many people would recommend this method - that's a > fair bit of unnecesary overhead to place ony our server...depending, of > course, on how often these images are created/modified/read. Do you mean the base64 part, or what?

Re: Antwort: Storing pictures in mySQL

2001-04-04 Thread Johan Andersson
om: "Peter Skipworth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Nicolas Villatte" <[EMAIL PROTECTED]>; "Mysql (E-mail)" <[EMAIL PROTECTED]> Sent: Wednesday, April 04, 2001 11:21 AM Subject: Re: Antwort: Storing pictures in mySQL > Ouch!

Re: Antwort: Storing pictures in mySQL

2001-04-04 Thread Peter Skipworth
Ouch! I don't know if many people would recommend this method - that's a fair bit of unnecesary overhead to place ony our server...depending, of course, on how often these images are created/modified/read. P > > Here's how I do b) in PHP: > > 1) Get the MIME type of the image. > 2) Read the b

Re: Storing pictures in mySQL

2001-04-04 Thread Johan Andersson
Regards, Johan Andersson Consultant - Original Message - From: "B. van Ouwerkerk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 04, 2001 9:01 AM Subject: Re: Storing pictures in mySQL > At 08:55 4-4-01 +0200, Nicolas Villatte wrote: > >

Antwort: Storing pictures in mySQL

2001-04-04 Thread alexander . skwar
On 04.04.2001 08:55:04 Nicolas Villatte wrote: > is it possible? If yes, how ? Could someone *PLEASE* add this to the FAQ? There are two answers you'll get: a) Don't store the binary data in the database. Instead store nothing but the metadata. b) Also store the binary data in the database.

Re: Storing pictures in mySQL

2001-04-03 Thread B. van Ouwerkerk
At 08:55 4-4-01 +0200, Nicolas Villatte wrote: >is it possible? If yes, how ? Yes.. BLOB (BinaryLargeOBject) Check the archive, and manual. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the ma

Storing pictures in mySQL

2001-04-03 Thread Nicolas Villatte
is it possible? If yes, how ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsub