PHP-MySQL Archives - The Urban Penguin

Creating MySQL Joins and Views

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…

The Urban PenguinJune 10, 2022

PHP-MySQL

TO_BASE64 Protects your MariaDB Data

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…

The Urban PenguinMarch 11, 2019

Apache PHP-MySQL

PHP XSS Example and Prevention

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…

The Urban PenguinApril 30, 2014

nagios PHP-MySQL Ubuntu

Nagios Monitoring MySQL Servers

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…

The Urban PenguinOctober 25, 2013

PHP-MySQL

Adding data to MySQL with PHP and Web Forms

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.…

The Urban PenguinOctober 3, 2013

PHP-MySQL

MySQL QUERIES and JOINS

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…

The Urban PenguinOctober 3, 2013

PHP-MySQL

Creating MySQL Joins and Views

TO_BASE64 Protects your MariaDB Data

PHP XSS Example and Prevention

Nagios Monitoring MySQL Servers

Adding data to MySQL with PHP and Web Forms

MySQL QUERIES and JOINS

Categories

Recent Posts

Quick Links

PHP-MySQL

Creating MySQL Joins and Views

TO_BASE64 Protects your MariaDB Data

PHP XSS Example and Prevention

Nagios Monitoring MySQL Servers

Adding data to MySQL with PHP and Web Forms

MySQL QUERIES and JOINS

Categories

Recent Posts

Quick Links

Sign up to our newsletter