RE: inserting images to mysql - is it possible?

2003-06-30 Thread Benjamin Davis
check out http://www.phpbuilder.com thay have a lot of things and that is one off them. -- eschew obfuscation. -Original Message- From: Digital Directory USA [mailto:[EMAIL PROTECTED] Sent: 29 June 2003 19:28 To: [EMAIL PROTECTED] Subject: inserting images to mysql - is it possible? I

Re: inserting images to mysql - is it possible?

2003-06-30 Thread Bob Ostermann
PROTECTED]> Sent: Monday, June 30, 2003 7:35 AM Subject: Re: inserting images to mysql - is it possible? > Armand- > > Why is it not recommended to store images in a database? I've not heard this... > > > bob. > > > > At 09:51 PM 6/29/03 +0200, you wrote: >

Re: inserting images to mysql - is it possible?

2003-06-30 Thread Gerald Jensen
Sent: Monday, June 30, 2003 7:35 AM Subject: Re: inserting images to mysql - is it possible? > Armand- > > Why is it not recommended to store images in a database? I've not heard this... > > > bob. > > > > At 09:51 PM 6/29/03 +0200, you wrote: > >Hi, > >

Re: inserting images to mysql - is it possible?

2003-06-30 Thread Bob Ostermann
Armand- Why is it not recommended to store images in a database? I've not heard this... bob. At 09:51 PM 6/29/03 +0200, you wrote: Hi, You have to insert a new blob field where you can store binary data. But it is not recommanded to store images in a database. I recommande you to store image

Re: inserting images to mysql - is it possible?

2003-06-29 Thread colbey
If you want to store images in the database, use a blob columntype.. And take a look at this example alot of people have based mysql binary storage off: http://www.php4.com/forums/viewtopic.php?t=6 good luck On Sun, 29 Jun 2003, Digital Directory USA wrote: > I am new to php and mysql, I have

Re: inserting images to mysql - is it possible?

2003-06-29 Thread Armand Turpel
Hi, You have to insert a new blob field where you can store binary data. But it is not recommanded to store images in a database. I recommande you to store images on a server filesystem and only the reference to the images in a database. Armand Digital Directory USA wrote: I am new to php an

Re: Inserting images (not the location of the images)

2002-06-26 Thread Eric L. Howard
[please honor my mail-followup-to header] At a certain time, now past, Dana Diederich spake thusly: > Out of curiosity, why would you recommend not putting images into a DB? > I've had a lot of success doing that sort of thing. > > Cheers. > -Dana I never said it wouldn't work, but you need to

Re: Inserting images (not the location of the images)

2002-06-25 Thread Eric L. Howard
At a certain time, now past, Emma Grant spake thusly: > Hi All, > >First of all I want to thank you all for all the help that you have given me >throughout the last week. > 8<--snip > I need to be able to insert images into the database through a FILE FIELD on a

Re: Inserting images (not the location of the images)

2002-06-25 Thread Neil Freeman
You can easily upload images using just your web browser - an FTP program is not needed. You'll need a form with it's encoding set to multipart/form-data, e.g. ... ... ... and then within your receiving script you'll need something similar to: $image_filename = $HTTP_POST_

Re: Inserting images (not the location of the images)

2002-06-25 Thread Keith C. Ivey
On 24 Jun 2002, at 18:36, Emma Grant wrote: > I know that many of you are about to tell me to store the images on my > server, and reference the location from my database field. As I have > read many times throughout my research. But I want the ability for the > user to choose the images they wan

Re: Inserting images (not the location of the images)

2002-06-24 Thread Paul DuBois
At 18:36 -0700 6/24/02, Emma Grant wrote: >Hi All, > >First of all I want to thank you all for all the help that >you have given me throughout the last week. > >I have learnt a great deal, and through your help and the >resources on the interenet I have successfully been able to cr

Re: Inserting images and other blobs

2002-05-21 Thread Tim Best
on 5/21/02 2:09 PM, Jim Philips at [EMAIL PROTECTED] wrote: > On Tuesday 21 May 2002 10:54 am, Info_Best-IT wrote: >> Any suggestions on how to load images from a web site into a MySQL db? I >> would like to set up a page that allows you to select an image from the >> local machine and load it t

Re: Inserting images and other blobs

2002-05-21 Thread Jim Philips
On Tuesday 21 May 2002 10:54 am, Info_Best-IT wrote: > Any suggestions on how to load images from a web site into a MySQL db? I > would like to set up a page that allows you to select an image from the > local machine and load it to my MySQL DB on my web server. > > I'm not sure if it would just

Re: Inserting images and other blobs

2002-05-21 Thread Harrison C. Fisk
There is a function called Load_File which will cause the mysqld to read the file into a field. It is designed for such things. Check out http://www.mysqldeveloper.com/faqs/index.pcgi?id=7 for more information. Keep in mind that generally it is better to use the file system to store files and th

Re: inserting images

2001-10-03 Thread Carl Troein
Sandeep Murthy writes: > The database I have created for storing images has a field called > binary_junk which is of type "BLOB" but its still not working... [snipped PHP code] Man, I can see why you have problems getting your code to work. Try checking for errors instead of assuming that every

Re: inserting images

2001-10-03 Thread Sandeep Murthy
t; Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 03, 2001 5:23 PM Subject: Re: inserting images > I have never done it but have seen posts on this topic. From what I > understand you need to create a BLOB field in your DB (MySQL) then upload > file to your server, read it with f

Re: inserting images

2001-10-03 Thread AJDIN BRANDIC
I have never done it but have seen posts on this topic. From what I understand you need to create a BLOB field in your DB (MySQL) then upload file to your server, read it with fopen (or ...) into a variable then insert that variable into the BLOB field you have in your DB. Hope I am right her

Re: inserting images in mysql tables

2001-06-19 Thread Cal Evans
IMHO, (take it for what it is worth) You shouldn't. Store a reference to the image in the database.(either a file system reference, or if you are doing HTML, store the URL) I've yet to see a good reason for stuffing an image in a database. In most cases the OS/file system will handle the image f

Re: inserting images in mysql tables

2001-06-19 Thread Tyler Longren
you should probably just store the images on your server, and provide the location to the image in the table...much quicker. Tyler - Original Message - From: Felicia <[EMAIL PROTECTED]> To: mysql post <[EMAIL PROTECTED]> Sent: Tuesday, June 19, 2001 11:03 AM Subject: inserting images in

RE: Inserting images into BLOB Fields

2001-05-20 Thread Mike
Thank you!!! -Original Message- From: indrek siitan [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 20, 2001 9:51 PM To: Mike; [EMAIL PROTECTED] Subject: RE: Inserting images into BLOB Fields Hi, > How can I insert an image file into a blob field? I search the MySQL > Documen

RE: Inserting images into BLOB Fields

2001-05-20 Thread indrek siitan
Hi, > How can I insert an image file into a blob field? I search the MySQL > Documents but nothing came up specificaly on inserting images from files. INSERT INTO sig VALUES ( 1, 'Paul', 'Davolio', LOAD_FILE('d:/signatures/paul.txt') ); Rgds, Tfr --==< [EMAIL PROTECTED]