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
-Original Message-
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
specified parameters or
editing an image.
HTH
- Paul
-Original Message-
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
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 I
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);
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 told
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
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
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 space they take up
hello,
you can do it this way (using mysql):
?php
/*
create table images(
img_id int(4) NOT NULL auto_increment,
img_name varchar(60),
img_file_type varchar(10),
img_content blob,
PRIMARY KEY (img_id)
) TYPE=MyISAM;
*/
if (empty($imgfile) or $go!==uploadimg)
{
// Generate the form to upload the
9:46 PM
Subject: Re: [PHP-DB] images
hello,
you can do it this way (using mysql):
?php
/*
create table images(
img_id int(4) NOT NULL auto_increment,
img_name varchar(60),
img_file_type varchar(10),
img_content blob,
PRIMARY KEY (img_id)
) TYPE=MyISAM;
*/
if (empty($imgfile) or $go
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:
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:
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 -
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
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: mailto:[EMAIL
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 4/10/2001 -0800, bryan wrote:
Maybe
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 access
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
19 matches
Mail list logo