Untitled

<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <?php

        if(isset($_POST['check'])){
            $dbhost = '127.0.0.1';
            $dbuser = 'root';
            $dbpass= '';
            $db = 'dbvehiculos';

          $conn =  mysqli_connect($dbhost, $dbuser, $dbpass);

          if(! $conn){
              die ("Fallo en conexión: " . mysqli_error());

          }

         $db_select = mysqli_select_db($conn, $db);

          if(! $db_select){
              die ("Fallo en conexión a base de datos: " .
                      mysqli_error());

          }

          $ID = $_POST['v_ID'];

          $sql = "SELECT * FROM `test` WHERE id=$ID";
          //$sql = "INSER INTO test "
                //. "(IDVeh, Marca, Modelo, Fecha)"
               // . "(monthlyAmount, intRate)"
               // . "VALUES ('$ID', '$MAR')";

        $qry = mysqli_query($conn, $sql) or
                die ('Consulta fallida');

                if(! $qry){
                    die(mysqli_error());

                }
                $result = mysqli_query($conn, $sql);
                while ($row = mysqli_fetch_object($result)) {
                    $intAmount = (($row->monthlyAmount * $row->monthsOwed * ($row->intRate/100))/30)*$row->pastDue;
                    echo 'Amount Owed per month: ' .$row->monthlyAmount;
                    echo '<br>';
                    echo 'Months past due: ' .$row->monthsOwed;
                    echo '<br>';
                    echo 'Interest rate per month: ' .$row->intRate;
                    echo '<br>';
                    echo 'Daily interest: ' .$row->intRate*$row->monthsOwed/30;
                    echo '<br>';
                    echo 'Rent due: ' .$row->monthlyAmount * $row->monthsOwed;
                    echo '<br>';
                    echo 'Interest charge: ' .(Calculate($row->monthlyAmount, $row->intRate/100, $row->monthsOwed) - ($row->monthlyAmount * $row->monthsOwed));
                    echo '<br>';
                    echo 'Total: ' . floor(Calculate($row->monthlyAmount, $row->intRate/100, $row->monthsOwed));
                    echo '<br>';
                    echo '<br>';
                }
                ?>
        <form method = "post" action = "<?php $_PHP_SELF ?>">
                  <table width = "400" border = "0" cellspacing = "1"
                     cellpadding = "2">
                                           <tr>
                        <td width = "100" >Account ID</td>
                        <td><input name = "v_ID" type = "text" value="<?php echo$ID ?>"
                           id = "veh_ID"></td>
                        </tr>
                     <tr>
                        <td width = "100" >NUMBER OF MONTHS TO REMOVE</td>
                        <td><input name = "v_Remove" type = "text"
                           id = "veh_Remove"></td>
                        </tr>
                        <tr>
                        <td width = "100"> </td>
                        <td>
                           <input name = "recheck" type = "submit" id = "recheck"
                              value = "RECHECK">
                        </td>
                     </tr>
                  </table>
               </form>
        <?php

                mysqli_close($conn);
                }
    else if(isset($_POST['recheck'])){
            $dbhost = '127.0.0.1';
            $dbuser = 'root';
            $dbpass= '';
            $db = 'dbvehiculos';

          $conn =  mysqli_connect($dbhost, $dbuser, $dbpass);

          if(! $conn){
              die ("Fallo en conexión: " . mysqli_error());

          }

         $db_select = mysqli_select_db($conn, $db);

          if(! $db_select){
              die ("Fallo en conexión a base de datos: " .
                      mysqli_error());

          }

          $ID = $_POST['v_ID'];
          $remove = $_POST['v_Remove'];

          $sqlRemove = "UPDATE `test` SET monthsOwed = monthsOwed - " . $remove . " WHERE id=$ID";
          $qryRemove = mysqli_query($conn, $sqlRemove) or
                die ('Consulta fallida');

                if(! $qryRemove){
                    die(mysqli_error());

                }
          $sql = "SELECT * FROM `test` WHERE id=$ID";
          //$sql = "INSER INTO test "
                //. "(IDVeh, Marca, Modelo, Fecha)"
               // . "(monthlyAmount, intRate)"
               // . "VALUES ('$ID', '$MAR')";

        $qry = mysqli_query($conn, $sql) or
                die ('Consulta fallida');

                if(! $qry){
                    die(mysqli_error());

                }
                $result = mysqli_query($conn, $sql);
                while ($row = mysqli_fetch_object($result)) {
                    $intAmount = (($row->monthlyAmount * ($row->intRate/100))/30)*$row->pastDue;
                    echo '<br>';
                    echo '<br>';
                    echo 'UPDATED AND REMOVED MONTHS';
                    echo '<br>';
                    echo 'RECALCULATED';
                    echo '<br>';
                    echo '<br>';
                    echo 'Amount Owed per month: ' .$row->monthlyAmount;
                    echo '<br>';
                    echo 'Months past due: ' .$row->monthsOwed;
                    echo '<br>';
                    echo 'Interest rate per month: ' .$row->intRate;
                    echo '<br>';
                    echo 'Daily interest: ' .$row->intRate*$row->monthsOwed/30;
                    echo '<br>';
                    echo 'Rent due: ' .$row->monthlyAmount * $row->monthsOwed;
                    echo '<br>';
                    echo 'Interest charge: ' .(Calculate($row->monthlyAmount, $row->intRate/100, $row->monthsOwed) - ($row->monthlyAmount * $row->monthsOwed));
                    echo '<br>';
                    echo 'Total: ' . floor(Calculate($row->monthlyAmount, $row->intRate/100, $row->monthsOwed));
                    echo '<br>';
                    echo '<br>';
                }
                }
         else{

                ?>
<form method = "post" action = "<?php $_PHP_SELF ?>">
                  <table width = "400" border = "0" cellspacing = "1"
                     cellpadding = "2">
                     <tr>
                        <td width = "100">ID NUMBER</td>
                        <td><input name = "v_ID" type = "text"
                           id = "veh_ID"></td>
                        </tr>
                        <tr>
                        <td width = "100"> </td>
                        <td>
                           <input name = "check" type = "submit" id = "check"
                              value = "CHECK">
                        </td>
                     </tr>
                  </table>
               </form>

<?php
         }
    function Calculate($monthly, $rate, $months){
                 for ($i=1; $i<=$months; $i++){
             if($i==1){
                 //does the very first month and stores it in $amount
                $amount = ($monthly * ($rate)) + $monthly;
             }
             else if ($i<=$months){
                 //does every other month until 12 months
                $amount = ($amount + $monthly) + (($amount + $monthly) * ($rate));
             }
                }
        return $amount;
    }
?>


    </body>
</html>