Search Results

If a project is accidentally deleted, corrupted, moved to another computer, or you need to continue working from a backup, both the website files and database must be restored. This tutorial demonstrates how to restore a complete XAMPP project from a backup. B...

One of the advantages of using XAMPP is that projects can easily be moved between computers. This is useful when: Working between school and home. Upgrading to a new computer. Sharing a project with a teacher. Creating a backup before reinstalling Windows. A c...

In this tutorial, you will create a MySQL table to store security event data imported from a JSON file. The JSON file contains homes, devices and events. Rather than storing the entire JSON structure, each event will be stored as a separate row in a database t...

In the previous tutorial, you created a security_events table. In this tutorial, you will read data from a JSON file and import it into MySQL using PHP. The JSON file contains devices and events. Each event will be inserted into the security_events table as ...

In the previous tutorial, you imported JSON data into the security_events table. In this tutorial, you will use SQL queries to analyse the imported data. View All Events Open phpMyAdmin and select the: security_events table. Run: SELECT * FROM security_events...

In the previous tutorial, you used SQL queries to analyse imported JSON data. In this tutorial, you will build a dashboard that displays security statistics directly from the database. The dashboard will display: Total Devices Total Events Critical Events High...

In this tutorial, you will load data from a JSON file and display it on a webpage using JavaScript. The JSON file contains information about a smart home, including devices and security events. Create the Project Files Create a new folder called: json-demo Ins...

In the previous tutorial, you loaded a JSON file and displayed basic information about the smart home. In this tutorial, you will display the device data in an HTML table using JavaScript. Current Project Structure Your project should contain: json-demo ├── in...

In the previous tutorial, you displayed device information in a table. In this tutorial, you will work with nested JSON data by displaying the security events associated with each device. The JSON file contains devices, and each device contains its own list of...

In the previous tutorial, you displayed individual security events in a table. In this tutorial, you will create a simple dashboard that summarises the data and highlights important security information. The dashboard will display: Total Devices Total Events C...

In this tutorial, you will create a simple API using PHP. The API will return JSON data when visited in a browser. This is the same type of data format used by many real-world APIs. Project Structure Create a folder called: api-demo Inside the folder place: ap...

In the previous tutorial, you created a simple API using PHP. The API returns JSON data when visited in a browser. In this tutorial, you will use JavaScript to read data from the API and display it on a webpage. Project Structure Your project should contain: a...

In the previous tutorials, the API returned data from a JSON file. In this tutorial, you will create an API that reads data from a MySQL database and returns it as JSON. The System Architecture The completed system will work like this: security_events table ...

In the previous tutorial, you created an API that returned every record from the security_events table. In this tutorial, you will create multiple API endpoints that return different types of data. This approach is commonly used in modern web applications. Wh...