Learn how to use ADOdb and MySQL for a more efficient website.

This article explains how to make a Dynamic Jump menu in Dreamweaver MX with PHP. It was adapted from the tutorial at http://www.dmxzone.com/ShowDetail.asp NewsId=3218

After having worked through this tutorial you will be able to: * know how the additional phpMyAdmin features using special seperate tables work and how to set them up * store pictures inside a MySQL table and view them from within phpMyAdmin * put specific transformations on any of your columns * create your own transformations, even with active PHP-code in it! * create PDF pages of your table layout, with relations and individually positioned ER-models At the end of this tutorial there's also some hints on getting the most out of your phpMyAdmin config file, showing you some configuration directives which seem to get less public attention.

A detailed introduction to PHP and mySQL interaction. Includes detailed comments to help newbies get used to PHP and understand what is happening in each script.

The usage of databases in larger web-based applications is essential. By using basic object-orientated techniques we can minimize the fuss of connecting and interacting with a database. We can also reuse this code in other applications: a huge benefit of 'OO' programming.

This tutorial shows you what is involved in storing binary files (images, pdfs, or whatever) in a mySQL database. It takes you through the steps of creating a database, uploading the files to it, and getting them back out again. The tutorial is broken up into two parts, the first part covering the uploading, while the second explains getting the files back out.

Learn to utilize Microsoft Access Database and ODBC Connections with your PHP scripts. This method Very similar to using MySQL.

This tutorial will show you how to create relationships in your databases. PHP classes are provided that will perform the job.

This tutorial is very basic, and will provide you with all of the information you'll need to start using PostgreSQL With PHP.

Not sure how to make use of the free MySQL database space included with your web-hosting plan This step-by-step tutorial explains a simple way to upload data from a Microsoft Access database to the MySQL database at your ISP. The tutorial also contains a free sample application that is available in ASP and PHP versions.

Got a MySQL database with content within it Want to be able to search it and display paged search results on screen This tutorial and script will do just that. (Apache, PHP, MySQL database required)

Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal.

This is a tutorial on how to create a web database application using PHP and MySQL on Mac OS X or Linux platforms. The example used is a database to manage web site links. The same ideas used in this tutorial can be expanded to most web applications like phone directories, personalization, survey polls, etc... All are based on inserting, displaying and managing data in a database.

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 interemediate tutorial shows you a way to capture time spent for MySQL tasks. Find out how to output page generation time and percent when MySQL was running.

Find out and learn this beautiful technique how to output any MySQL table to the HTML page. The source code shown here will teach you how to create a function that is useful on any web site having MySQL backend database.

This tutorial will show you how to display data from a database and allow the user to sort it.

Want to reduce the load that MySQL has on your web server Generating Static HTML pages to replace queries is the solution. Read this tutorial to learn how.

So you've written a great application with PHP and it is up and running smooth. Then, your boss calls and tells you that your company won't be using MySQL anymore. You're moving to Oracle. Your application is dead in the water. You should have used database abstraction.

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