Working with Data
Importing JSON into MySQL with PHP
Creating a Security Events Table
In this tutorial, you will create a MySQL table to store security event data imported from a JSON...
Importing JSON into MySQL with PHP
In the previous tutorial, you created a security_events table. In this tutorial, you will read d...
Querying Imported Data with SQL
In the previous tutorial, you imported JSON data into the security_events table. In this tutoria...
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...
Data Visualisation with Google Charts
Creating Charts with Google Charts
Google Charts is a free JavaScript library that can create professional graphs and charts using y...
Pie Charts from SQL Data
In the previous tutorial, the chart data was entered manually. In this tutorial, the chart data w...
Bar Charts from SQL Data
Bar charts are useful for comparing values between categories. In this tutorial, the number of se...
Line Charts from SQL Data
Line charts are used to display trends and changes over time. In this tutorial, the number of sec...
Working with APIs
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...
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 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...
Creating API Endpoints for Specific Data
In the previous tutorial, you created an API that returned every record from the security_events...
Working with JSON Data in JavaScript
Loading JSON Data with JavaScript
In this tutorial, you will load data from a JSON file and display it on a webpage using JavaScrip...
Displaying JSON Data in a Table
In the previous tutorial, you loaded a JSON file and displayed basic information about the smart ...
Displaying Nested Event Data from JSON
In the previous tutorial, you displayed device information in a table. In this tutorial, you will...
Creating a Security Dashboard from JSON Data
In the previous tutorial, you displayed individual security events in a table. In this tutorial, ...