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

Made with Slides.com