[gentoo-user] CSV or mysql table as spreadsheet-like web page
Hi, how would you go about creating a web page from either a CSV file or a table in a mysql database which presents the data to a user and lets them edit some of the data, preferably with the ability to use formulas like you can in a spreadsheet to do some calculations on the fly? Once editing the data is finished, it should all be saved to a table in a database or as a CSV file. Is there some php script or the like which can do this or get me started?
Re: [gentoo-user] CSV or mysql table as spreadsheet-like web page
On Mar 24, 2015, at 17:21, hw h...@gartencenter-vaehning.de wrote: Hi, how would you go about creating a web page from either a CSV file or a table in a mysql database which presents the data to a user and lets them edit some of the data, preferably with the ability to use formulas like you can in a spreadsheet to do some calculations on the fly? A php script that does that kind of table drawing is really easy :) Editing the content is harder... You have to think how you wan't to do it. Htlm has its limitations :/ Once editing the data is finished, it should all be saved to a table in a database or as a CSV file. Design it so that you know for certain which cells the user has edited so you don't need to overwrite the entire table even if the table has changed in between. Many things depend on the size of your table. Raw non-relational database is really easy to interface even with html. Excel can do a table with 2^16 rows and few hundred columns. With mysql you can easily do like a million rows :) design the database so that it has a separate value for the user typed cell content and another for the displayable result of the content. Is there some php script or the like which can do this or get me started? Well i would never use HTML for real work, it is for free-time (facebook etc). Qt has has a really good frontend for working with mysql table. It is fast and supports getting rows asynchronously in the background and in the specified range. With a qt frontend the gui looks much better and unified than with a web-browser. -- -Matti
Re: [gentoo-user] CSV or mysql table as spreadsheet-like web page
Hi There seems to be open source solutions already available : http://en.wikipedia.org/wiki/Online_spreadsheet I don't like to reinvent the wheel, but they may be too complex for your need. Tell us what you choose or build yourself Mickaël 2015-03-24 16:21 GMT+01:00 hw h...@gartencenter-vaehning.de: Hi, how would you go about creating a web page from either a CSV file or a table in a mysql database which presents the data to a user and lets them edit some of the data, preferably with the ability to use formulas like you can in a spreadsheet to do some calculations on the fly? Once editing the data is finished, it should all be saved to a table in a database or as a CSV file. Is there some php script or the like which can do this or get me started?
Re: [gentoo-user] CSV or mysql table as spreadsheet-like web page
On Tue, 24 Mar 2015 12:44:02 -0400, Michael Orlitzky wrote: how would you go about creating a web page from either a CSV file or a table in a mysql database which presents the data to a user and lets them edit some of the data, preferably with the ability to use formulas like you can in a spreadsheet to do some calculations on the fly? Once editing the data is finished, it should all be saved to a table in a database or as a CSV file. Is there some php script or the like which can do this or get me started? The lazy solution: phpMyAdmin. The *really* lazy solution, Google Docs. you can create a spreadsheet and that export the HTML needed to allow input from a web page. -- Neil Bothwick WinErr 01E: Timing error - Please wait. And wait. And wait. And wait. pgpsb7Hqo7svQ.pgp Description: OpenPGP digital signature
Re: [gentoo-user] CSV or mysql table as spreadsheet-like web page
On 03/24/2015 11:21 AM, hw wrote: Hi, how would you go about creating a web page from either a CSV file or a table in a mysql database which presents the data to a user and lets them edit some of the data, preferably with the ability to use formulas like you can in a spreadsheet to do some calculations on the fly? Once editing the data is finished, it should all be saved to a table in a database or as a CSV file. Is there some php script or the like which can do this or get me started? The lazy solution: phpMyAdmin.