-
Notifications
You must be signed in to change notification settings - Fork 0
/
save.php
80 lines (79 loc) · 2.31 KB
/
save.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
<?php
ob_start();
session_start();
include('connect.php');
if(isset($_COOKIE["userid"]))
{
if($_COOKIE["userid"]=="user_id_auth_remember")
$_SESSION['userid']="admuser";
}
if(!isset($_SESSION['userid']))
{
header('location:index.php');
}
?>
<?php
if(isset($_GET['pro'])){
$bran=$_GET['bran'];
$moff=$_GET['moff'];
$yoff=$_GET['yoff'];
$name=$_GET['name'];
$roll=$_GET['roll'];
$cour=$_GET['cour'];
$dide=$_GET['dide'];
$exte=$_GET['exte'];
$cgpa=$_GET['cgpa'];
$q="select sname,yoff from stud where sroll='$roll'";
$r=mysqli_query($con,$q);
if(mysqli_num_rows($r)>0){
while($row=mysqli_fetch_array($r)){
if($row[1]==='0000'){
$query="insert into history values('$roll','$dide','issue','provisional',now())";
$result=mysqli_query($con,$query);
}
else{
$query="insert into history values('$roll','$dide','reissue','provisional',now())";
$result=mysqli_query($con,$query);
}
}
$query="update stud set course='$cour',branch='$bran',cgpa=$cgpa,moff='$moff', yoff='$yoff' where sroll='$roll'";
$result=mysqli_query($con,$query);
}
else{
$query="insert into stud values('$name','$roll','$dide','$cour','$bran',$cgpa,'$moff','$yoff','$exte','',now())";
$result=mysqli_query($con,$query);
$query="insert into history values('$roll','$dide','issue','provisional',now())";
$result=mysqli_query($con,$query);
}
}
else if(isset($_GET['mig'])){
$name=$_GET['name'];
$roll=$_GET['roll'];
$dide=$_GET['dide'];
$exte=$_GET['exte'];
$yofj=$_GET['yofj'];
$yofp=$_GET['yofp'];
$q="select sname,yofp from stud where sroll='$roll'";
$r=mysqli_query($con,$q);
if(mysqli_num_rows($r)>0){
while($row=mysqli_fetch_array($r)){
if($row[1]==='0000'){
$query="insert into history values('$roll','$dide','issue','migration',now())";
$result=mysqli_query($con,$query);
}
else{
$query="insert into history values('$roll','$dide','reissue','migration',now())";
$result=mysqli_query($con,$query);
}
}
$query="update stud set yofp='$yofp' where sroll='$roll'";
$result=mysqli_query($con,$query);
}
else{
$query="insert into stud(sname,sroll,type,extension,yofp,time) values('$name','$roll','$dide','$exte','$yofp',now())";
$result=mysqli_query($con,$query);
$query="insert into history values('$roll','$dide','issue','migration',now())";
$result=mysqli_query($con,$query);
}
}
?>