From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) by finch.gentoo.org (Postfix) with ESMTP id 403DA138CC5 for ; Tue, 24 Mar 2015 16:30:11 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 7D789E0944; Tue, 24 Mar 2015 16:30:05 +0000 (UTC) Received: from lyseo.edu.ouka.fi (unknown [82.128.138.2]) by pigeon.gentoo.org (Postfix) with ESMTP id 43BEAE090F for ; Tue, 24 Mar 2015 16:30:04 +0000 (UTC) Received: from [100.81.170.153] (85-76-81-168-nat.elisa-mobile.fi [85.76.81.168]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by lyseo.edu.ouka.fi (Postfix) with ESMTPSA id 4237C13F3459 for ; Tue, 24 Mar 2015 18:29:42 +0200 (EET) Subject: Re: [gentoo-user] CSV or mysql table as spreadsheet-like web page References: <551180F3.8010707@gartencenter-vaehning.de> From: Matti Nykyri Content-Type: text/plain; charset=us-ascii X-Mailer: iPhone Mail (11D201) In-Reply-To: <551180F3.8010707@gartencenter-vaehning.de> Message-Id: <3A084D9E-4D91-4FAD-9F93-D966FBE5CFB3@iki.fi> Date: Tue, 24 Mar 2015 18:29:43 +0200 To: "gentoo-user@lists.gentoo.org" Content-Transfer-Encoding: quoted-printable Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org Mime-Version: 1.0 (1.0) X-Archives-Salt: ca4e951d-20b5-49c3-8b5d-fbac56707810 X-Archives-Hash: d4e8b79c7d82fda7904186c578cdf5fe > On Mar 24, 2015, at 17:21, hw wrote: >=20 > Hi, >=20 > how would you go about creating a web page from either a CSV file or a tab= le in a mysql database which presents the data to a user and lets them edit s= ome 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 t= he content is harder... You have to think how you wan't to do it. Htlm has i= ts limitations :/ > Once editing the data is finished, it should all be saved to a table in a d= atabase or as a CSV file. Design it so that you know for certain which cells the user has edited so yo= u don't need to overwrite the entire table even if the table has changed in b= etween. 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 row= s 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 cel= l 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 fas= t and supports getting rows asynchronously in the background and in the spec= ified range. With a qt frontend the gui looks much better and unified than w= ith a web-browser. --=20 -Matti=