Link to home
Start Free TrialLog in
Avatar of udsfsg
udsfsgFlag for United States of America

asked on

Is there a way to update a row in an HTML table without having to query a database?

Hello all,
I have been working with an excel speadsheet to track moving items from 1 remote location to another location. This is a 2 person task, basically, the person at 1 location, notates the spreadsheet when they ship an item, and the second person notates the spreadsheet when they receive the item. This process works fine, however, being the ever perfectionist I am, I am wondering if there is a way to web-erize this process. :)

Basically what I would like to do if create a table in html, and populate this table with rows for every week in the year. Now the items that are shipped are based on a specific date, so their would be a column notated that date. Then there would be several columns that would have user input. (where the 2 workers update the date sent, and date received.) - There would also be 1 additional column to indicate any comments for the shipment.
User generated image
My 1st question - Is there a way to do this using php, without having to create a database, or is it possible to use something like jquery or ajax to fill each row as the change is made, using a button as a confirmation/acknowledgment? if not - does anyone have any tips or suggestions on how to accomplish this?

2nd Question - Is it possible that when a row is updated, this script could send a quick generated email letting the other party know that the item has been acknowledged?

3rd Question - Would this script be able to archive data saved at the end of the year?

So - These questions are obviously progressive in nature.
Thank you all for your time, and help!
Chris
SOLUTION
Avatar of ollyatstithians
ollyatstithians
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Do you have a separate spreadsheet for each item?
If so, it would be worth adding columns for an item id and a location id and removing your return columns to reduce duplication.
Avatar of udsfsg

ASKER

no, I create a new spreadsheet once a year, and just keep to old spreadsheet for an additional year before deleting it.

I had begun exploring something like flexigrid as a possible solution -  http://code.google.com/p/flexigrid/

however, the combination of fixed static fields and dynamic updating fields seems to ever complicate this.
This is what lead me to reach out to the community to see if anyone else had tried to do something like this before.
Avatar of udsfsg

ASKER

I don't mind doing it in a db, I was thinking it might be an easier coding project if it wasn't, since I don't really wanna keep this information permanently.
Avatar of udsfsg

ASKER

Here's a related question - Has anyone successfully embedded a working excel 2010 spreadsheet into a php page?
If yes - How did you do it?
Why not just use GoogleDocs?
Avatar of udsfsg

ASKER

this is internal, on our intranet.
Avatar of udsfsg

ASKER

I almost thought I could do this with a spry dataset, but it doesn't appear that you can edit the entries. :(
Avatar of leakim971
My 1st question - Is there a way to do this using php, without having to create a database, or is it possible to use something like jquery or ajax to fill each row as the change is made, using a button as a confirmation/acknowledgment? if not - does anyone have any tips or suggestions on how to accomplish this?

Check this page : http://www.sqlite.org/serverless.html
Main page of course: http://www.sqlite.org/

>2nd Question - Is it possible that when a row is updated, this script could send a quick generated email letting the other party know that the item has been acknowledged?
Using ajax you can send silently the content of the mail to the php server as @ollyatstithians suggested it

>3 - You possibly wouldn't need to archive anything, as it would already be stored in a database. You might want to look at backing up the data though.
If you don't want to use sqlite for example you can store all the data in a CSV file but it's a bad idea

>Here's a related question - Has anyone successfully embedded a working excel 2010 spreadsheet into a php page?
Not me, but have a look here : http://phpexcel.codeplex.com/
Avatar of udsfsg

ASKER

HI leak. I actually have mysql, I was simply asking if their was an easier way then developing all the tables etc. (more like iterate the rows & columns, and store it text based.) I've since just created all the tables.. It seems it was quicker then I thought.. ;)

I've played with all the examples from phpexcel, and I cannot seem to get it to actually show anything. It creates the spreadsheet based on the inputs, but doesn't show it inline on the page..  In first reading about this, I get the feeling its supposed to read the excel page into memory and print it on the page, however, I don't see it actually doing this..
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of udsfsg

ASKER

Thanks guys, I think the combination of php code, mysql backend and datatables jquery will fit the bill! Much appreciate the suggestions.