Re: How can I display images from a mySQL Database in a web page?

2003-07-15 Thread colbey
.. good luck. On Tue, 15 Jul 2003, Dan Anderson wrote: I have created a BLOB field to store images. Is there any way to embed them within HTML with something like: image start: jpeg /image Thanks in advance, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: How can I display images from a mySQL Database in a web page?

2003-07-15 Thread Partap Davis
PROTECTED] wrote: I have created a BLOB field to store images. Is there any way to embed them within HTML with something like: image start: jpeg /image Thanks in advance, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: How can I display images from a mySQL Database in a web page?

2003-07-15 Thread William R. Mussatto
[EMAIL PROTECTED] wrote: I have created a BLOB field to store images. Is there any way to embed them within HTML with something like: image start: jpeg /image Thanks in advance, Dan blob datatype. But again why do this. use a file system and put the file's address in the database

Re: How can I display images from a mySQL Database in a web page?

2003-07-15 Thread Dan Anderson
I think there is a way to insert binary image data in your html, but is there any particular reason you need to do that? Yes, my client's server is running with particularly restrictive PHP safe mode settings and has informed me that dynamic images are a /must have/. :: bangs head against wall

Re: How can I display images from a mySQL Database in a web page?

2003-07-15 Thread Keith C. Ivey
images are a /must have/. :: bangs head against wall. starts to bleed :: Dynamic images don't require inserting binary data into your HTML. (It is possible to use 'data:' URLs to insert arbitrary data into your HTML, but very few broswers support it, and it's not relevant for your purposes

Is it possible to dump images into a database?

2003-07-09 Thread Dan Anderson
Can anyone point me to a reference on how to insert images into a column in a mySQL database -- or is that not possible? Thanks in advance, Dan Anderson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Is it possible to dump images into a database?

2003-07-09 Thread colbey
images into a column in a mySQL database -- or is that not possible? Thanks in advance, Dan Anderson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives

RE: Is it possible to dump images into a database?

2003-07-09 Thread Mike Hillyer
images into a database? Can anyone point me to a reference on how to insert images into a column in a mySQL database -- or is that not possible? Thanks in advance, Dan Anderson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http

RE: Is it possible to dump images into a database?

2003-07-09 Thread Rudy Metzger
. Cheers /rudy -Original Message- From: Dan Anderson [mailto:[EMAIL PROTECTED] Sent: woensdag 9 juli 2003 16:49 To: [EMAIL PROTECTED] Subject: Is it possible to dump images into a database? Can anyone point me to a reference on how to insert images into a column in a mySQL database

NEWBIE how can i store images in a database?

2003-07-09 Thread cronix
hello, i'm just changing from openbase SQL to MySQL, so i'm new here. in openbase i had images stored in a database. the 'type' was set to 'object'. i can't find something like that here and also not in the manual. what should i use? thanx for advance cheers christian -- MySQL General

RE: NEWBIE how can i store images in a database?

2003-07-09 Thread Mike Brum
You'd want to use a BLOB (binary large object) if that's what your goal is. But if you're using this for a web application I'd highly suggest that you instead save images to a directory and make a reference to the path in the database. If you have many BLOB inserts or selects on a site, your

Re: NEWBIE how can i store images in a database?

2003-07-09 Thread cronix
thanks a lot!!! cheers christian You'd want to use a BLOB (binary large object) if that's what your goal is. But if you're using this for a web application I'd highly suggest that you instead save images to a directory and make a reference to the path in the database. If you have many BLOB

Re: NEWBIE how can i store images in a database?

2003-07-09 Thread Peter Burden
mislead next year's students ;-) You'd want to use a BLOB (binary large object) if that's what your goal is. But if you're using this for a web application I'd highly suggest that you instead save images to a directory and make a reference to the path in the database. If you have many BLOB inserts

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

Re: inserting images to mysql - is it possible?

2003-06-30 Thread Gerald Jensen
Bob: This question comes up over and over on the list ... do a search for 'images' of the list archive and you can read the accumulated pros and cons. Gerald Jensen - Original Message - From: Bob Ostermann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 30, 2003 7:35 AM

Re: inserting images to mysql - is it possible?

2003-06-30 Thread Bob Ostermann
Hi Gerald- I understand the pros and cons of db vs filesystem, and for images (static, rarely changing) it makes sense. I was pursuing any info about large chunk transfers or fragmented storage issues for large field tables. I'm working with a table containing historical information for 67,000

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

inserting images to mysql - is it possible?

2003-06-29 Thread Digital Directory USA
I am new to php and mysql, I have searched looked over and cannot find a way to do this... can it be done? I have set up the following in mysql. How do I upload the product images to the pPhoto column. Any suggestions? ds_produc Field Type Attributes Null Default Extra pID

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

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: Color Images + Installation Questions

2003-06-07 Thread David Blomstrom
At 12:44 AM 6/7/2003 -0400, Becoming Digital wrote: Personally, I prefer Apache over IIS (or PWS, as the case may be), even in a WinXP environment. Joining the Linux/Apache bandwagon is one of my goals. I even got Linux installed on my computer a couple months ago. But I've been so overwhelmed,

Re: MySQL versus Color Images

2003-06-07 Thread Curtis Maurand
MySQL tables also incorporate style sheet attributes, regulating the cell background colors/images, font type, etc.? You can see an example of what I'm getting ready to tackle at http://www.geobop.com/Marini/2.htm The second and third tables each have rows representing several Central

MySQL versus Color Images

2003-06-06 Thread David Blomstrom
- especially any that offer visitors a choice of HOW they want to sort them? 2. Can MySQL tables also incorporate style sheet attributes, regulating the cell background colors/images, font type, etc.? You can see an example of what I'm getting ready to tackle at http://www.geobop.com/Marini/2.htm

Re: MySQL versus Color Images

2003-06-06 Thread Becoming Digital
] To: [EMAIL PROTECTED] Sent: Friday, 06 June, 2003 20:18 Subject: MySQL versus Color Images I joined this list some time ago, but I still haven't had time to really start learning MySQL yet. I just wanted to ask a couple questions while they're fresh in my mind: 1. Can you point me to some good examples

Color Images + Installation Questions

2003-06-06 Thread David Blomstrom
At 09:55 PM 6/6/2003 -0400, Becoming Digital wrote: Rather than let discussion here stray too far from strictly MySQL issues, try subscribing to the PHP-DB mailing list ([EMAIL PROTECTED]) and re-posting there. We'd all be happy to help you. :) Thanks. I just e-mailed that address with subscribe

Re: Color Images + Installation Questions

2003-06-06 Thread Becoming Digital
PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, 07 June, 2003 00:27 Subject: Color Images + Installation Questions At 09:55 PM 6/6/2003 -0400, Becoming Digital wrote: Rather than let discussion here stray too far from strictly MySQL issues, try subscribing to the PHP-DB mailing list ([EMAIL

Storing Images in MySQL

2003-03-28 Thread vernon
Hey all, I'm using phpNewsAds and am wanting to store images in MySQL. I have this working on my Red Hat 7.2 Box and am moving to a new server running Red Hat 7.3 and of course, after moving the database the images are not being dispalyed. The database, however, is working. I'm assuming

RE: Storing Images in MySQL

2003-03-28 Thread Dathan Vance Pattishall
: Storing Images in MySQL Hey all, I'm using phpNewsAds and am wanting to store images in MySQL. I have this working on my Red Hat 7.2 Box and am moving to a new server running Red Hat 7.3 and of course, after moving the database the images are not being dispalyed. The database, however, is working

RE: Storing Images in MySQL

2003-03-28 Thread William R. Mussatto
: Storing Images in MySQL Hey all, I'm using phpNewsAds and am wanting to store images in MySQL. I have this working on my Red Hat 7.2 Box and am moving to a new server running Red Hat 7.3 and of course, after moving the database the images are not being dispalyed. The database, however

Auto-emai/fax MySQL's data, with images/forms attachment.

2003-03-27 Thread thomas getty
I need some feedback on the capability of PF-Merge from anyone who might share their experience. It seems very solid from their testimonies at their web sites though. Merge databases’ data (including images) directly into Acrobat-based Forms, without programming; optionally auto

Auto-emai/fax MySQL's data, with images/forms attachment.

2003-03-27 Thread thomas getty
I need some feedback on the capability of PF-Merge from anyone who might share their experience. It seems very solid from their testimonies at their web sites though. Merge databases’ data (including images) directly into Acrobat-based Forms, without programming; optionally auto

Re: images with mysql

2003-03-21 Thread lasse
don't like the possible securtyissues with that. Besides... if you render a page with a selectbox from mysqltables and another with images and let the user match them together, it's idiotproof =) If you have a php(or whatever)-file wich sole purpouse is to check users rights and render images

RE: images with mysql

2003-03-21 Thread Paul Larue
Don't forget that the images can be stored *outside* the root dir. Access them using ../../ until you reach your img dir. There's no way to get to the images directly then. Paul -Original Message- From: lasse [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 12:14 AM To: unlisted

Re: images with mysql

2003-03-21 Thread B. van Ouwerkerk
Not an issue since you don't need to edit the htaccess file for every file. You set it for the whole directory. The only reason for preventing ppl to access files would be theft of bandwith. If you worry about ppl being able to get the images then you shouldn't publish them at all. You can't

Re: images with mysql

2003-03-20 Thread stefano . cardo
Hi! I have a problem with my MySQL I need to have some a images related with an item for example -- ! author ! date of birth an death ! image! -- How can I define the field for the images? I have read

RE: images with mysql

2003-03-20 Thread Simon Green
a bit. Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 20 March 2003 09:34 To: [EMAIL PROTECTED] Subject: Re: images with mysql Hi! I have a problem with my MySQL I need to have some a images related with an item for example

Re: images with mysql

2003-03-20 Thread Lai Liu-yuan
I am now having a database storing images of chinese characters for research purpose. I wrote a program to store and retrieve them. My images are of type ppm. This is how I designed my table: mysql describe poor; +++--+-+-+---+ | Field | Type

Re: images with mysql

2003-03-20 Thread B. van Ouwerkerk
so it might be quicker.. B. At 18:34 20-03-2003 +, Lai Liu-yuan wrote: I am now having a database storing images of chinese characters for research purpose. I wrote a program to store and retrieve them. My images are of type ppm. This is how I designed my table: mysql describe poor

Re: images with mysql

2003-03-20 Thread Lai Liu-yuan
Well, this may be off topic. In my case, I store tens of thousands of images, gradually growing. All of them are quite small, most around 30*30 gray scale. Would it still be faster to store them on disk? On Thu, 20 Mar 2003 13:57:06 +0100 B. van Ouwerkerk [EMAIL PROTECTED] wrote: IMHO it's

Re: images with mysql

2003-03-20 Thread walt
Lai Liu-yuan wrote: Well, this may be off topic. In my case, I store tens of thousands of images, gradually growing. All of them are quite small, most around 30*30 gray scale. Would it still be faster to store them on disk? In most cases yes. We have over 3.5 million images stored

Re: images with mysql

2003-03-20 Thread B. van Ouwerkerk
I assume it is, have not tested it.. If you need to fetch the files from the database your app needs to wait until it has recieved the data. If you only store name/path info it will take less time to fetch the data, ship it off to the browser which can start fetching the images without

Re: images with mysql

2003-03-20 Thread lasse
hey all.. new to the list. Just my 5 cents... I think it's better to store images in the database, sure you loose a bit in performance, but it's easier to code. The way i've done it before is always a separate render.php (or what ever) that compares the users rights to view that image, get's

Re: images with mysql

2003-03-20 Thread B. van Ouwerkerk
You can use other ways to protect your images from linking by others. Like with Apache and htaccess.. I don't agree with you on your opinion that it's easier to code. If you insert a link into your database all you have to do is retrieve it and push the link to the browser. B. At 20:18 20

Re: Getting Images in and out of a Blob

2003-01-31 Thread Paul DuBois
At 1:26 -0700 1/30/03, Mike Walth wrote: Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field. I am curious on how to insert the image from a web form upload, and how to display the picture

RE: Getting Images in and out of a Blob

2003-01-31 Thread Sherzod Ruzmetov
: Has anyone done any work with getting images into and out of a MYSQL : database? I have used mysql for some time, but never : stored an image : in a : blob field. I am curious on how to insert the image from a web form : upload, : and how to display the picture

RE: Getting Images in and out of a Blob

2003-01-31 Thread Hoffman, Geoffrey
You might find this helpful - I did. http://www.phpbuilder.com/columns/florian19991014.php3 Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field

Getting Images in and out of a Blob

2003-01-30 Thread Mike Walth
Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field. I am curious on how to insert the image from a web form upload, and how to display the picture on another HTML page. Preferred web scripting

RE: Getting Images in and out of a Blob

2003-01-30 Thread Sherzod Ruzmetov
:Has anyone done any work with getting images into and out of a MYSQL :database? I have used mysql for some time, but never stored :an image in a :blob field. I am curious on how to insert the image from a :web form upload, :and how to display the picture on another HTML

Re: Getting Images in and out of a Blob

2003-01-30 Thread Stefan Hinz, iConnect \(Berlin\)
Mike, Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field. I am curious on how to insert the image from a web form upload, and how to display the picture on another HTML page. You might

Re[2]: Storeing images in Database

2003-01-25 Thread Dyego Souza do Carmo
Dobrý den, sexta-feira, 24 de janeiro de 2003, 22:41:47, napsal jste: WRM Since you obviously aren't going to search the images themselves there is WRM no reason to put them into a database. File systems are designed for WRM this. I might suggest using an Id field and then split them into WRM

Storeing images in Database

2003-01-24 Thread Dyego Souza do Carmo
Hello community !!! The software house on i'm work want to store images ( TIF FILES +/- 100kb compressed with gzip ) on database... using InnoDB database... ( files or raw devices ) The discussion is : - The innodb ( or myisam ) is sufficient robust to allow store 10.000.000 images

Re: Storeing images in Database

2003-01-24 Thread William R. Mussatto
Hello community !!! The software house on i'm work want to store images ( TIF FILES +/- 100kb compressed with gzip ) on database... using InnoDB database... ( files or raw devices ) The discussion is : - The innodb ( or myisam ) is sufficient robust to allow store 10.000.000

Re: Embedding images stored in database

2003-01-13 Thread Dan Nelson
In the last episode (Jan 13), Toomas said: Hello List, Is there a simplier way to embed an image stored in BLOB field into HTML than using 2 calls to Perl scripts - one to generate HTML and another call from that HTML via IMG tag to retrieve and print image? I mean, something like you do it

View multiple images in a page

2002-12-29 Thread tan tan
Hi, I'm able to run the following code in the jsp. But my problem is I have multiple images in a table and would like all of it to be display as an icon. I have tried to put while(rs.next())... it doesn't work. How should I go about to do it. Thanks. Tan %@ page import=java.sql.* % %@ page

Re: Multiple indexed images or property id or both

2002-11-30 Thread rw
Greetings mysql gurus! I have a client who has specified using 5 fields, each indexed with an image id. Would it be better to have a separate table using image urls, with each set of images using the corresponding property id? I'm not clear why he wants to index the image ids. Thanks

Re: Storing 100 million images in the database

2002-09-30 Thread Ben Goodwin
Mmm.. filter goodness. Trying again with the required words: sql query ... along the lines of using the database as a pointer to the real file in a normal filesystem that others have suggested.. may I add the idea of using a 'hashed' directory structure such that you don't end up with an

Storing 100 million images in the database

2002-09-26 Thread Andrew Bryant
demanding in this respect. We have 125 million smallish images (each one is tens of KB, produced by gene sequencing machines). Currently we store these in tarfiles and index the images (the offset in the tar file) using an Oracle database. Each tarfile is around 1.5GB, containing tens of thousands

RE: Storing 100 million images in the database

2002-09-26 Thread Dean Harding
. -Original Message- From: Andrew Bryant [mailto:[EMAIL PROTECTED]] Sent: Thursday, 26 September 2002 7:31 pm To: [EMAIL PROTECTED] Subject: Storing 100 million images in the database Hello all, This discussion appeared recently: | Can I use MySQL to store pictures as part

Re: Storing 100 million images in the database

2002-09-26 Thread Michael T. Babcock
the last_insert_id() and store the image as /{reiserfs path}/{last_insert_id()}.png. Retrieving these images is as simple as making a DB query for the primary key ID and then opening that image number. This has the added advantage of not needing to do any conversions on the data to open the files

Re: Storing 100 million images in the database

2002-09-26 Thread Michael Bacarella
On Thu, Sep 26, 2002 at 10:31:06AM +0100, Andrew Bryant wrote: We have 125 million smallish images (each one is tens of KB, produced by gene sequencing machines). Currently we store these in tarfiles and index the images (the offset in the tar file) using an Oracle database. Each tarfile

Storing images in MySQL bad idea, performance-wise?

2002-07-08 Thread René Fournier
store all such images in the DB? (Which I understand reduces performance.) Or do I--somehow--store the images as files on the client's web server? And if so, how? (Because my PHP scripts are being executed on a different server.) ...Rene --- René Fournier, [EMAIL PROTECTED] Toll-free

Re: Storing images in MySQL bad idea, performance-wise?

2002-07-08 Thread Gerald R. Jensen
a search of the list archive for 'blob versus file' and read some informed opinions. Gerald Jensen - Original Message - From: René Fournier [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 08, 2002 5:34 PM Subject: Storing images in MySQL bad idea, performance-wise

resizing images in blobs

2002-07-04 Thread andy
Hi there, I am wondering if it is anyhow possible to resize an image stored in a blob field. Lets say the image is 400 x 300 px and I would like tor resize the image to 40 x 30. Is there a way without php or similar? Maybe someone has done this already and can give me a hint on that. Thanx in

Re: resizing images in blobs

2002-07-04 Thread sherzodr
:Lets say the image is 400 x 300 px and I would like tor resize the image to :40 x 30. :Is there a way without php or similar? Go with ImageMagick. It has a imaging resizing and cropping functions : :Maybe someone has done this already and can give me a hint on that. : :Thanx in

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

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 want

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. form name=formAddTitle method=post action=save_details.php enctype=multipart/form-data ... input type=file name=imgCover

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 web

Inserting images (not the location of the images)

2002-06-24 Thread Emma Grant
even know how to access MySQL last Thursday ☺ But as you expected, here comes my question; I need to be able to insert images into the database through a FILE FIELD on a web form. I have already tried this through a simple form that I created, but it only inserts the actual location (eg

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

2002-06-24 Thread Paul DuBois
) Just to think, I didn’Äôt even know how to access MySQL last Thursday ’ò† But as you expected, here comes my question; I need to be able to insert images into the database through a FILE FIELD on a web form. I have already tried this through a simple form that I created, but it only inserts

Inserting images and other blobs

2002-05-21 Thread Info_Best-IT
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 be a regular insert statement or something else? Thanks

Re: Inserting images and other blobs

2002-05-21 Thread Harrison C. Fisk
and the database to store data. The preferred way to do this with images is to just keep track of the name and location of the file in the database. Good luck with your application. Harrison - Original Message - From: Info_Best-IT [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 21

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 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 to my

Problem with Images and Blobs

2002-03-01 Thread Hector Rosas
Hello, look I'm trying to insert an Image into a blob field with a Normal insert query. I know that the information that will be contained on the blob field should be between (quotation marks), but if inside the info of the image is a quotation mark it should be escaped with a \ (back slash).

Re: Problem with Images and Blobs

2002-03-01 Thread Paul DuBois
At 10:09 -0700 3/1/02, Hector Rosas wrote: Hello, look I'm trying to insert an Image into a blob field with a Normal insert query. I know that the information that will be contained on the blob field should be between (quotation marks), but if inside the info of the image is a quotation mark

Images in MySql

2002-01-29 Thread Victoria Reznichenko
Eric, Monday, January 28, 2002, 2:30:47 PM, you wrote: ETK Eric here from South Africa. ETK I'm fairly new at using mysql and need to access images via a php website. ETK What is the best way to store images or reference to images like jpg and ETK gifs in a mysql db? Also what would the sql

Submit/View images using PHP/MySQL

2002-01-29 Thread Mike C
Hi, Can anyone point me to some good examples of how to add images using PHP 4 (from within a browser) to a MySQL database running on MacOSX, which is already configured working, then display the images by selecting their name or category etc, again within the browser. I also need

Images in MySql

2002-01-28 Thread Eric Torr Klopper
Hi all. Eric here from South Africa. I'm fairly new at using mysql and need to access images via a php website. What is the best way to store images or reference to images like jpg and gifs in a mysql db? Also what would the sql querie look like to call the and view the image. Is there any

RE: Images in MySql

2002-01-28 Thread John Lodge
Eric, Generally you would store references to the images in the database as a full or partial pathname. You can store binary data in the db itself using the BLOB type but this is not necessarily the most efficient approach to take John Lodge -Original Message- From: Eric Torr Klopper

How does one put images into a MySql database

2002-01-22 Thread Rochester, Dean
Greeting all Is there a way to put images like jpgs, tifs, gifs, bmp files into a mysql database? I have done this with OLE objects using MS Access... can this be done using the blob data type some how? Thanks in advance Dean-O

RE: How does one put images into a MySql database

2002-01-22 Thread Todd Williamsen
If it’s a web based DB, then put the URL path in the text field of the DB. Otherwise if you put the images into the database, the database will become overwhelmed, plus a bunch of wasted disk space -Original Message- From: Brian P. Austin [mailto:[EMAIL PROTECTED]] Sent: Tuesday

RE: How does one put images into a MySql database

2002-01-22 Thread Matthew Smith
This is an OK solution for a small number of images. Most filesystems (unix/linux et al included) have a severe time penalty in opening a known file in a folder when the folder contains many files. So while easier to hold a reference to a file (filename) it will become slower when your number

How does one put images into a MySql database

2002-01-22 Thread Victoria Reznichenko
Rochester, Tuesday, January 22, 2002, 3:49:40 PM, you wrote: Reoen Is there a way to put images like jpgs, tifs, gifs, bmp files into a mysql Reoen database? I have done this with OLE objects using MS Access... can this be Reoen done using the blob data type some how? Yes, but don't forget

To insert images in a table - BLOB

2001-11-14 Thread Carlos Alberto Afranllie
Hello List: I am new in this list and in MySQL, I have the following problem: I need to insert files of images in a table, which has a field of type BLOB, I have understood that to do this I can use the function LOAD_FILE(file.bmp), but that this file must be in the server. It is not possible

Re: To insert images in a table - BLOB

2001-11-14 Thread M. A. Alves
On Wed, 14 Nov 2001, Carlos Alberto Afranllie wrote: I need to insert files of images in a table, which has a field of type BLOB, I have understood that to do this I can use the function LOAD_FILE(file.bmp), but that this file must be in the server. It is not possible to insert a file

Re: inserting images

2001-10-03 Thread AJDIN BRANDIC
here? Regards Ajdin On Wed, 3 Oct 2001, Sandeep Murthy wrote: hi all, I have been trying to insert images into my mysql database thru PHP for the past 2 days without any luck.. After having tried various combinations of queries, I gave up.. Wud be grateful if anyone can post a query

Re: inserting images

2001-10-03 Thread Sandeep Murthy
The database I have created for storing images has a field called binary_junk which is of type BLOB but its still not working... TIA, sandeep - Original Message - From: AJDIN BRANDIC [EMAIL PROTECTED] To: Sandeep Murthy [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 03

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

storing images in MYSQl database

2001-09-22 Thread phani krishna
hi , how to store the images in mysql database and how to retrieve the images onto teh VB form.how to do it. please mail me the suggestions. thanx phani = S.V.PHANI KRISHNA STESALIT LIMITED 10,BELVEDERE ROAD, ALIPORE KOLKATTA

Re: storing images in MYSQl database

2001-09-22 Thread Carl Troein
phani krishna writes: how to store the images in mysql database and how to retrieve the images onto teh VB form.how to do it. What about it? Lemme guess, you're wondering how to do it, right? Two points: 1) Images are just like any other data. Just store them in a BLOB. As with all other

images

2001-09-03 Thread Neil Davies
I was wondering if it's possible to place image files within mysql tables? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

RE: images

2001-09-03 Thread Carsten H. Pedersen
From: Neil Davies [mailto:[EMAIL PROTECTED]] I was wondering if it's possible to place image files within mysql tables? http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_15_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

RE: images

2001-09-03 Thread Cal Evans
yes but not advisable. Check the archives for more info. Cal http://www.calevans.com -Original Message- From: Neil Davies [mailto:[EMAIL PROTECTED]] Sent: Monday, September 03, 2001 10:28 AM To: [EMAIL PROTECTED] Subject: images I was wondering if it's possible to place image files

[MySQL] Inserting images into a MySQL DB

2001-08-16 Thread Tim Thorburn
Hi, I'm attempting to store jpg images into a MySQL DB using PHP. I've found a few sample scripts that should do this for me, however, they don't seem to be working. Could someone take a look at this and see if you notice any problems? Thanks -Tim ?php if ($submit

Re: [MySQL] Inserting images into a MySQL DB

2001-08-16 Thread Mark Maggelet
On Thu, 16 Aug 2001 14:11:59 -0500, Tim Thorburn ([EMAIL PROTECTED]) wrote: Hi, I'm attempting to store jpg images into a MySQL DB using PHP. I've found a few sample scripts that should do this for me, however, they don't seem to be working. Could someone take a look at this and see if you

Help me HOw to load Images or pictures into MYSQL database

2001-06-22 Thread R. Palaniappan
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

2001-06-22 Thread Ansgar Becker
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: http

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

2001-06-22 Thread Seth Northrop
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

inserting images in mysql tables

2001-06-19 Thread Felicia
I am new to mysql. I am attempting to place images in one of my columns. As for my table structure, I have gotten as far as: image blob NOT NULL, How should I proceed? Thanks a bunch Get free email and a permanent address

<    1   2   3   >