online table for input?

Looking for volunteers to join your project? Need help with a script but can't afford to pay? Want to offer your services as a volunteer to build up your portfolio? This is the place for you...

Moderator: General Moderators

Post Reply
toshesh
Forum Commoner
Posts: 33
Joined: Thu Jun 19, 2003 9:32 pm

online table for input?

Post 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.
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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.
leoden
Forum Newbie
Posts: 21
Joined: Sat May 24, 2003 8:48 pm

Post 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
toshesh
Forum Commoner
Posts: 33
Joined: Thu Jun 19, 2003 9:32 pm

Post 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.
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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.
toshesh
Forum Commoner
Posts: 33
Joined: Thu Jun 19, 2003 9:32 pm

Post 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.
Post Reply