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 esi
"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-
-
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,
e img 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]
Subje
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, image
Hallo People,
I have one problem with creating images on-fly.
Therefore I created 2 files:
1. resize_image.php with the following
AND
2. filex.php .In that file i read from database where the image is stored en
then i show small images(thumbnails).
thet part of the code is :
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 :-)
Th
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 databa
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
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 tha
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
> 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
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
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
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
plug
;
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,
#x27;)";
$result = mysql_query( $query ) or die("Query failed");
echo "Hope this will help ;)";
}
?>
Regards,
Hatem
- Original Message -
From: "Edward Peloke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002
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
om (EdwardTo: <[EMAIL PROTECTED]>
Peloke) cc:
Subject:
Message-
> 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
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
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:
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, ma
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
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 ->
iginal Message -
From: "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
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?
Thanks a lot
Clever Anjos
--
PHP Database Mailing List (http://www.php.net/)
T
>MIME-version: 1.0
>X-MIMEOLE: Produced By Microsoft MimeOLE 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:
>
>
>
>Will this tag work in both IE and Netscap
I have seen in several places the following line:
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--
Am I getting this, or am I missing the whole point?
Thanks
RDB
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
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
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-
&
.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
Question:
Having problems with a site I am doing.
How can I stop a user from gaining access to images in
a certain directory. I have directory browsing turned
off, but in the instance someone buys something, if
the path to the image is 2001/apr/a1/image1.jpg, what
would stop someone from typing
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
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,
37 matches
Mail list logo