Nusic Website

Nusic was part of a web development project in the third year of my honours degree. 

Features:

• MySQL Database
• Bootstrap CSS
• PHP backend
• RESTful API
• Security 
  • bcrypt password hashing
  • preg_match()
  • Prepared statement
  • POST requests
  • SMTP Email account verification
  • Admin account verification
• Model-View-Controller (MVC) framework
• IoT Implementation over restful API
• Web service weather over RESTful API
• Reading External RSS
  • and an XSLT version
• User login system
• User comment system
• Articles 

PHP:

<?php
function displayAllArticles(){

 global $con;
  $query = $con->prepare('
    SELECT article.articleID, article.articleHeadline, article.articleDesc, article.articleImgLink, article.postDate
   FROM article
    WHERE article.articleDeleted != 1
    ORDER BY article.articleID DESC');
 $query->execute();
  $stmt = $query->fetchAll(PDO::FETCH_OBJ);
 return json_encode($stmt);
}
?>

Database Design: