Menu
SQL (Structured Query Language)

Run PHP From Flash Key With Server2go
Do you want to learn (or teach) PHP and / or MySQL, but don't want to install a web server + PHP + database on your PC? Server2go is a neat little application that you can put on a USB flash drive and run your PHP MySQL webpages from there. More ...

Introduction to Variables in PHP
Computer programs usually work with some form of data. This article is an introduction to variables in PHP. More ...

Build Relational Databases in Seven Steps
Many web applications revolve around a relational database. So to create a good application design, you should always create a good database design. Database design is a step-by-step process. More ...

Gettting Started With MySQL Database
MySQL is a powerful relational database management system. The fact that MySQL is used by many major organizations such as Yahoo, NASA and the U.S. Census Bureau proves that it can outperform the big name database management systems. More ...

A Free Windows Graphical Interface to MySQL
In my previous article "Gettting Started With MySQL Database" we installed MySQL on Windows and worked with it using MySQL monitor in a DOS window. In this article, rather than work with a DOS window, we will use a free Windows Graphical Interface to MySQL. More ...

Working With Strings in PHP
Computer programs usually work with some form of data. One of the most common forms of data used in PHP is a text character or an array of text characters. An array of text characters is called a string. More ...

How to Connect to an Unresponsive SQL Server: Direct Admin Connection
When SQL Server stops responding but is still, the first impulse is to reboot SQL Server. This may stop the symptom, but will not tell you anything to help you prevent the cause. More ...

The Entity-Relationship Model
After you have a data model that meets the organizations business requirements, the easiest way to transform that model into a relational database is to first transform that model into an entity-relationship model. More ...