-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpg_next.php
106 lines (103 loc) · 5.08 KB
/
pg_next.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
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
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Application Form Submitted</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<?php
include("connection.php");
if(isset($_POST['submit']))
{
$course = $_POST['course'];
$fname = $_POST['fname'];
$mname = $_POST['mname'];
$lname = $_POST['lname'];
$dob = $_POST['dob'];
$bloodgroup = $_POST['bloodgroup'];
$address = $_POST['address1'];
$pincode = $_POST['pincode'];
$stat = $_POST['stat'];
$email = $_POST['email'];
$number = $_POST['number1'];
$religion = $_POST['religion'];
$caste = $_POST['caste'];
$ffname = $_POST['ffname'];
$fmname = $_POST['fmname'];
$flname = $_POST['flname'];
$mfname = $_POST['mfname'];
$mmname = $_POST['mmname'];
$mlname = $_POST['mlname'];
$gfname = $_POST['gfname'];
$gmname = $_POST['gmname'];
$glname = $_POST['glname'];
$relation = $_POST['relation'];
$occupation = $_POST['occupation'];
$gnum = $_POST['gnum'];
$board = $_POST['board'];
$schoolx = $_POST['schoolx'];
$yearp = $_POST['yearp'];
$marksobx = $_POST['marksobx'];
$marksfullx = $_POST['marksfullx'];
$marksavgx = $_POST['marksavgx'];
$bb = $_POST['board1'];
$schoolxii = $_POST['schoolxii'];
$yearpxii = $_POST['yearpxii'];
$marksobxii = $_POST['marksobxii'];
$marksfullxii = $_POST['marksfullxii'];
$marksavgxii = $_POST['marksavgxii'];
$university = $_POST['university'];
$college = $_POST['college'];
$yearc = $_POST['yearc'];
$marksobc = $_POST['marksobc'];
$marksfullc = $_POST['marksfullc'];
$marksavgc = $_POST['marksavgc'];
$covid = $_POST['covid'];
$file = addslashes(file_get_contents($_FILES["filep"]["tmp_name"]));
$file1 = addslashes(file_get_contents($_FILES["files"]["tmp_name"]));
$checkid = "SELECT * FROM `pgregistration` ORDER BY id DESC LIMIT 1";
$checkres = mysqli_query($conn,$checkid);
if(mysqli_num_rows($checkres)>0){
if($row = mysqli_fetch_assoc($checkres)){
$uid = $row['app_no'];
$get_numbers = str_replace("BGCPG","",$uid);
$id_increase = $get_numbers+1;
$get_string = str_pad($id_increase,4,0, STR_PAD_LEFT);
$id = "BGCPG".$get_string;
$query="INSERT INTO Pgregistration(app_no,course,fname,mname,lname,dob,bloodgroup,address1,pincode,stat,email,number1,religion,caste,ffname,fmname,flname,mfname,mmname,mlname,gfname,gmname,glname,relation,occupation,gnum,board,schoolx,yearp,marksobx,marksfullx,marksavgx,board1,schoolxii,yearpxii,marksobxii,marksfullxii,marksavgxii,university,college,yearc,marksobc,marksfullc,marksavgc,covid,filep,files) VALUES ( '$id','$course','$fname','$mname','$lname',' $dob','$bloodgroup','$address',$pincode,'$stat','$email',$number,'$religion','$caste','$ffname','$fmname','$flname','$mfname','$mmname','$mlname','$gfname','$gmname','$glname','$relation','$occupation',$gnum,'$board','$schoolx',$yearp,$marksobx,$marksfullx,$marksavgx,'$bb','$schoolxii',$yearpxii,$marksobxii,$marksfullxii,$marksavgxii,'$university','$college','$yearc',$marksobc,$marksfullc,$marksavgc,'$covid','$file','$file1')";
$data= mysqli_query($conn,$query);
if($data){
?>
<h5 style="color:red;background-color:white;">Your form is successfully submitted</h5><br><br>
<?php
echo " Your Application Number is : ".$id;
}
else{
echo "<script>alert('Something Went Wrong ...TRY AGAIN')</script>";
}
}
}
else{
$id = "BGCPG0001";
$query="INSERT INTO pgregistration(app_no,course,fname,mname,lname,dob,bloodgroup,address1,pincode,stat,email,number1,religion,caste,ffname,fmname,flname,mfname,mmname,mlname,gfname,gmname,glname,relation,occupation,gnum,board,schoolx,yearp,marksobx,marksfullx,marksavgx,board1,schoolxii,yearpxii,marksobxii,marksfullxii,marksavgxii,university,college,yearc,marksobc,marksfullc,marksavgc,covid,filep,files) VALUES ( '$id','$course','$fname','$mname','$lname',' $dob','$bloodgroup','$address',$pincode,'$stat','$email',$number,'$religion','$caste','$ffname','$fmname','$flname','$mfname','$mmname','$mlname','$gfname','$gmname','$glname','$relation','$occupation',$gnum,'$board','$schoolx',$yearp,$marksobx,$marksfullx,$marksavgx,'$bb','$schoolxii',$yearpxii,$marksobxii,$marksfullxii,$marksavgxii,'$university','$college','$yearc',$marksobc,$marksfullc,$marksavgc,'$covid','$file','$file1')";
$data= mysqli_query($conn,$query);
if($data){
?>
<h5 style="color:red;background-color:white;">Your form is successfully submitted</h5><br><br>
<?php
echo " Your Application Number is : ".$id;
}
else{
echo "<script>alert('Something Went Wrong ...TRY AGAIN')</script>";
}
}
}
?>
<div class="buttons">
<a href="home.php">Home</a>
<a href="login.php">Login</a>
</div>
</html>