Skip to main content
J
Jonathan_Fortis
Inspiring
March 26, 2012
Question

equations using php and / or javascript

  • March 26, 2012
  • 1 reply
  • 1950 views

i have a excel spreadsheet that has a basic - input one amount in column A then it adds column A to Column C to give Col D results. Well thats the rough idea.,

to basically a field comes from a mysql database then need to start the equation ( the field from the DB would be COL A)

what is the best way to do this?

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
March 26, 2012

If the user is simply going to enter a single value and get the results, I would use php. If it's going to be more interactive - like they may try lots of different values, then javascript will provide a better user experience.

J
Jonathan_FortisAuthor
Inspiring
March 26, 2012

ok it is basically one amount coming from the DB and a fixed equation. What do i need to do to get going on this? are there any good tutorials out there?

J
Jonathan_FortisAuthor
Inspiring
March 27, 2012

>>I'm not following you. These are calculated values. Why do you need to send them to the database?

>ok once the option is selected this figures need to be stored so they can be retrieved on the next page so as to make payment?

Store the selected option in a session variable. Then do the calculations on the payment page. You can then store the options they select in the database when the payment is made. But you almost never want to store calculated values in the database.


>Store the selected option in a session variable. Then do the calculations on the payment page. You can then store the options they select in the database when the payment is made. But you almost never want to store calculated values in the database.

Again this is what i dont know how to do, i dont know what goes where

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices