How many ways are there to output HTML using PHP

The con, the cat and t’e nation! Have you heard of concatenation? No? Stay with me if you haven’t! According to wikipedia: String concatenation is the operation of joining character strings end-to-end. For example, the concatenation of “snow” and “ball” is “snowball”. Concatenation is an import concept in PHP for outputting HTML. Also used in […]

How to access PHP session variables from another PHP page

​​ One of my subscribers sent me an email asking me about problems he was having with sessions. He had already created a session variable in one PHP file. Now he had a second PHP and wanted to access the session variable in it. However he was struggling to access his session variable. He found […]

How to use PDO to UPDATE data in MySQL using PHP

You need to get data safely updated from a web page to a MySQL table in your database You need to sanitize that data from user input and protect against SQL injections. The following simple example will show you how to accomplish that. These are the ingredients you will need: A MySQL database A table […]

How to use PDO to DELETE data from MySQL using PHP

You need to delete data safely from a web page and your MySQL table in your database You need to sanitize that data from user input and protect against SQL injections. The following simple example will show you how to accomplish that. These are the ingredients you will need: A MySQL database A table to […]

How to use PDO to INSERT data into MySQL using PHP

You need to get data safely from a web page to a MySQL table in your database You need to sanitize that data from user input and protect against SQL injections. The following simple example will show you how to accomplish that. These are the ingredients you will need: A MySQL database A table to […]

How to use PDO to SELECT data from MySQL using PHP example

You have a MySQL table of data in your database, you want to display it on a webpage, so it can be displayed and viewed by other people. You need to have a few things in order to accomplish this: A MySQL database A table containing data in the above database The credentials to above […]

How to check an email address is valid when a form is submitted to your PHP code?

How to check an email address is valid when a form is submitted to your PHP code? You have a form on your website and you are collecting email addresses You want to make sure they are valid email addresses, so that you can make use of them Whether you are replying to a customer […]

How to hire a developer when you don’t know code at all

Need a developer for your startup and don’t know where to start? Hiring a developer can be daunting without technical knowledge. I don’t know code at all. Even with technical knowledge, are you aware of all the latest trends and platforms? What kind of developer should I be hiring? Wondering what the difference is between […]

How to join a table many times in a single SQL query statement?

Having more than one join to the same table within a query can be confusing. More than one join can create a messy SQL statement. If you don’t use aliases they can be difficult to read. If your database tables need to have many columns with the same relationship to another table. You can join […]