On Friday 01 October 2004 05:52, Ed Lazor wrote:
Images take up more space when stored in the db, because you're storing
raw
binary data. Gif and jpeg are compression methods that convert binary
data
into something smaller that can be stored in a file.
??
If you store a jpeg file
No problem Ed thanks...
Actually I was supprised to see this conversation (thread) come back
into my GMAIL inbox
On Wed, 6 Oct 2004 15:57:12 -0700, Ed Lazor [EMAIL PROTECTED] wrote:
On Friday 01 October 2004 05:52, Ed Lazor wrote:
Images take up more space when stored in the db,
If you're uploading a file then you can make a script that reads the
temp file into the database (otherwise you need to muck around with
image functions and I'm not the one to ask about that), something
like:
$image = mysql_escape_string(fread(fopen($_FILES['file']['tmp_name'],
r),
HEre is a question that I have been wondering about:
- Does the image file use more space in the db or as a file itself
(Do Not count the extra data that one would store in the db along with
the image... ie. ID number)
Thanks
On Thu, 30 Sep 2004 09:55:30 -0700, Jasper Howard [EMAIL
[snip]
HEre is a question that I have been wondering about:
- Does the image file use more space in the db or as a file itself
(Do Not count the extra data that one would store in the db along with
the image... ie. ID number)
[/snip]
While better asked on a SQL list, I'll give you an answer
I'm not any kind of expert on this, but you just read the file byte
for byte, dont you? So it should be the same amount of data.
On Thu, 30 Sep 2004 15:51:28 -0400, GH [EMAIL PROTECTED] wrote:
HEre is a question that I have been wondering about:
- Does the image file use more space in the
Images take up more space when stored in the db, because you're storing raw
binary data. Gif and jpeg are compression methods that convert binary data
into something smaller that can be stored in a file.
The recent tests I did took 270megs of images and stored them into 180megs
of jpg files.
On Friday 01 October 2004 05:52, Ed Lazor wrote:
Images take up more space when stored in the db, because you're storing raw
binary data. Gif and jpeg are compression methods that convert binary data
into something smaller that can be stored in a file.
??
If you store a jpeg file into a
I was wondering how to get images into and out of a Mysql database
with in php... I do not have anything in my book... but was told it
was possible.
I have PHP 4.3.4 and mysql 4.0.18
Thanks
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
for performance reasons.
- Original Message -
From: GH [EMAIL PROTECTED]
To: Daniel Watrous [EMAIL PROTECTED]
Cc: GH [EMAIL PROTECTED]
Sent: Monday, September 27, 2004 4:31 PM
Subject: Re: [PHP] Images in PHP and MySQL
Do you know of a good tutorial on this topic.
On Mon, 27 Sep 2004 16
HTH
Graham
-Original Message-
From: GH [mailto:[EMAIL PROTECTED]
Sent: 27 September 2004 23:19
To: php-general
Subject: [PHP] Images in PHP and MySQL
I was wondering how to get images into and out of a Mysql database
with in php... I do not have anything in my book... but was told
Graham
-Original Message-
From: GH [mailto:[EMAIL PROTECTED]
Sent: 27 September 2004 23:19
To: php-general
Subject: [PHP] Images in PHP and MySQL
I was wondering how to get images into and out of a Mysql database
with in php... I do not have anything in my book... but was told
1) there is no need to fiddle with directory permissions to write images.
2) if the content is sensitive you have the added security of the database
password (and the fact that the database is ususally not directly
accessible).
3) a mysqldump gives a backup of all images along with other
13 matches
Mail list logo