Dynamic PHP based MySQL data readout with HTML output

This brief article gives a step-by-step description on how to dynamically read data coming from a MySQL database and how to both visualize and edit that data using HTML table and form markup. How our data management markup will look like Let’s assume we want to build a Comic management database application handling data like this: If a user clicks “Delete” the […]

How to connect to MySQL using PHP

This brief article describes step-by-step how to connect to a MySQL database using PHP. If you want to provide content coming from a database, you will at least have to know the following methods: mysql_connect($server, $user, $password) — opens a connection to a database server mysql_select_db($database_name) — chooses a database within the database server mysql_query($sql_query_string) — […]

How to build a website — PHP navigational skeleton step by step

This brief article describes step-by-step how to build a website’s base structure using PHP. If you attempt to follow this course, you should have at least read the following articles first: HTML coding basics Learning PHP — output, calculation and variables PHP control structures — loops and conditions PHP inter-script GET and POST parameters However […]

PHP GET and POST parameters

This brief article shows step-by-step how PHP inter-script GET and POST parameters are to be used in dynamic web pages. Why script parameters? Basically, you could use just one script (file) for your entire website project. However, your code will get rather long, maintenance will get harder and errors more difficult to track. So you may want to […]

HTML form elements

This brief article gives an introduction to HTML form elements and how they are used within web pages. A simple HTML form First of all, let’s look at how a form is used in general. 1 2 3 <form action="mailto:user@domain.de" method="POST" enctype="text/plain"> <!– Some input and/or button elements –> </form><form action="mailto:user@domain.de" method="POST" enctype="text/plain"> <!– Some […]