[olug] PHP vs. Perl

[Joe Catanzaro]

And that's exactly what I'm doing with Perl. Setting the MIME header and 
streaming the data and this works very well. Would there be an advantage to 
moving to PHP? Faster, easier to code?

sub display_image
{
my ($name, $size) = @_;
my $col_name = (defined ($size) ? $size : "image");
my ($dbh, $mime_type, $data);
         $dbh = WebDB::connect ();
         ($mime_type, $data) = $dbh->selectrow_array (
                 "SELECT mime_type, $col_name FROM image WHERE name = ?", 
undef, $name);
         $dbh->disconnect ();
         error ("Cannot find image named $name") unless defined ($mime_type);
         print header (-type => $mime_type, -Content_Length => length ($data)),
                         $data;
}



At 11/27/02 10:58 AM Wednesday, you wrote:
>It looks like PHP is able to do just that...
>
><http://www.onlamp.com/pub/a/onlamp/2002/05/09/webdb2.html>http://www.onlamp.com/pub/a/onlamp/2002/05/09/webdb2.html
>
>Basically, set the mime header, stream the data.
>
>Andrew
>
>Andrew Holm-Hansen wrote:
>>I think in Java, you can just retrieve them as blobs or longs, typecast 
>>them, and embed them.  I don't know about PHP, but it would surely have 
>>the same functionality.
>>
>>Andrew
>>
>>Jonathan Warren wrote:
>>>
>>>Normally a photo linked into a page is a pointer back to the image.  It 
>>>seems to me if you want a photo to be served up from a db your going to 
>>>have to some how alias the db pointer in your web server to a url.  I 
>>>don't know of anythign to do this.  I don't know if you can embed the 
>>>image than the browser should be able to interpret it.  Basically I am 
>>>suggesting you dump all your images in a scripted manner and write php 
>>>to interpret your pictures directory.  If you find a way to use images 
>>>direct from a db please share with the list.  I would like to know how 
>>>it is done.
>>>
>>>-Jon W
>>>
>>>
>>>On Wed, Nov 27, 2002 at 09:18:25AM -0600, Joe Catanzaro wrote:
>>>
>>>>
>>>>I'm in the process of building a web page for my family (we just had a
>>>>baby, blah, blah, blah), and I have several questions.
>>>>
>>>>1. Most of my web page data, such as photos are stored in a MySQL 
>>>>database.
>>>>To manage the database I use MySQLMan by Gossamer-Threads
>>>><http://www.gossamer-threads.com/scripts/mysqlman/>http://www.gossamer-threads.com/scripts/mysqlman/ 
>>>>, and it's a great web
>>>>interface to manage the database, but when it lists the photos on the web
>>>>page, it displays them as they are stored, rather than as they should
>>>>appear (funky garbage characters). Can someone recommend a web 
>>>>interface to
>>>>manage a MySQL database? I've heard of PHPmyadmin. Any good? If so, 
>>>>does it
>>>>display photo images rather than a bunch of garbage characters all over 
>>>>the
>>>>screen?
>>>>
>>>>2. To extract these photos and other data (text and video) from the
>>>>database, I normally use Perl's DBI. Is there any advantage in learning 
>>>>PHP
>>>>to create these web pages? The reason I'm asking this question here is
>>>>because of the survey I saw posted on OLUG that most people prefer PHP 
>>>>over
>>>>Perl to create web pages.
>>>><http://www.olug.org/modules.php?name=Surveys&op=results&pollID=10&mode=&order=&thold=>http://www.olug.org/modules.php?name=Surveys&op=results&pollID=10&mode=&order=&thold=
>>>>
>>>>3. I'm using a MySQL database in hopes all of this is going to scale no
>>>>matter how many photos I've got in that database. Are there any
>>>>disadvantages to building my site in this manner or have I assumed
>>>>correctly that this is a best practice?
>>>>
>>>>Thanks in advance and have a very Happy Thanksgiving,
>>>>
>>>>
>>>>
>>>>
>>>>Joe Catanzaro
>>>><mailto:joecatanzaro at cox.net>joecatanzaro at cox.net
>>>>
>>>>_______________________________________________
>>>>OLUG mailing list
>>>><mailto:OLUG at olug.org>OLUG at olug.org
>>>>http://lists.olug.org/mailman/listinfo/olug
>>>>
>>>
>>>_______________________________________________
>>>OLUG mailing list
>>><mailto:OLUG at olug.org>OLUG at olug.org
>>>http://lists.olug.org/mailman/listinfo/olug
>>>
>>
>


Joe Catanzaro
joecatanzaro at cox.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.olug.org/pipermail/olug/attachments/20021127/ca2fa657/attachment.html>