-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathRegistration of loan.php
61 lines (57 loc) · 1.38 KB
/
Registration of loan.php
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
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "bank";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$fname=$_POST["fname"];
$lname=$_POST["lname"];
$aadharno=$_POST["aadharno"];
$isdt=$_POST["isdt"];
$closingdate=$_POST["isdt"];
$loan=$_POST["loan"];
$closingbalance=$_POST["loan"];
$ip=$_POST["ip"];
$ir=$_POST["ir"];
$email=$_POST["email"];
$ph=$_POST["ph"];
$ad=$_POST["ad"];
$pc=$_POST["pc"];
$sql = "INSERT INTO MyGuest (fname, lname,aadharno, isdt, loan, ip,ir,email, ph,ad,pc,closingdate,closingbalance)
VALUES ('$fname',
'$lname',
$aadharno,
'$isdt',
$loan,
$ip,
$ir,
'$email',
$ph,
'$ad',
$pc,
'$closingdate',
$closingbalance);";
if (mysqli_query($conn, $sql)) {
echo '
<!DOCTYPE html>
<html >
<head>
<meta charset="UTF-8">
<title>OOPs</title>
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="css/stylegood.css">
<p><font size="25" color =#ffff80>You have successfull Registered for Loan...Thank You </font></p>
</head>
<a class="button" href="index.html">HOME</a>
</body>
</html>';
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>