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 deal purchase page thumbnailEatThisNow.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 Recent Coupons ThumbnailSpiderSavings.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)

CSC Management Information Systems Homepage ThumbnailThe 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 Information Request and Tracking System ThumbnailCSC 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

CSC Management Information Systems Homepage ThumbnailAs 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

NCSU CRDM Students PageAs 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