Installation In this chapter are detailed installation notes written. Getting started &name; enables PHP scripters to quickly create forms used to interact with data stored in a MySQL database table. The procedure described below will enable you to generate the calling script containing the database logon and a variety of options. An included file phpMyEdit.class.php will later manipulate MySQL records based on user options which are configurable in the calling script. The calling script essentially generates one form which facilitates actions that include add record, change record, copy record, view record, delete record, etc. &name; is available for download from Platon.SK. Extract, or unzip, the program files to your computer's hard disk. The download file includes icons and various language files which should be extracted into sub-folders below the file named phpMyEdit.class.php. Before uploading the program files to your server, make certain that your FTP client is not configured to force filenames to lower case letters. With the program files uploaded to your server, point your web browser to the file named phpMyEditSetup.php. You will be prompted to enter your MySQL database logon (hostname, username, and password) and click the Submit button. The logon screen should resemble the picture below. &name; logon screen Table selection After successfully logging on to a MySQL database, a list of MySQL tables will be displayed. Select a table and click the Submit button. &name; table selection screen ID selection After selecting a table, a list of its MySQL columns will be displayed. Select a column that is a unique numeric identifier. The unique numeric identifier is typically that column which is the unique auto-incremented record ID. Although non-numeric unique identifiers are also supported, we recommend you to use numeric one. Below the list of column names you will find two input boxes containing a suggested Page Title and suggested Base Filename. Either accept or change the content of the input boxes. An attempt will be made to generate a script, write the script to the base filename, and then display the script in the web browser. &name; ID selection screen Result script After clicking the Submit button, the script should appear in your web browser along with a message indicating whether or not the attempted disk write was successful. Depending on your system configuration, the script may or may not have been written to the directory from which phpMyEditSetup.php was run. You will need to either open the file that was written to disk or else highlight and copy the script from the web browser and paste it into a blank document in your text editor. &name; result script screen If the proposed Base Filename was "employees" and the disk write was successful, a file named employees.php would exist in the directory from which phpMyEditSetup.php was run. If the disk write was NOT successful and you've pasted the script into your text editor, save the file in the same directory which contains the phpMyEdit program files. Save the file with the .php extension. Because HTML header and footer requirements vary between users, no header or footer is generated. Add or include appropriate HTML markup as necessary (e.g. <HTML><HEAD> [headers] </HEAD><BODY> [script] </BODY></HTML>). By default the table will be enclosed by <div class="main"> ... </div> which offers a degree of formatting in terms of using CSS (cascading style sheets). Once the header and footer are in place, there are script configuration options that you should review and possibly change.