Success

Notes

Error

 
 
 
 
Budget

3,000 - 6,000

Posted on

2014-05-27 08:34:34.0

Buyer:

IRI***

This project has expired

Why don't you register anyway? We are sure that you will find many similar projects out of the thousands waiting for you!

Post similar project now

Description

We are currently working on a project based on create an user interfaces for our current system of data adquisition. The deliver only affect front-end and backend but not database design.

For the administration part we need a generic table editor in AJAX in order to allow the admins to edit some kinds of informations (company information, users, etc...).

To make it generic the table editor must have an external php file with an array of arrays with definition of tables to edit. A table definition must contain this elements: [0] = Recovery information statement (can be a select or a procedure call). [1] = Upsert information statement with parametrized pass of values of the fields ($1 for field1, $2 for field 2, etc...) [2] = Optional. A comma separated list with locked fields that the user can't modify.

A sample of this can be: $editable = array   (   array("SELECT user,name FROM users", "UPDATE users SET name='$2' WHERE user='$1'","1"),   array("SELECT company,address,fiscaID FROM companies", "UPDATE companie SET address='$2' WHERE company='$1'","1,3")   );

Front-end must use Metronic responsive admin dashboard template.  http://www.keenthemes.com/preview/index.php?theme=metronic_admin&page=index.html