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.