CodeLab_WebTech_Project/update_student.php at main · Kamil-Ahmed67/CodeLab_WebTech_Project · 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
<?php
@include 'dbcon.php';
$s_id=$_GET['updates_id'];
$sql1="SELECT * FROM `student_registration` WHERE s_id=$s_id";
$result1=mysqli_query($conn,$sql1);
$row=mysqli_fetch_assoc($result1);
$fname=$row['fname'];
$lname=$row['lname'];
$uname=$row['uname'];
$dob=$row['DOB'];
$email=$row['email'];
$phone=$row['phone'];
$address=$row['address'];
$password=$row['password'];

if(isset($_POST['submit']))
{
	$fname = $_POST['fname'];
   $lname = $_POST['lname'];
   $uname = $_POST['uname'];
   $dob = $_POST['dob'];
   $email = $_POST['email'];
   $phone = $_POST['phone'];
   $address = $_POST['address'];
	$password = $_POST['password'];
	$pass1 = $_POST['pass1'];
	if($password == $pass1)
	{

		$sql = "UPDATE `student_registration` SET
        `fname`='$fname',`lname`='$lname',`uname`='$uname',`DOB`='$dob',`email`='$email',`phone`=' $phone',`address`='$address ',`password`='$password'
         WHERE  s_id=$s_id ";
		$result=mysqli_query($conn,$sql);
  if($result)
  {
   echo "<i>Registration Updated Successfully!</i>";
   header('location:manage_student.php');
  }
	}
	else
	{
		echo "<i>Password doesn't match</i>";
	}
}
?>
<!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>Student Registration</title>

   <!-- font awesome cdn link  -->
   <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.1.2/css/all.min.css">

   <!-- custom css file link  -->
   <link rel="stylesheet" href="css/style.css">

</head>
<body>


<section class="form-container">

   <form method = "post"  enctype="multipart/form-data">
      <h3>Register New Student</h3>
      <p>First name <span>*</span></p>
      <input type="text" name="fname" placeholder="enter your first name" value=<?php echo $fname;?> required maxlength="50" class="box">

      <p>Last name <span>*</span></p>
      <input type="text" name="lname" placeholder="enter your last name" value=<?php echo $lname;?> required maxlength="50" class="box">

      <p>User name <span>*</span></p>
      <input type="text" name="uname" placeholder="enter your user name" value=<?php echo $uname;?> required maxlength="50" class="box">

      <p>Date of birth <span>*</span></p>
      <input type="date" name="dob" placeholder="enter your date of birth"value=<?php echo $dob;?> required maxlength="50" class="box">

      <p>E-mail <span>*</span></p>
      <input type="email" name="email" placeholder="enter your email" value=<?php echo $email;?> required maxlength="50" class="box">

      <p>Phone <span>*</span></p>
      <input type="text" name="phone" placeholder="enter your phone number" value=<?php echo $phone;?> required maxlength="50" class="box">

      <p>Address <span>*</span></p>
      <input type="text" name="address" placeholder="enter your address" value=<?php echo $address;?> required maxlength="50" class="box">

      <p>Password <span>*</span></p>
      <input type="password" name="password" placeholder="enter your password" value=<?php echo $password;?> required maxlength="20" class="box">
      <p>Confirm password <span>*</span></p>
      <input type="password" name="pass1" placeholder="confirm your password" required maxlength="20" class="box">
      <p>select profile <span>*</span></p>
      <input type="file" accept="image/*" required class="box">
      <input type="submit" value="Update" name="submit" class="btn">
   </form>

</section>

<!-- custom js file link  -->
<script src="js/script.js"></script>

</body>
</html>