School-Management-System/edit_school.php at main · waqaskanju/School-Management-System · 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
<?php
/**
 * Edit School
 * php version 8.1
 *
 * @category Site
 *
 * @package None
 *
 * @author Waqas <admin@waqaskanju.com>
 *
 * @license http://www.waqaskanju.com/license MIT
 *
 * @link http://www.waqaskanju.com
 **/
session_start();
require_once 'sand_box.php';
$link=$LINK;

if ($SCHOOL_CHANGES!=1) {
    echo '<div class="bg-danger text-center"> Not allowed!! </div>';
    exit;
}

/* Rules for Naming add under score between two words. */
if (isset($_POST['submit'])) {
    $name=$_POST['school_name'];
    $name=Validate_input($name);

    $status=Get_Permission_value('status');
    $status=Validate_input($status);

    $id=$_POST['id'];
    $id=Validate_input($id);

    $q="Update  schools SET Name='$name', Status='$status' WHERE Id='$id'";
    $exe=mysqli_query($link, $q) or
    die('Error in School Updation '. mysqli_error($link));
    if ($exe) {
          $message="$name school info updated";
          $alert_type="info";
          Show_alert($message,$alert_type);
    } else {
          echo "Error in Updation";
    }
}
?>
  <?php Page_header('Edit School'); ?>
</head>
<body>
<?php
$url_id= $_GET['id'];
$url_id=Validate_input($url_id);
$q="SELECT * from schools WHERE Id='$url_id'";
$exe=mysqli_query($link, $q);
$exer=mysqli_fetch_assoc($exe);

$school_name=$exer['Name'];
$status=$exer['Status'];
$id=$exer['Id'];
?>
<div class="container-fluid">
  <?php require_once 'nav.html'; ?>
  <form class="p-3" method="POST" action="#">
    <div class="row">
      <div class="col-sm-6 form-group">
        <label for="school_name" class="form-label">School Name:</label>
        <input type="text" placeholder="Type School Name"
                class="form-control" name="school_name"
                value="<?php echo $school_name; ?>" id="school_name" required>
      </div>
    <div>
    <div class="row mt-1">
      <div class="form-check form-switch col-sm-6 pt-3 ml-5">
        <input class="form-check-input" type="checkbox" name="status"
             role="switch" value="1"
             <?php
                if ($status==1) {
                    echo "checked";
                }
                ?> >
        <label class="form-check-label">Status</label>
      </div>
      <div class="col-sm-6">
      <input type="hidden" value="<?php echo $id;?>" name="id">
      <input type="submit" name="submit" class="btn btn-primary mt-4"
            value="Update School Name">
      </div>
    <div>
    </form>
  </div>

  <div class="container-fluid">
  <h3>Existing Schools</h3>
  <div id="existing_schools" class="bg-white">
  </div>
</div>
<script type="text/javascript" src="js/add_schools.js">
<?php Page_close(); ?>