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.
online table for input?
Moderator: General Moderators
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.
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.
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
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
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.
Platform is multi-based but the pg runs on linux so I guess w32 stuff won't work.
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.
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.