Web Programming

AJAX, PHP and MySQL are three common elements of many professional-quality websites. AJAX is a programming technique that allows you to create more interactive and dynamic websites. PHP is a...

PHP is a programming language of the Internet. Part of creating dynamic pages is using SQL in PHP to retrieve data from the server. This code is produced in the PHP pages where it calls the...

If you need to convert an MS SQL or MS Access database to a MySQL database and either do or do not have access to the MS SQL server that contains the original database, then this article is for you.

MySQL is a free, open source database owned and developed by Sun Microsystems. Because of its wide use by the open source community, many user interfaces, such as the PHP-based phpMyAdmin, are...

The "Replace" command used in MySQL serves as a kind of "find and replace" function for databases; it can be used to update a name change, fix any possible spelling mistakes or change addresses....

One of the benefits of using the server-side language PHP is that it contains built-in tools for interacting with your MySQL databases. If you have a MySQL database set up, you can create and...

Connecting a web page to a database is really the key function of large data-driven websites. All but the smallest websites use data, usually through MySQL databases, to dynamically generate...

All but the smallest websites these days use databases to organize their content. Instead of placing important content directly in HTML files, eventually resulting in thousands of files, new...

It's easy to learn the basics of HTML code. It's not so easy to create a massive site with MySQL databases, tabbed layouts, embedded videos and a sales checkout section. Luckily, you can use...

If you plan on building complex websites, eventually you are going to discover that it is all about data management, usually with SQL (Structured Query Language) code. MySQL is currently the most...

Role Playing Games, also known as RPGs, are games in which participants assume roles as fictional characters. There may be a plot or it may be quite free form. On the Internet, RPGs are played in...

This article will teach users with a basic knowledge of PHP 5 and database structure to create a connection to a database, retrieve, add, change, and delete data from that database using PHP 5 and...

When working and writing scripts for a LAMP environment, not much effort or planning is taken into account during database design. Not until your database begins to crawl that you will investigate...

PHP is a programming language used with HTML to design websites. MySQL is a database program that is efficient and reliable. To properly use PHP and MySQL you need to have both programs downloaded...

MySQL provides a number of aggregate functions for quickly compiling data from your tables. These aggregate functions work within SELECT queries, and their results return in special columns. The...

Technically there is no "fetch array" function in MySQL. It's a PHP function that interacts with a MySQL database. MySQL databases are not very useful if application code can't have easy access to...

With a MySQL database, the UPDATE command is used to change some columns of a row already in the database. Usually, this is done to keep information in a database current.

There are multiple ways to delete data from a database in MySQL. At times it may even be necessary to delete entire tables, since some tables are temporary--created to be the target of a SELECT...

There will be times when multiple users need to access the same database, at which point you will need to change the MySQL privilege table. Depending on user needs, you may provide limited or full...

When you need to add or modify information to a database located on the server, you'll need to connect to the MySQL server. In order to do so, you need to know its hostname, port and what username...

Creating a MySQL table utilizes the CREATE command and the "Data Definition Language," or DDL. DDL is used to define data structures. MySQL provides a number of column types. Each column holds a...

There are many reasons you could want to convert a MySQL database to a comma deliminated CSV file. This guide will walk you through the process. To do this you will need the phpMyAdmin software...

Creating a MySQL database is a relatively simple task. This guide will help you create a MySQL database using either the phpMyAdmin interface or the SSH (Secure Shell) command line.

There are many uses for the structured query language (SQL). In order to begin harnessing the power of an SQL or MySQL database, you need to create it. This guide will walk you through the steps...