This tutorial might seem pretty simple and obvious for many advanced webmasters, but some beginners might have some problems. And since I remember I was a bit stuck on this years ago too, why not make things clear for anyone? When do we need to do this? Everytime we install a forum or a CMS that requires an empty database being already created for the install process.

This tutorial will hopefully teach you some basics of how to access data with your PHP scripting to gather information with in a MySQL database. The first step you need to do is get a basic understanding of what MySQL is. If your site can handle or has access to a MySQL database you should try using the PHP Myadmin application to help you use and access your MySQL datases fast and easy.

In some content management scripts case one needs to create a database and also populate it (insert the tables from the example .sql file). It's the case of PhpNuke for example. You will learn here to create a new database in phpmyadmin and also insert the needed information. There are some images too, to help you grasp the info easier.

For those working on php and mysql a server is mandatory. But what if you cannot have a place to upload and modify or maybe you just want to develop your project privately and then install online? This is the moment a local server is needed. Your computer can "act" like a normal server if you have some programs installed. PHPDEV is a free program that, once installed, can offer you the tools you needed to work offline on your projects and still be able to benefit from all the features a server has. This tutorial will guide you through all the steps needed till you have a working local server on your PC.

Do you get stressed out by mysql or other database queries? Do you use multiple databases and wish there was just one way to handle all of your queries? ADOdb is a system that executes queries to any type of database the same way, so you only have to know how to do it their way. This tutorial walks you through installing ADOdb on your web server, and configuring it to work with a mysql server.

This is a short tutorial on how to program in PHP and MySQL. Covers several MySQL functions via telnet command, and a short example on using PHP with MySQL.

The author writes: Whilst working on the automatic production of web statistics - came across the following problem: "How do I get relational data from an Hierarchical structure?" It didn't take long to realize - I'd have to use PHP to talk to LDAP, pull off records & upload into a series of tables, using the cn as primary key. Which then could be queried relationally. Pulling off large, queries and repeatedly transcending LDAP trees is pretty slow - so I built my LDAP to SQL engine, by flattening dns into table names. Then used PHP scripts to query & produce daily snap shots.

This is the Full chapter 6 from the recently published book 'Mastering phpMyAdmin for Effective MySQL Management'. The Chapter 'Changing Table Structure' give a great step by step guide with diagrams. Publshed in HTML for your enjoyment.

mSQL is a lightweight SQL database engine for Unix systems. It is extremely easy to install and configure and it does a great job of handling simple SQL queries. This tutorial shows you how to communicate with the mSQL database engine using various mSQL-PHP functions.

Putting your data into multiple columns with PHP is a snap. This tutorial will show you how it is done.