Database Systems Using Webserver-side Scripting
EatThisNow.com
SpiderSavings.com
Management Information System
Information Request Tracking System
Product/Project Description Maintenance System
Student Bios
EatThisNow.com
EatThisNow.com
is a customized, written from scratch, social deals page, in the same
vein as dealmobs.com or GroupOn.com, but is in this case targeted for
restaurants. It ties in with related, regional websites that create print
and online magazines featuring restaurants and their cuisine.EatThisNow.com employs the full suite of eCommerce and dynamic web technologies common to such sites, including an encrypted interface with Authorize.net, a leading online payment gateway for merchant accounts, written in a way that integrates information stored within customer accounts on EatThisNow.com; a hand-written AJAX package to handle customer payment and account creation and shuttling; jQuery to provide in-page user-feedback; and, as with all projects on this page, server-side scripting and rdbms interfaces.
SpiderSavings.com
SpiderSavings.com
is the online portion of Spider Savings, a marketing company that
helps local companies with print, video, and online
advertisements. SpiderSavings.com has three sections, one for end
users, one for coupon providers, and another for the Spider
Savings' employees to administer the site.This project involved creating a new database schema from scratch, allowing image manipulation on the server to create and design coupons, accept web payments, produce and send SMS messages, and use AJAX to provide thick functionality within a browser.
Screenshots, in png format
Most Recent Coupon Listing
Example Coupon
Example Coupon with YouTube Embed
Coupon Provider Home Page
Administrator Provider Review Page
Admin Banner Ad Review Page
Coastal Services Center Management Information System (MIS)
The MIS assists CSC allot its
fifteen-plus million dollar budget and nearly one
hundred employees over scores of projects. This
application uses Microsoft SQL Server running on
Microsoft Internet Information Server (IIS) and
creates a web interface using vbscript-powered Active
Server Pages (ASP). Javascript is used to ensure data
entry meets specific criteria, and server-side
processing rechecks before entering data into the MIS
database. This project is an intranet-only site.
Screenshots, in png format
Front Page
General Project Information
Project Personnel
Milestone Edit
Project Review
Milestone Report
Information Request Tracking System (IRTS)
CSC solicits online customer
information on a voluntary basis and the IRTS collects
and reports this information for internal use. The
system both requests information from users who are
downloading products, including email address and
organization type, and reports these variables to the
lead webmaster for yearly reporting. The IRTS is also
used to create mailing labels when past customers
request new products. This site is another MS-SQL
Server driven ASP site, and its reporting capabilities
are intranet-only.
Screenshots, in png format
Front Page
CSS Mailing Labels
Search Constraint Page
Products by State Report
CSC Product/Project Description (PPD) Maintenance System
As products at the Coastal Services
Center became more numerous, a products maintenance
system was created that allowed employees to create
entries for new products as they were being produced
along with the ability to post-date their release on
the external web site. A second level of review was
built in to allow managers to "green-light" entries
and later edits before releasing them to the web.
One major advantage of the system was that the database template was passed through the normal review channels for web design, ensuring the Center-wide, mandated look and feel was utilized, but new products could be added without additional, intra-office review.
Administration page mock-ups (uneditable; for viewing only)
Entry Edit Form
URL and Date Review
Description Edit and Review Page
NCSU CRDM Students Page
As the North Carolina State
University's new Communication and Rhetoric of Digital
Media program added new classes, keeping the students
information page up to date was a headache. This
PHP/MySQL system allowed students to make their own
edits and additions, pushing the maintenance from the
college's webmaster to the system with its
pre-approved template design.
Description of development process for NCSU CRDM student information page
Description Page