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.

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.

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.

If you are writing an application that is used in multiple environments and operating systems, you need to plan to support multiple databases. This article is based on my experiences with multiple database systems, stretching from 4th Dimension in my Mac days, to the databases I currently use, which are: Oracle, FoxPro, Access, MS SQL Server and MySQL. Although most of the advice here applies to Perl, Python and other programming languages, we will focus on PHP and how the ADOdb database abstraction library offers some solutions.

Even though loading data from a text file into the database is not a task that user would perform on a daily basis, there are several cases when the speed of this process is important to DBA and company management. One example would be having a "database guy" receive the daily reports from the field offices or sales people on daily basis. Reports come as Excel documents or delimited spreadsheets of some kind, and DBA's responsibility includes updating the database on constant basis, so that by the end of the day, he is able to give the management a report on the amount of daily sales or field office transactions. Here you will find a MS Word-format downloadable file that examines the benchmark results for Oracle and MySQL speed of loading the data from a text file.