Location: PHPKode > scripts > phpMyAccess > phpmyaccess-1.5.3/phpmyaccess/README.TXT
Go visit the PHPMyEdit pages on sourceforge.
It explains quite well what this application does as well, since it is derived from it.
This application is much less simple, since it adds a lot of additional features, but
it is still similar enough you should look over that excellent explanation first.
In order to be able to use PHPMyEdit files transparantly (it should be possible to at
least get some output) the engine is still named the same.
The innards are however rather different by now.

phpMyAccess was baised on phpMyEdit 2.3. Although as of Dec 2010 up to version 5.7,
phpMyAccess 1.5.0 is compatable with php 5, and 1.5.1 includes ability to edit some
fields right in place with the addition of some javascript making this an AJAX enabled.
Version 1.5.3 expands upon those libraries with some additional sample code and some bug fixes. 

NOTE: with the new Edit in place feature in version 1.5.x there are a few things you should
be aware of:
	1. It only works on string types for now.
	2. It only edits fields that CURRENTLY have less than 60 characters, you can tell by looking
	   at the field. If it ends in "..." then it won't allow you to edit it by clicking on this.
	   I hope to add this ability in future versions.
	3. It does NOT yet check for MAXLENGTH of a field. If you enter more than the field can hold,
	   mySQL will truncate the data being posted. This is a limitation of mySQL, and I will be adding
	   error checking to prevent this in future versions.
	I felt this feature was super cool and wanted to get it out to you all ASAP, so enjoy while knowing
	the above limitations for now.
	   
Installation of the demo application is relatively simple, roughly in order :

-  Download the install file (You probably did since you're reading this)
-  Unpack : tar xvzf phpmyaccess.tar.gz or use one of the windows programs 
   that do the same thing, eg. Winzip, or winrar.
-  Read the README.TXT and manual.txt file in the phpmyaccess directory
-  Create your database.
   Use either the command line tool mysql or one of the web based managment tools.

   Check your local setup for the password and user to use.
   Setup a new user for the demo database and add a password, and reload the server.
-  Insert the tables into the database
   example :
   mysql -u admin -p < default.sql
   NB: this assumes the database is called demo, if that is not the case change "use demo;"
   into the name of your database in the default.sql file. It will ask for your password,
   create the tables and insert the data.
-  Make sure password etc. are changed in the dbaccess.php file to what you set up earlier.
-  Place the PHPMyAccess files in the web directory.
-  Make sure Apache or IIS know where your site is and allows access.
-  Start Up your browser, and point it at the right location.
   Log in using admin/admin, and browse around.

   As with PHPMyEdit you can use the setup.php to generate a new program for an existing table.
   Compared to PHPMyEdit there is an added cycle to add linked table entries.
   Since there is no way for the program to verify if these fields are correctly selected
   without a lot of extra checks and some testing they are commented out by default.
   You as the user will have to make sure things work as you think they should by
   manually enabling and / or adding any features you need by removing comments or
   manually adding the correct entries..
   There is an include for the dbaccess.php (which contains login data for the database)
   and the commented-out lines the dbaccess.php should contain.
   If this is a standalone new table editor, you may not need the whole thing in a separate file.
   In that case you can just comment out the include and use the commented-out lines.
   Using it is strongly recommended for larger numbers of files, since changing a password
   is much easier if you only have to change one file
Return current item: phpMyAccess