loan-application/application.php at master · yaswanthram/loan-application · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
<?php
session_start();
require_once('config.php');
?>
<html>
<head>
    <title>Application</title>
    <link href="application.css" rel="stylesheet">
</head>

<body>

<?php

//if the user clicks on the "Submit" button
if(isset($_POST['done']))
{
    $db_host="localhost";
    $db_user="root";
    $db_pass="";
    $db_name="project";

    $con = mysqli_connect($db_host,$db_user,$db_pass,$db_name);

    $first = $_POST['firstname'];
    $last = $_POST['lastname'];
    $email = $_SESSION['email'];
    $age = $_POST['age'];
    $dob = $_POST['dob'];
    $income = $_POST['income'];
    $loan = $_POST['loan'];
    $purpose = $_POST['purpose'];
    $tenure = $_POST['tenure'];

    $sql = "INSERT into application (fname,lname,email,age,date_of_birth,income,loan_amt,purpose,tenure)
            VALUES (?,?,?,?,?,?,?,?,?)";

    $stmtinsert = $db->prepare($sql);
    $result = $stmtinsert->execute([$first,$last,$email,$age,$dob,$income,$loan,$purpose,$tenure]);
    $row=mysqli_fetch_array($result);
    $count=mysqli_num_rows($result);

    if($result)
    {
        $_SESSION['app_msg']="your loan application was successfully submitted.";
        $_SESSION['app_location']="application_details.php";
        $_SESSION['firstname']=$first;
    }
    else
    {
        $_SESSION['app_msg']="There were errors submitting your form. Please try again.";
        $_SESSION['app_location']="application.php";
    }
    header('location: application_action.php');
}

?>

<div class="details">

    <h1>Loan Application Form</h1>
    <form method="POST" class="info">
        <label class="labels">First Name</label><br>
        <input class="select" name="firstname" placeholder="Enter first name" required></input>
        <br>
        <label class="labels">Last Name</label><br>
        <input class="select" name="lastname" placeholder="Enter last name" required></input>
        <br>
        <label class="labels">Email</label><br>
        <input class="select select1" name="email" placeholder="<?php echo $_SESSION['email']; ?>" disabled></input>
        <br>
        <label class="labels">Age</label><br>
        <input class="select" name="age" placeholder="Enter age" maxlength="3" id="age" required></input>
        <br>
        <label class="labels">Date Of Birth</label><br>
        <input class="select" name="dob" placeholder="Enter date of birth" type="date" required></input>
        <br>
        <label class="labels">Monthly income</label><br>
        <input class="select" name="income" placeholder="Enter monthly income" id="income" required></input>
        <br>
        <label class="labels">Loan amount needed</label><br>
        <input class="select" name="loan" placeholder="Enter loan amount" id="loan_amt" required></input>
        <br>
        <label class="labels">Purpose :</label>
        <select name="purpose" id="purpose" required>
            <option value="housing" name="purpose1">Housing Loan</option>
            <option value="car" name="purpose2">Car Loan</option>
            <option value="personal" name="purpose3">Personal Loan</option>
        </select>
        <br><br>
        <label class="labels">Tenure :
			<input type="radio" name="tenure" value="6" required>6 months
			<input type="radio" name="tenure" value="12">12 months
			<input type="radio" name="tenure" value="24">24 months
            <input type="radio" name="tenure" value="32">32 months
		</label>

        <div class="btn">
            <button type="submit" name="done" class="btn_submit">Submit</button>
        </div>

    </form>

</div>

<!-- function to input only numbers -->
<script>
    function setInputFilter(textbox, inputFilter) {
        ["input", "keydown", "keyup", "mousedown",
        "mouseup", "select", "contextmenu", "drop"].forEach(function(event) {
            textbox.addEventListener(event, function() {
                if (inputFilter(this.value)) {
                    this.oldValue = this.value;
                    this.oldSelectionStart = this.selectionStart;
                    this.oldSelectionEnd = this.selectionEnd;
                }
                else if (this.hasOwnProperty("oldValue")) {
                    this.value = this.oldValue;
                    this.setSelectionRange(this.oldSelectionStart, this.oldSelectionEnd);
                }
                else {
                    this.value = "";
                }
            });
        });
    }

    //accept only numbers in input field 'Age'
    setInputFilter(document.getElementById("age"), function(value) {
        return /^-?\d*$/.test(value); });

    //accept only numbers in input field 'Monthly income'
    setInputFilter(document.getElementById("income"), function(value) {
        return /^-?\d*$/.test(value); });

    //accept only numbers in input field 'Loan amount'
    setInputFilter(document.getElementById("loan_amt"), function(value) {
        return /^-?\d*$/.test(value); });

</script>

</body>
</html>