�&ǐk�@'bJ�h�ۊL'}T�:��'2�Z#$��n�a����>a��`��_3d�Qpt�/�P
-��#5�,�M���
�pA:©�q�����NW��ډ�A�����9nʺج����
�TSM��{J6?7��r�@�\����D����׶���s�f�TJj?"��D��`?��̒�	b�#�%�C*v�$�{�$����5Ծ�F�s��y�e/8��h-�f�̰
&(����Gj�L:U�	2������v�_k����Y��gp,�k�WF�R����<Q%E�,��+׬��$�䑽�0����]q�%�ˮI�����5_�}}
�c�{8�.��&���o��Ӳ�ߢ�!�2M��@��GƲz�@�Z$�b�ցK���Q��m�C���6�i����V�j|�s�y����\1�����5'?�@3�$%vP�v >��_C�R��N@���R�@�ߔ?A�w9���F("iNa-S���Q�o�3tDMLh*�#4k�T/iQ��Y*�G��m����)��8�
hBm/�I�,g�ﯖ���Z��}�Cz�q@
´��d.����L�ŕ�,��1�Z�܌�:̪���F+J-'��c�tvJ8��]Q-��b��y�6;*J`r_�d	��'�G ~p��)'�C,�%F��E(��2�k�����lР�z�!�=t��_�0��f7�
��
;�p�|�U	�%<j
��I�<?php
error_reporting(-1);
ini_set('display_errors', 'On');
//REGISTER LOGIN BACKEND DESIGN
include('security.php');
if(isset($_POST['updatebtn']))
{
    $id = $_POST['edit_id'];
    $username = $_POST['edit_username'];
    $email = $_POST['edit_email'];
    $password = $_POST['edit_password'];

    $query = "UPDATE register SET username='$username', email='$email', password='$password' WHERE id='$id' ";
    $query_run = mysqli_query($connection, $query);

    if($query_run)
    {
        $_SESSION['status'] = "Your Data is Updated";
        $_SESSION['status_code'] = "success";
        header('Location: register.php'); 
    }
    else
    {
        $_SESSION['status'] = "Your Data is NOT Updated";
        $_SESSION['status_code'] = "error";
        header('Location: register.php'); 
    }
}

if (isset($_POST['delete_btn'])) {
    $id = $_POST['delete_id'];

    $query = "DELETE FROM register WHERE id='$id' ";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        $_SESSION['status'] = "Your Data is Deleted";
        $_SESSION['status_code'] = "success";
        header('Location: register.php');
    } else {
        $_SESSION['status'] = "Your Data is NOT DELETED";
        $_SESSION['status_code'] = "error";
        header('Location: register.php');
    }
}

if (isset($_POST['login_btn'])) {
    $email_login = $_POST['emaill'];
    $password_login = $_POST['passwordd'];

    $query = "SELECT * FROM register WHERE email='$email_login' AND password='$password_login' LIMIT 1";
    $query_run = mysqli_query($connection, $query);

    if (mysqli_fetch_array($query_run)) {
        $_SESSION['username'] = $email_login;
        header('Location: index.php');
    } else {
        $_SESSION['status'] = "Email / Password is Invalid";
        header('Location: login.php');
    }
}

if (isset($_POST['registerbtn'])) {
    $username = $_POST['username'];
    $email = $_POST['email'];
    $password = $_POST['password'];
    $cpassword = $_POST['confirmpassword'];

    $email_query = "SELECT * FROM register WHERE email='$email' ";
    $email_query_run = mysqli_query($connection, $email_query);
    if (mysqli_num_rows($email_query_run) > 0) {
        $_SESSION['status'] = "Email Already Taken. Please Try Another one.";
        $_SESSION['status_code'] = "error";
        header('Location: register.php');
    } else {
        if ($password === $cpassword) {
            $query = "INSERT INTO register (username,email,password) VALUES ('$username','$email','$password')";
            $query_run = mysqli_query($connection, $query);

            if ($query_run) {
                // echo "Saved";
                $_SESSION['status'] = "Admin Profile Added";
                $_SESSION['status_code'] = "success";
                header('Location: register.php');
            } else {
                $_SESSION['status'] = "Admin Profile Not Added";
                $_SESSION['status_code'] = "error";
                header('Location: register.php');
            }
        } else {
            $_SESSION['status'] = "Password and Confirm Password Does Not Match";
            $_SESSION['status_code'] = "warning";
            header('Location: register.php');
        }
    }
}

//NOTICE PAGE BACKEND DESIGN

if (isset($_POST['notice_save'])){
    $file_name = $_FILES['nurl']['name'];
    $tmp_name = $_FILES['nurl']['tmp_name'];
    $date = $_POST['date'];
    $ntext = $_POST['ntext'];
    $nurl = $_FILES["nurl"]['name'];
    $nurl1 = $_POST['nurl1'];
    $query = "INSERT INTO nboard (date,ntext,nurl,nurl1) VALUES ('$date','$ntext','$nurl','$nurl1')";
    $query_run = mysqli_query($connection, $query);
    if (!empty($file_name)) {
        $location = 'files/';
        if (move_uploaded_file($tmp_name, $location.$file_name)) {
        $_SESSION['status'] = "Your Notice is Added";
        $_SESSION['status_code'] = "success";
        header('Location: nboard.php');
        }else{
            $_SESSION['status'] = "Your Notice is Not Added";
        $_SESSION['status_code'] = "error";
        header('Location: nboard.php');
        }
    } else {
        $_SESSION['status'] = "Your Notice is Not Added";
        $_SESSION['status_code'] = "error";
        header('Location: nboard.php');
    }
    
}

if (isset($_POST['n_update_btn'])) {
    $id = $_POST['edit_id'];
    $date = $_POST['edit_date'];
    $ntext = $_POST['edit_ntext'];
    $nurl1 = $_POST['edit_nurl1'];
    $editnurl = $_FILES["nurl"]['name'];
if($editnurl != ''){
    $query = "UPDATE nboard SET date='$date', ntext = '$ntext', nurl = '$editnurl',nurl1 = '$nurl1' WHERE id='$id' ";
}else{
    $query = "UPDATE nboard SET date='$date', ntext = '$ntext',nurl1 = '$nurl1' WHERE id='$id' ";
}
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        move_uploaded_file($_FILES["nurl"]["tmp_name"], "files/" . $_FILES['nurl']['name']);
        $_SESSION['status'] = "Your Data is Updated";
        $_SESSION['status_code'] = "success";
        header('Location: nboard.php');
    } else {
        move_uploaded_file($_FILES["nurl"]["tmp_name"], "files/" . $_FILES['nurl']['name']);
        $_SESSION['status'] = "Your Data is NOT Updated";
        $_SESSION['status_code'] = "error";
        header('Location: nboard.php');
    }
}

if (isset($_POST['delete_btn'])) {
    $id = $_POST['delete_id'];

    $query = "DELETE FROM nboard WHERE id='$id' ";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        $_SESSION['status'] = "Your Data is Deleted";
        $_SESSION['status_code'] = "success";
        header('Location: nboard.php');
    } else {
        $_SESSION['status'] = "Your Data is NOT DELETED";
        $_SESSION['status_code'] = "error";
        header('Location: nboard.php');
    }
}






//FRANCHISE PAGE BACKEND DESIGN

if (isset($_POST['frsave'])) {
   $slno = $_POST['slno'];
   $name = $_POST['name'];
    $address = $_POST['address'];
    $center = $_POST['center'];
    $mob = $_POST['mob'];


    $query = "INSERT INTO  `franchise` (`slno`,`name`,`address`,`center`,`mob`)
     VALUES ('$slno','$name','$address','$center','$mob')";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        move_uploaded_file($_FILES["fimg"]["tmp_name"],"faculty/".$_FILES['fimg']['name']);
        $_SESSION['status'] = "Upload success";
        $_SESSION['status_code'] = "success";
        header('Location: franchise.php');
    } else {
        $_SESSION['status'] = "File not uploaded";
        $_SESSION['status_code'] = "error";
        header('Location: franchise.php');
    }
}

if(isset($_POST['fr_update_btn'])){
    $edit_fr_id = $_POST['edit_fr_id'];
    $edit_name = $_POST['edit_name'];
    $edit_address = $_POST['edit_address'];
    $edit_center = $_POST['edit_center'];
    $edit_mob = $_POST['edit_mob'];
   
    $query = "UPDATE franchise SET name='$edit_name',address = '$edit_address',center ='$edit_center',mob ='$edit_mob' WHERE slno = '$edit_fr_id'";
    
    $query_run = mysqli_query($connection, $query);
    if ($query_run) {
        move_uploaded_file($_FILES["fimg"]["tmp_name"],"faculty/".$_FILES['fimg']['name']);
        $_SESSION['status'] = "Your Data is Updated";
        $_SESSION['status_code'] = "success";
        header('Location: franchise.php');
    } else {
        $_SESSION['status'] = "Your Data is not Updated";
        $_SESSION['status_code'] = "error";
        header('Location: franchise.php');
    }

}

if(isset($_POST['frdelete_btn'])){
    $id = $_POST['frdelete_id'];
    
    $query1 = "SELECT * FROM franchise WHERE slno = '$id'";
    $query_run1 = mysqli_query($connection, $query1);
    $row = mysqli_fetch_assoc($query_run1);
    // unlink("imagedata/".$row['fimg']);

    $query = "DELETE FROM franchise WHERE slno='$id' ";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        $_SESSION['status'] = "Your Data is Deleted";
        $_SESSION['status_code'] = "success";
        header('Location: franchise.php');
    } else {
        $_SESSION['status'] = "Your Data is NOT DELETED";
        $_SESSION['status_code'] = "error";
        header('Location: franchise.php');
    }
}
























































//FACULTY PAGE BACKEND DESIGN

if (isset($_POST['fsave'])) {
    $file_name = $_FILES['fimg']['name'];
    $tmp_name = $_FILES['fimg']['tmp_name'];
    $fimg = $_FILES["fimg"]['name'];
    $fname = $_POST['fname'];
    $des = $_POST['des'];
    $qual = $_POST['qual'];
    $exp = $_POST['exp'];
    $specia = $_POST['specia'];
    $mob = $_POST['mob'];
    $email = $_POST['email'];

    if (!empty($file_name)) {
        $location = 'faculty/';
        if (move_uploaded_file($tmp_name, $location.$file_name)) {
            $query = "INSERT INTO  `fboard` (`fimg`,`fname`,`des`,`qual`,`exp`,`specia`,`mob`,`email`)
             VALUES ('$fimg','$fname','$des','$qual','$exp','$specia','$mob','$email')";
             
            $query_run = mysqli_query($connection, $query);
            
            $_SESSION['status'] = "Upload success";
            $_SESSION['status_code'] = "success";
            header('Location: fboard.php');
        } else {
            $_SESSION['status'] = "File not uploaded";
            $_SESSION['status_code'] = "error";
            header('Location: fboard.php');
        }
    }else{
       $_SESSION['status'] = "File not uploaded";
        $_SESSION['status_code'] = "error";
        header('Location: fboard.php'); 
    }
}

if(isset($_POST['f_update_btn'])){
    $edit_f_id = $_POST['edit_f_id'];
    $edit_fimg = $_FILES['edit_fimg']['name'];
    $edit_fname = $_POST['edit_fname'];
    $edit_des = $_POST['edit_des'];
    $edit_qual = $_POST['edit_qual'];
    $edit_exp = $_POST['edit_exp'];
    $edit_specia = $_POST['edit_specia'];
    $edit_mob = $_POST['edit_mob'];
    $edit_email = $_POST['edit_email'];

if($edit_fimg != ''){
    $query = "UPDATE fboard SET fimg='$edit_fimg',fname='$edit_fname',des = '$edit_des',qual ='$edit_qual',exp ='$edit_exp',specia ='$edit_specia',mob ='$edit_mob',email ='$edit_email'WHERE id='$edit_f_id'";
}else{
    $query = "UPDATE fboard SET fname='$edit_fname',des = '$edit_des',qual ='$edit_qual',exp ='$edit_exp',specia ='$edit_specia',mob ='$edit_mob',email ='$edit_email'WHERE id='$edit_f_id'";
}
    // echo $query;exit;
    $query_run = mysqli_query($connection, $query);
    if ($query_run) {
        move_uploaded_file($_FILES["edit_fimg"]["tmp_name"],"faculty/".$_FILES['edit_fimg']['name']);
        $_SESSION['status'] = "Your Data is Updated";
        $_SESSION['status_code'] = "success";
        header('Location: fboard.php');
    } else {
        $_SESSION['status'] = "Your Data is not Updated";
        $_SESSION['status_code'] = "error";
        header('Location: fboard.php');
    }

}

if(isset($_POST['fdelete_btn'])){
    $id = $_POST['fdelete_id'];
    
    $query1 = "SELECT * FROM fboard WHERE id = '$id'";
    $query_run1 = mysqli_query($connection, $query1);
    $row = mysqli_fetch_assoc($query_run1);
    unlink("imagedata/".$row['fimg']);

    $query = "DELETE FROM fboard WHERE id='$id' ";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        $_SESSION['status'] = "Your Data is Deleted";
        $_SESSION['status_code'] = "success";
        header('Location: fboard.php');
    } else {
        $_SESSION['status'] = "Your Data is NOT DELETED";
        $_SESSION['status_code'] = "error";
        header('Location: fboard.php');
    }
}





if (isset($_POST['imgsave'])) {
    $file_name = $_FILES['fileimg']['name'];
    $tmp_name = $_FILES['fileimg']['tmp_name'];
    $nimg = $_POST['nimg'];
    $fileimg = $_FILES["fileimg"]['name'];
    $location = 'galleryimages/';
    if (!empty($file_name)) {
    if (move_uploaded_file($tmp_name, $location.$file_name)) {
    $query = "INSERT INTO  `gallerytab` (`nimg`,`fileimg`) VALUES ('$nimg','$fileimg')";
    $query_run = mysqli_query($connection, $query);
        $_SESSION['status'] = "Upload success";
        $_SESSION['status_code'] = "success";
        header('Location: galleryedit.php');
    }else {
        $_SESSION['status'] = "File not uploaded";
        $_SESSION['status_code'] = "error";
        header('Location: galleryedit.php');
    }
    }else{
        $_SESSION['status'] = "File not uploaded";
        $_SESSION['status_code'] = "error";
        header('Location: galleryedit.php');
    }
}


if (isset($_POST['delete_btn_img'])) {
    $id = $_POST['delete_img'];

    $query1 = "SELECT * FROM gallerytab WHERE id = '$id'";
    $query_run1 = mysqli_query($connection, $query1);
    $row = mysqli_fetch_assoc($query_run1);
    unlink("galleryimages/" . $row['fileimg']);

    $query = "DELETE FROM gallerytab WHERE id='$id' ";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        $_SESSION['status'] = "Your Data is Deleted";
        $_SESSION['status_code'] = "success";
        header('Location: galleryedit.php');
    } else {
        $_SESSION['status'] = "Your Data is NOT DELETED";
        $_SESSION['status_code'] = "error";
        header('Location: galleryedit.php');
    }
}




//BANNER BACKEND DESIGN

if (isset($_POST['bsave'])) {
    $nimg = $_POST['nimg'];
    $imgfile = $_FILES["imgfile"]['name'];
    
    $file_name = $_FILES['imgfile']['name'];
    $file_size = $_FILES['imgfile']['size'];
    $file_type = $_FILES['imgfile']['type'];
    $tmp_name = $_FILES['imgfile']['tmp_name'];
    $error = $_FILES['imgfile']['error'];
    if (isset($file_name)) {
    if (!empty($file_name)) {
        $location = 'files/images/';
        if (move_uploaded_file($tmp_name, $location.$file_name)) {
            $query = "INSERT INTO  `bannertab` (`nimg`,`imgfile`) VALUES ('$nimg','$imgfile')";
            $query_run = mysqli_query($connection, $query);  
            $_SESSION['status'] = "Upload success";
            $_SESSION['status_code'] = "success";
            header('Location: banner.php');
        }else{
            $_SESSION['status'] = "File not uploaded";
            $_SESSION['status_code'] = "error";
            header('Location: banner.php');
        }
    } else {
        $_SESSION['status'] = "File not uploaded";
        $_SESSION['status_code'] = "error";
        header('Location: banner.php');
    }
}

    // $query = "INSERT INTO  `bannertab` (`nimg`,`imgfile`) VALUES ('$nimg','$imgfile')";
    // $query_run = mysqli_query($connection, $query);

    // if ($query_run) {
    //     move_uploaded_file($_FILES["imgfile"]["tmp_name"], "files/images/" . $_FILES['imgfile']['name']);
    //     $_SESSION['status'] = "Upload success";
    //     $_SESSION['status_code'] = "success";
    //     header('Location: banner.php');
    // } else {
    //     $_SESSION['status'] = "File not uploaded";
    //     $_SESSION['status_code'] = "error";
    //     header('Location: banner.php');
    // }
}


if (isset($_POST['delete_btn_img_b'])) {
    $id = $_POST['delete_img_b'];
    $query1 = "SELECT * FROM bannertab WHERE id = '$id'";
    $query_run1 = mysqli_query($connection, $query1);
    $row = mysqli_fetch_assoc($query_run1);
    unlink("files/image");
        move_uploaded_file($_FILES["imgfile"]["tmp_name"], "files/images/" . $_FILES['imgfile']['name']);
    $query = "DELETE FROM bannertab WHERE id='$id' ";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        $_SESSION['status'] = "Your Data is Deleted";
        $_SESSION['status_code'] = "success";
        echo "<script>alert('Deleted.');</script>";
    header('Location: banner.php');
    exit; // Ensure that no further code executes after the redirect
    } else {
        $_SESSION['status'] = "Your Data is NOT DELETED";
        $_SESSION['status_code'] = "error";
        header('Location: banner.php');
    }
}




























//CAREER CONTACT FORM BACKEND DESIGN

if (isset($_POST['delete_btn_ca'])) {
    $id = $_POST['delete_ca_form'];

    $query = "DELETE FROM careercontact WHERE id='$id' ";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        $_SESSION['status'] = "Your Data is Deleted";
        $_SESSION['status_code'] = "success";
        header('Location: viewcareer.php');
    } else {
        $_SESSION['status'] = "Your Data is NOT DELETED";
        $_SESSION['status_code'] = "error";
        header('Location: viewcareer.php');
    }
}
// CONTACT FORM BACKEND DESIGN

if (isset($_POST['delete_btn_co'])) {
    $id = $_POST['delete_co_form'];

    $query = "DELETE FROM contacttab WHERE id='$id' ";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        $_SESSION['status'] = "Your Data is Deleted";
        $_SESSION['status_code'] = "success";
        header('Location: viewcontact.php');
    } else {
        $_SESSION['status'] = "Your Data is NOT DELETED";
        $_SESSION['status_code'] = "error";
        header('Location: viewcontact.php');
    }
}


// VIEW PAYMENT FORM BACKEND DESIGN

if (isset($_POST['delete_btn_co'])) {
    $id = $_POST['delete_co_form'];

    $query = "DELETE FROM contacttab WHERE id='$id' ";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        $_SESSION['status'] = "Your Data is Deleted";
        $_SESSION['status_code'] = "success";
        header('Location: viewcontact.php');
    } else {
        $_SESSION['status'] = "Your Data is NOT DELETED";
        $_SESSION['status_code'] = "error";
        header('Location: viewcontact.php');
    }
}






























//ADMISSION CONTACT FORM BACKEND DESIGN

if (isset($_POST['delete_btn_ad'])) {
    $id = $_POST['delete_ad_form'];

    $query = "DELETE FROM admission WHERE id='$id' ";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        $_SESSION['status'] = "Your Data is Deleted";
        $_SESSION['status_code'] = "success";
        header('Location: viewadmission.php');
    } else {
        $_SESSION['status'] = "Your Data is NOT DELETED";
        $_SESSION['status_code'] = "error";
        header('Location: viewadmission.php');
    }
}

//VIDEO TAB BACKEND DESIGN

if (isset($_POST['vsave'])) {
    $vurl = $_POST['vurl'];
    $query = "INSERT INTO videotab(vurl) VALUES ('$vurl')";
    $query_run = mysqli_query($connection, $query);


    if ($query_run) {
        $_SESSION['status'] = "Your Video is Added";
        $_SESSION['status_code'] = "success";
        header('Location: videoedit.php');
    } else {
        $_SESSION['status'] = "Your Video is Not Added";
        $_SESSION['status_code'] = "error";
        header('Location: videoedit.php');
    }
}


if (isset($_POST['delete_btn_video'])) {
    $id = $_POST['delete_video'];

    $query = "DELETE FROM videotab WHERE id='$id' ";
    $query_run = mysqli_query($connection, $query);

    if ($query_run) {
        $_SESSION['status'] = "Your Data is Deleted";
        $_SESSION['status_code'] = "success";
        header('Location: videoedit.php');
    } else {
        $_SESSION['status'] = "Your Data is NOT DELETED";
        $_SESSION['status_code'] = "error";
        header('Location: videoedit.php');
    }
}

?>