MySQL

As a way to learn some ColdFusion basics, in 2003 I decided to implement a project I had been meaning to do for a long time in PHP: A central Bookmark manager. I never envisioned some of the social possibilities that del.icio.us has implemented since, but I was thinking along those lines.

While any web browser worth its salt has a feature for saving favorite URLs, users of more than one computer or browser (Mozilla, MSIE, Lynx, Opera, Home, work, laptop, etc) often find themselves with several different bookmark lists, each one out of sync.

FLWFinder was a PQA (Palm Query Application, also known as "Web Clipping Application") for looking up the addresses of Frank Lloyd Wright-designed buildings from any PalmOS handheld with an internet connection. The backend consisted of a set of PHP scripts which in turn accessed a MySQL database.

Image(s): 

Notifications is a compenent of inResonance’s Portal Web Services, which allows students who have applied to a school to check the progress of their application via the web, and view their decision letter online on the day decisions are released.

Originally developed for Trinity Pawling School, WebGrades is a web application that allows student grades and comments to be exported from inResonance’s KEYSTONE SIS (Student Information System) to a PHP/MySQL web application via ODBC. Parents can log in and view their students’ grades, and administrators can log in and manage system settings. WebGrades was also deployed for The Harvey School.

Image(s): 

Broadcaster is a module and web service which adds the ability to send batch e-mail messages to preselected groups of constituents in inResonance’s core FileMaker solutions. While the list management and message composition is managed by FileMaker, a web component was required to create unique identifiers for each client as well as track information about each e-mail broadcast:

• Which recipient(s) read a given e-mail
• Which link(s) a recipient followed out of a given e-mail

Clients can access this information in CSV or FMPXMLRESULT format via unique URLs.

I used MovableType 2.64 to manage my weblog from late 2003 through early 2005, and I discovered that one thing the system lacked was a native way to create paged archive listings organized by category.

I was approached by Wrox Press to contribute to Professional PHP4 Multimedia Programming as a result of the pieces I had written for Wired Publications’ Webmonkey.

Image(s): 

The Fund For Women Artists wanted a system that would allow artists to sign up for a free account, and create their own artist profile on the womenarts.org web site, searchable by name, location, or artistic interest. The system was build from scratch using PHP and MySQL, and currently supports more than 800 artist profiles at .

Image(s):