Looking for a web form creating application for sqlite or mysql

[Colin Law]

On 4 October 2011 22:32, Chris G <cl at isbd.net> wrote:
> I want to create some data entry forms for use on web pages to enter
> data into an sqlite database.  I could also easily enough migrate to a
> mySql database.
>
> It only needs to be very basic, I want it to provide a form that will
> simply allow entry of data in a format on the screen that reflects the
> columns and rows of the database.
>
> I.e. if the database has, say, five columns I want a form that looks
> something like:-
>
>    Col1Row1    Col2Row1        Col3Row1        Col4Row1        Col5Row1
>    Col1Row2    Col2Row2        Col3Row2        Col4Row2        Col5Row2
>    Col1Row3    Col2Row3        Col3Row3        Col4Row3        Col5Row3
>    Col1Row4    Col2Row4        Col3Row4        Col4Row4        Col5Row4
>    Col1Row5    Col2Row5        Col3Row5        Col4Row5        Col5Row5
>    Col1Row6    Col2Row6        Col3Row6        Col4Row6        Col5Row6
>    New Data    New Data        New Data        New Data        New Data
>
> Obviously there will need to be some customisation/configuration but if
> I can effectively define what is shown by specifying the database
> columns as I want then that should be it.

If this is more than a once in a lifetime requirement then have a look
at Ruby on Rails.  Someone with a small amount of experience in RoR
would knock up an app like that in about 10 minutes.  Also if you
suspect that this will actually turn out to be something that will be
developed and extended then definitely look ar RoR, the initial
learning time will be repaid many many times over.  There is a good
tutorial at railstutorial.org (free to use online) that you could look
at to get a feel for what it is all about.

Colin

>
> --
> Chris Green
>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
>



-- 
gplus.to/clanlaw