I. PHP AND MYSQL TUTORIALS AND SAMPLES

There are many good tutorials on the web to learn about Php and Mysql. We think its worth a try and gives you the best links to them.

• What is php? (Tutorial, including tips how to use variables on forms or prepare a multipage form)
• Mysql + php tutorial
• Tutor: Integrating PHP with the MySql database
• MySql for Win95/98/NT
• Dynamic web page with php3
• Web mail in PHP (tutorial on creating your own Webmail program)
• Using Object Oriented PHP for secure and maintainable CGI applications (Tutorial with code snippets)
• MySQL Basics - A Tutorial (Including MySql on Win32)
• Building an E-Commerce Site Part 1-4: Building a Product Catalog (Tutorial)
• Efficient SQL in PHP (Tutorial with sample code)
• Frequently Asked Questions about MySQL
• Workshop: Using PHP/MySql (Tutorial with many code samples to study)
• 7 Reasons Why PHP is Better than ASP (Article)
• A Comparison of PHP and Cold Fusion
• Keeping Track of Your Visitors - PHP Session Management (Excellent tutorial with code samples)
• PHP database objects for ODBC (Complete PHP script)
• Binary Data on MySql ("..article is aimed at answering one of the most asked questions on the PHP mailing list and discussion forums alike: How to store binary files in a MySQL database" Nice tutorial)
• How to import a binary file into the MYSQL tables. (Tips & Scripts)
• PHP Application Server and Code Generator (Nice tools to create quickly database-driven web applications)
• Server Databases Clash ("..a comprehensive benchmark of the latest available versions of five server databases..We tested IBM's DB2 7.2 with FixPack 5, Microsoft Corp.'s SQL Server 2000 Enterprise Edition with Service Pack 2, MySQL AB's MySQL 4.0.1 Max, Oracle Corp.'s Oracle9i Enterprise Edition 9.0.1.1.1 and Sybase Inc.'s ASE (Adaptive Server Enterprise) 12.5.0.1..." - 2/2002)
• JavaScript behaviors within PHP
• and more...

II. APPLICATION/PROJECTS/TOOLS

Php and MySql are now for many years on the net. The result: Many useful applications ranging from forums to shopping cards and e-mail clients are now available. The best? Most of them are free.

• Free native client of Windows32 for mySql database!
• Php3 & MySql utilities (Web interface, shopping cart, calendar...)
• Free Forums written in PHP
• E-mail using php scripts
• Several excellent PHP editors being used in a php development environment for Win32, both to write and debug.
• PHP IDE tool(s)
• A fully-featured web authoring and maintenance tool with flexibility and power. Coding tools generate standards agnostic pages, with tools ranging from an FTP client, to a Perl -compliant web server and Style Sheet Editor. Support of PHP, HTML, XML, ASP. Freeware!
• A compiling PHP template engine
• Many(!) free Delphi components, including a MySQL direct access package to access MySQL database directly, skipping the BDE. Supports data-aware components
• MySQL database console for creating and managing simple databases for web sites, no matter where your MySQL Database is.
• Visual SQL-Designer [$]
• A Win32 application for transferring data from FoxPro .DBF files into MySQL sql server
• and more...

III. PHP CLASSES

Not everything needs to be invented again. Using classes you can integrate third party with ease into your programs.

• Accessing databases with class (php/mysql tutor article)
• Mysql classes for php! (setup, fetch, insert, update...)
• Php class library
• Accessing databases with class - Building library components with objects(php/mysql tutor article)
• A set of PHP functions which provide a framework for developing any HTML form with a database backend including more than 10 widgets types such as text field, date, file upload and select
• PHP Classes Repository (with virtual hundreds of free to use php/mysql classes)
• A PHP Unified Database Abstraction Layer for supporting multiple databases
• A NNRP class provides a PHP API for reading news on the web
• A set of functions written in PHP3 for helping in the building of a site accessing a complex database scheme. For Postgres and for Mysql)
• and more...

IV. PHP CODE SNIPPETS AND SCRIPTS

As a programmer, you are always looking for the perfect code to assist you. There are many problem solving php scripts on the net. You need only to pick them up.

• A resourceful PHP club
• More than 45 PHP tips & tricks
• A function to convert from ACCESS to MYSQL!
• The PHP Form Processor
• Various php3 scripts to download (35+)
• PHP Forms / Regular Expressions (Sample Code)
• A resource site with many php/mysql scripts (Currently over 230)
• and more...

V. PHP/MYSQL FORUMS AND DISCUSSION LISTS

VI. XITAMI PERSONAL SERVER

If you want to develop or test applications for php/mysql you need to have a development system on your pc. It would be more than awkful to upload your php/html files to your host and test from there if everything works, including the mysql database.

Better is, you install a Xitami personal web server on your Windows9x system and test almost everything here. Its very easy to setup and runs everything: Html. Php and Mysql. You'll love it!