1#@!#!123s

: / home / diafrica / public_html /
Filename : update_staff.php
back
<?php
include 'includes/config.php';
session_start();
if (isset($_POST['username']) && isset($_POST['password'])) {
    $manager = $_POST['username'];
    $password = $_POST['password'];
    $cmem = "SELECT id FROM auth WHERE username='$manager' AND password='$password' LIMIT 1";
    $run_cmem = mysqli_query($con, $cmem);
    $count_mem = mysqli_num_rows($run_cmem);
    if ($count_mem == 1) {
        while ($row = mysqli_fetch_array($run_cmem)) {
            $id = $row['id'];
        }
        $_SESSION['id'] = $id;
        $_SESSION['manager'] = $manager;
        $_SESSION['password'] = $password;
        header('location: mod-auth');
        exit();
    } else {
        echo "<script>alert('Incorrect Password !!!')</script>";
        echo "<script>window.open('sacredheartdadmin','_self')</script>";
        exit();
    }
}
?>
<?php
$page_title;
$page_title = ucfirst(basename(__FILE__, '.php'));

if ($page_title === 'index') {
    $page_title = 'Home';
}

$page_title = "Update Staff page";
include 'section/header.php';
include 'section/pages-header.php';
include 'includes/functions.php';
$Functions = new Functions();
?>


<!DOCTYPE html>
<html dir="ltr" lang="en">

 <!-- Start main-content -->
  <div class="main-content">


     <!-- Section: Team -->
     <section id="team">
      <div class="container">
        <div class="row mtli-row-clearfix mb-5000">    
          <div class="col-lg-9">           
            <p><a href="mod-auth">Go back to Admin Dashboard</a></p>
            <?php
              $id = mysqli_real_escape_string($con, $_GET['sn']);
              if (isset($_POST['update'])) {
                $title = str_replace("'", "''", $_POST['title']);
                $qualification = str_replace("'", "''", $_POST['qualification']);
                $name = str_replace("'", "''", $_POST['name']);
                $category = str_replace("'", "''", $_POST['category']);
                $filename = $_FILES['file']['name'];
                $filepath = 'images/staff/' . $filename;
                move_uploaded_file($_FILES['file']['tmp_name'], $filepath);

                
                global $con;
                if ($filename == ""){
                    $query = "UPDATE staff SET title='$title', qualification='$qualification', name='$name', category='$category' WHERE id='$id' ";
                    $query_run = mysqli_query($con, $query);
                }else{
                    $query = "UPDATE staff SET title='$title', qualification='$qualification', name='$name', category='$category', image='$filepath' WHERE id='$id' ";
                    $query_run = mysqli_query($con, $query);
                }
                
                if ($query_run) {
                    echo "<div class='alert alert-success'> Updated Successfully! </div>";
                } else {
                    echo "<div class='alert alert-danger'> An error occured, please try again! </div>";
                }
              }


            ?>        
            <h3 style="color: #17569E;">Edit Staff!</h3>
            <?php
                $query = "SELECT * FROM staff WHERE id='$id' ";
                $query_run = mysqli_query($con, $query);
                while ($row_post = mysqli_fetch_array($query_run)) {
                    $title = $row_post['title'];
                    $qualification = $row_post['qualification'];
                    $name = $row_post['name'];
                    $category = $row_post['category'];
                    
                }
            ?>
            <form id="form1" name="form1" method="post" action="" enctype="multipart/form-data">
                <table width="100%" cellpadding="1" cellspacing="2">
                    <div class="mb-3">
                        <label>Title</label>
                        <input type="text" name="title" value="<?= $title; ?>" class="form-control" required>
                    </div>
                    <div class="mb-3">
                        <label>Qualification</label>
                        <input type="text" name="qualification" value="<?= $qualification; ?>" class="form-control">
                    </div>
                    <div class="mb-3">
                        <label>Name</label>
                        <input type="text" name="name" value="<?= $name; ?>" class="form-control" required>
                    </div>
                    <div class="mb-3">
                        <label>select category</label><br>
                        <select name="category" class="form-control" id="">
                          <option value="<?= $category; ?>"><?= $category; ?> staff</option>
                          <option value="principal">Principal staff</option>
                          <option value="academic">Academic staff</option>
                        </select>
                    </div
                    <div class="mb-3">
                        <label>Image</label>
                        <input name="file" type="file" accept=".png,.jpeg,.jpg,.svg,.gif,.tiff" class="form-control">
                    </div>
                    
                    <!-- <div class="mb-3">
                        <label>Content</label>
                        <textarea id="editor" type="text" name="content" class="form-control"></textarea>
                        <script>
                             ClassicEditor
                             .create( document.querySelector( '#editor' ) )
                             .then( editor => {
                                                 console.log( editor );
                             } )
                             .catch( error => {
                                                 console.error( error );
                             } );
                        </script>
                    </div> -->
                    <br>
                    <div class="mb-3">
                        <input style="margin-left: 100px;" name="update" type="submit" style="font-size:12px;" class="btn btn-primary" id="addnews" value="Update" />
                        <a style="margin-left: 100px;" class="default-btn" href="add_staff">Back</a>
                    </div>
                </table>
            </form>
            <hr/>
            
          </div>        
        </div>
      </div>
    </section>
  </div>
  <!-- end main-content -->
  
  <?php include_once 'section/footer.php'; ?>s