Category archives: Web Tutorials - Page 1

Linux Basics – awk

It’s not a noise, it’s a command! The awk command is one of those strange commands, much like the extinct bird with the same name. You either love it or you […]

Michael O.

3min Read

Linux Basics – sed

How to use Linux sed ‘s’ function As Linux commands go, this one has a very confusing name. That is, until someone tells you that like many Linux commands, it […]

Michael O.

4min Read

Troubleshooting website issues

Basic troubleshooting methodology At HOSTAFRICA, we believe that troubleshooting must be structured to be useful. I find the best method is the “Macro to Micro” approach. This means that you […]

Michael O.

7min Read

Howto – A short MySQL tutorial with examples – 03

In our previous MySQL tutorial, we did some basic SELECT queries, a CONCAT for output and a JOIN to lookup data on a different table that was linked or related to […]

Michael O.

4min Read

Howto – A short MySQL tutorial with examples – 02

In our previous MySQL tutorial, we created a small database with four tables. In this article, we will learn to manipulate the data we entered using JOIN to derive data […]

Michael O.

5min Read

Howto – A short MySQL tutorial with examples – 01

Following on my previous article on databases and database planning, I have decided to add a quick practical tour of a MySQL database. MySQL and MariaDB are equivalent for the […]

Michael O.

4min Read

Planning Your SQL Database Structure

This article is not from a professional SQL Database Administrator’s perspective. It is from someone who has been using MySQL, PostgreSQL and MariaDB for the last 18 years. I have found […]

Michael O.

3min Read

Installing Apache/MySQL/PHP On Linux (LAMP Stack)

LAMP Server To develop PHP web apps, you need to set up Apache, MySQL and PHP, in a LAMP Stack (Linux/Apache/MySQL/PHP) environment. You can either install the individual components i.e […]

Michael O.

3min Read

Some easy diagnostic tools for everyone

Struggling to connect to your email or website? Cannot see if your server is up or not? Here are a few tips and diagnostic tools to help you get a […]

Michael O.

4min Read

Category archives: Web Tutorials - Page 1

Linux Basics – awk

Linux Basics – sed

Troubleshooting website issues

Howto – A short MySQL tutorial with examples – 03

Howto – A short MySQL tutorial with examples – 02

Howto – A short MySQL tutorial with examples – 01

Planning Your SQL Database Structure

Installing Apache/MySQL/PHP On Linux (LAMP Stack)

Some easy diagnostic tools for everyone

Categories