MAINHACK

Viewing / Editing File: all-schools.php

<?php include("../functions.php");
 //error_reporting(0);
//  if(!isset($_SESSION['dbmail_Xw211qAAsq4'])){
//      header("location:../auth-login");
//  } else {

$s_code = $_SESSION['s_code_Xw2119904'];

function generateUniqueCode($length = 6) {
// Define the characters allowed in the code (uppercase letters and digits)
$characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
$charactersLength = strlen($characters);
$uniqueCode = '';

// Generate a random string of the desired length
for ($i = 0; $i < $length; $i++) {
  $randomIndex = random_int(0, $charactersLength - 1);
  $uniqueCode .= $characters[$randomIndex];
}

return $uniqueCode;
}

$code = generateUniqueCode();

if($_SERVER["REQUEST_METHOD"] == "POST"){
if(!csrf_token_is_valid() || !csrf_token_is_recent()) {
$message = "<p class='alert alert-danger text-center ' 
role='alert'>Token Authentication Failed</p>";
} else {

$school_region = test_input($_POST['school_region']);
$school_location = test_input($_POST['school_location']);
$head_title = test_input($_POST['head_title']);
$school_head = test_input($_POST['school_head']);

$school_name = test_input($_POST['school_name']);
$school_email = test_input($_POST['school_email']);
$phone_num = test_input($_POST['phone_num']);
$password = test_input($_POST['password']);

$code = generateUniqueCode();

$file1 = $_FILES['file'];
$originalFileName = $_FILES['file']['name'];
$fileType = $_FILES['file']['type'];
$fileTmpName = $_FILES['file']['tmp_name'];
$fileSize = $_FILES['file']['size'];

$sql_e = "SELECT school_email FROM schools WHERE school_email ='$school_email'";
$res_e = mysqli_query($new, $sql_e);

$sql_ee = "SELECT school_name FROM schools WHERE school_name ='$school_name'";
$res_ee = mysqli_query($new, $sql_ee);

if(mysqli_num_rows($res_e) > 0){

echo "<script>
document.addEventListener('DOMContentLoaded', function() {
Swal.fire({
title: 'Error!',
text: 'Sorry... email already taken',
icon: 'error',
confirmButtonText: 'OK'
});
});
</script>";      
}

elseif(mysqli_num_rows($res_ee) > 0){

echo "<script>
document.addEventListener('DOMContentLoaded', function() {
Swal.fire({
title: 'Error!',
text: 'Sorry... School name already exist',
icon: 'error',
confirmButtonText: 'OK'
});
});
</script>";      
}

elseif (!preg_match('/^(\+?\d{1,3})?(\d{10})$/', $phone_num)) {
       echo "<script>
document.addEventListener('DOMContentLoaded', function() {
Swal.fire({
title: 'Error!',
text: 'Invalid phone number. Please enter a valid 10-digit phone number with optional country code.',
icon: 'error',
confirmButtonText: 'OK'
});
});
</script>";
 }

else {

$randomName = bin2hex(random_bytes(8)); // Generates a random 16-character string
$fileExtension = pathinfo($originalFileName, PATHINFO_EXTENSION);
$newFileName = $randomName . '.' . $fileExtension;
// Define the folder to save the uploaded file
$uploadFolder = 'uploads/';

if (!file_exists($uploadFolder)) {
mkdir($uploadFolder, 0777, true);
}
// The path where the file will be saved
$destination = $uploadFolder . $newFileName;
move_uploaded_file($fileTmpName, $destination);

$pass = password_hash($password,PASSWORD_BCRYPT, array('cost'=>12));
$validation_code = 0;
$active = 1;
$registered_date = date("Y-m-d H:i:s");
$reset_token = 'none';

$stmt = $con->prepare("insert into schools (school_code,school_name,school_region,school_location,school_email,phone_num,head_title,school_head,password,validation_code,reset_token,active,registered_date,logo) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?) ");
$stmt->execute(array($code,$school_name,$school_region,$school_location,$school_email,$phone_num,$head_title,$school_head,$pass,$validation_code,$reset_token,$active,$registered_date,$destination));

if($stmt == true){
         echo "<script>
document.addEventListener('DOMContentLoaded', function() {
Swal.fire({
title: 'Success!',
text: 'New school is added',
icon: 'success',
confirmButtonText: 'OK'
});
});
</script>";
}

}
}
}

if(isset($_POST['update'])){
$sid = test_input($_POST['sid']);
$updatestatus = test_input($_POST['updatestatus']);

$stmt_update_service = mysqli_query($new,"UPDATE schools SET active = '$updatestatus'  WHERE id = '$sid'");

echo "<script>
document.addEventListener('DOMContentLoaded', function() {
Swal.fire({
title: 'Success!',
text: 'Status updated successfully.',
icon: 'success',
confirmButtonText: 'OK'
});
});
</script>";

}

if(isset($_POST['editme'])){

$eschool_region = test_input($_POST['eschool_region']);
$eschool_location = test_input($_POST['eschool_location']);
$ehead_title = test_input($_POST['ehead_title']);
$eschool_head = test_input($_POST['eschool_head']);

$eschool_name = test_input($_POST['eschool_name']);
$eschool_email = test_input($_POST['eschool_email']);
$ephone_num = test_input($_POST['ephone_num']);
$sid = test_input($_POST['sid']);

$file1 = $_FILES['file'];
$originalFileName = $_FILES['file']['name'];
$fileType = $_FILES['file']['type'];
$fileTmpName = $_FILES['file']['tmp_name'];
$fileSize = $_FILES['file']['size'];

$stmt_update_service = mysqli_query($new,"UPDATE schools SET school_name = '$eschool_name', school_region = '$eschool_region',school_location = '$eschool_location',school_email = '$eschool_email', phone_num = '$ephone_num', head_title = '$ehead_title', school_head = '$eschool_head', logo = '$destination' WHERE id = '$sid'");

if($stmt_update_service == true){

echo "<script>
document.addEventListener('DOMContentLoaded', function() {
Swal.fire({
title: 'Success!',
text: 'Records updated successfully.',
icon: 'success',
confirmButtonText: 'OK'
});
});
</script>";

}
}

if(isset($_POST['del'])){
$SID  = test_input($_POST['SID']);
$stmt = $con->prepare("DELETE FROM schools WHERE id = ?");
$stmt->execute(array($SID)); 
   echo "<script>
document.addEventListener('DOMContentLoaded', function() {
Swal.fire({
title: 'Success!',
text: 'Records deleted successfully.',
icon: 'success',
confirmButtonText: 'OK'
});
});
</script>";
}

?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>MANAGE REGISTERED STUDENTS </title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="Premium Multipurpose Admin & Dashboard Template" name="description" />
<meta content="Themesbrand" name="author" />

<link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
<link href="assets/libs/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link href="assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link rel="stylesheet" href="assets/css/preloader.min.css" type="text/css" />

<link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />

<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />

<link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />

<body>

<div id="layout-wrapper">

<?php include("includes/header.php");?>
<?php include("includes/sidebar.php");?>
<div class="main-content">

<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0 font-size-18">ALL REGISTERED SCHOOLS</h4>

<div class="page-title-right">
<ol class="breadcrumb m-0">
<li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
<li class="breadcrumb-item active">ALL REGISTERED SCHOOLS</li>
</ol>
</div>

</div>
</div>
</div>

<div class="card-body">
  <button type="button" class="btn btn-primary waves-effect waves-light" data-bs-toggle="modal" data-bs-target=".bs-example-modal-xl">Add new school</button>
  <br  /><br />
<table style="color: red;" class="table table-bordered dt-responsive nowrap w-100" >
<thead>
<tr>
<th>#</th>
<th>School Name</th>
<th>School Code </th>
<th>School number</th>
<th>Status</th>
<th>Date</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php 
$cnt = 1;
$regis = mysqli_query($new,"SELECT * FROM schools WHERE user_name = 'Admin' ORDER BY id DESC");
while($dothis = mysqli_fetch_array($regis)){
?>
<tr>
<td><?php echo $cnt++;?></td>
<td><?php echo $dothis['school_name'];?></td>
<td><?php echo $dothis['school_code'];?></td>
<td><?php echo $dothis['phone_num'];?></td>
<td><?php  if($dothis['active'] == 1){
   echo '<span style="color:green">Approved</span>';
} else {
   echo '<span style="color:red">Pending</span>';
}

;?></td>
<td><?php echo $dothis['registered_date'];?></td>

<div class="btn-group">
<button type="button" style="width:40%" class="btn btn-primary dropdown-toggle" data-bs-toggle="dropdown" aria-expanded="false">Action <i class="mdi mdi-chevron-down"></i></button>
<div class="dropdown-menu">

<button type="button" style="background-color: green;color: white;"  class="dropdown-item" data-bs-toggle="modal" data-bs-target="#<?php echo $edit_data; ?>">Approve</button>

<div class="dropdown-divider"></div>
  <button type="button" style="background-color: #e62e00;color: white;"  class="dropdown-item" data-bs-toggle="modal" data-bs-target="#<?php echo $delete_data; ?>">Delete</button>
</div>
</div>

<div class="modal fade bd-example-modal-lg" id="<?php echo $edit_data; ?>" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-lg">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="myLargeModalLabel">Approve school</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
      </div>
      <div class="modal-body">

<div class="container">
          <div class="row justify-content-center">
            <div class="col-md-8 col-lg-6">
              <form method="POST">               
                <div class="mb-3">
                  <label for="exampleInputPassword1" class="form-label">Status</label>
                  <select class="form-control" name="updatestatus">
              <option value="">Select </option>
                      <option value="1">Approve</option>
                      <option value="0">Cancel</option>
                  </select>
                </div>

<input type="hidden" name="sid" value="<?php echo $dothis['id'];?>">
        
                <button type="submit" name="update" class="btn btn-primary">Submit</button>
              </form>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>

<div class="modal fade bs-example-modal-xl1" id="<?php echo $edit_data1; ?>" tabindex="-1" role="dialog" aria-labelledby="myExtraLargeModalLabel" aria-hidden="true">
<div class="modal-dialog modal-xl">
<div class="modal-content">
    <div class="modal-header">
        <h5 class="modal-title" id="myExtraLargeModalLabel">Edit school records</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
    </div>
     
    
    <div class="modal-body">
    <form method="POST" enctype="multipart/form-data" class="needs-validation mt-4 pt-2" novalidate>
        <?php //echo csrf_token_tag(); ?>
            <div class="row">
                
                <div class="col-md-3 mb-3">
                    <label for="name" class="form-label">School name</label>
              <input type="text" name="eschool_name" value="<?php echo $dothis['school_name'];?>" class="form-control" id="name">
                </div>

<div class="col-md-3 mb-3">
                    <label for="email" class="form-label">School email</label>
                    <input type="email" name="eschool_email" value="<?php echo $dothis['school_email'];?>" class="form-control" id="email">
                </div>

<div class="col-md-3 mb-3">
                    <label for="phone" class="form-label">Phone Number</label>
                    <input type="tel" name="ephone_num" class="form-control" id="phone" value="<?php echo $dothis['phone_num'];?>">
                </div>

<div class="col-md-3 mb-3">
                    <label for="address" class="form-label">Region located</label>
                    <input type="text" class="form-control" name="eschool_region" value="<?php echo $dothis['school_region'];?>" id="address">
                </div>
            </div>

<div class="row">
                
                <div class="col-md-3 mb-3">
                    <label for="city" class="form-label">School Address</label>
                    <input type="text" class="form-control" name="eschool_location" value="<?php echo $dothis['school_location'];?>" id="city">
                </div>

<div class="col-md-3 mb-3">
                    <label for="state" class="form-label">Title of Head eg. Headmaster</label>
                    <input type="text" class="form-control" name="ehead_title" value="<?php echo $dothis['head_title'];?>" id="state">
                </div>

<div class="col-md-3 mb-3">
                    <label for="zip" class="form-label">Name of Head of School</label>
                    <input type="text" name="eschool_head" value="<?php echo $dothis['school_head'];?>" class="form-control">
                </div>

<div class="col-md-3 mb-3">
                    <label for="city" class="form-label">School logo</label>
                    
                    <input type="file" name="file" class="form-control" value="<?php echo  $dothis['logo'];?>">
                </div>
            </div>

</div>

<div class="row">
                <div class="col-md-12">
                    <button type="submit" name="editme" class="btn btn-primary">Update</button>
                </div>
            </div>
        </form>
    </div>
</div>
</div>
</div>

<div class="modal fade bd-example-modal-lg13" id="<?php echo $delete_data; ?>" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-sm">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="myLargeModalLabel">Delete School</h5>
 <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<form method="POST">
Are you sure you want to delete this?
</div>
<input type="hidden" name="SID" value="<?php echo $getdata['id']; ?>">
<div class="modal-footer">
<button type="submit" name="del" class="btn btn-success">Delete</button>
</form>
</div>
</div>
</div>

</td>

<?php }?>
</tr>
</tbody>
</table>
</div>
</div>

</div> 
</div> 
</div> 
</div>

<?php include("includes/footer.php");?>
</div>

</div>

<div class="modal fade bs-example-modal-xl" tabindex="-1" role="dialog" aria-labelledby="myExtraLargeModalLabel" aria-hidden="true">
<div class="modal-dialog modal-xl">
<div class="modal-content">
    <div class="modal-header">
        <h5 class="modal-title" id="myExtraLargeModalLabel">Register new school</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
    </div>
     
    <div class="modal-body">
    <form method="POST" enctype="multipart/form-data" class="needs-validation mt-4 pt-2" novalidate>
        <?php echo csrf_token_tag(); ?>
            <div class="row">
                
                <div class="col-md-3 mb-3">
                    <label for="name" class="form-label">School name</label>
                    <input type="text" name="school_name" class="form-control" id="name" placeholder="School name" required>
                </div>

<div class="col-md-3 mb-3">
                    <label for="email" class="form-label">School email</label>
                    <input type="email" name="school_email" class="form-control" id="email" placeholder="School email" required>
                </div>

<div class="col-md-3 mb-3">
                    <label for="phone" class="form-label">Phone Number</label>
                    <input type="tel" name="phone_num" class="form-control" id="phone" placeholder="Phone Number" required>
                </div>

<div class="col-md-3 mb-3">
                    <label for="address" class="form-label">Region located</label>
                    <input type="text" class="form-control" name="school_region" id="address" placeholder="Region located" required>
                </div>
            </div>

<div class="row">
                
                <div class="col-md-3 mb-3">
                    <label for="city" class="form-label">School Address</label>
                    <input type="text" class="form-control" name="school_location" id="city" placeholder="School Address" required>
                </div>

<div class="col-md-3 mb-3">
                    <label for="state" class="form-label">Title of Head eg. Headmaster</label>
                    <input type="text" class="form-control" name="head_title" id="state" placeholder="Title of Head eg. Headmaster" required>
                </div>

<div class="col-md-3 mb-3">
                    <label for="zip" class="form-label">Name of Head of School</label>
                    <input type="text" name="school_head" class="form-control" id="zip" placeholder="Name of Head of School" required>
                </div>

<div class="col-md-3 mb-3">
                    <label for="city" class="form-label">School logo</label>
                    <input type="file" name="file" class="form-control" required>
                </div>
            </div>

<div class="col-md-3 mb-3">
                    <label for="state" class="form-label">Password</label>
                    <input type="password" name="password" class="form-control" id="state" placeholder="Password" required>
                </div>
            </div>

<div class="row">
                <div class="col-md-12">
                    <button type="submit" name="add" class="btn btn-primary">Submit</button>
                </div>
            </div>
        </form>
    </div>
</div>
</div>
</div>

<div class="right-bar">
<div data-simplebar class="h-100">
<div class="rightbar-title d-flex align-items-center p-3">

<h5 class="m-0 me-2">Theme Customizer</h5>

<hr class="m-0" />

<div class="p-4">
<h6 class="mb-3">Layout</h6>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-vertical" value="vertical">
<label class="form-check-label" for="layout-vertical">Vertical</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-horizontal" value="horizontal">
<label class="form-check-label" for="layout-horizontal">Horizontal</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Mode</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-light" value="light">
<label class="form-check-label" for="layout-mode-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-dark" value="dark">
<label class="form-check-label" for="layout-mode-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Width</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-fuild" value="fuild" onchange="document.body.setAttribute('data-layout-size', 'fluid')">
<label class="form-check-label" for="layout-width-fuild">Fluid</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-boxed" value="boxed" onchange="document.body.setAttribute('data-layout-size', 'boxed')">
<label class="form-check-label" for="layout-width-boxed">Boxed</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Position</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-fixed" value="fixed" onchange="document.body.setAttribute('data-layout-scrollable', 'false')">
<label class="form-check-label" for="layout-position-fixed">Fixed</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-scrollable" value="scrollable" onchange="document.body.setAttribute('data-layout-scrollable', 'true')">
<label class="form-check-label" for="layout-position-scrollable">Scrollable</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Topbar Color</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-light" value="light" onchange="document.body.setAttribute('data-topbar', 'light')">
<label class="form-check-label" for="topbar-color-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-dark" value="dark" onchange="document.body.setAttribute('data-topbar', 'dark')">
<label class="form-check-label" for="topbar-color-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Size</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-default" value="default" onchange="document.body.setAttribute('data-sidebar-size', 'lg')">
<label class="form-check-label" for="sidebar-size-default">Default</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-compact" value="compact" onchange="document.body.setAttribute('data-sidebar-size', 'md')">
<label class="form-check-label" for="sidebar-size-compact">Compact</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-small" value="small" onchange="document.body.setAttribute('data-sidebar-size', 'sm')">
<label class="form-check-label" for="sidebar-size-small">Small (Icon View)</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Color</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-light" value="light" onchange="document.body.setAttribute('data-sidebar', 'light')">
<label class="form-check-label" for="sidebar-color-light">Light</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-dark" value="dark" onchange="document.body.setAttribute('data-sidebar', 'dark')">
<label class="form-check-label" for="sidebar-color-dark">Dark</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-brand" value="brand" onchange="document.body.setAttribute('data-sidebar', 'brand')">
<label class="form-check-label" for="sidebar-color-brand">Brand</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Direction</h6>

</div>

</div> 
</div>

<div class="rightbar-overlay"></div>

<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<script src="assets/libs/feather-icons/feather.min.js"></script>

<script src="assets/libs/pace-js/pace.min.js"></script>

<script src="assets/libs/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>

<script src="assets/libs/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
<script src="assets/libs/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js"></script>
<script src="assets/libs/jszip/jszip.min.js"></script>
<script src="assets/libs/pdfmake/build/pdfmake.min.js"></script>
<script src="assets/libs/pdfmake/build/vfs_fonts.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.html5.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.print.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.colVis.min.js"></script>

<script src="assets/libs/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
<script src="assets/libs/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js"></script>
        <script src="assets/libs/sweetalert2/sweetalert2.min.js"></script>

<script src="assets/js/pages/datatables.init.js"></script>

myModal.addEventListener('shown.bs.modal', function () {
myInput.focus()
})
</script>

</body>
</html>
<?php // }?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: all-schools.php

Server Info

System Features

User Info