-
Notifications
You must be signed in to change notification settings - Fork 14
/
updatedetailsfromstudent.php
108 lines (95 loc) · 3.55 KB
/
updatedetailsfromstudent.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
107
108
<?php
session_start();
if ( $_SESSION[ "sidx" ] == "" || $_SESSION[ "sidx" ] == NULL ) {
header( 'Location:studentlogin' );
}
$userid = $_SESSION[ "sidx" ];
$userfname = $_SESSION[ "fname" ];
$userlname = $_SESSION[ "lname" ];
?>
<?php include('studenthead.php'); ?>
<div class="container">
<div class="row">
<div class="col-md-12">
<h3> Welcome <a href="welcomestudent"><?php echo "<span style='color:red'>".$userfname." ".$userlname."</span>";?></a></h3>
<?php
include( "database.php" );
$new3 = $_GET[ 'eno' ];
//below query will print the existing record of student
$sql = "select * from studenttable where Eno=$new3";
$result = mysqli_query( $connect, $sql );
while ( $row = mysqli_fetch_array( $result ) ) {
?>
<form action="" method="POST" name="update">
<div class="form-group">
Enrolment number : <?php echo $row['Eno']; ?>
</div>
<div class="form-group">
First Name : <input type="text" name="fname" value="<?php echo $row['FName']; ?>">
</div>
<div class="form-group">
Last Name : <input type="text" name="lname" value="<?php echo $row['LName']; ?>"><br>
</div>
<div class="form-group">
Father Name : <input type="text" name="faname" value="<?PHP echo $row['FaName'];?>"><br>
</div>
<div class="form-group">
Addres : <input type="text" name="addrs" value="<?PHP echo $row['Addrs'];?>"><br>
</div>
<div class="form-group">
Gender : <input type="text" name="gender" value="<?PHP echo $row['Gender'];?>"><br>
</div>
<div class="form-group">
Course : <input type="text" name="course" value="<?PHP echo $row['Course'];?>"><br>
</div>
<div class="form-group">
D.O.B. : <input type="text" name="DOB" value="<?PHP echo $row['DOB'];?>" readonly><br>
</div>
<div class="form-group">
Phone Number : <input type="text" name="phno" value="<?PHP echo $row['PhNo'];?>" maxlength="10"><br>
</div>
<div class="form-group">
Email : <input type="text" name="email" value="<?PHP echo $row['Eid'];?>" readonly><br>
</div>
<div class="form-group">
Password : <input type="text" name="pass" value="<?PHP echo $row['Pass'];?>"><br>
</div><br>
<div class="form-group">
<input type="submit" value="Update!" name="update" class="btn btn-primary">
</div>
</form>
<?php
}
?>
<?php
if ( isset( $_POST[ 'update' ] ) ) {
$tempfname = $_POST[ 'fname' ];
$templname = $_POST[ 'lname' ];
$tempfaname = $_POST[ 'faname' ];
$tempaddrs = $_POST[ 'addrs' ];
$tempgender = $_POST[ 'gender' ];
$tempcourse = $_POST[ 'course' ];
$tempphno = $_POST[ 'phno' ];
$tempeid = $_POST[ 'email' ];
$temppass = $_POST[ 'pass' ];
//below query will update the existing record of student
$sql = "UPDATE `studenttable` SET FName='$tempfname', LName='$templname', FaName='$tempfaname', Gender='$tempgender', Course='$tempcourse', Addrs='$tempaddrs', PhNo=$tempphno, Eid='$tempeid', Pass='$temppass' WHERE Eno=$new3";
if ( mysqli_query( $connect, $sql ) ) {
echo "
<br><br>
<div class='alert alert-success fade in'>
<a href='#' class='close' data-dismiss='alert' aria-label='close'>×</a>
<strong>Success!</strong> Student Details has been updated.
</div>
";
} else {
//below statement will print error if SQL query fail.
echo "<br><Strong>Student Updation Faliure. Try Again</strong><br> Error Details: " . $sql . "<br>" . mysqli_error( $connect );
}
//for close connection
mysqli_close( $connect );
}
?>
</div>
</div>
<?php include('allfoot.php'); ?>