My migration of my Access databases to mysql has started. I've got mysql, PHP and apache up and running and I've imported the data from my Access database. I can see it all in phpMyAdmin, most impressive!
Now I need to be able to design/build replacements for the Access data input forms and the Access reports.
Starting at the input end (seems reasonable!), has anyone got any recommendations for designing input forms for mysql databases? Searching Google isn't very helpful because as soon as you enter 'mysql forms PHP' (with or without the 'PHP' actually) you get zillions of hits on HTML forms for entering data via PHP into a mysql database.
The problem is that this gives a rather backwards approach which assumes a 'typical' HTML form and that's not what I want really. For data entry it doesn't really even have to be a web form.
What I'm after is essentially a view of my table with some calculations/filters between data entry and the database. I.e. when the 'form' is opened it loads up the whole database table and presents it on screen in tabular fashion. I can edit existing entries simply by moving to them and changing them, I can add entries at the end. Most fields simply get inserted unchanged in the database as I type them but some fields are automatically calculated and inserted when I enter/change other fields in the same row.
This is what I've done in Access and I want to do something similar for the mysql database if I can, preferably with some sort of tool to help me! It's the sort of thing Oracle Forms does too. Surely someone must be doing it for mysql.
The phpMyAdmin 'Browse' window looks somewhat like what I'm after but I need to be able to edit the data in place (I.e. move to the field and change it), add rows at the end and have 'auto calculated' values.