Home
Name Modified Size Downloads / Week Status
Totals: 3 Items   4.7 kB 1
phpmyaccess 2012-10-22 3 weekly downloads
beta 2011-03-18 1 weekly downloads
README.TXT 2012-10-22 4.7 kB 11 weekly downloads
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
Source: README.TXT, updated 2012-10-22