I want a php & mysql automated code generator web application in which anyone who does not know programming can also create customized database centric php web applications which can be run online and offline also with help of wamp/xampp. For example you can see [url removed, login to view] or [url removed, login to view] (user type : Data entry user | user name : demo [url removed, login to view] | password : demo). The new app should be capable of creating any such web applications inside it as mentioned in example. With the new app anyone can easily create his own Library Management system or School Management system or Billing management system or any customized web based application which will run on php & [url removed, login to view] will be similar to MS Access or a small version of Oracle in which anyone who does not know programming can also create database centered web applications.
User can define his own tables, fields, field types, primary key, relationship between various tables and fields, default field sort order , formula to calculate value of any field in the same way we do in ms excel ,or ms access,etc... The application will have inbuilt search & sort functions with which user can search any string or value in any or all fields and sort in ascending or descending order by any column or field. User can also upload photos and link to videos. When user will create a field in a table he will have to specify the field data type from a list as specified in my sql - varchar, tinyint, text, date, smallint, mediumint, int, bigint, float, double, etc...
Users will also be able to create their account. Account can be of 5 types - 1) Data view user - can only view values posted by other users. 2) Data entry user - can view values posted by other users as well as post their own values and edit them in future. 3)Power user - can do functions of Data view & Data entry user as well as edit/delete values posted by other users 4) Administrator - can do functions of Data view, Data entry & Power users as well as specify default sorting order, edit/delete/create user accounts & manage user rights. 5) Super admin - can do functions of previous 4 as well as create new tables, forms, fields, specify relationship between various tables & fields. Specify primary keys, field type, formula, etc... Various users can also chat among themselves.
This app will also have manual & automatic synchronization feature to synchronize offline work data on online server and Vice a versa. If user has selected automatic synchronization feature then system will automatically update older values with newer values and if manual it will occur only when user presses synchronize button.
Programmer must be available on voice chat & screen sharing programs like skype at least for 4-5 hours in day time (10 am - 8 pm GMT +5:30 IST). Should be easily reachable by mobile phone, answer emails quickly and provide work status report every 2 days. Programmer must only work on my project until completed successfully and should not be working in any other company part time or full time. If u complete this project successfully I have loads of more projects every month.
Application interface can be similar to ms access.