PHP/MYSQL/AJAX Data Grid

IN PROGRESS
Bids
22
Avg Bid (USD)
$178
Project Budget (USD)
$30 - $250

Project Description:
We are looking for a PHP Module to create a crosstab/XY Data Grid editable data form, from a mysql data set.

The module/form will provide the ability for simple data ( strings, numbers, enumerated types ), to be presented in a spreadsheet format, edited, and saved.
eg
Col1 Col2 Col3
Row1 Value1 Value2 Value3
Row2 Value4 Value5 Value6
Row3 Value7 Value8 Value9

The application will call the module using a simple interface, for example
sql => ' select row_id, row_value, column_id, column_value, cell_id, cell_value from dataset'
row_id_field => 'row_id'
row_value_field => 'row_value'
col_id_field => 'column_id'
column_value_field => 'column_value'
cell_id => 'cell_id'
cell_value => 'cell_value'

Data will be presented in a Grid, using an AJAX component. Where possible the solution should re-use an open source Ajax component.
The Solution should be able to support up to 1000 rows and 1000 columns, and hence support selective/subset data fetching and managing.

The component/resulting HTML output will support CSS, and the solution must demonstrate how to use CSS to present the output. An example CSS/html style will be provided which the solution must demonstrate.

Three remote example data sets will be provided and used to confirm successful delivery.

Additional Project Description:
05/29/2010 at 9:06 BST
I have added the three examples/test cases, and test data for the project. It should provide some additional clarity.

I have also hi-lighted an Additional test/slight increase which has resulted from further discussions. This clarifies how the module should potentially cope with grouped columns and grouped headings. eg.
sql => ' select row_id, row_value, row_group, column_id, column_value, column_group, cell_id, cell_value from dataset'
row_id_field => 'row_id'
row_value_field => 'row_group, row_value'
col_id_field => 'column_id'
column_value_field => 'column_group, column_value'
cell_id => 'cell_id'
cell_value => 'cell_value'

Ive added this as Example 3a in the examples provided, and ask bidders to include this in their bids or clarify if this is included in their PM's

Many Thanks
Any Questions please PM


05/29/2010 at 10:26 BST
Example CSS/Style and code added. The output should include a CSS that looks similar to this example.

05/31/2010 at 16:08 BST
Update..

The Missing files Issue is with Freelancer.com and being dealt with. I will find/post the files somehow.
;-)


05/31/2010 at 16:24 BST
The Missing Files have been added to the Project Clarification Board. Rgds

05/31/2010 at 21:03 BST
Okay SQL files should be available view project board...
Cant upload files ending in Zip or SQL...hmmm

Skills required:
AJAX, MySQL, PHP
Additional Files: examples.txt example.sql example.sql.zip ExampleCSS.zip
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire soner
$ 400
in 0 days
$ 225
in 5 days
$ 140
in 5 days
$ 400
in 7 days
$ 100
in 4 days
$ 50
in 4 days
$ 150
in 5 days
$ 150
in 5 days
Hire ArtyCreateStudio
$ 360
in 3 days
Hire YashpalSingh123
$ 200
in 4 days