Programmng Projects
The following is a partial list of some of the web sites that I have worked on.
Most were done with PHP/MySQL, a few use Perl/MySQL. A lot of my work is behind
the scenes, in password protected areas. I have demos of some of the coding
and can provide URL's to those demos if needed.
- Member's area. New members can register themselves and place orders for virtual tours.
Site admin can manage member accounts.
- Created password protected pages for church membership. New members can register themselves and
once approved by the site admin, can view and search a directory of all members. Site admin can
manage member accounts.
-
Option Cart is being used for the password protected Catalog, no prices
are displayed, instead the 'shopping cart' collects a list of items
that the buyer is interested in, the list is then passed to the site owner
and a price quote is created.
-
Created call-back script for payment processor to populate a local database
with items selected by potential customer.
-
Created scripts to allow site owner to create a quote for buyer by adding
prices and shipping cost. A note to buyer can also be added and the quote
emailed to the buyer.
-
Created script to display the quote for buyer and provide links to payment
processor
-
Troubleshooting PHP problems after the site was moved from one host
to another. The new host had different PHP settings requiring some modification
of the scripts.
-
More troubleshooting after new host turned off a cron job without warning (Arrgghh!!)
-
Expected Family Contribution (EFC) calculator, EFC is used when determining financial aid
-
College Costs Search: search for college based on location and enrollment
-
Password protected pages allowing the site owner to update MySQL data from Excel file
-
Password protected database of products for internal use. (A demo of this is
available. Please email for the link.)
-
Heavily modified a Help Desk application written in Perl to interface with
the custom product database
-
Created MySQL database of training programs and wrote search script
-
Protected page for members to update their profile
-
Reorganized the database and wrote new scripts to create a member's area
for update of information
-
Rewrote the public scripts for the new database scheme
-
Perl script to import and update package tracking information into MySQL
-
Created 'track order' scripts, one for customers and another, password
protected, for staff
-
Rewrote the 'request a catalog' scripts, changing it from
Perl to PHP so the designer can have an easier time maintaining it
-
Reworked database of 9,500 listings, migrating from Perl/flat-file to PHP/MySQL
-
Member's area: registration, listing submission, payment for regular or
enhanced listings