Forum Moderators: coopster

Message Too Old, No Replies

retrieving exist values changing data and upgrading again

         

Mikekie

5:45 pm on Aug 4, 2009 (gmt 0)

10+ Year Member



I am new to PHP could anyone please point me in the right direction to : alter numeric values in a Mysql data base via a form in a web page example: existing val = 20 add 4 update databse to hold new val of 24 BUT is there a way to store this and all future similar entries in a file on the data base, so that one can keep track of the total individual entries made and retrieve this info when required?
Thanks.

andrewsmd

8:32 pm on Aug 4, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



If you want to create a file on the server check out the fopen and fwrite functions. As far as connecting to a mysql database check out the php mysql functions. Start on those and post back when you run into a problem.

Mikekie

7:47 am on Aug 5, 2009 (gmt 0)

10+ Year Member



Thank you Andrew - i have successfully installed Apache, Mysql and php - all working ok. My problem is with the coding. I have three numeric fields a,b,c, the form input will read 'a' adjust by adding or subtracting, enter new val. Same for 'b' field 'c' is a running total of what happens in a and b. Is there a way I can save and store the results of this input and all future transactions, sequentially, in a file for future reference?
Also is it possible to store the forms as they come in (also for possible future reference)and download the results when required?

andrewsmd

1:30 pm on Aug 5, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I'm not really for sure on what your problem is. Post your code please and I'll take a look.