Re: [PHP-DB] Re: A good tutorial
Thanks for the info JD , will keep this in mind for projects that retrieve
higher number of images . Currently I'm only bringing back 1-3 images from
the dir (sorry...meant dir instead of db in previous post:)at time and it
doesn't seem too bad.
Cheers, Joe:)
Jd Daniels <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> It has never timed out bringing back from the db... only when reading from
> disk.
> I think the big difference is I need to create both fancy web pages and
neat
> printable pages. So I need to open up an image stream to manipulate the
> photo.
>
> I had a top level dir called photos, then a sub folder named from the row
id
> in the MySQL table.. so the path was always something like
> /photos/1066/photo.jpg
> once I hit 1000+ records (thusly, 1000+ sub dirs in photos/) ... it would
> time out opening the 1066 directory. (displaying 15 records at a time) It
is
> much faster now with a separate table with binary data and storing just
the
> id for an image in the original table... then just select using an id. ( a
> separate select staement seems to be faster than joining the tables) The
> biggest problem tho was that I have two servers working as web farms. if
one
> domain needed access to the photos from another domain located on the
other
> server, I could not open the photos. (For resizing and such) When they are
> in the db, I can get them from anywhere.
>
> JD
>
> -Original Message-
> From: Joe Van Meer [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 19, 2002 3:04 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Re: A good tutorial
>
>
> Hi again JD...I got to thinkin':)
>
> Just out of curiosity...how many images were you bringing back from the db
> when your script timed out?
> I store the path of my image in the db and echo it out when I need to.
>
> Cheers Joe:)
>
>
>
>
>
> Jd Daniels <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I am just going to interject a second here... sorry :P
> >
> > About storing images on a server... I did that for awhile, but once i
hit
> > 1000+ images, my scripts started timing out.(from reading the directory)
> > Storing them in the DB seems to actually improve performance for php...
> > Another issue is that I have one copy of a php script in my apache site
> root
> > folder, and use aliases to install the same script on many domains
(Using
> > VirtualHost containers in httpd.conf)
> >
> > I have gone back and forth from one system to another, and haven't found
a
> > perfect solution yet :)
> >
> >
> > JD
> >
> > -Original Message-
> > From: Lerp [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, February 19, 2002 12:20 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] Re: A good tutorial
> >
> >
> > Hi Jen, here's some code I posted up in the general ng for storing in db
> and
> > retrieving images from db for display on your page.
> > It's recommended that you stay away from storing actual images in the
db.
> If
> > you are storing a path the code below might help you out. It select a
> > firstname, and
> > an image according to an id. You'll have to change the
"youridentityfield"
> > and "youridentity" values to suit your needs.
> >
> >
> >
> >
> >
> > # display image from db
> > #
> > #connect to db
> > $connectionToDBid = odbc_connect("ceo34deesnr43ipits", "joeyscode",
> > "joeyscode");
> >
> >
> > // sql statement
> > $sqlb = "SELECT imagepath, firstname FROM IMAGES WHERE youridentityfield
> ="
> > . $youridentity;
> >
> > # execute the query
> > $resultset = odbc_do($connectionToDBid, $sqlb);
> >
> > $image = odbc_result($resultset,1);
> > $firstname = odbc_result($resultset,2);
> >
> > print "";
> > print "" ;
> > print "" ;
> > print "" . "Welcome back " .
> > $firstname . "";
> > print "";
> > print "" ;
> > print "";
> > print "";
> > print "";
> >
> > # close the db connection here
> >
> > # end of display image from db
> > #
> >
> >
> >
> > #photo upload
RE: [PHP-DB] Re: A good tutorial
It has never timed out bringing back from the db... only when reading from
disk.
I think the big difference is I need to create both fancy web pages and neat
printable pages. So I need to open up an image stream to manipulate the
photo.
I had a top level dir called photos, then a sub folder named from the row id
in the MySQL table.. so the path was always something like
/photos/1066/photo.jpg
once I hit 1000+ records (thusly, 1000+ sub dirs in photos/) ... it would
time out opening the 1066 directory. (displaying 15 records at a time) It is
much faster now with a separate table with binary data and storing just the
id for an image in the original table... then just select using an id. ( a
separate select staement seems to be faster than joining the tables) The
biggest problem tho was that I have two servers working as web farms. if one
domain needed access to the photos from another domain located on the other
server, I could not open the photos. (For resizing and such) When they are
in the db, I can get them from anywhere.
JD
-Original Message-
From: Joe Van Meer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 3:04 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: A good tutorial
Hi again JD...I got to thinkin':)
Just out of curiosity...how many images were you bringing back from the db
when your script timed out?
I store the path of my image in the db and echo it out when I need to.
Cheers Joe:)
Jd Daniels <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am just going to interject a second here... sorry :P
>
> About storing images on a server... I did that for awhile, but once i hit
> 1000+ images, my scripts started timing out.(from reading the directory)
> Storing them in the DB seems to actually improve performance for php...
> Another issue is that I have one copy of a php script in my apache site
root
> folder, and use aliases to install the same script on many domains (Using
> VirtualHost containers in httpd.conf)
>
> I have gone back and forth from one system to another, and haven't found a
> perfect solution yet :)
>
>
> JD
>
> -Original Message-
> From: Lerp [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 19, 2002 12:20 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: A good tutorial
>
>
> Hi Jen, here's some code I posted up in the general ng for storing in db
and
> retrieving images from db for display on your page.
> It's recommended that you stay away from storing actual images in the db.
If
> you are storing a path the code below might help you out. It select a
> firstname, and
> an image according to an id. You'll have to change the "youridentityfield"
> and "youridentity" values to suit your needs.
>
>
>
>
>
> # display image from db
> #
> #connect to db
> $connectionToDBid = odbc_connect("ceo34deesnr43ipits", "joeyscode",
> "joeyscode");
>
>
> // sql statement
> $sqlb = "SELECT imagepath, firstname FROM IMAGES WHERE youridentityfield
="
> . $youridentity;
>
> # execute the query
> $resultset = odbc_do($connectionToDBid, $sqlb);
>
> $image = odbc_result($resultset,1);
> $firstname = odbc_result($resultset,2);
>
> print "";
> print "" ;
> print "" ;
> print "" . "Welcome back " .
> $firstname . "";
> print "";
> print "" ;
> print "";
> print "";
> print "";
>
> # close the db connection here
>
> # end of display image from db
> #
>
>
>
> #photo upload form
>
>
> Here's a common form that allows you to upload a file (say an image) to
the
> db
>
>
>
> Upload Photo: type='file' name='userfile'> value='Upload!!!'>
>
> end of photo upload form
> ##
>
>
> start of upload process to db
>
>
> # $userfile is the file being uploaded
>
>
> # print $userfile . "";
> # print $userfile_name . "";
>
> #use a time stamp plus the original file name to uniquely name the image
> before storing in db to prevent two files with the same name
>
> $timestamp = time();
> $userfile_name = $timestamp.$userfile_na
Re: [PHP-DB] Re: A good tutorial
Hi again JD...I got to thinkin':)
Just out of curiosity...how many images were you bringing back from the db
when your script timed out?
I store the path of my image in the db and echo it out when I need to.
Cheers Joe:)
Jd Daniels <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am just going to interject a second here... sorry :P
>
> About storing images on a server... I did that for awhile, but once i hit
> 1000+ images, my scripts started timing out.(from reading the directory)
> Storing them in the DB seems to actually improve performance for php...
> Another issue is that I have one copy of a php script in my apache site
root
> folder, and use aliases to install the same script on many domains (Using
> VirtualHost containers in httpd.conf)
>
> I have gone back and forth from one system to another, and haven't found a
> perfect solution yet :)
>
>
> JD
>
> -Original Message-
> From: Lerp [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 19, 2002 12:20 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: A good tutorial
>
>
> Hi Jen, here's some code I posted up in the general ng for storing in db
and
> retrieving images from db for display on your page.
> It's recommended that you stay away from storing actual images in the db.
If
> you are storing a path the code below might help you out. It select a
> firstname, and
> an image according to an id. You'll have to change the "youridentityfield"
> and "youridentity" values to suit your needs.
>
>
>
>
>
> # display image from db
> #
> #connect to db
> $connectionToDBid = odbc_connect("ceo34deesnr43ipits", "joeyscode",
> "joeyscode");
>
>
> // sql statement
> $sqlb = "SELECT imagepath, firstname FROM IMAGES WHERE youridentityfield
="
> . $youridentity;
>
> # execute the query
> $resultset = odbc_do($connectionToDBid, $sqlb);
>
> $image = odbc_result($resultset,1);
> $firstname = odbc_result($resultset,2);
>
> print "";
> print "" ;
> print "" ;
> print "" . "Welcome back " .
> $firstname . "";
> print "";
> print "" ;
> print "";
> print "";
> print "";
>
> # close the db connection here
>
> # end of display image from db
> #
>
>
>
> #photo upload form
>
>
> Here's a common form that allows you to upload a file (say an image) to
the
> db
>
>
>
> Upload Photo: type='file' name='userfile'> value='Upload!!!'>
>
> end of photo upload form
> ##
>
>
> start of upload process to db
>
>
> # $userfile is the file being uploaded
>
>
> # print $userfile . "";
> # print $userfile_name . "";
>
> #use a time stamp plus the original file name to uniquely name the image
> before storing in db to prevent two files with the same name
>
> $timestamp = time();
> $userfile_name = $timestamp.$userfile_name ;
>
> // copy the file being posted -- remember to escape backslashes!!!
> if(copy($userfile, "/ez/codesnipits/consultant/tempimages/".
> $userfile_name)){
> print " size='2'>Your picture has been uploaded successfully and has been made
> available for
> online users to view." ;
> }
> else
> {
> print " color='#663399'>Error encountered during resume upload
process.";
> }
>
> $patharola = "tempimages/". $userfile_name;
>
> // insert path into database here
> # connect to db
> $connectionToDBid = odbc_connect("cdefc5onwesulertt", "joeyscon",
> "joeyscon");
>
> session_register("consultantid");
> $consultantid = $consultantid;
>
> # create query statement -- update image field in db using path
> $sqlr = "UPDATE CONSULTANT SET image= '$patharola' WHERE consultantid=" .
> $consultantid;
> # execute the sql statement (query) on the connection made
> $resultset = odbc_do($connectionToDBid, $sqlr);
>
>
> ?>
>
> end of image to db process
> ##
>
>
> Hope this helps you out :)
>
> Cheers Joe :)
>
>
>
>
>
>
>
> "Jennifer Downey" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > If anyone knows of one, would someone please point me towards a good
> > tutorial on storing images in a database then fetching them out again.
> >
> > I would really appreciate it and thanks in advance!
> >
> > Jen Downey
> >
> >
>
>
>
> --
> 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/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: A good tutorial
> perfect solution yet :)
is there such a thing? :)
Jd Daniels <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am just going to interject a second here... sorry :P
>
> About storing images on a server... I did that for awhile, but once i hit
> 1000+ images, my scripts started timing out.(from reading the directory)
> Storing them in the DB seems to actually improve performance for php...
> Another issue is that I have one copy of a php script in my apache site
root
> folder, and use aliases to install the same script on many domains (Using
> VirtualHost containers in httpd.conf)
>
> I have gone back and forth from one system to another, and haven't found a
> perfect solution yet :)
>
>
> JD
>
> -Original Message-
> From: Lerp [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 19, 2002 12:20 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: A good tutorial
>
>
> Hi Jen, here's some code I posted up in the general ng for storing in db
and
> retrieving images from db for display on your page.
> It's recommended that you stay away from storing actual images in the db.
If
> you are storing a path the code below might help you out. It select a
> firstname, and
> an image according to an id. You'll have to change the "youridentityfield"
> and "youridentity" values to suit your needs.
>
>
>
>
>
> # display image from db
> #
> #connect to db
> $connectionToDBid = odbc_connect("ceo34deesnr43ipits", "joeyscode",
> "joeyscode");
>
>
> // sql statement
> $sqlb = "SELECT imagepath, firstname FROM IMAGES WHERE youridentityfield
="
> . $youridentity;
>
> # execute the query
> $resultset = odbc_do($connectionToDBid, $sqlb);
>
> $image = odbc_result($resultset,1);
> $firstname = odbc_result($resultset,2);
>
> print "";
> print "" ;
> print "" ;
> print "" . "Welcome back " .
> $firstname . "";
> print "";
> print "" ;
> print "";
> print "";
> print "";
>
> # close the db connection here
>
> # end of display image from db
> #
>
>
>
> #photo upload form
>
>
> Here's a common form that allows you to upload a file (say an image) to
the
> db
>
>
>
> Upload Photo: type='file' name='userfile'> value='Upload!!!'>
>
> end of photo upload form
> ##
>
>
> start of upload process to db
>
>
> # $userfile is the file being uploaded
>
>
> # print $userfile . "";
> # print $userfile_name . "";
>
> #use a time stamp plus the original file name to uniquely name the image
> before storing in db to prevent two files with the same name
>
> $timestamp = time();
> $userfile_name = $timestamp.$userfile_name ;
>
> // copy the file being posted -- remember to escape backslashes!!!
> if(copy($userfile, "/ez/codesnipits/consultant/tempimages/".
> $userfile_name)){
> print " size='2'>Your picture has been uploaded successfully and has been made
> available for
> online users to view." ;
> }
> else
> {
> print " color='#663399'>Error encountered during resume upload
process.";
> }
>
> $patharola = "tempimages/". $userfile_name;
>
> // insert path into database here
> # connect to db
> $connectionToDBid = odbc_connect("cdefc5onwesulertt", "joeyscon",
> "joeyscon");
>
> session_register("consultantid");
> $consultantid = $consultantid;
>
> # create query statement -- update image field in db using path
> $sqlr = "UPDATE CONSULTANT SET image= '$patharola' WHERE consultantid=" .
> $consultantid;
> # execute the sql statement (query) on the connection made
> $resultset = odbc_do($connectionToDBid, $sqlr);
>
>
> ?>
>
> end of image to db process
> ##
>
>
> Hope this helps you out :)
>
> Cheers Joe :)
>
>
>
>
>
>
>
> "Jennifer Downey" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > If anyone knows of one, would someone please point me towards a good
> > tutorial on storing images in a database then fetching them out again.
> >
> > I would really appreciate it and thanks in advance!
> >
> > Jen Downey
> >
> >
>
>
>
> --
> 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/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: A good tutorial
I am just going to interject a second here... sorry :P
About storing images on a server... I did that for awhile, but once i hit
1000+ images, my scripts started timing out.(from reading the directory)
Storing them in the DB seems to actually improve performance for php...
Another issue is that I have one copy of a php script in my apache site root
folder, and use aliases to install the same script on many domains (Using
VirtualHost containers in httpd.conf)
I have gone back and forth from one system to another, and haven't found a
perfect solution yet :)
JD
-Original Message-
From: Lerp [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 12:20 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: A good tutorial
Hi Jen, here's some code I posted up in the general ng for storing in db and
retrieving images from db for display on your page.
It's recommended that you stay away from storing actual images in the db. If
you are storing a path the code below might help you out. It select a
firstname, and
an image according to an id. You'll have to change the "youridentityfield"
and "youridentity" values to suit your needs.
# display image from db
#
#connect to db
$connectionToDBid = odbc_connect("ceo34deesnr43ipits", "joeyscode",
"joeyscode");
// sql statement
$sqlb = "SELECT imagepath, firstname FROM IMAGES WHERE youridentityfield ="
. $youridentity;
# execute the query
$resultset = odbc_do($connectionToDBid, $sqlb);
$image = odbc_result($resultset,1);
$firstname = odbc_result($resultset,2);
print "";
print "" ;
print "" ;
print "" . "Welcome back " .
$firstname . "";
print "";
print "" ;
print "";
print "";
print "";
# close the db connection here
# end of display image from db
#
#photo upload form
Here's a common form that allows you to upload a file (say an image) to the
db
Upload Photo:
end of photo upload form
##
start of upload process to db
";
# print $userfile_name . "";
#use a time stamp plus the original file name to uniquely name the image
before storing in db to prevent two files with the same name
$timestamp = time();
$userfile_name = $timestamp.$userfile_name ;
// copy the file being posted -- remember to escape backslashes!!!
if(copy($userfile, "/ez/codesnipits/consultant/tempimages/".
$userfile_name)){
print "Your picture has been uploaded successfully and has been made
available for
online users to view." ;
}
else
{
print "Error encountered during resume upload process.";
}
$patharola = "tempimages/". $userfile_name;
// insert path into database here
# connect to db
$connectionToDBid = odbc_connect("cdefc5onwesulertt", "joeyscon",
"joeyscon");
session_register("consultantid");
$consultantid = $consultantid;
# create query statement -- update image field in db using path
$sqlr = "UPDATE CONSULTANT SET image= '$patharola' WHERE consultantid=" .
$consultantid;
# execute the sql statement (query) on the connection made
$resultset = odbc_do($connectionToDBid, $sqlr);
?>
end of image to db process
##
Hope this helps you out :)
Cheers Joe :)
"Jennifer Downey" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> If anyone knows of one, would someone please point me towards a good
> tutorial on storing images in a database then fetching them out again.
>
> I would really appreciate it and thanks in advance!
>
> Jen Downey
>
>
--
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/)
To unsubscribe, visit: http://www.php.net/unsub.php
