jump to navigation

Starting a MySQL Database January 20, 2010

Posted by flutebrarian in Web Design.
Tags: , , ,
add a comment

Today was one of those “Eureka!” days. Last fall, the library’s web server was replaced. We had a number of web databases set up in Access and ASP using FrontPage. Life was easy, life was good.

When we upgraded, the new server no longer supported FrontPage Server Extensions and all the ASP database connections broke. Life was no longer easy.

The time had come to face the fact that I needed to learn MySQL and PHP and could no longer put it off. I took an online class on the basics of MySQL through eClasses.org and got that part under control. Taking the bull by the horns, I set up the new database on the new server and figured out how to import the nearly 8,200 records.

I’ve been working on piecing together a web form with a PHP script to add new records to the database for the past few days and this afternoon … Ta da! It worked.

I still need to figure out how to create a search form that will find various strings of data. I have a script that will pass the variable and display the results but that’s not real practical for the average user.

The saga continues …