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

//function for connecting to the database
function Connect(){
    $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());
    }
    return $conn;
}

//searches the database for the id number input
if (isset($_POST['check'])) {
    $conn = Connect();

    $ID = $_POST['p_ID'];

    $sql = "SELECT * FROM `test` WHERE id=$ID";

    $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)) {
        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)); //calculates the interest amount with the Calculate function
        echo '<br>';
        echo 'Total: ' . (Calculate($row->monthlyAmount, $row->intRate / 100, $row->monthsOwed)); //calculates the total amount using the Calculate function
        echo '<br>';
        echo '<br>';
    }
        mysqli_close($conn);
?>
<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

}
//removes the entered months from the database and recalculates the amount
else if (isset($_POST['recheck'])) {
    $conn = Connect();

    $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";

    $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)) {
        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)); //calculates the interest amount with the Calculate function
        echo '<br>';
        echo 'Total: ' . (Calculate($row->monthlyAmount, $row->intRate / 100, $row->monthsOwed)); //calculates the total amount using the Calculate function
        echo '<br>';
        echo '<br>';
    }
    mysqli_close($conn);
} 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 calculates the interest per month
function Calculate($monthly, $rate, $months)
{
    for ($i = 1; $i <= $months; $i++) {
        //first if determins the first month amount
        if ($i == 1) {
            $amount = ($monthly * ($rate)) + $monthly;
        }
        //takes the first month and calculates it into the other months
        else if ($i <= $months) {
            $amount = ($amount + $monthly) + (($amount + $monthly) * ($rate));
        }
    }
    return $amount;
}
?>

    </body>
</html>