phpMyAccess alpha (2.x) is NOT an upgrade to phpMyAccess 1.x!!!!
DO NOT copy files from 2.x into your existing phpMyAccess 1.x installation folder as they are not compatible.
phpMyAccess 1.5.x is still maintained and updated and still available here!!!
-=-
Why is this called PHPMyAccess ?
Well, the idea is to make something that is as easy to use as MS Access for doing
the basic editing of a table. Actually, it should be _easier_ to use, and support the
usual things people drool over.
What is the difference between phpMyAccess 1.5.x and phpMyAccess alpha 2.0.x
phpMyAccess 1.x came first. It is based on some code from and older version of phpMyEdit, but with added complexity. After version 1.5.x it was made PHP 5 Ready, and then the Edit in line libraries were added from what became phpMyAccess alpha
phpMyAccess alpha 2.x came from the idea of making something that LOOKS a lot like MS Access, and runs right in the browser.
phpMyAccess alpha is a complete from scratch rewrite, more keeping with what the name
sounds like it is -- a MS Access like GUI for mySQL databases, written in php.
There is minimal code from phpMyAccess 1.5.x that I am integrating to allow for basic
authentication. This is not ment to be the "be all end all" authentication, and you
can add whatever other auth mechanisim in that suits you. I personally use LDAP auth,
and that option may make it into future relases. -- No point in reinventing that wheel.
Eventually the alpha (2.x) GUI may be added to phpMyAccess 1.x to create a 3.x, but
for now only the Edit in line libraries have been added to the 1.5.x versions.
phpMyAccess alpha (2.x) is usable to replicate some of the functionality of MS Access like query building, running, data modification, DIRECTLY in the browser.
Below are explanations of what each are more fully:
1.x phpMyAccess 1.x
PHPMyAccess is a generic table editing program. It uses a separate engine and
table program. The table and fields to be edited are defined in the table program,
which just calls the engine to do the grunt work.
A number of features have been implemented to make the calling program more capable
of influencing exactly what the engine should display.
The engine itself works in three passes. Pass 1 displays the selected MySQL table
in a scrolling table on the screen. Radio buttons are used to select a record for
editing, viewing or deletion. If the user chooses Add, Change, Zoom, or Delete buttons,
Pass 2 starts, displaying the selected record. If the user chooses
the Save or Delete button from this screen, Pass 3 processes the update and
the display returns to the original table view (Pass 1).
The engine now has the ability to click on a field, edit the field, and post when
clicking else where in the page. This is made possible by the addition of javascript
to the code making this an AJAX enabled application.
The engine also fully supports searches and will handle multiple filter criteria, and allows
for one column to be the sort column, in either ascending or descending order.
When in filtered table display mode, the filter can easily be removed by pressing
the "Clear Filter" button. This will clear any filter settings, but will preserve the
sort order.
NOTE: From version 1.5.0 onwards PHP 5.xx is recommended, and preferably one of the latest versions
(that is 5.1x or later), since they fix a number of pretty serious security issues.
May still run on PHP 4.x, but has only been tested on 5.1.2 and 5.
The previous versions of PHPMyAccess were late php3/early php4 and many php functions have depreciated.
PHPMyAccess 1.5.0 is only a PHP 5 syntax revision, no new features have been added
or developed, versions 1.5.1 and later have added the Edit in line feature set.
NOTE: Version 1.5.3 adds an updated version of the pma-editinline/pma-ajaxcell libraries
2.x phpMyAccess alpha 2.x
phpMyAccess alpha is a mySQL query builder in the open source spirit of MS Access
It uses a completely unique engine -- it is not a port, no part of it is baised on MS code.
A number of features have been implemented to make it act and look like MS Access,
but as the name implys it is in alpha stages right now.
Some portions of the code are borrowed from phpMyAccess 1.5.x, for roll out
purposes.
NOTE: PHP 5.xx is recommended, and preferably one of the latest versions
(that is 5.1x or later), since they fix a number of pretty serious security issues.
It has only been tested on 5.1.2.
mySQL 5.0 is recommended, It has only been tested on 5.0.51a