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 : | password : demo). The new app should be capable of creating any such web applications in it as mentioned in example.
It will be similar to MS Access or a small version of Oracle in which anyone who does not know much programming can also create database centered 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, search box, etc... 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 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 & 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 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 phone, answer emails quickly and provide work status report every 3 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.