Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

How to update database from a datagrid style form.

Hi experts,

http://www.fobgfc.org/sq1a.php

My problem here is how to update the database via the save button (which currently does nothing).  Of course data may have been changed on other pages which will need writing to the db.  I could save each page as loads of session variables, but apparently this isn't the most secure method? and with telephone numbers I need to be careful.

The pagination is done by a package which I am reluctant to tamper with, so updating every time I move page isn't an option.

On the real db there would be about 500 rows.

Thanks and regards,

    Colin
0
colinspurs
Asked:
colinspurs
  • 3
1 Solution
 
zazagorCommented:
Hi,
What kind of database are you using?
Try adding an action to the savebutton which loads a "save-to-database.php" file.

//zaZagor
0
 
colinspursAuthor Commented:
mysql

My problem is keeping track of all the fields.
0
 
colinspursAuthor Commented:
Any help please?

How is this usually done?

Ta,

   Col
0
 
colinspursAuthor Commented:
I didn't realise I don't need to keep track of all the changes between pages. I am going the jeditable/datatables route.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now