1#@!#!123s

: / home3 / encodto1 / guruglobalpreschool.com / admin /
Filename : manage-faculty.php
back
<?php
include'config.php';
include'function.php';

$action = $_GET['action'];
$action_title = stringModify($action);
$item_name = "";
$item_post = "";
$item_img = "";

if($action == 'delete_faculty'){
    $del_id = $_GET['id'];
    $del_query = mysqli_query($conn, "DELETE FROM `faculty` WHERE faculty_id = '$del_id'");
    if ($del_query) {
        echo '<script>alert("Faculty data deleted.")</script>';
        echo '<script>window.location.href = "faculty-list.php";</script>';
    }
}

if($action == 'edit_faculty'){
    $edit_id = $_GET['id'];
    $view_qury = mysqli_query($conn, "SELECT * FROM `faculty` WHERE faculty_id = '$edit_id'");
    
    while($row = mysqli_fetch_array($view_qury)) {
        $item_name = $row['faculty_name'];
        $item_post = $row['faculty_post'];
        $item_img = $row['faculty_img'];
    } 
}
?>
<!doctype html>
<html lang="en">
<head>
    <meta charset="utf-8" />
    <title>Manage Faculty Data | <?php echo $company; ?></title>
    <?php include'style.php'; ?>
</head>

<body>
        <!-- Begin page -->
        <div id="layout-wrapper">
    <?php include'header.php'; ?>

            <!-- ============================================================== -->
            <!-- Start right Content here -->
            <!-- ============================================================== -->
            <div class="main-content">

                <div class="page-content">
                    <div class="container-fluid">

                        <!-- start page title -->
                        <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"><?php echo $action_title; ?> / 
                                        <span class="mx-2"><a class="" href="image-gallery.php">Faculty List</a></span>
                                    </h4>

                                    <div class="page-title-right">
                                        <ol class="breadcrumb m-0">
                                            <li class="breadcrumb-item"><a href="./">Admin</a></li>
                                            <li class="breadcrumb-item active"><?php echo $action_title; ?></li>
                                        </ol>
                                    </div>

                                </div>
                            </div>
                        </div>
                        <!-- end page title -->

                        <div class="row">
                            <div class="col-12">
                                <div class="card">
                                    <div class="card-body p-4">
                                        <div class="row">
                                            <div class="col-lg-6">
                                                <form action="" method="POST" enctype="multipart/form-data" >
                                                    <div class="mb-3">
                                                        <label for="example-text-input" class="form-label">Faculty Name:</label>
                                                        <input class="form-control" type="text" value="<?php echo $item_name; ?>" name="item_name" placeholder="Faculty Name">
                                                    </div>

                                                    <div class="mb-3">
                                                        <label for="example-text-input" class="form-label">Faculty Post:</label>
                                                        <input class="form-control" type="text" value="<?php echo $item_post; ?>" name="item_post" placeholder="Faculty Post">
                                                    </div>

                                                    <div class="mb-3">
                                                        <label for="example-text-input" class="form-label">Faculty Image:</label>
                                                        <input class="form-control" type="file" value="<?php echo $item_img; ?>" name="item_img" placeholder="Gallery Image">
                                                    </div>

                                                    <div class="mt-4">
                                                        <div class="btn_div">
                                                            <button type="submit" name="<?php echo $action; ?>" class="btn btn-primary w-md btn_manage"><?php echo $action_title; ?></button>
                                                        </div>
                                                    </div>
                                                    
                                                </form>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div> <!-- end col -->
                        </div>
                        <!-- end row -->
                        
                    </div> <!-- container-fluid -->
                </div>

    <?php include'right-sidebar.php'; ?>

    <?php include'script.php'; ?>

</body>
</html>

<?php
if (isset($_POST['add_faculty'])){
    $item_name = $_POST['item_name'];
    $item_post = $_POST['item_post'];
    $item_status = 1;

    $itemImgdir = 'faculty-gallery';
    if(!is_dir($itemImgdir)){
        mkdir($itemImgdir);
    }

    $item_img = $_FILES['item_img']['name'];
    $tmp_img = $_FILES['item_img']['tmp_name'];

    // echo $item_img = $_FILES['item_img']['name'];
    // echo "<br>";
    // echo $tmp_img = $_FILES['item_img']['tmp_name'];
    // echo "<br>";
    // echo $tmp_img = $_FILES['item_img']['error'];
    // echo "<br>";

    $itemImg_path = $itemImgdir ."/". $item_img;

    if(move_uploaded_file($tmp_img, $itemImg_path)){
        echo '<script>alert("Faculty Image uploaded.")</script>';
    }
    else{
        echo '<script>alert("Faculty Image not uploaded.")</script>';
    }

    echo $insert_query = "insert into faculty() values('', '$item_name', '$item_post', '$item_img', '$item_status')";
    $run_query = mysqli_query($conn, $insert_query) or mysqli_error($conn);

    if ($run_query){ ?>
        <!-- <script>
        var ask = window.confirm('Are you sure you want to Add more faculty?');
        if (ask) { window.alert('data uploaded in Faculty.'); }
        else{ window.alert('data uploaded in Faculty.');
            window.location.href = "faculty-list.php"; }
        </script> -->
    <?php
    }
    else{
        echo '<script>alert("Faculty Details not uploaded in dashboard.")</script>';
    }
}

if (isset($_POST['edit_faculty'])) {
 
    $item_name = $_POST['item_name'];
    $item_post = $_POST['item_post'];
    $ItemImg_Condition = '';

    if ($_FILES['item_img']['name'] != '') {
        $item_img = $_FILES['item_img']['name'];
        $ItemImg_path = 'faculty-gallery/'.$item_img;
        move_uploaded_file($_FILES['item_img']['tmp_name'], $ItemImg_path);
        $ItemImg_Condition = ", faculty_img='$item_img'";
    }

    $update_event = mysqli_query($conn, "UPDATE faculty SET `faculty_name`='$item_name', `faculty_post`='$item_post' $ItemImg_Condition WHERE `faculty_id` = '$edit_id'");
    if ($update_event){
        echo '<script>alert("Faculty data edited.")</script>';
        echo '<script> window.location.href = "faculty-list.php";</script>';
    }
    else{
        echo '<script>alert("Faculty data not edited.")</script>';
    }
}

?>