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['p_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 = "p_ID" type = "text" value="<?php echo $ID; ?>" id = "post_ID">
            </td>
        </tr>
        <tr>
            <td width = "100" >NUMBER OF MONTHS TO REMOVE</td>
                <td><input name = "p_Remove" type = "text" id = "post_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['p_ID'];
    $remove = $_POST['p_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 = "p_ID" type = "text" id = "post_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) {
            $amount = ($monthly * ($rate)) + $monthly;
        } else if ($i <= $months) {
            $amount = ($amount + $monthly) + (($amount + $monthly) * ($rate));
        }
    }
    return $amount;
}
?>


    </body>
</html>