Home / phpmyaccess
Name Modified Size InfoDownloads / Week
Parent folder
phpMyAccess alpha 2.0.1 2012-10-22
phpMyAccess 1.5.3 2012-10-22
PHPMyAccess 1.0.3 2011-06-20
PHPMyAccess 1.0.10 2011-06-20
PHPMyAccess 1.5.0 2011-06-20
phpMyAccess 1.5.1 2011-06-20
phpMyAccess 1.5.2 2011-06-20
README1.5.3.TXT 2012-10-22 3.9 kB
README.TXT 2012-10-22 4.4 kB
Totals: 9 Items   8.3 kB 0
phpMyAccess alpha (2.x) is NOT an upgrade to phpMyAccess 1.x!!!! DO NOT copy files from this into 
your existing phpMyAccess 1.x installation folder as they are not compatable.

phpMyAccess 1.5.x is still maintained and updated and still available here!!!

-=- 

phpMyAccess alpha is baised on the idea of being able to create and run queries from a 
mySQL database as "easy" as you can in MSAccess -- right from a web browser. 
It was also inspired by the fact that you can't edit the resulting query out put generated
by other tools (like phpMyAdmin).

phpMyAccess alpha 2.0.x was developed with php 5, and mySql 5.0.x and includes ability to edit 
fields right in place with the addition of some javascript making this AJAX enabled. 

NOTE: based on the Edit in place feature in phpMyAccess 1.5.x the Edit in place feature has some
limitations you should be aware of:
	1. It does NOT yet do any type validation checks.
	2. 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.

KNOWN ISSUE with Linked/JOINed tables:
	This version is ALPHA -- so here is how JOINED tables work for now -- it will allow queries to be
	built for joined tables ONLY when the following is true: both tables to be joined are linked on a
	field named "ID" existing in both tables.

I felt this alpha 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 application is relatively simple, roughly in order :

-  Download the install file (You probably did since you're reading this)
-  Unpack : tar xvzf phpmyaccessalpha.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
-  Configure database access
   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.

   Modify default.sql for the demo database user and password.
   Modify default.sql for the tables and fields you want to be able to create queries from in the
   table "Table_Permissions". (For the time being these must be in the same database as the
   rest of the tables in default.sql)
-  Insert the tables into the database
   example :
   mysql -u admin -p < default.sql
   NB: FOR phpMyAccess alpha (2.x) this assumes the database is called demoalpha, if that is not the case change "use demoalpha;"
	FOR phpMyAccess (1.5.x) 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 alpha 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, or whatever you setup.

Unmodified, this will give you a demo with 2 tables: Employees and Jobs that allow you to create, save, edit and run queries
in your browser, where you will also have the ability to edit the data in the resulting queries right in place.

You can add your own tables, but you will need to modify Table_Permissions with either an entry for the entire table (use NULL as field name),
or an entry for each field you want to appear in phpMyAccess alpha.
NOTE: Demo tables, Employees and Jobs are linked, and can be used in the same query only because the both have a field called "ID" that has been added in Table_Permissions. (See "KNOWN ISSUE with Linked/JOINed tables" above)

KNOWN ISSUE: The query building tool doesn't have any of the "fancy" functions that MS Access has (yet),
so the 'Criteria' and 'or' fields just except logical/mathmatical operators or text that would normally be used in 
a mySQL query -- that is you will have to restate the name of the field when doing AND/OR operations.
  example:
  mysql Query text: SELECT a FROM table WHERE a>1 AND a<100 OR a=1000
  IN phpMyAccess alpha query design view:
  Table.field: table.a
  Sort:
  Show:
  Criteria: >1 AND a<100
  or: a=1000
Source: README.TXT, updated 2012-10-22