<?php 
   include('config.php');
   if (!isLoggedIn()) {
		$_SESSION['msg'] = "You must log in first";
		header('location: login.php');
	}
   
   if(isset($_POST['update'])) 
   { 
   
       $id = $_POST['id'];
       $head1 = htmlspecialchars($_POST['head1'],ENT_QUOTES);
       $head2 = htmlspecialchars($_POST['head2'],ENT_QUOTES);
       $text = htmlspecialchars($_POST['text'],ENT_QUOTES);
       $button_link = htmlspecialchars($_POST['button_link'],ENT_QUOTES);
       $meta_title = htmlspecialchars($_POST['meta_title'],ENT_QUOTES);
       $meta_desc = htmlspecialchars($_POST['meta_desc'],ENT_QUOTES);
    //   $logo = $_FILES['logo']['name'];
    //   $slider_img = $_FILES['slider_img']['name'];
    if($_FILES['logo']['name'] == '' && $_FILES['slider_img']['name'] == ''){
        $sql= "UPDATE `home_page` SET `head1`= '$head1',`head2`= '$head2', `text`= '$text',`button_link`= '$button_link', `meta_title`= '$meta_title', `meta_desc`= '$meta_desc' WHERE id = 1";
       // echo "<br> <h1>No image</h1>";
   
       $result = mysqli_query($db, $sql) or die("Query unsuccessful");
       // echo "<br> <h1>No image</h1>";
   
       if($result){
        echo ("<script>
    window.alert('Succesfully Updated');
    window.location.href='manage-home.php';
    </script>");
          
          mysqli_close($db);
    }
  
  else{
        //    header('location:add-sub-course.php');
        echo "Not Sybmitted";
     }
    }
       if($_FILES['logo']['name'] == ''){
        $upload_image2 = $_FILES['slider_img']['name'];
       move_uploaded_file($_FILES['slider_img']['tmp_name'],'../images/'.$_FILES['slider_img']['name']);
        $sql= "UPDATE `home_page` SET `slider_img` = '$upload_image2', `head1`= '$head1',`head2`= '$head2', `text`= '$text',`button_link`= '$button_link', `meta_title`= '$meta_title', `meta_desc`= '$meta_desc' WHERE id = 1";
       // echo "<br> <h1>No image</h1>";
   
       $result = mysqli_query($db, $sql) or die("Query unsuccessful");
       // echo "<br> <h1>No image</h1>";
   
       if($result){
        echo ("<script>
    window.alert('Succesfully Updated');
    window.location.href='manage-home.php';
    </script>");
          
          mysqli_close($db);
       }
       else{
       //    header('location:add-sub-course.php');
       echo "Not Sybmitted";
       }
   
    }
    if($_FILES['slider_img']['name'] == ''){
        $upload_image2 = $_FILES['logo']['name'];
        move_uploaded_file($_FILES['logo']['tmp_name'],'../images/'.$_FILES['logo']['name']);
        $sql= "UPDATE `home_page` SET `logo` = '$upload_image2', `head1`= '$head1',`head2`= '$head2', `text`= '$text',`button_link`= '$button_link', `meta_title`= '$meta_title', `meta_desc`= '$meta_desc' WHERE id = 1";
       // echo "<br> <h1>No image</h1>";
   
       $result = mysqli_query($db, $sql) or die("Query unsuccessful");
       // echo "<br> <h1>No image</h1>";
   
       if($result){
        echo ("<script>
    window.alert('Succesfully Updated');
    window.location.href='manage-home.php';
    </script>");
          
          mysqli_close($db);
       }
       else{
       //    header('location:add-sub-course.php');
       echo "Not Sybmitted";
       }
   
    }else{
       $upload_image1 = $_FILES['logo']['name'];
       $upload_image2 = $_FILES['slider_img']['name'];
       move_uploaded_file($_FILES['logo']['tmp_name'],'../images/'.$_FILES['logo']['name']);
       move_uploaded_file($_FILES['slider_img']['tmp_name'],'../images/'.$_FILES['slider_img']['name']);
        $sql= "UPDATE `home_page` SET `logo` = '$upload_image1',`slider_img` = '$upload_image2',`head1`= '$head1',`head2`= '$head2', `text`= '$text',`button_link`= '$button_link', `meta_title`= '$meta_title', `meta_desc`= '$meta_desc' WHERE id = 1";
       // echo "<br> <h1>image</h1>";
       
      $result1 = mysqli_query($db, $sql) or die("Query unsuccessful");
      if($result1){
        echo ("<script>
        window.alert('Succesfully Updated');
        window.location.href='manage-home.php';
        </script>");
         mysqli_close($db);
      }else{
       //   header('location:add-sub-course.php');
       echo "Not Submitted";
      }
    }
   }

?>
<!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>Admin</title>

    <!-- Custom fonts for this template-->
    <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
    <link
        href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"
        rel="stylesheet">

    <!-- Custom styles for this template-->
    <link href="css/sb-admin-2.min.css" rel="stylesheet">

    <style>
        div.dataTables_wrapper div.dataTables_filter input {
            box-shadow: 0px 0 0 !important;
            transform: translate(-123px,1px);
        }
    </style>

    
    <link href="vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">

</head>

<body id="page-top">

    <!-- Page Wrapper -->
    <div id="wrapper">

       <?php include_once('side-bar.php')?>

        <!-- Content Wrapper -->
        <div id="content-wrapper" class="d-flex flex-column">

            <!-- Main Content -->
            <div id="content">

                <!-- Topbar -->
                <?php include_once('topbar.php')?>
                <!-- End of Topbar -->

                <!-- Begin Page Content -->
                <div class="container-fluid">

                    <!-- Page Heading -->
                    <div class="d-sm-flex align-items-center justify-content-between mb-4">
                        <h1 class="h3 mb-0 text-gray-800">Home</h1>
                    </div>
                    <!-- DataTales Example -->
                    <div class="card shadow mb-4">
                        <div class="card-header py-3">
                            <h6 class="m-0 font-weight-bold text-primary">Home Page Details</h6>
                        </div>
                        <div class="card-body">
                            <div class="container-fluid">
                            
                                <form action="<?php $_PHP_SELF ?>" method="post" enctype="multipart/form-data">
                                <?php 
                                    $sql = "SELECT * FROM home_page WHERE id=1";
                                    $run = mysqli_query($db,$sql) or die("Query Not run");
                                    $data = mysqli_fetch_assoc($run);
                                ?>  
                                    <div class="row">
                                       <input type="text" hidden name="id" value="<?php echo $data['id'];?>"/>
                                        <div class="col">
                                            <div class="form-group">
                                                <label>Logo</label>
                                                <input type="file" class="form-control"  name="logo">
                                                <img width="200px;" src="../images/<?php echo $data['logo'];?>" alt="">
                                            </div>
                                        </div>
                                    </div>
                                    <!--<div class="row">-->
                                    <!--    <div class="col">-->
                                    <!--        <div class="form-group">-->
                                    <!--            <label>Slider Image</label>-->
                                    <!--            <input type="file" class="form-control"  name="slider_img">-->
                                    <!--            <img width="100px;" src="../images/<?php echo $data['slider_img'];?>" alt="">-->
                                    <!--        </div>-->
                                    <!--    </div>-->
                                    <!--</div>-->
                                    <!--<div class="row">-->
                                    <!--    <div class="col">-->
                                    <!--        <div class="form-group">-->
                                    <!--            <label>Heading 1</label>-->
                                    <!--            <input type="text" class="form-control"  name="head1" value="<?php echo $data['head1'];?>">-->
                                    <!--        </div>-->
                                    <!--    </div>-->
                                    <!--</div>-->
                                    <!--<div class="row">-->
                                    <!--    <div class="col">-->
                                    <!--        <div class="form-group">-->
                                    <!--            <label>Heading 2</label>-->
                                    <!--            <input type="text" value="<?php echo $data['head2'];?>" class="form-control" name="head2">-->
                                    <!--        </div>-->
                                    <!--    </div>-->
                                    <!--</div>-->
                                    <!--<div class="row">-->
                                    <!--    <div class="col">-->
                                    <!--        <div class="form-group">-->
                                    <!--            <label>Slider Text</label>-->
                                    <!--            <input type="text" value="<?php echo $data['text'];?>" class="form-control" name="text">-->
                                    <!--        </div>-->
                                    <!--    </div>-->
                                    <!--</div>-->
                                    <!--<div class="row">-->
                                    <!--    <div class="col">-->
                                    <!--        <div class="form-group">-->
                                    <!--            <label>Slider Button Link</label>-->
                                    <!--            <input type="text" value="<?php echo $data['button_link'];?>" class="form-control" name="button_link">-->
                                    <!--        </div>-->
                                    <!--    </div>-->
                                    <!--</div>-->
                                    <?php
                                    if (isset($_SESSION['user']) && $_SESSION['user']['user_type'] == 'supadmin' ) {
                          
                              echo '<div class="row">
                                        <div class="col">
                                            <div class="form-group">
                                                <label>Meta Title</label>
                                                <input type="text" class="form-control" name="meta_title" value="'.$data['meta_title'].'">
                                            </div>
                                        </div>
                                        <div class="col">
                                            <div class="form-group">
                                                <label>Meta Description</label>
                                                <input type="text" class="form-control" name="meta_desc" value="'.$data['meta_desc'].'">
                                            </div>
                                        </div>
                                    </div>';
                                }
                                    ?>
                                    
                                    <div class="row">
                                        <div class="col-12">
                                            <button name="update" type="submit" class="btn btn-success" >Update Details</button>
                                        </div>
                                    </div>
                                </form>
                                
                            </div>
                        </div>
                    </div>


                </div>
                <!-- /.container-fluid -->

            </div>
            
            <!-- End of Main Content -->
            
            <!-- Footer -->
            <?php include_once('footer.php')?>

</body>

</html>