PHPMyEdit V4.0b3 ---------------- IMPORTANT: When submitting a bug report, please include a mysqldump of the affected table and the .inc file generated by PHPMyEditSetup. Be sure to strip out database host/user/password info from the generated file! This project was the brain child of John McCreesh who has now moved on to other, more pressing projects. Mr. McCreesh had the foresight and fortitude to put together an excellent framework. This program is developed and tested using PHP 4.0.6 and MySQL 3.23.44 under RedHat Linux 7.2. Full documentation for using this program can be found on the PHPMyEdit web site, http://PHPMyEdit.sourceforge.net/4.0b 1. Extract PHPMyEdit.inc and PHPMyEditSetup.php 2. copy/ftp/whatever them to your development web site 3. Using a browser, run PHPMyEditSetup.php to log on to your MySQL server 4. select a database and table 5. PHPMyEditSetup.php will attempt to write two files and will display a php file and a 'calling program' include file in your web browser 6. If the file write to the directory where the files were to be written fails, copy it into your php editor, save it to a file, and then run it in the same directory that you used for PHPMyEdit.php. The generated .inc file is pretty heavily commented... if there's anything you don't understand, look on the PHPMyEdit web site! I'm happy to accept bug reports, suggestions for improvement, or improved code, preferably via SourceForge where everyone can see them, but failing that via email. If you're submitting a bug report, please include the main table schema (mysqldump -d [database_name] [table_name]), schema for supporting ['values']['table'] tables, and the contents of the generated PHP file in the body of your bug report. Many thanks to the SourceForge crew for providing these facilities and to all those who have contributed code (see changes.txt for credits). Special thanks to Pau Aliagas (pau@newtral.com) who converted PHPMyEdit to PHP classes in version 3.0. +-+-+-+ Usage notes phpMyEdit uses htmlentities() extensively. However, there is a bug in PHP which means that this function currently only escapes the ISO-8859-1 (or ISO-latin-1) charset. If you need to handle other character sets, a simple workaround is to use htmlspecialchars() instead of htmlentities(). However, specialchars is not as robust as entities, so PHPMyEdit will persevere with entities in the hope it will be fixed in a future release of PHP! If MySQL support is linked into PHP with the header files shipped with PHP, PHP will not correctly report all column types. I've only had problems with TINYINT and other infrequently used types. +-+-+-+ Jim Kraai 03-Dec-02 jkraai@users.sourceforge.net