Just A simple CMS

Just A simple CMS
In above stated projects I have made good use of HTML5, CSS, JavaScript / JQuery, PHP / MYSQLI and APIs. Which require great level of PHP, JavaScript CSS, and Object-oriented programming (OOP) skills.
In this projects I created content management system (CMS) using HTML5 , CSS, JavaScripts / Jquery , PHP and MySql (Structured Query Language).
Such application enables the organisation to:
• Execute queries against a database
• Retrieve data from a database
• Insert records in a database
• Delete records from a database
• Update records in a database
Needs
A client request a system where the ministries they are mentoring can impute data and later be accessible by the Administration department whom will in turn process the imputed data and use that data for mentoring and administering of those ministries. The system also include; payment, mail, SMS and message log.
Approach
The system consist of;
User and admin login and ability to delete update insert data and auto complete/populate result , search engine.
/index.html
The home page consist of intro information and buttons for both user and administrator to trigger action to render their allowed pages. Which render a default.php content at an instantaneous.
• images/
Consist of general images and graphics
• php/
• render.php
Consist of php render class which render a requested and allowed pages to user and administrators the request is been sent based onClick event by user and received by control.js using Jquery Ajax
• config.php
Consist of all constants [using php define(‘name’,’value ‘,true); - function)] which are globally accessible across the system such as servername, database name, database username , database password system name and other constant that will require more than once or for common use across the system.
• connect.php
Consist of scripts and variable used to connect to the database. If any of the connection parameters are invalid it die(); and printout an error message otherwise if successful connection to the database is made .
• controller.php
Consist of scripts and variable used to manipulate the system functionalities such as get username, retrieve specific data from database, insert, delete, and update database and $_SESSION() starter and holder. The controller also consist of form submission validation, it consist php classes that distributes actions and regulate trigger events, and it allocate imputed data to their correct Table, columns and row in the database.
• login.php
This page consist of scripts and variable that enables users to register, login, retrieve lost or forgotten password, and set session variable that can be use across other pages such as $_SESSION[‘username’]; and $_SESSION[‘userId’]; having controller.php included.
• js/
• control.js
The page consist of JavaScript which listen to onClick, OnSubmit, and other css enhancers, it take command to controller.php via Ajax in turn pass regulated command to render.php on page view request it send login details to the login.php. In short, it work like an intermediary between the .htlm and the .php pages as the system will not regularly refresh. It render views, transmit and support forms validation and submission, add animations instead of flash elements.
• jquery.js
This the Jquery Library
• css/
• images
• fonts
• system.css
Consist of pseudo-class which is use create the system element fonts weight and sizes, display, colour, transition, animation and transformations
• views/
• default.php
• pages/
• adminview.php
High priority with ability to delete or remove user, update data, add data and so on.
• userview.php
Same as Admin view but with less priorities of input and system executions
Database Structure
PhpMsql Table: UserLogin
userId (AI) UserName(Var) UserPass(Var) UserEmail(Var) UserRegDate(datetimestamp) ActivaTed ActCode

When user register we send auto responds mail with their new username and password in turn they click a link with activation code. If the activation code marches the activation code in the database the system automatically update the ActivaTed column in the Table UserLogin. We then display a login page where they can use their new registration detail to pass through authentications.
We then create further Tables such as payment and full registration table which insert ministries contact details (Telephone, address, correspondent name etc.).