Home / beta
Name Modified Size InfoDownloads / Week
Parent folder
phpMyAccess alpha 2.0 2011-03-21
Totals: 1 Item   0
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