stocking pictures in mysql database ?

Hello, How can i stocking pictures in mysql database ? i've tried to open a file as binary, i've replaced ascii(0) by '\O', etc. i've done an 'insert into table set field='datas'' but doesn't work please help me Pierrot

Re: stocking pictures in mysql database ?

: Friday, September 06, 2002 3:57 AM Subject: stocking pictures in mysql database ? Hello, How can i stocking pictures in mysql database ? i've tried to open a file as binary, i've replaced ascii(0) by '\O', etc. i've done an 'insert into table set field='datas'' but doesn't work please help

Re: stocking pictures in mysql database ?

Hi, You have to use LOAD_FILE() function to load a file into a blob column. See:http://www.mysql.com/doc/en/String_functions.html Gurhan On Fri, 2002-09-06 at 04:57, navarra/mail.satori.fr wrote: Hello, How can i stocking pictures in mysql database ? i've tried to open a file as binary

Re: Binaries /Pictures in mysql

programming. Can someone please tell me where I can find some info on putting pictures into mysql fields and also how I can use a web interface to add the pictures to the database. Thanks Denis - Before posting

Pictures in mysql

Hello friends. I am a newbie in mysql and web programming. Can someone please tell me where I can find some info on putting pictures into mysql fields and also how I can use a web interface to add the pictures to the database. Thanks Denis

Re: Pictures in mysql

You should just enter the path to the picture in the database, in a varchar field. On Wednesday 24 October 2001 08:09 am, [EMAIL PROTECTED] wrote: Hello friends. I am a newbie in mysql and web programming. Can someone please tell me where I can find some info on putting pictures

RE: Pictures in mysql

structure of your choice. This works well for us. -Original Message- From: Kodrik [mailto:[EMAIL PROTECTED]] Sent: 24 October 2001 07:16 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Pictures in mysql You should just enter the path to the picture in the database, in a varchar field

RE: Pictures in mysql

, of course, if you have the correct permissions on the server's temp folder. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 8:10 AM To: [EMAIL PROTECTED] Subject: Pictures in mysql Hello friends. I am a newbie in mysql and web

Re: Pictures in mysql

that only because of the pictures. Now making the backups, etc isnt too easy. Cheers S. Hello friends. I am a newbie in mysql and web programming. Can someone please tell me where I can find some info on putting pictures into mysql fields and also how I can use a web interface to add

Help me HOw to load Images or pictures into MYSQL database

hello Please inform me how to load IMAGES INTO MYSQL TABLES. thanks Palaniappan _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Re: Help me HOw to load Images or pictures into MYSQL database

Please inform me how to load IMAGES INTO MYSQL TABLES. You can do so with MySQL-Front - www.mysqlfront.de . Simply paste image from clipboard into BLOB-Editor. Greetings, Ansgar - Before posting, please check:

Re: Help me HOw to load Images or pictures into MYSQL database

Please inform me how to load IMAGES INTO MYSQL TABLES. Having created several similar applications in the past I would recommend NOT storing these images IN the database; your filesystem makes for a nice blob storage device. I would instead store pointers of some sort to the files to

Re: Storing pictures in mySQL

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 has

Re: Storing pictures in mySQL

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

Storing pictures in mySQL

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

Re: Storing pictures in mySQL

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

Antwort: Storing pictures in mySQL

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

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: is it possible? If yes, how ?

Re: Antwort: Storing pictures in mySQL

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

Re: Antwort: Storing pictures in mySQL

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! I don't know if many people would recommend th

Re: Antwort: Storing pictures in mySQL

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: Storing pictures in mySQL

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 Alias

Re: Antwort: Saving pictures in MySql

Hi All Thanks for the info but I need to be able to read a selected file from client host and write this to te db. I use this to get the file from client Picture:input type="file" name="picture_path"br input type="Submit" name="submit" value="Enter information" this gets the path and file

Re: Antwort: Saving pictures in MySql

Danie Weideman schrieb: I played around with fread PHP function but with no-luck how about fopen(), or $fp=fsockopen( "$host", 80,); $anfrage="GET $seite HTTP/1.0\r\n"); etc. IrmundThum - Before posting, please check:

Saving pictures in MySql

Hi everyone I am new to MySql and PHP I have downloaded and configured both I have just finished my first db and are on a high. I was quickly broad to ground when I tried to load a image via a form into the database. Could someone please help with: What field type must be defined for

Re: Saving pictures in MySql

... Some of them may or maynot be helpful.. regards Barry -Original Message- From: Danie Weideman [mailto:[EMAIL PROTECTED]] Sent: 23 February 2001 02:02 To: [EMAIL PROTECTED] Subject: Saving pictures in MySql Hi everyone I am new to MySql and PHP I have downloaded

Antwort: Saving pictures in MySql

On 23.02.2001 13:01:44 Danie Weideman wrote: What field type must be defined for pictures. MEDIUMTEXT for the data VARCHAR/ENUM/INTEGER/whatever for the image type How to load and retreive pictures from a database using PHP The same you do with "normal" data. Ie.: Store:INSERT INTO