Jump to content

kirkwebsites

New Members
 View Profile  See their activity

  • Posts

    5

  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

kirkwebsites's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. kirkwebsites
    the below code has worked for months but in modifying I got lost. below is the error message and code. I could use some help <?php mysql_connect('localhost','root',''); mysql_select_db('numbersdb') or die("Unable to select invcalc database"); $query = "SELECT taxrate from numbdata"; $result = mysql_fetch_assoc(mysql_query($query)); $taxrate = $result['taxrate']; mysql_connect('localhost','root',''); mysql_select_db('oodb') or die("Unable to select database"); $query = "SELECT id, shipamt, duedate, charges, dayslate, tax, amtdue FROM oocust WHERE DATEDIFF(NOW(), duedate) > 30 AND amtdue > '0.00'"; $result=mysql_query($query); $num=mysql_numrows($result); while($row = mysql_fetch_array($result)) { $id = $row['id']; $shipamt = $row['shipamt']; $duedate = $row['duedate']; $charges = $row['charges']; $dayslate = $row['dayslate']; $tax = $row['taxrate']; $amtdue = $row['amtdue']; $tax = $charges * $rate; $amtdue = $charges + $tax + $shipamt; $currdate = date('Y-m-d'); $date1 = $duedate; $date2 = $currdate; $diff = abs(strtotime($date2) - strtotime($date1)); $years = floor($diff / (365*60*60*24)); $months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24)); $days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24)); // echo "Difference is $months months, $days days."; $dayslate = $months *30; $dayslate = $dayslate + $days; $sql = "UPDATE oocust SET tax = '" . mysql_real_escape_string($tax) . "', amtdue = '" . mysql_real_escape_string($amtdue) . "', dayslate = '" . mysql_real_escape_string($dayslate) . "', duedate = '" . mysql_real_escape_string($duedate) . "', WHERE id='".$id."'"; mysql_query($sql) or die("Update query failed."); } echo "Invoice Prep completed"; mysql_close(); ?>
  2. kirkwebsites
    it wasn't a requirement in HTML4
  3. kirkwebsites
    the amtdue from the database shows 63 More importantly, the paidamt shows 10.00 and the balance shows -10
  4. kirkwebsites
    they're set to decimal (7,2) not float
  5. kirkwebsites
    the amtdue doesn't print the 2 decimals, and the balance printed is wrong. I've confirmed that all the amounts in the database are decimal(7,2) ??? This code worked when I was adding the paidamt to the balance. <html><head> <!--when the paidamt is keyed in, the current date, pd & balance are autoinserted--> <script> function $_(IDS) { return document.getElementById(IDS); } function calculate_paid() { var pd = document.getElementById("pd"); var datepaid = document.getElementById("datepaid"); var amtdue = document.getElementById("amtdue"); var paidamt = document.getElementById("paidamt"); var balance = document.getElementById("balance"); // ********************set up date********************** var dateNow = new Date(); var dayNow = dateNow.getDate(); var datePaid = (dateNow.getMonth()+1)+"/"+dateNow.getDate()+"/"+dateNow.getFullYear(); datepaid.value = datePaid; // ***************end date setup************************* // ********calculate balance & set up pd*** amtdue.value = parseFloat(amtdue.value); balance.value = parseFloat(balance.value) - parseFloat(paidamt.value); pd.value = "P"; // ********************* end of calcs ****************** } </script> <script type="text/javascript"> window.google_analytics_uacct = "UA-256751-2"; </script> <script type="text/javascript"> window.google_analytics_uacct = "UA-256751-2"; </script> </head><body> <?php mysql_connect("localhost","root",""); mysql_select_db('oodb') or die( "Unable to select database"); if(!empty($_POST["submit"])) { $invnum = $_POST['invnum']; $query="SELECT * FROM oocust Where invnum='$invnum'"; $result=mysql_query($query); if(mysql_num_rows($result)) { ?> <form action="#" method="post"><strong>Invoice Payment :</strong><br /><br /> <table cellspacing="0" cellpadding="0" border="1"> <tr> <th>Inv#</th> <th>check/ord#</th> <th>Name</th> <th>Description</th> <th>Paid Amt</th> <th>Amt Due</th> <th>Date Paid</th> <th>Code</th> <th>Balance</th> </tr> <?php while($row = mysql_fetch_assoc($result)) { extract($row); ?> <tr> <td><input type="text" size="5" name="invnum" value="<?php echo $invnum;?>" /></td> <td><input type="text" size="5" name="ordernum" value="<?php echo $ordernum;?>" /></td> <td><input type="text" size="25" name="bname" value="<?php echo $bname;?>" /></td> <td><input type="text" size="25" name="descr" value="<?php echo $descr;?>" /></td> <td><input type="text" size="7" id="paidamt" name="paidamt" value="<?php echo $paidamt;?>" onBlur="calculate_paid(this);" /></td> <td><input type="text" size="7" id="amtdue" name="amtdue" value="<?php echo $amtdue;?>" /></td> <td><input type="text" size="10" id="datepaid" name="datepaid" value="<?php echo $datepaid;?>"></td> <td><input type="text" size="1" id="pd" name="pd" value="<?php echo $pd;?>"></td> <td><input type="text" size="7" id="balance" name="balance" value="<?php echo $balance;?>"></td> </tr> <?php } ?> </table> <input type="submit" name="update" value="Make Payment" /> </form> <?php } else { echo "No listing for invoice no. $invnum.<br />Please select another.<br />"; } } if(isset($_POST["update"])) { $sql = "UPDATE oocust SET pd = '" . mysql_real_escape_string($_POST['pd']) . "', datepaid = '" . mysql_real_escape_string($_POST['datepaid']) . "', paidamt = '" . mysql_real_escape_string($_POST['paidamt']) . "', amtdue = '" . mysql_real_escape_string($_POST['amtdue']) . "', balance = '" . mysql_real_escape_string($_POST['balance']) . "' WHERE invnum='".$_POST["invnum"]."'"; mysql_query($sql) or die("Update query failed: " . mysql_error()); echo "Record for invoice ".$_POST["invnum"]." has been updated"; } ?> <form method="post" action="#"> <br /> <input type="text" name="invnum"/> <p> <input type="submit" name="submit" value="select invoice no."/> </form> <script type="text/javascript"><!-- var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); //--> </script> <script type="text/javascript"><!-- try { var pageTracker = _gat._getTracker("UA-256751-2"); pageTracker._trackPageview(); } catch(err) {} //--> </script> <script type="text/javascript"><!-- var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); //--> </script> <script type="text/javascript"><!-- try { var pageTracker = _gat._getTracker("UA-256751-2"); pageTracker._trackPageview(); } catch(err) {} //--> </script> </body></html>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.