bRIDGEhOUSE aDMINISTRATOR
Senior Project Presentation Spring 2014
Alexander Murphy
Customer: Cathy Bentwood
Advisor: Peter Drexe
Questions & answers
My Project at a glance
- Secure, web-based "participant" administration dashboard
- User Experience driven design and development
- Began as my Systems Analysis and Design project
- Built from the ground up for specific use by 3 people
- Currently being Utilized by staff on a daily basis
FUNCTION and purpose
-
Streamlined Record Management
-
Ability to access and edit all records from desktop or tablet computers
-
Facilitate productive, easy to refer to Notes
- Coined as "The Electric Records"
Frameworks, Languages and technologies utilized
reveal.js
Data model and framework implementation
- MySQL and PHP server side form handling
-Twitter Bootstrap HTML5 Responsive Front End
- Node.js server Hosted on Openshift for Chat server
-Git for code modification and revision control
-Presentation Design and Display using reveal.js
Strategies and Features Utilized
$_POST //Global Post Array {Form input variables}
$_GET //Participant Database ID passed between pages in URL
if($_POST){ do stuff } // Prevent Queries before Form Posting
$_SESSION //Global Session Information {User, ID}
<?php
$posted_var = addslashes(($_POST['input_field'])); //no SQL injection
$popfrom_id = mysql_query("SELECT * FROM `intake_form` WHERE ID ='$id';"); //Select statements based on ID in URL
?>
Security
- Secure PHP login Framework sourced from CodeCanyon
- Passwords Encrypted using the Blowfish Symetric Key-Block Cipher
- SQL ijection Attack prevention
- Every Page and SS Script verifies values in $_SESSION
<!-- Begin sesson object and check for user login-->
<?php
session_start();
if ( !isset($_SESSION['login']) || $_SESSION['login'] !== true) {
if(empty($_SESSION['access_token']) || empty($_SESSION['access_token'] ['oauth_token']) || empty($_SESSION['access_token']['oauth_token_secret'])){
header('Location: login.php');
exit;
}
}
?>
Client Side HTML/Javascript
<script src="/socket.io/socket.io.js"></script>
<script>
var socket = io.connect('http://localhost');
socket.on('news', function (data) {
console.log(data);
socket.emit('my other event', { my: 'data' });
});
</script>
Server Side Javascript
var io = require('socket.io').listen(80);
io.sockets.on('connection', function (socket) {
socket.emit('news', { hello: 'world' });
socket.on('my other event', function (data) {
console.log(data);
});
});
Resources utilized at psu
CS3600 Database Management Systems
{Intro to MySQL, PHP, RDB Schema}
CS3720 Systems Analysis and Design
CS3020 Web Programing
{JavaScript, DOM, WordPress}
The Peace and Quiet of the Senior Programming Lab
Thanks Everyone!
WORkflow demonstration
Senior Project Final Presentation
By thexande
Senior Project Final Presentation
- 219