[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • 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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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