Working with MySQL 8 we look at how we can use Joins to show the data we need and how Views to simplify the select statement in MySQL. We have imported the Northwind database to…
When your PHP application needs to authenticate users you can add the user names and passwords to a MariaDB table, brilliantly simple. However, having done so you probably will notice that the password is in…
I think very often cross-site scripting or XSS attacks are mentioned especially in relationship to desktop courses and how browsers can help prevent them but they do not give details of what they are or…
From what we have seen so far with Nagios, the configuration has been quite simple with none of the plugin requiring additional parameters. In this example where we monitor MySQL servers, we will need to…
As we start to build are application we need to add users to simple demonstration database. We can add the users from an HTML form and submit the information to PHP on the Web Server.…
Previously, we looked at creating tables with FOREIGN KEY constraints. Although this is better for data management it does not help with queries as the column data in a single table no longer has much…