[olug] PHP vs. Perl

[Andrew Holm-Hansen]

It looks like PHP is able to do just that...

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/ , 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/68859262/attachment.html>