[olug] PHP vs. Perl

[Jonathan Warren]

Depends what you mean by advantage.  If you know php java server pages will be easier to learn.  If you want to know more web languages I would say learn php it is very simple and can helpful to learn others.  I can't think of anything you couldn't do in perl.  It all just ends up being html.  Weather or not one language is easier seems to be perference more than a factual argument.  

-Jon W

On Wed, Nov 27, 2002 at 11:21:04AM -0600, Joe Catanzaro 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...
>      [1]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
> [2]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.
> [3]http://www.olug.org/modules.php?name=Surveys&op=results&pollID=10&mode=&orde
> r=&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
> [4]joecatanzaro at cox.net
> 
> _______________________________________________
> OLUG mailing list
> [5]OLUG at olug.org
> [6]http://lists.olug.org/mailman/listinfo/olug
> 
> 
> _______________________________________________
> OLUG mailing list
> [7]OLUG at olug.org
> [8]http://lists.olug.org/mailman/listinfo/olug
> 
> 
>    Joe Catanzaro
>    joecatanzaro at cox.net
> 
> References
> 
>    1. http://www.onlamp.com/pub/a/onlamp/2002/05/09/webdb2.html
>    2. http://www.gossamer-threads.com/scripts/mysqlman/
>    3. http://www.olug.org/modules.php?name=Surveys&op=results&pollID=10&mode=&order=&thold=
>    4. mailto:joecatanzaro at cox.net
>    5. mailto:OLUG at olug.org
>    6. http://lists.olug.org/mailman/listinfo/olug
>    7. mailto:OLUG at olug.org
>    8. http://lists.olug.org/mailman/listinfo/olug