Page 1 of 1

online table for input?

Posted: Mon Nov 03, 2003 7:44 am
by toshesh
I have no idea how to do this so any help is appreciated.

I want to create a table (web based) to enter values like excel and press send to update some database. I'm running PHP but so far had no luck. Could anyone tell how to do this? Thank you.

Also anyone know how to run a php or perl program to run on a regular basis automatically on a linux server? Like specify which day of the week to run the script.

Posted: Mon Nov 03, 2003 9:42 am
by JAM
How much experience do you have writing <form>'s in html? You can 'simulate' excel cells using input type="text"-fields.

For live calculations (as excel works) you require javascript. (Example; sum cell1 & cell2 to cell3)

Main question, what database are you currently using? Flatfile one (like Access) or 'real' (like MySql, MsSql, Postg.)?

Automating scripts; http://www.phpfreaks.com/tutorials/28/0.php could be interesting if you need want to learn. There are cron-ports for the win32 platform also if needed.

Posted: Mon Nov 03, 2003 11:43 am
by leoden
TRANSLATION : you have alot of coding ahead!

If you're starting out visit somewhere like http://www.evilwalrus.com or http://www.hotscripts.com for tutorials on database connectivity.

The basic premise for what you're trying to do is

HTML form with text boxes you specify i.e. Name , Address , Email
and a submit button to POST the information to the server.

Then a php page that that checks the contents of the POSTED textboxes and if valid, whacks them in a simple INSERT statement into your database.

There are loads of tutorials out there so find out the basics, give it a whirl and if you encounter problems ask for help!

Good Luck

Posted: Mon Nov 03, 2003 5:55 pm
by toshesh
Thank you both for replying. Currently I'm using postgre 7.2(maybe 3) for database. I have basic understanding of connecting to databases and entering values and stuff. My main topic is creating an online "table" like entry sheet. real time display would be nice but I'm not going to ask too much. Just having a table to enter data and sending it would be nice.

Platform is multi-based but the pg runs on linux so I guess w32 stuff won't work.

Posted: Tue Nov 04, 2003 2:40 pm
by JAM
I might be able to get you started, if you indeed are prepared to get help rather than get a solution, if you still need help, and noone else is interested.

Mail me a draft and/or what you think would be of interest, and we can take it from there.

Posted: Fri Nov 07, 2003 12:20 am
by toshesh
Hello JAM, sorry for the late reply.

What I am trying to do is to create an internal website displaying data from a database. The website should act as an "interface" to the database. A user should be able to insert new data, modify existing data and delete data if necessary. But the main feature is to have an excel like spreadsheet to achieve all this. Any starting point would be very appreciated.