How do you accualty stor jpegs in a mysql db? And what's the pros and cons
of storing the whole image in the db and not just the path to the file on
the server?
It feels to me that it can be a bit difficult to organize the images if
they're just placed in a directory on the server. It would be
Hello All,
I am interested in storing images in a table. My question is - What
is the proper way of retrieving the images and displaying them on a
web page?
Will I need to go through the GD library and create an image from the
information stored in the table?
While PHP is not new to me,
tags with src property set to the image. You probably
don't want to store FULL path info, just enough to find the image.
Ryan
-Original Message-
From: John T. Beresford [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 2:23 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Images stored
-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
Hallo People,
I have one problem with creating images on-fly.
Therefore I created 2 files:
1. resize_image.php with the following
?php
if (!$max_width)
$max_width = 150;
if (!$max_height)
$max_height = 100;
$size = GetImageSize($image);
$width = $size[0];
$height = $size[1];
$x_ratio =
Hi there everyone,
I am storing images in the filesystem and in a MySQL DB, my question is, I know when
you upload the images you can do the image width, height etc .. from the image, is
it possible to also do a pixel count and image color depth?
Any help would be REALLY appreciated :-)
Hey,
Just something easy, using a MySQL database, I don't know how to convert
Binary to a image file to be placed into html.
Could someone please help.
Thanks
Dallas Freeman
Please ignore my previous email, I figured out how.
Thanks anyways.
-Original Message-
From: Dallas Freeman [mailto:[EMAIL PROTECTED]
Sent: Friday, 7 March 2003 1:51 AM
To: '[EMAIL PROTECTED]'
Subject: images - BINARY - HTML
Hey,
Just something easy, using a MySQL
Hello,
If you have time, please run the code below. It is a very simple code
which has 2 nested loops and assigns colors to a given value. If the
product of $i and $j is smaller or equal to 256 (exactly the number of
colors allowed), then you'll get a random pattern. If this product is
bigger
Hello,
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 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);
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 there are already some code for this online that can be
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
How can I allow the user to upload images to a php website and have the
image stored in the mysql db?
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 3:23 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] images
How can I allow the user to upload images to a php website
and have the
image stored in the mysql db?
Thanks,
Eddie
--
PHP Database
To: [EMAIL PROTECTED]
Peloke) cc:
Subject: [PHP-DB] images
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
: [PHP-DB] images
How can I allow the user to upload images to a php website and have the
image stored in the mysql db?
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net
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,
I am trying to do this:
- I have an image stored in database 'A'
- a php script should load this image, and stamp it with a watermark
- then the php script should save the new image (with the watermark)
in database 'B' ...
How can I do this? I guess somehow I have to buffer the output,
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:
: Clever [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 12:35 PM
Subject: [PHP-DB] Images on MySQL
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
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
I have seen in several places the following line:
img src='myScript.php' etc..etc..
Will this tag work in both IE and Netscape?
What does myScript.php do? Does it find an image and pass the binary data back?
Something like this--
?php
// Code to find get a path from a database
$fp =
V5.50.4133.2400
X-Priority: 3
X-MSMail-priority: Normal
Subject: [PHP-DB] Images from database
I have seen in several places the following line:
img src='myScript.php' etc..etc..
Will this tag work in both IE and Netscape?
What does myScript.php do? Does it find an image and pass the binary data
back
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
Although i have compiled php with gd i don't get image do i have to make
any changes in php.ini
-Regards
--
The secret of the universe is @*!'^#+ NO CARRIER
___ _ _ _
|_|_||_||_||\/||_|| \
_|| || || \| || ||_/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
32 matches
Mail list logo
