Performing a Calculation While Submitting........

Elliott

Hello, I am still quite new to php, but me and a couple of others are using PHP for a website we are working on for our Uni project.

Heres what i have so far........

<html>
<body>

<?php

mysql_connect (localhost,elliott,password);
mysql_select_db ("quote");
mysql_query ("insert inTO main (applicant_id, firstname, surname, situation, title, dob, address, postcode, time_at_address,
 previous_address, phone, work_phone, email, contact_time, employment, occupation, contract_length, service_length, accounts,
income_2001, income_2000, income_1999, income1, income2, total_income, ccj, ccj_details, bankruptcy, arrears, details,
lender, mortgage_outstanding, property_sold, loans_outstanding, monthly_payment, loan_expires, cards, cards_outstanding,
property_price, mortgage_req, mortgage_reason, urgency, other_info)



VALUES ('$_GET[applicant_id]', '$_GET[firstname]', '$_GET[surname]', '$_GET[situation]', '$_GET[title]', '$_GET[dob]',
'$_GET[address]', '$_GET[postcode]', '$_GET[time_at_address]', '$_GET[previous_address]', '$_GET[phone]', '$_GET[work_phone]',
'$_GET[email]', '$_GET[contact_time]', '$_GET[employment]', '$_GET[occupation]', '$_GET[contract_length]',
'$_GET[service_length]', '$_GET[accounts]', '$_GET[income_2001]', '$_GET[income_2000]', '$_GET[income_1999]',
'$_GET[income1]', '$_GET[income2]', '$_GET[total_income]', '$_GET[ccj]', '$_GET[ccj_details]', '$_GET[bankruptcy]',
'$_GET[arrears]', '$_GET[details]', '$_GET[lender]', '$_GET[mortgage_outstanding]', '$_GET[property_sold]', '$_GET[loans_outstanding]',
'$_GET[monthly_payment]', '$_GET[loan_expires]', '$_GET[cards]', '$_GET[cards_outstanding]', '$_GET[property_price]', '$_GET[mortgage_req]',
'$_GET[mortgage_reason]', '$_GET[urgency]', '$_GET[other_info]')
");
mysql_close;



mysql_connect (localhost, elliott, password);
mysql_select_db ("quote");
mysql_query ("UPDATE main SET mortgage_quote='$income'*3/0.95 WHERE email='$email'");



?>

</body>
</html>

Basically we want to take the details from the form into the table "main" but the final field in the table is called mortgage_quote, and this needs a formula which uses the value from the income field.

The update is probably all wrong, but i have not much idea on how to do it, and the books i have are pretty useless for this. The WHERE email bit is to try stick it in the same row as the form details etc.

If you can help with this thankyou very much, its much appreciated.

Pig

Just run the calculation before the sql.

$var = $var * 10;

Then just use the new $var instead of your $_GET in the VALUES portion of the query.

Pig

post if that didn't make sense.

Elliott

ok i fiddles with this and also i did a really dumb thing.....
i said $income, even tho my field name was total_income (whooops)

So now the calculation works well, BUT it updates every row, so i need to know just how to make it update the current row that they r submitting to at the moment.

Sxooter

Unless you're dealing with more than one table, don't insert THEN update, just change the data in PHP before you insert it.

Elliott

ok i will try this, just i wasnt sure that the php would know the values of the form b4 it gets it.

Thanks for the help

This is mental, my heads gonna blow, gotta be handed in in 2 days

Elliott

ok i tried this, got no error but nothing appeared in the mortgage_quote field in the row of the table;

<html>
<body>

<?php

$mortgage_quote='$total_income'*3/0.95;

mysql_connect (localhost,elliott,password);
mysql_select_db ("quote");
mysql_query ("insert inTO main (applicant_id, firstname, surname, situation, title, dob, address, postcode, time_at_address,
 previous_address, phone, work_phone, email, contact_time, employment, occupation, contract_length, service_length, accounts,
income_2001, income_2000, income_1999, income1, income2, total_income, ccj, ccj_details, bankruptcy, arrears, details,
lender, mortgage_outstanding, property_sold, loans_outstanding, monthly_payment, loan_expires, cards, cards_outstanding,
property_price, mortgage_req, mortgage_reason, urgency, other_info, mortgage_quote)



VALUES ('$_GET[applicant_id]', '$_GET[firstname]', '$_GET[surname]', '$_GET[situation]', '$_GET[title]', '$_GET[dob]',
'$_GET[address]', '$_GET[postcode]', '$_GET[time_at_address]', '$_GET[previous_address]', '$_GET[phone]', '$_GET[work_phone]',
'$_GET[email]', '$_GET[contact_time]', '$_GET[employment]', '$_GET[occupation]', '$_GET[contract_length]',
'$_GET[service_length]', '$_GET[accounts]', '$_GET[income_2001]', '$_GET[income_2000]', '$_GET[income_1999]',
'$_GET[income1]', '$_GET[income2]', '$_GET[total_income]', '$_GET[ccj]', '$_GET[ccj_details]', '$_GET[bankruptcy]',
'$_GET[arrears]', '$_GET[details]', '$_GET[lender]', '$_GET[mortgage_outstanding]', '$_GET[property_sold]', '$_GET[loans_outstanding]',
'$_GET[monthly_payment]', '$_GET[loan_expires]', '$_GET[cards]', '$_GET[cards_outstanding]', '$_GET[property_price]', '$_GET[mortgage_req]',
'$_GET[mortgage_reason]', '$_GET[urgency]', '$_GET[other_info]', '$mortgage_quote')
");
mysql_close;
?>
</body>
</html>

Pig

Did you alter your table to match your new query? Is there a column named "mortgage_quote"?

Elliott

yeah theres a field named mortgage_quote in the table.

Pig

Well, that beats the hell out of me. Your SQL looks fine. I can only offer a couple more suggestions.

This shouldn't make a difference, but change this line:
$mortgage_quote='$total_income'3/0.95;
to this:
$mortgage_quote= (($total_income 3) / 0.95);

You can also check to make sure you have a integer and not a string:
if( is_int($mortgage_quote) )
{
echo("JOY, AN INTEGER!");
}
else
{
echo("not an integoer");
}

Elliott

ok thanks, tried that and its working fine.

With the code if i do the calculation b4 the SQL stuff it just leaves the mortgage_quote column blank.

But if i use an UPDATE after the INSERT statement it updates ALL the rows in the table.

What i need os something to put after the WHERE to make it update only the last(or current) row.

any idea?

Pig

yeah, check out mysql_insert_id()

just use it in your where clause to identify the row you inserted.

http://www.php.net/manual/en/function.mysql-insert-id.php

Elliott

ok i had a look and tried that, but im new to this so i dont understand it at all.

Think thats what im looking for tho.

Just seems now tho that nothing is being stored into my tabe

Pig

try running your first query, then immediately after put this:
$new_id = mysql_insert_id();
mysql_query("UPDATE main SET mortgage_quote='$mortgage_quote' WHERE id='$new_id'");