[olug] PHP vs. Perl
Andrew Holm-Hansen
olug at einer.org
Wed Nov 27 16:51:05 UTC 2002
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/ , 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=
>>
>>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
>>joecatanzaro at cox.net
>>
>>_______________________________________________
>>OLUG mailing list
>>OLUG at olug.org
>>http://lists.olug.org/mailman/listinfo/olug
>>
>>
>_______________________________________________
>OLUG mailing list
>OLUG at olug.org
>http://lists.olug.org/mailman/listinfo/olug
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.olug.org/pipermail/olug/attachments/20021127/0ef45101/attachment.html>
More information about the OLUG
mailing list