[olug] PHP vs. Perl

[Joe Catanzaro]

An example would be here. This is what the results would be after a person 
clicks on a thumbnail.

http://68.96.137.47:8000/cgi-bin/runordie/serve_image.pl?name=tim4.jpg&size=small


At 11/27/02 11:21 AM Wednesday, you wrote:
>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


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