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) — […]

Database Modelling and Structurization

This brief article shall give some advice on how to start your database project regarding data model and a way to think it through. The first thing you need to make sure is that you know what your application shall be able to do. Having thought about that, you can decide for your data structure. […]

Relational Database Management System Basics

This brief article is meant to give a short overview towards basic relational database management system concepts. It serves informational purpose only. You don’t need this in order to build your application. However understanding what your application is doing can help in designing better software. A relational database system (DBS) consists of the following components: A […]

Client and Server Infrastructure: File, Web, Database

This article takes you by the hand and shows which client and server side components you need and what ways exist in order to successfully build a database supported web application. The overall architecture First of all, let’s take a look at the overall architecture we’re dealing with while developing: Our client provides us with […]