need to insert field fields into input

ckdoublenecks · December 22, 2010

can someone tell me why this won't work? I just want to key in the amtpaid and have fields inserted. I get no errors but the only field inserted is the datepaid .

function $_(IDS) { return document.getElementById(IDS); }

function calculate_paid() {

var amtpaid = parseInt($_("amtpaid").value);

var rentdue = parseInt($_("rentdue").value);

var prevbal = parseInt($_("prevbal").value);

var secdep = parseInt($_("secdep").value);

var latechg = parseInt($_("latechg").value);

var damage = parseInt($_("damage").value);

var courtcost = parseInt($_("courtcost").value);

var nsf = parseInt($_("nsf").value);

var hudpay = parseInt($_("hudpay").value);

var late = ($_("late").value);

var paidsum = parseInt($_("paidsum").value);

var dateNow = new Date();

var dayNow = dateNow.getDate();

var datePaid = (dateNow.getMonth()+1)+"/"+dateNow.getDate()+"/"+dateNow.getFullYear();

$_('datePaid').value = datePaid;

if(dayNow > 5) { late = "L"; prevbal = prevbal + 10; }

paidsum = paidsum + amtpaid

var tentpay = amtpaid - hudpay;

var totOwed = rentdue + prevbal - hudpay;

var left = totOwed - amtpaid;

if (amtpaid <= totOwed) { prevbal = left; }

left = amtpaid - totOwed;

if (left <= secdep) { secdep = secdep - left; }

left = left - secdep;

if (left <= damage) { damage = damage - left; }

left = left - damage;

if (left <= latechg) { latechg = latechg - left; }

left = left - latechg;

if (left <= courtcost) { courtcost = courtcost - left; }

left = left - courtcost;

if (left <= nsf) { nsf = nsf - left; }

prevbal = left - nsf;

}

</script>

</head><body>

<?php
mysql_connect(localhost,root,"");
mysql_select_db(test) or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
$apt = $_POST['apt'];
$query="SELECT * FROM testdata Where apt='$apt'";
$result=mysql_query($query);
if(mysql_num_rows($result))
{
echo "<form action='#' method='post'><b>Rent Payment :<br /><br />
<table cellspacing=0 cellpadding=0 border=1>
<tr>
  <th>Name</th>
  <th>Apt</th>
  <th>Paid</th>
  <th>Due</th>
  <th>Prev Bal</th>
   <th>Sec Dep</th>
   <th>Late Chg</th>
   <th>Dmg</th>
   <th>Court Cost</th>
   <th>NSF</th>
  <th>Tent Pay</th>
  <th>Hud Pay</th>
    <th>Date Paid</th>
  <th>Late</th>
  <th>Comments</th>
<th>Paidsum</th>
</tr>";
while($row = mysql_fetch_assoc($result))
{
echo "<tr>
<td><input type='text' size=25 name='name' value='" . $row['name'] . "'></td>
<td><input type='text' size=2 name='apt' value='" . $row['apt'] . "' ></td>
<td><input type='text' size=4 id='amtpaid' name='amtpaid' value='" . $row['amtpaid'] ."' onBlur='calculate_paid(this)'></td>
<td><input type='text' size=4 id='rentdue' name='rentdue' value='" . $row['rentdue'] . "'></td>
<td><input type='text' size=4 id='prevbal' name='prevbal' value='" . $row['prevbal'] ."'></td>
<td><input type='text' size=4 id='secdep' name='secdep' value='" . $row['secdep'] ."'></td>
<td><input type='text' size=4 id='latechg' name='latechg' value='" . $row['latechg'] ."'></td>
<td><input type='text' size=4 id='damage' name='damage' value='" . $row['damage'] ."'></td>
<td><input type='text' size=4 id='courtcost' name='courtcost' value='" . $row['courtcost'] ."'></td>
<td><input type='text' size=4 id='nsf' name='nsf' value='" . $row['nsf'] ."'></td>
<td><input type='text' size=4 id='tentpay' name='tentpay' value='" . $row['tentpay'] . "'></td>
<td><input type='text' size=4 id='hudpay' name='hudpay' value='" . $row['hudpay'] ."'></td>
<td><input type='text' size=10 id='datepaid' name='datepaid' value='" . $row['datepaid'] . "'></td>
<td><input type='text' size=1 id='late' name='late' value='" . $row['late'] . "'></td>
<td><input type='text' size=25 name='comments' value='" . $row['comments'] . "'></td>
<td><input type='text' size=4 id='paidsum' name='paidsum' value='" . $row['paidsum'] . "'></td>
</tr>";
}
echo "</table>
<input type='submit' name='update' value='Make Payment' />
</form>";
}
else{echo "No listing for apartment $apt.<br />Please select another.<br />";}
}
if(!empty($_POST["update"]))
{
$sql = "UPDATE testdata SET
name = '" . mysql_real_escape_string($_POST['name']) . "',
amtpaid = '" . mysql_real_escape_string($_POST['amtpaid']) . "',
rentdue = '" . mysql_real_escape_string($_POST['rentdue']) . "',
prevbal = '" . mysql_real_escape_string($_POST['prevbal']) . "',
secdep = '" . mysql_real_escape_string($_POST['secdep']) . "',
latechg = '" . mysql_real_escape_string($_POST['latechg']) . "',
nsf = '" . mysql_real_escape_string($_POST['nsf']) . "',
damage = '" . mysql_real_escape_string($_POST['damage']) . "',
courtcost = '" . mysql_real_escape_string($_POST['costcost']) . "',
tentpay = '" . mysql_real_escape_string($_POST['tentpay']) . "',
hudpay = '" . mysql_real_escape_string($_POST['hudpay']) . "',
datepaid = '" . mysql_real_escape_string($_POST['datepaid']) . "',
late = '" . mysql_real_escape_string($_POST['late']) . "',
comments = '" . mysql_real_escape_string($_POST['comments']) . "',
paidsum = '" . mysql_real_escape_string($_POST['paidsum']) . "'
WHERE apt='".$_POST["apt"]."'";
mysql_query($sql) or die("Update query failed.");
echo "Record for apartment ".$_POST["apt"]." has been updated";
}
?>

<br />

</form>

</body></html>

msaz87 · December 22, 2010

I don't think you're showing the code we really need to see, other than the SQL. We need to see the form code where you're keying in the values you're going to update the table with.

ckdoublenecks · December 22, 2010

no, you're seeing it and don't know it. the input with the onblur is where the amtpaid is entered.

Sign In

need to insert field fields into input

Recommended Posts

ckdoublenecks

Link to comment

Share on other sites

msaz87

Link to comment

Share on other sites

ckdoublenecks

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information