[WEB4LIB] Creating local content for web

[bob frasier]

I'm moving some records systems that were originally created in Access to a
MySQL database - I don't think there was much thought in selecting Access other
than that the University has a site license & it was readily available. The
motive for the change are essentially those that you mention. MySQL seems to
handle everything that I've needed.

I've switched from Perl DBI to PHP to build the web pages that access the MySQL
database. PHP seems to work so well with web based documents and has a number of
handy functions to interact with MySQL. It is relatively painless to build a
user interface that has the look and feel of your library pages.

There are a number of other possible approaches - but this seems to be a good
solution for us.

Bob Frasier
Western Illinois University

"Drew, Bill" wrote:

> I am looking for better ways to create locally produced content for our
> website.  Currently we can't mount any database driven functions on our web.
> That will change after our computer center people get more training.  I am
> looking for a free or cheap database program that can be used to eventually
> create such content.  I am finding that Access is too complicated and
> requires too much in the way of programming skills.  I am after something
> that can be used now to create static pages that we will then move to the
> webserver.  Access will create static pages but when a report is exported to
> the web each record from the database is made into a separate web page.  I
> want the ability to create a single file.  Any suggestions?  The content we
> have is lists of resources as well as more substantial projects.
> ___________________
> Wilfred (Bill) Drew
> Associate Librarian, Systems and Reference
> SUNY Morrisville College Library
> E-mail: mailto:drewwe at morrisville.edu
> BillDrew.Net: http://billdrew.net/
> Not Just Cows: http://people.morrisville.edu/~drewwe/njc/
> Library: http://www.morrisville.edu/library/
> Wireless Librarian: http://people.morrisville.edu/~drewwe/wireless/
> Have Laptop -- Will Travel.
> "You teach a child to read, and he or her will be able to pass a literacy
> test.''- George W. Bush; Townsend, Tenn., Feb. 21, 2001