RE: [PHP-DB] Images stored in a db - how to get them?

2004-01-26 Thread John T. Beresford
"Content-Length: ".filesize($row_file["file_path"])); $fp=fopen($row_file["file_path"], "rb"); fpassthru($fp); } ?> The GD library is for creating new images using specified parameters or editing an image. HTH - Paul -Original Message-

RE: [PHP-DB] Images stored in a db - how to get them?

2004-01-26 Thread Paul Miller
- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED] Sent: Monday, January 26, 2004 3:28 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Images stored in a db - how to get them? about once a quarter this question comes up and the answer is always the same. Don't store them in the database,

RE: [PHP-DB] Images stored in a db - how to get them?

2004-01-26 Thread Ryan Jameson (USA)
about once a quarter this question comes up and the answer is always the same. Don't store them in the database, just store filenames and store the files in the filesystem. That way you just generate a link and treat it like any other image. Then when you query the database you would create img ta

RE: [PHP-DB] Images

2003-02-01 Thread Mihail Bota
John, the code is listed below. Very cluttered, I acknoweledge:) The limit you'll see in the second query is the maximal value for which I get a good checkerboard. Mihai $q1=mysql_query("select distinct idsend from connections where publi=1 and uid=1 order by idsend"); $nu1=m

RE: [PHP-DB] Images

2003-02-01 Thread John W. Holmes
> I try to create a simple image from some data from a database (something > like a checkerboard: if $a=1 then red, elseif $a=2 then blue etc). > Everthing works fine until the assignment of colors. Whenever I use the > whole set of data that I have to display, wrong colors are assigned. > Whenever

Re: [PHP-DB] images

2002-10-21 Thread Jason Wong
On Monday 21 October 2002 22:33, Edward Peloke wrote: > I am attempting to create a page on my website which will allow users to > upload images. I will need to rename and resize the image and then grab > the location of the image and place it in the mysql db in a varchar field. > > I have been to

Re: [PHP-DB] images [Oops]

2002-10-15 Thread Hatem Ben
; Sent: Tuesday, October 15, 2002 9:46 PM Subject: Re: [PHP-DB] images > hello, > > you can do it this way (using mysql): > > /* > create table images( > img_id int(4) NOT NULL auto_increment, > img_name varchar(60), > img_file_type varchar(10), > img_content blob,

Re: [PHP-DB] images

2002-10-15 Thread Hatem Ben
hello, you can do it this way (using mysql): Specify a name for your image : Select your image file : "; echo $form; } else { // You have an image that you can insert it in database /* Connecting, selecting database */ $link = @mysql_connect("mysql_host", "mysql_user", "mysql_password") or

RE: [PHP-DB] images

2002-10-15 Thread Edward Peloke
EMAIL PROTECTED] Subject: Re: [PHP-DB] images to upload use copy and the $_FILES array. then around mysql, I tend to store the path in mysql and the images on the server. I personally don't like to work with blobs and don't think it makes as much sense as they do on the server. the spa

Re: [PHP-DB] images

2002-10-15 Thread Jeffrey_N_Dyke
to upload use copy and the $_FILES array. then around mysql, I tend to store the path in mysql and the images on the server. I personally don't like to work with blobs and don't think it makes as much sense as they do on the server. the space they take up in the db seems like a waste. my $.02

RE: [PHP-DB] images

2002-10-15 Thread Hutchins, Richard
This has been asked many times before, but unless you have a really good reason for storing the image in the database, don't. Instead, upload the image file to a directory on the server and store the URL to the image in the database. Fewer db resources are consumed. > -Original Message---

RE: [PHP-DB] Images and MySQL - please help

2002-04-17 Thread Ruprecht Helms
Hi DrTebi, fetch the image from database A and put it into a buffer then > I guess somehow I have to buffer the output, manipulate > the buffer by adding the watermark, and then "insert" the image into the > database B ^^ Regards, Ruprecht -- E-Mail:

Re: [PHP-DB] Images on MySQL

2002-03-29 Thread Steve Cayford
I keep hearing this from people (not to store images in mysql), but I would like to hear a bit more about why. Mysql has blob fields, so it seems perfectly reasonable to use them, doesn't it? I'm storing some images in a database and what's attractive to me about it is that I can put the image

Re: [PHP-DB] Images on MySQL

2002-03-29 Thread Jason Wong
On Thursday 28 March 2002 19:35, Clever wrote: > Hi, > I'm designing a site and I have to store a lot of images. > Which is the best for speed? > 1) Store all images on a MySQL table? > 2) Save them on disk like normal files and only have pointers to them on > the database? 2) -- Jason Wong ->

Re: [PHP-DB] Images on MySQL

2002-03-29 Thread Cannis
In my experience storing images on disk is simpler, easier and not messy. I wouldn't think of storing binaries in a MySQL table...It just doesn't seem right, but then again I have never tested this, only relied on my peers telling me "It's not right" ;) -Lasse - Original Message - From:

Re: [PHP-DB] Images from database

2001-07-10 Thread Benjamin Bleything
Check out http://www.phpbuilder.com/columns/florian19991014.php3. It's a tutorial that explains getting images in and out of databases. It also describes what this myscript.php thingy does. Good luck, Ben >Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm >list-help:

RE: [PHP-DB] images

2001-04-11 Thread Steve Brett
ved a dozen e-mails from the two guys arguing at my works address, which was nice. > -Original Message- > From: Ron Brogden [mailto:[EMAIL PROTECTED]] > Sent: 10 April 2001 19:57 > To: bryan; [EMAIL PROTECTED]; db > Subject: Re: [PHP-DB] images > > > At 11:48 AM

Re: [PHP-DB] images

2001-04-10 Thread Ron Brogden
At 11:48 AM 4/10/2001 -0800, bryan wrote: >Maybe there is a way to use .htaccess more appropriately, >but, this site allows guest / non-members, to buy something. >Once they buy something, they are given a username of >email, and password (they choose). If they log back in, they >should have acce

Re: [PHP-DB] images

2001-04-10 Thread bryan
riginal Message - From: "John Huggins" <[EMAIL PROTECTED]> To: "bryan" <[EMAIL PROTECTED]>; "db" <[EMAIL PROTECTED]> Sent: Tuesday, April 10, 2001 10:31 AM Subject: RE: [PHP-DB] images > .htaccess > > > -Original Message- &

RE: [PHP-DB] images

2001-04-10 Thread John Huggins
.htaccess > -Original Message- > From: bryan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 10, 2001 2:47 PM > To: db > Subject: [PHP-DB] images > > > Question: > > Having problems with a site I am doing. > How can I stop a user from gaining access to images in > a certain director

Re: [PHP-DB] Images donot appear

2001-04-09 Thread Sharmad Naik
On Mon, Apr 09, 2001 at 08:08:47AM +0100, Corin Rathbone wrote: > If you are using windows, > Uncomment (un ;) the following line in php.ini > extension=php_gd.dll > I m using Linux.What to do then .I looked at the ini file .There r gd options for only Windoze.What do i do now or do i require a

RE: [PHP-DB] Images donot appear

2001-04-08 Thread Corin Rathbone
If you are using windows, Uncomment (un ;) the following line in php.ini extension=php_gd.dll Regards, Corin Rathbone [EMAIL PROTECTED] -Original Message- From: Sharmad Naik [mailto:[EMAIL PROTECTED]] Sent: 08 April 2001 18:44 To: [EMAIL PROTECTED] Subject: [PHP-DB] Images donot appear