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?

B
bregent
Participating Frequently
March 27, 2012

ok i am going to look at this so the variable would be for example

$monthly = $sql_row["montly_rent"];

$deposit = $monthly * 4

$payable=$monthly *52

>Assuming you have already retrieved the SQL record

you mean the $D record from the database?

so i need to know what goes where. I was going to get  all these variable names into a form to that can be sent off to the DB in order to get the correct figures for the next page.




>you mean the $D record from the database?

Yes

>so i need to know what goes where.

I thought I just showed you?

>I was going to get  all these variable names into a form to that

>can be sent off to the DB in order to get the correct figures for the next page.

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

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