Recently Updated Pages
Creating API Endpoints for Specific Data
In the previous tutorial, you created an API that returned every record from the security_events...
Creating a Database-Driven API with PHP and MySQL
In the previous tutorials, the API returned data from a JSON file. In this tutorial, you will cre...
Reading API Data with JavaScript
In the previous tutorial, you created a simple API using PHP. The API returns JSON data when visi...
Creating a Simple JSON API with PHP
In this tutorial, you will create a simple API using PHP. The API will return JSON data when visi...
Creating a Security Dashboard from JSON Data
In the previous tutorial, you displayed individual security events in a table. In this tutorial, ...
Displaying Nested Event Data from JSON
In the previous tutorial, you displayed device information in a table. In this tutorial, you will...
Displaying JSON Data in a Table
In the previous tutorial, you loaded a JSON file and displayed basic information about the smart ...
Loading JSON Data with JavaScript
In this tutorial, you will load data from a JSON file and display it on a webpage using JavaScrip...
Building a Security Dashboard Using PHP and MySQL
In the previous tutorial, you used SQL queries to analyse imported JSON data. In this tutorial, y...
Querying Imported Data with SQL
In the previous tutorial, you imported JSON data into the security_events table. In this tutoria...
Importing JSON into MySQL with PHP
In the previous tutorial, you created a security_events table. In this tutorial, you will read d...
Creating a Security Events Table
In this tutorial, you will create a MySQL table to store security event data imported from a JSON...
Moving a XAMPP Project to Another Computer
One of the advantages of using XAMPP is that projects can easily be moved between computers. This...
Restoring a XAMPP Project from BackupNew Page
If a project is accidentally deleted, corrupted, moved to another computer, or you need to contin...
Backing Up a XAMPP Project
A XAMPP project usually consists of two parts: The website files stored in the htdocs folder. Th...
Secure Password Storage with Password Hashing
In the previous tutorial, passwords were stored as plain text in the database. In this tutorial, ...
Creating a Navigation Menu Based on User Roles
In the previous tutorial, you created a role-based access control system using admin, teacher and...
Adding Role-Based Access Control
In the previous tutorials, users could register, log in, access protected pages and log out. In t...
Creating a Logout Page
In the previous tutorial, you protected pages so that only logged-in users could access them. In ...
Protecting Pages and Preventing Unauthorised Access
In the previous tutorial, you used PHP sessions to remember who was logged in. In this tutorial, ...