In Progress

PHP/MYSQL/AJAX Data Grid

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.

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

Example CSS/Style and code added. The output should include a CSS that looks similar to this example.

Update..

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

The Missing Files have been added to the Project Clarification Board. Rgds

Okay SQL files should be available view project board...
Cant upload files ending in Zip or SQL...hmmm

Skills: AJAX, MySQL, PHP

See more: ajax php grid, grid php mysql ajax open source, grid ajax php mysql, set data, remote html css, php style, php ajax sql, html spreadsheet example, html form to spreadsheet, how to create php form, how to create a php application, how create form in php, spreadsheet grid php mysql, numbers grid ajax mysql, ajax php grid mysql, php mysql grid, php mysql ajax data, php ajax spreadsheet grid, ajax crosstab grid, ajax data grid using php, mysql ajax grid, grid php mysql ajax, data grid ajax php, php ajax spreadsheet, ajax php mysql grid

About the Employer:
( 1 review ) London, United Kingdom

Project ID: #698193

Awarded to:

programer22

The solution is YUI this is done there already I could set up php / javascript interface for this if curious check my portfolio [url removed, login to view]

$120 USD in 2 days
(3 Reviews)
1.0

22 freelancers are bidding on average $178 for this job

soner

I can offer my high quality programming services to you. Please contact if interested. I'm js/php expert.

$400 USD in 0 days
(118 Reviews)
7.9
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$225 USD in 5 days
(232 Reviews)
7.8
rockerstech

Hey ! i am ready to do

$140 USD in 5 days
(80 Reviews)
7.7
CrossBiz

Please view PMB

$400 USD in 7 days
(60 Reviews)
7.4
saivisiontech

Dear Sir having Highly Experts. check the PMB for our skilled work. We are fully confident to execute your project efficiently within the given deadline and would consider it an explicit opportunity to work with y More

$100 USD in 4 days
(23 Reviews)
6.7
arnab0143

-- Please check your pm. Thanks. --

$50 USD in 4 days
(70 Reviews)
6.6
h114

Please have a look at the PMB.

$150 USD in 5 days
(22 Reviews)
6.0
infoisoft

Dear Sir, SERIOUS BIDDER. Please check PM. Regards, Jainam Shah, iSoft Solutions.

$150 USD in 5 days
(29 Reviews)
5.8
ArtyCreateStudio

Hello, we are interested. Please check your PMB. Thank you.

$360 USD in 3 days
(3 Reviews)
4.9
YashpalSingh123

php/mysql/ajax professional, ready to start

$200 USD in 4 days
(11 Reviews)
4.8
wisemove123

please check pm

$150 USD in 5 days
(6 Reviews)
3.5
A1bert

I would like to do this job. Please provide me more details. Thanks

$150 USD in 4 days
(2 Reviews)
3.1
puneIT

Please check pmb

$130 USD in 3 days
(3 Reviews)
2.5
jeegsh

Ready to work anytime.

$100 USD in 3 days
(5 Reviews)
2.7
phptechselva

Having 5+ years of experience web development. Looks forward to work with you.

$60 USD in 2 days
(1 Review)
1.4
frankdan

[url removed, login to view]

$175 USD in 10 days
(0 Reviews)
0.0
rekhasingh

Greetings Employer! Lets start your project tasks to finish it! Please check PMB for review our work experience. Thanks & Regards, Ms. Rekha Singh from BLI Team

$125 USD in 5 days
(0 Reviews)
0.0
chinaaccessivy

ready to work

$100 USD in 4 days
(0 Reviews)
0.0
hgoyal

Respected Client This is Himanshi from Tri-Force Consulting Services. I am PHP developer and have 3 yrs of experience and also have a well experience team and we have worked on the project related to it and we are a More

$220 USD in 12 days
(0 Reviews)
0.0
alihsyed23

we are group of expert people in ajax php javascript joomla css html. you can expect quality and timley work from us. thank you.

$200 USD in 0 days
(0 Reviews)
0.0