Meeting Location
(this link takes you back to a page on the main PACS site)
Michael J. Hernandez's
Website
Databases in Action
Curriculum 2005
Curriculum 2001
Articles & Editorials
Tips and Tricks
Database Store
January 15, 2005 Notes
In continuance with our joint project with
Web Design SIG to build our own database-driven
websites using PHP and MySQL, Reed Gustow from Web Design SIG showed us the code for a
survey form on the web and the scripts that take the responses and enter them into a
database. He used PHP. In the remaining time we discussed
"Why you should--or shouldn't--migrate to MySQL," with the focus on migration
from Access or FileMaker. Later at Web Design SIG,
Reed showed the "design" part of the survey form--how to make a form look good using
CSS.
Guest SIG Leader Reed Gustow from Web Design SIG covered chapter 5, "Relational Database Design," from Kevin Yank's book Build Your Own Database Driven Website Using PHP & MySQL. Reed used a song lyric database he constructed rather than the joke database that author Yank uses in the book. March 12, 2005 Notes
Guest SIG Leader Reed Gustow from Web Design SIG began coverage of chapter 6, "A Content Management System," from Kevin Yank's book Build Your Own Database Driven Website Using PHP & MySQL.
April 16, 2005 Notes
Guest SIG Leader Reed Gustow from Web Design SIG finished covering chapter 6 of Kevin Yank's book Build Your Own Database Driven Website Using PHP & MySQL. Database SIG ended early at 11:45 in order to enable all members to attend the Main Meeting at 12:00 noon featuring Tracy Brant of Gryphyn Media, an excellent speaker who has generously supplied free hosting for our webdata project site databasedrivenwebsite.net.
May 21, 2005 Notes
Guest SIG Leader Rich Sias did a presentation on security features using his Sanity Savers database. He incorporated issues raised in Kevin Yank's book Build Your Own Database Driven Website Using PHP & MySQL and also incorporated his own ideas. Topics covered included:
- Logging in to mysql with plain text as login
- Not normally visible to html viewer except when php server nonfunctional. Then security risk.
- Used Includes and include_path in php.ini to use directory not accessable by html user. PHP can get there and process the php stuff.
- Defined $vars1 & $vars2 for login and password for mysql.
- More includes for defining the vars separately and defined encrypt() and decrypt() functions.
- Started with strings like this "0Ghtg4%^HutyRghuIO83TYghj" which might decrypt into something like the original login etc.
June 18, 2005 Notes
We looked at Mark and Ouida's revised online searchable library database, which touched
off a discussion about searching, so we didn't get around to looking at the rest of their
new work. However, they will be doing a live video chat at the summer SIG meeting on
July 16, 2005.
July 16, 2005 Notes
We met at 1:15 PM in the Upper Moreland Library Community Room at 109 Park Avenue in Willow Grove, following Web Design SIG's 12:00-1:15 pm meeting in the same room. The internet connection had been turned off, so we moved to the Barnes and Noble Cafe across the street and gathered around the laptop for a live chat with Ouida from her new home in Florida, in which she showed us her new T-shirt e-shop and how it worked, and shared a wealth of book resources for PHP and Perl, etc.
September 17, 2005 Notes
October 15, 2005 Notes
November 19, 2005 Notes
December 17, 2005 Notes
--Linda M. Kalb