Project: Seattle Central Community College student newspaper - online version - Phase 1

Team project - my role was PHP and MySQL programming along with JavaScript and some CSS and HTML - primarily associated with the Content Management System.

Client needed a dynamically generating online version of it's 41 year-old print newspaper. This is phase 1.

Back to Portfolio

The City Collegian public home page:

TCC home page

To upload new articles and images, editor or developer (two roles) logs in to secure Content Management System:

Editor login

Instructions and admin menu for article and image uploading, as well as limited database access (Developer 'role' required):

Instructions/Menu page

Editor adds or edits an article by inputting data here:

Adding an article

Editor can view an article and upload images:

Article show and image upload

Editor views currently loaded images, and can upload new images associated with a specific article:

Image upload

Editor can browse for images on his/her computer, and upload them. PHP prevents files larger than 100k:

Image upload page

This where the editor prioritizes articles within a section by first selecting the section they want to work with:

Section selection

Then, editor can position up to 10 articles in order or priority or most-recent. Once this is done, article is immediately live on the public site:

Section editing

Finally, with special developer-only login, access to the database is granted for admin purposes. Developer has access to all 9 MySQL tables:

Section editing

Back to Portfolio