StudentManagement/edit.php at master · proteendas/StudentManagement · 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
<!--private-page-->
<?php
require_once("config.php");
if(!isset($_SESSION['email']))
{
    header("location:index.php");
}
if(!empty($_POST))
{
    $sql = mysqli_query($al, "UPDATE students SET name = '".$_POST['name']."', address = '".$_POST['address']."', dob = '".$_POST['dob']."' WHERE email = '".$_SESSION['email']."'");
    if($sql)
    {
        $msg = "Updated Successfully.";
    }
    else
    {
        $msg = "Cannot update credentials.";
    }
}
$details = mysqli_fetch_array(mysqli_query($al, "SELECT * FROM students WHERE email = '".$_SESSION['email']."'"));
?>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8">
        <title>
            <?php echo $details['name'];?>
        </title>
        <link href="css/style.css" rel="stylesheet" type="text/css">
    </head>
    <body>
        <?php require("banner.php");?>
        <br>
        <div align="center">
            <div id="box">
                <span class="formHeading">Edit Account Information</span>
                <br>
                <br>
                <img src="profile_pictures/<?php echo $details['picture'];?>" height="100" width="100" />
                <br>
                <form method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
                    <table border="0" cellpadding="5" cellspacing="5">
                        <tr>
                            <td class="labels" align="center" colspan="2"><?php if(isset($msg)) {echo $msg; }?></td>
                        </tr>
                        <tr>
                            <td class="labels">Name:</td>
                            <td class="labels"><input type="text" name="name" value="<?php echo $details['name'];?>" size="20" required></td>
                        </tr>
                        <tr>
                            <td class="labels">Date of Birth:</td>
                            <td class="labels"><input type="date" name="dob" value="<?php echo $details['dob'];?>" size="20" required></td>
                        </tr>
                        <tr>
                            <td class="labels">Email ID:</td>
                            <td class="labels"><input type="email" name="email" value="<?php echo $details['email'];?>" size="30" readonly disabled></td>
                        </tr>
                        <tr>
                            <td class="labels">Address:</td>
                            <td class="labels"><textarea name="address" placeholder="Enter Permanent Address" required><?php echo $details['name'];?></textarea></td>
                        </tr>
                        <tr>
                            <td class="labels" colspan="2" align="center"><input type="submit" value="UPDATE" onClick="return confirm('Are you sure?');"/></td>
                        </tr>
                    </table>
                </form>
                <br>
                <input type="button" value="BACK" onClick="window.location='profile.php'">
                <input type="button" value="HOME" onClick="window.location='home.php'">
            </div>
        </div>
        <?php require("footer.php");?>
    </body>
</html>