Web Design Forums

2Dfruit · 29-10-2006, 14:23

i have a mortgage calculator from site but can't get it to work. any ideas.
I've set the permissons to 755 on all files and the folder.

here's the table with some code:

Code:

<?
/*
TigerTom's Loan & Mortgage Calculator (TTLoanCalc)

http://www.tigertom.com
http://www.ttfreeware.com

Copyright (c) 2005 T. O' Donnell
Developed for TigerTom by Jon K.

Released under the GNU General Public License, with the
following proviso: 

That the HTML of hyperlinks to the authors' websites
this software generates shall remain intact and unaltered, 
in any version of this software you make.
 
If this is not strictly adhered to, your licence shall be 
rendered null, void and invalid.
*/

// Remove bad input

$year = eregi_replace ("\)|\(|src|\[|\]|script|<|>|\"|\'|;|&", "", $year);
$downpayment_percent = eregi_replace ("\)|\(|src|\[|\]|script|<|>|\"|\'|;|&", "", $downpayment_percent);
$loan = eregi_replace ("\)|\(|src|\[|\]|script|<|>|\"|\'|;|&", "", $loan);
$interest_rate = eregi_replace ("\)|\(|src|\[|\]|script|<|>|\"|\'|;|&", "", $interest_rate);

	$s = $currency;

	// Show form only if there is no action
	if ($action!="Calculate") {
		print "<html>\n";
		print "<head><TITLE>Mortgage Calculator</TITLE>\n";
		print "<link href=loan.css rel=stylesheet type=text/css />\n";
		print "</head>\n";
		print "<form>\n";
		print "<table cellpadding=2 width=300 border=0 ALIGN=center>\n";
		print "<tr align=center><td colspan=2><b>Mortgage Information</b></td></tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Sale Price of Home</td>\n";
		print "<td class=finput><input type=text name=loan size=7></td>\n";
		print "</tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Percentage Down, %</td>\n";
		print "<td class=finput><input type=text name=downpayment_percent size=7></td>\n";
		print "</tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Length of mortgage, years</td>\n";
		print "<td class=finput><input type=text name=year size=7></td>\n";
		print "</tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Interest rate, %</td>\n";
		print "<td class=finput><input type=text name=interest_rate size=4></td>\n";
		print "</tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Currency</td>\n";
		print "<td class=finput>\n";
		print "<select name=currency>\n";
		print "<option value=$>$</option>\n";
		print "<option value=&euro;>&euro;</option>\n";
		print "<option value=&pound;>&pound;</option>\n";
		print "</td>\n";
		print "</tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Show amortization</td>\n";
		print "<td class=finput><input type=checkbox name=amortization></td>\n";
		print "</tr>\n";

		print "<input type=hidden name=periodicity value=12>\n";
		print "<tr><td colspan=2 align=center><input type=submit value=Calculate name=action></td></tr>\n";
		print "</table>\n";
		print "</html>\n";
		print "</form>\n";
		print "<center>";
		footer();
		print "</center>";
		exit;
	}

	// Only perform calculation and show tables if user
	// click calculate button
	include "math.php";
?>

<html>
<head>
<link href="loan.css" rel="stylesheet" type="text/css" />
</head>
<table cellpadding="2" cellspacing="0" border="0" width="100%">
<tr>
	<td colspan=2 class=header>Mortgage Payment Report</td>
</tr>
<tr class=top>
	<td align="right">Down Payment:</td>
	<td><b>
	<? print $s.$downpayment; ?>
	</b></td>
</tr>
<tr class=top>
	<td align="right">Amount Financed:</td>
	<td><b>
	<? print $s.$loan; ?>
	</b></td>
</tr>
<tr class=top>
	<td align="right">Length:</td>
	<td><b>
	<? print "$year years"; ?>
	</b></td>
</tr>
<tr class=top>
	<td align="right">Annual interest:</td>
	<td><b>
	<? print $interest_rate; ?> %
	</b></td>
</tr>
<tr class=toptotal>
	<td align="right">Monthly Payment:</td>
	<td><b>
	<? print $s.$periodic_payment; ?>
	</b><br>(excluding tax and insurance)</td>
</tr>
</table>

<!--
	This is the Totals table
--!>

<table cellpadding="5" cellspacing="0" border="1" width="100%">
<tr class=total1>
	<td colspan="4">Totals</td>
</tr>
<tr class=total2>
	<td>&nbsp;</td>
	<td colspan="3">
		Outgoings: <B><? print $s.$total_paid; ?></B> paid out.<br>
		<? print $s.$total_interest; ?> paid in <b>interest</b>.<br>
		<? print $s.$loan; ?> paid towards <b>principal</b>.<br>
	</td>
</tr>

<!--
	This is the Amortization table
--!>

<?
	if (!$amortization) {
		footer();
		exit;
	}
?>

<tr class=aheader>
	<td colspan="4">Amortization</td>
</tr>
<tr class=aheader align=right>
	<td>Month</td>
	<td>Interest Paid</td>
	<td>Principal Paid</td>
	<td>Balance Outstanding</td>
</tr>

<?
	$yr = 0;
	for ($i=0; $i<$year*12; $i++) {
		print "<tr class=acontent>\n";
		print "<td>".(($i%12)+1)."</td>\n";
		print "<td>$s$periodic_interest[$i]</td>\n";
		print "<td>$s$periodic_principal[$i]</td>\n";
		print "<td>$s$balance[$i]</td>\n";
		print "</tr>\n";

		if ($i%12==11) {
			$ytotal = $yinterest[$yr] + $yprincipal[$yr];

			print "<tr class=total1>\n";
			print "<td colspan=4>Totals for year ".($yr+1)."</td>\n";
			print "</tr>\n";
			print "<tr class=total2>\n";
			print "<td>&nbsp;</td>\n";
			print "<td colspan=3>\n";
			print "Outgoings: <B>$s$ytotal</B> paid out in year ".($yr+1).".<br>\n";
			print "$s$yinterest[$yr] paid in <b>interest</b>.<br>\n";
			print "$s$yprincipal[$yr] paid towards <b>principal</b>.<br>\n";
			print "</td>\n";
			print "</tr>\n";

			if ($yr != $year-1) {
				print "<tr class=aheader align=right>\n";
				print "<td>Month</td>\n";
				print "<td>Interest Paid</td>\n";
				print "<td>Principal Paid</td>\n";
				print "<td>Balance Outstanding</td>\n";
				print "</tr>\n";
			}

			$yr++;
		}
	}

	footer();
	
	function footer()
	{
		print "<BR><BR><tr class=total2><td colspan=4 align=center>\n";
		print "<!--// Altering the following HTML code in any way invalidates your licence to use this software --><FONT SIZE=\"1\"><a href=\"http://www.ttfreeware.com\">TTLoanCalc</a> by Jon K. for <a href=\"http://www.tigertom.com\">TigerTom</a></FONT>\n";
		print "</td></tr>\n";
	}
?>

here's the math.php include

Code:

<?
/*
TigerTom's Loan & Mortgage Calculator (TTLoanCalc) 

Version 1.1

http://www.tigertom.com
http://www.ttfreeware.com

Copyright (c) 2005 T. O' Donnell
Developed for TigerTom by Jon K.

Released under the GNU General Public License, with the
following proviso: 

That the HTML of hyperlinks to the authors' websites
this software generates shall remain intact and unaltered, 
in any version of this software you make.
 
If this is not strictly adhered to, your licence shall be 
rendered null, void and invalid.
*/

	
	$downpayment = $downpayment_percent / 100 * $loan;
	$downpayment = number_format($downpayment, 2, '.', '');
	$interest_rate = number_format($interest_rate, 2, '.', '');

	$loan = (1-$downpayment_percent/100)*$loan;
	$loan = number_format($loan, 2, '.', '');
	
	$periodic_payment = ($loan*$interest_rate/100)/($periodicity*(1-pow(1+($interest_rate/100)/$periodicity, -$year*$periodicity)));
//	$periodic_payment = $loan * (($interest/12) / (1-pow((1+$interest/12), (-$year*12))));
	$total_paid = $periodic_payment * $year * $periodicity;
	$total_interest = $total_paid - $loan;
	
	$amount_left = $loan;
	$year_interest = $year_principal = 0;
	$periodic_interest = array();
	$periodic_principal = array();
	$balance = array();
	$yinterest = array();
	$yprincipal = array();
	$j = 0;

	for ($i=0; $i<$year*$periodicity; $i++) {
		$periodic_interest[$i] = $amount_left * ($interest_rate/100) / $periodicity;
		$periodic_principal[$i] = $periodic_payment - $periodic_interest[$i];
		$amount_left -= $periodic_principal[$i];
		$balance[$i] = $amount_left;

//		print "[$i] $periodic_interest[$i]\t$periodic_principal[$i]\t$balance[$i]\n";
		$year_interest += $periodic_interest[$i];
		$year_principal += $periodic_principal[$i];

		$periodic_interest[$i] = number_format($periodic_interest[$i], 2, '.', '');
		$periodic_principal[$i] = number_format($periodic_principal[$i], 2, '.', '');
		$amount_left = $amount_left < 0 ? 0 : $amount_left;
		$balance[$i]= number_format($amount_left, 2, '.', '');

//		if ($i%$periodicity==($periodicity-1)) {
		if (!(($i+1) % $periodicity)) {
			$yinterest[$j] = number_format($year_interest, 2, '.', '');
			$yprincipal[$j] = number_format($year_principal, 2, '.', '');
			$j++;

			$year_interest = $year_principal = 0;
		}
	}

	$periodic_payment = number_format($periodic_payment, 2, '.', '');
	$total_paid = number_format($total_paid, 2, '.', '');
	$total_interest = number_format($total_interest, 2, '.', '');


?>

datahound · 29-10-2006, 15:04

further investigation proved incorrect.

freelancr · 30-10-2006, 04:01

Its a basic If statment datahound, the whole point of it was so math.php does not get included? Instead of using an else (which they should of done?) they just quit PHP inside the IF.

And looking at that mess, i'm glad I do ASP.NET where there are 3 distinct layers:
- Presentation
- Application
- Data

For the OP, Have you got an example online, would make it easier to diagnose exactly what isnt working.

adminitrator · 30-10-2006, 08:22

hi, i can't see how you are getting what has been send back to the server in your script. I have only had a quick look at it but i cannot find any $_GET[] vars anywhere.
$action is not defined
try importing the values using $action=$_GET['action'];
maybe you could change the method to post and import using $_POST[];
hth, adminitrator

adminitrator · 30-10-2006, 08:34

Change index.php to this. I havn't deleted any code i just commented yours because i didnt know what it was doing but you could re arrange it so that the vars are defined above and your code can be un commented below.

Code:

<?
//Import vars sent from form
@$action=$_GET['action'];
@$interest_rate=$_GET['interest_rate'];
@$downpayment=$_GET['downpayment_percent'];
@$loan=$_GET['loan'];
@$year=$_GET['year'];
@$periodicity=$_GET['periodicity'];
@$s = $_GET['currency'];
//uses @ so doesnt throw an error
/*
TigerTom's Loan & Mortgage Calculator (TTLoanCalc)

http://www.tigertom.com
http://www.ttfreeware.com

Copyright (c) 2005 T. O' Donnell
Developed for TigerTom by Jon K.

Released under the GNU General Public License, with the
following proviso: 

That the HTML of hyperlinks to the authors' websites
this software generates shall remain intact and unaltered, 
in any version of this software you make.
 
If this is not strictly adhered to, your licence shall be 
rendered null, void and invalid.
*/

// Remove bad input

/*wtf? $year = eregi_replace ("\)|\(|src|\[|\]|script|<|>|\"|\'|;|&", "", $year);
$downpayment_percent = eregi_replace ("\)|\(|src|\[|\]|script|<|>|\"|\'|;|&", "", $downpayment_percent);
$loan = eregi_replace ("\)|\(|src|\[|\]|script|<|>|\"|\'|;|&", "", $loan);
$interest_rate = eregi_replace ("\)|\(|src|\[|\]|script|<|>|\"|\'|;|&", "", $interest_rate);
*/

	// Show form only if there is no action
	if ($action!="Calculate") {
		print "<html>\n";
		print "<head><TITLE>Mortgage Calculator</TITLE>\n";
		print "<link href=loan.css rel=stylesheet type=text/css />\n";
		print "</head>\n";
		print "<form>\n";
		print "<table cellpadding=2 width=300 border=0 ALIGN=center>\n";
		print "<tr align=center><td colspan=2><b>Mortgage Information</b></td></tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Sale Price of Home</td>\n";
		print "<td class=finput><input type=text name=loan size=7></td>\n";
		print "</tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Percentage Down, %</td>\n";
		print "<td class=finput><input type=text name=downpayment_percent size=7></td>\n";
		print "</tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Length of mortgage, years</td>\n";
		print "<td class=finput><input type=text name=year size=7></td>\n";
		print "</tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Interest rate, %</td>\n";
		print "<td class=finput><input type=text name=interest_rate size=4></td>\n";
		print "</tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Currency</td>\n";
		print "<td class=finput>\n";
		print "<select name=currency>\n";
		print "<option value=$>$</option>\n";
		print "<option value=&euro;>&euro;</option>\n";
		print "<option value=&pound;>&pound;</option>\n";
		print "</td>\n";
		print "</tr>\n";

		print "<tr>\n";
		print "<td class=flabel>Show amortization</td>\n";
		print "<td class=finput><input type=checkbox name=amortization></td>\n";
		print "</tr>\n";

		print "<input type=hidden name=periodicity value=12>\n";
		print "<tr><td colspan=2 align=center><input type=submit value=Calculate name=action></td></tr>\n";
		print "</table>\n";
		print "</html>\n";
		print "</form>\n";
		print "<center>";
		footer();
		print "</center>";
		exit;
	}

	// Only perform calculation and show tables if user
	// click calculate button
	include "math.php";
?>

<html>
<head>
<link href="loan.css" rel="stylesheet" type="text/css" />
</head>
<table cellpadding="2" cellspacing="0" border="0" width="100%">
<tr>
	<td colspan=2 class=header>Mortgage Payment Report</td>
</tr>
<tr class=top>
	<td align="right">Down Payment:</td>
	<td><b>
	<? print $s.$downpayment; ?>
	</b></td>
</tr>
<tr class=top>
	<td align="right">Amount Financed:</td>
	<td><b>
	<? print $s.$loan; ?>
	</b></td>
</tr>
<tr class=top>
	<td align="right">Length:</td>
	<td><b>
	<? print "$year years"; ?>
	</b></td>
</tr>
<tr class=top>
	<td align="right">Annual interest:</td>
	<td><b>
	<? print $interest_rate; ?> %
	</b></td>
</tr>
<tr class=toptotal>
	<td align="right">Monthly Payment:</td>
	<td><b>
	<? print $s.$periodic_payment; ?>
	</b><br>(excluding tax and insurance)</td>
</tr>
</table>

<!--
	This is the Totals table
--!>

<table cellpadding="5" cellspacing="0" border="1" width="100%">
<tr class=total1>
	<td colspan="4">Totals</td>
</tr>
<tr class=total2>
	<td>&nbsp;</td>
	<td colspan="3">
		Outgoings: <B><? print $s.$total_paid; ?></B> paid out.<br>
		<? print $s.$total_interest; ?> paid in <b>interest</b>.<br>
		<? print $s.$loan; ?> paid towards <b>principal</b>.<br>
	</td>
</tr>

<!--
	This is the Amortization table
--!>

<?
	if (!$amortization) {
		footer();
		exit;
	}
?>

<tr class=aheader>
	<td colspan="4">Amortization</td>
</tr>
<tr class=aheader align=right>
	<td>Month</td>
	<td>Interest Paid</td>
	<td>Principal Paid</td>
	<td>Balance Outstanding</td>
</tr>

<?
	$yr = 0;
	for ($i=0; $i<$year*12; $i++) {
		print "<tr class=acontent>\n";
		print "<td>".(($i%12)+1)."</td>\n";
		print "<td>$s$periodic_interest[$i]</td>\n";
		print "<td>$s$periodic_principal[$i]</td>\n";
		print "<td>$s$balance[$i]</td>\n";
		print "</tr>\n";

		if ($i%12==11) {
			$ytotal = $yinterest[$yr] + $yprincipal[$yr];

			print "<tr class=total1>\n";
			print "<td colspan=4>Totals for year ".($yr+1)."</td>\n";
			print "</tr>\n";
			print "<tr class=total2>\n";
			print "<td>&nbsp;</td>\n";
			print "<td colspan=3>\n";
			print "Outgoings: <B>$s$ytotal</B> paid out in year ".($yr+1).".<br>\n";
			print "$s$yinterest[$yr] paid in <b>interest</b>.<br>\n";
			print "$s$yprincipal[$yr] paid towards <b>principal</b>.<br>\n";
			print "</td>\n";
			print "</tr>\n";

			if ($yr != $year-1) {
				print "<tr class=aheader align=right>\n";
				print "<td>Month</td>\n";
				print "<td>Interest Paid</td>\n";
				print "<td>Principal Paid</td>\n";
				print "<td>Balance Outstanding</td>\n";
				print "</tr>\n";
			}

			$yr++;
		}
	}

	footer();
	
	function footer()
	{
		print "<BR><BR><tr class=total2><td colspan=4 align=center>\n";
		print "<!--// Altering the following HTML code in any way invalidates your licence to use this software --><FONT SIZE=\"1\"><a href=\"http://www.ttfreeware.com\">TTLoanCalc</a> by Jon K. for <a href=\"http://www.tigertom.com\">TigerTom</a></FONT>\n";
		print "</td></tr>\n";
	}
?>

hth, dandono

2Dfruit · 30-10-2006, 08:48

It was a script i got off hotscripts or something of the like. That's the code straight out of the zip file. I'll try the suggestions and keep you updated.

at the ASP comment: I did a bit of Vbasic in my first year in college. pretty much the same premise right? It was soo much easier than this php shite.

adminitrator · 31-10-2006, 12:54

php is one of the easiest languages to learn. i learnt it and started using it within a week and havn't stopped since

29-10-2006, 15:04	#2 (permalink)
datahound Spare Parts Join Date: Jan 2005 Location: Bracknell Forest Posts: 4,717	further investigation proved incorrect. __________________ poochmedia \| Computer Spare Parts \| Computer & Telephone Disposals Last edited by datahound : 30-10-2006 at 09:02.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

30-10-2006, 04:01	#3 (permalink)
freelancr Senior Member Join Date: Oct 2006 Posts: 2,076	Its a basic If statment datahound, the whole point of it was so math.php does not get included? Instead of using an else (which they should of done?) they just quit PHP inside the IF. And looking at that mess, i'm glad I do ASP.NET where there are 3 distinct layers: - Presentation - Application - Data For the OP, Have you got an example online, would make it easier to diagnose exactly what isnt working.

30-10-2006, 08:22	#4 (permalink)
adminitrator Registered User Join Date: Oct 2006 Location: Cornwall, UK Posts: 95	hi, i can't see how you are getting what has been send back to the server in your script. I have only had a quick look at it but i cannot find any $_GET[] vars anywhere. $action is not defined try importing the values using $action=$_GET['action']; maybe you could change the method to post and import using $_POST[]; hth, adminitrator

30-10-2006, 08:48	#6 (permalink)
2Dfruit Biscuit Join Date: Jun 2006 Location: Ireland Posts: 915	It was a script i got off hotscripts or something of the like. That's the code straight out of the zip file. I'll try the suggestions and keep you updated. at the ASP comment: I did a bit of Vbasic in my first year in college. pretty much the same premise right? It was soo much easier than this php shite.

31-10-2006, 12:54	#7 (permalink)
adminitrator Registered User Join Date: Oct 2006 Location: Cornwall, UK Posts: 95	php is one of the easiest languages to learn. i learnt it and started using it within a week and havn't stopped since

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)