<?php
$values = $_GET['Username'];
  include 'connection.php';
  
  //course
if(isset($_POST['update7']))
{
    $id = isset($_POST['Course_sno'])?$_POST['Course_sno']:null;
    $CourseCategory = isset($_POST['Course_Category'])?$_POST['Course_Category']:null;
    $CourseName1 = isset($_POST['Course_name'])?$_POST['Course_name']:null;
    $CourseShort =  isset($_POST['course_short'])?$_POST['course_short']:null;
    $CourseLong = isset($_POST['course_long'])?$_POST['course_long']:null;
    $CourseShortImage = $_FILES['course_short_img']['name']; 
    $tempimgname1= $_FILES['course_short_img']['tmp_name'];
    $CourseLongImage = $_FILES['course_long_img']['name']; 
    $tempimgname2= $_FILES['course_long_img']['tmp_name'];
    $CourseFees = isset($_POST['course_fees'])?$_POST['course_fees']:null;
    $CourseDuration = isset($_POST['course_duration'])?$_POST['course_duration']:null;
    $CourseType = isset($_POST['course_type'])?$_POST['course_type']:null; 
  	move_uploaded_file($tempimgname1,"../img/$CourseShortImage");
    move_uploaded_file($tempimgname2,"../img/$CourseLongImage");
  
  $result = mysqli_query($sql_con, "UPDATE `course` SET `Sno`='$id',`Course_Category`='$CourseCategory', `Course_Name`='$CourseName1', `CourseShortDetail`='$CourseShort', `CourseLongDetail`='$CourseLong', `CourseShortImage`='$CourseShortImage', `CourseLongImage`='$CourseLongImage',`CourseFees`='$CourseFees ', `CourseDuration`=' $CourseDuration ', `CourseType`='$CourseType' WHERE Sno='$id'"); 

}
if(isset($_POST['delete7']))
{
  	$id = isset($_POST['Course_sno'])?$_POST['Course_sno']:null;
	$result1 = mysqli_query($sql_con,"DELETE FROM `course` WHERE Sno='$id'");

}
  
?>


<!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">
    <title>FINAL HOPE INSTITUTE</title>
    <!-- ================= Favicon ================== -->
    <!-- Standard -->
    <link rel="shortcut icon" href="http://placehold.it/64.png/000/fff">
    <!-- Retina iPad Touch Icon-->
    <link rel="apple-touch-icon" sizes="144x144" href="http://placehold.it/144.png/000/fff">
    <!-- Retina iPhone Touch Icon-->
    <link rel="apple-touch-icon" sizes="114x114" href="http://placehold.it/114.png/000/fff">
    <!-- Standard iPad Touch Icon-->
    <link rel="apple-touch-icon" sizes="72x72" href="http://placehold.it/72.png/000/fff">
    <!-- Standard iPhone Touch Icon-->
    <link rel="apple-touch-icon" sizes="57x57" href="http://placehold.it/57.png/000/fff">
    <!-- Styles -->
    <link href="assets/css/lib/select2/select2.min.css" rel="stylesheet">
    <link href="assets/css/lib/font-awesome.min.css" rel="stylesheet">
    <link href="assets/css/lib/themify-icons.css" rel="stylesheet">
    <link href="assets/css/lib/menubar/sidebar.css" rel="stylesheet">
    <link href="assets/css/lib/bootstrap.min.css" rel="stylesheet">
    <link href="assets/css/lib/helper.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">
</head>

<body>
    
	      	    <div class="sidebar sidebar-hide-to-small sidebar-shrink sidebar-gestures">
            <div class="nano">
                <div class="nano-content">
                    <div class="logo"><a href="address.php?Username=<?php echo $values; ?>"><!-- <img src="assets/images/logo.png" alt="" /> --><span>FINAL HOPE INSTITUTE</span></a></div>
                    <ul>
                       
                       
                           
                             <li><a href="course.php?Username=<?php echo $values; ?>">Courses</a></li>
                      <li><a href="contact.php?Username=<?php echo $values; ?>">Contact Form</a></li>
                      <li><a href="enquiry.php?Username=<?php echo $values; ?>">Free Demo</a></li>
                      <li><a href="address.php?Username=<?php echo $values; ?>">Address Master</a></li>
                      <li><a href="link.php?Username=<?php echo $values; ?>"> Link Master</a></li>
                      <li><a href="team.php?Username=<?php echo $values; ?>">Team Master</a></li>
                      <li><a href="gallery.php?Username=<?php echo $values; ?>">Gallery Master</a></li>
                      <li><a href="testimonial.php?Username=<?php echo $values; ?>">Testimonial Master</a></li>
                      <li><a href="blog.php?Username=<?php echo $values; ?>">Blog Master</a></li>
                      <li><a href="placement.php?Username=<?php echo $values; ?>">Placement Master</a></li>
                      <li><a href="afflication.php?Username=<?php echo $values; ?>">Afflication Master</a></li>
                      <li><a href="certificate.php?Username=<?php echo $values; ?>">Certificate</a></li>
                      
                       
                        <li style="display:none;"><a class="sidebar-sub-toggle"><i class="ti-layout"></i>Admission Master <span class="sidebar-collapse-icon ti-angle-down"></span></a>
                            <ul>
                                <li><a href="personal.php?branch=<?php echo $values; ?>">Personal Info</a></li>
                                <li><a href="bank.php?branch=<?php echo $values; ?>">Bank Detail</a></li>
                                
                                <li><a href="course-admin.php?branch=<?php echo $values; ?>">Course Detail</a></li>
                                 <li><a href="fee.php?branch=<?php echo $values; ?>">Fees Detail</a></li>
                            </ul>
                        </li>
                        <li style="display:none;"><a class="sidebar-sub-toggle"><i class="ti-panel"></i>Inquiry <span class="sidebar-collapse-icon ti-angle-down"></span></a>
                            <ul>
                                <li><a href="inquiry.php?branch=<?php echo $values; ?>">Inquiry Form</a></li>
                                <li><a href="inquiry-report.php?branch=<?php echo $values; ?>">All Inquiry Report</a></li>
                                <li><a href="converted.php?branch=<?php echo $values; ?>">Converted</a></li>
                                <li><a href="not-converted.php?branch=<?php echo $values; ?>">Not Converted</a></li>
                            </ul>
                        </li>
                        <li style="display:none;"><a class="sidebar-sub-toggle"><i class="ti-layout-grid4-alt"></i>Fees Master <span class="sidebar-collapse-icon ti-angle-down"></span></a>
                            <ul>
                                <li><a href="create-fee.php?branch=<?php echo $values; ?>">Fees Form</a></li>
                               
                                <li><a href="print-fees.php?branch=<?php echo $values; ?>">All Fees Detail</a></li>
                                <li><a href="due-fees.php?branch=<?php echo $values; ?>">Due Fees Detail</a></li>
                            </ul>
                        </li>
                        <li style="display:none;"><a class="sidebar-sub-toggle"><i class="ti-heart"></i>Document Master <span class="sidebar-collapse-icon ti-angle-down"></span></a>
                            <ul>
                                <li><a href="document.php?branch=<?php echo $values; ?>">Document</a></li>
                                <li><a href="certificate.php?branch=<?php echo $values; ?>">Certificate</a></li>
                                <li><a href="document-records.php?branch=<?php echo $values; ?>">All Document Records</a></li>
                                <li><a href="Certificate-record.php?branch=<?php echo $values; ?>">All Certificate Records</a></li>
                            </ul>
                        </li>
                         <li style="display:none;"><a class="sidebar-sub-toggle"><i class="ti-heart"></i>Certificate Master <span class="sidebar-collapse-icon ti-angle-down"></span></a>
                            <ul>
                                <li><a href="create-certificate.php?branch=<?php echo $values; ?>">Certificate Create</a></li>
                                <li><a href="print-certificate.php?branch=<?php echo $values; ?>">All Certificate Records</a></li>
                            </ul>
                        </li>
                        <li><a href="admin-login.php"><i class="ti-close"></i> Logout</a></li>
                    </ul>
                </div>
            </div>
        </div>
        <!-- /# sidebar -->


                  <div class="header">
                      <div class="container-fluid">
                          <div class="row">
                              <div class="col-lg-12">
                                  <div class="float-left">
                                      <div class="hamburger sidebar-toggle">
                                          <span class="line"></span>
                                          <span class="line"></span>
                                          <span class="line"></span>
                                      </div>
                                  </div>
                                  </div>
                              </div>
                          </div>


                  <div class="content-wrap">
                      <div class="main">
                          <div class="container-fluid">
                              <div class="row">
                                  <div class="col-lg-8 p-r-0 title-margin-right">
                                      <div class="page-header">
                                          <div class="page-title">
                                              <h1>Course Information</h1>
                                          </div>
                                      </div>
                                  </div>

                              </div>
                              <!-- /# row -->
                              <section id="main-content">
                                  <div class="row">
                                      <div class="col-lg-12">
                                          <div class="card">
                                              <div class="card-body">
                                                  <div class="table-responsive">
       
      <table class="table table-bordered">
        <thead>
          <tr>
            <th>Sno</th>
            <th>Course Category</th>
            <th>Course Name</th>
            <th>Course Short Detail</th>
            <th>Course Long Detail</th>
            <th>Course Short Image</th>
            <th>Course Long Image</th>
            <th>Course Fees</th>
            <th>Course Duration</th>
            <th>Course Type</th>
          </tr>
        </thead>
        <tbody>
     
        <?php
            $result = mysqli_query($sql_con,"SELECT * FROM `course`");
            while($row = mysqli_fetch_array($result))
            {
              $ia = $row["Sno"];
              $CourseCategory = $row["Course_Category"];
              $CourseName1 = $row["Course_Name"];
              $CourseShort = $row["CourseShortDetail"];
              $CourseLong = $row["CourseLongDetail"];
              $CourseShortImage = $row['CourseShortImage'];
              $CourseLongImage = $row['CourseLongImage'];
              $CourseFees = $row['CourseFees'];
              $CourseDuration = $row['CourseDuration'];
              $CourseType = $row['CourseType'];
         ?>
   	<tr>
    	<td><?php echo $ia;?></td>
    	<td><?php echo $CourseCategory;?></td>
		<td><?php echo $CourseName1;?></td>
        <td><?php echo $CourseShort; ?></td>
        <td><?php echo $CourseLong;?></td>
        <td><img src="../img/<?php echo $CourseShortImage;?>" style="height: 50px;"></td>
        <td><img src="../img/<?php echo $CourseLongImage;?>" style="height: 50px;"></td>
        <td><?php echo $CourseFees;?></td>
        <td><?php echo $CourseDuration;?></td>
        <td><?php echo $CourseType;?></td>
      
        <td><button type="button" class="btn btn-primary" data-toggle="modal" onclick="document.getElementById('course_id11').value = '<?php echo $ia; ?>';document.getElementById('Course_Category').value = '<?php echo $CourseCategory; ?>';document.getElementById('Course_name').value = '<?php echo $CourseName1; ?>';document.getElementById('course_short').value = '<?php echo $CourseShort; ?>';document.getElementById('course_long').value = '<?php echo $CourseLong; ?>';document.getElementById('coursefee').value = '<?php echo $CourseFees; ?>';document.getElementById('course_duration').value = '<?php echo $CourseDuration; ?>';document.getElementById('course_type').value = '<?php echo $CourseType; ?>';document.getElementById('course_short_img').value = '<?php echo $CourseShortImage; ?>';document.getElementById('course_long_img').value = '<?php echo $CourseLongImage; ?>';"
data-target="#myModa25">Details
    </button></td>
     
 <!--  <td><button type="button" class="btn btn-primary" data-toggle="modal" onclick="document.getElementById('course_id11').value = '< ?php echo $ia; ?>';document.getElementById('Course_Category').value = '< ?php echo $CourseCategory; ?>';document.getElementById('Course_name').value = '< ?php echo $CourseName1; ?>';document.getElementById('course_short').value = '< ?php echo $CourseShort; ?>';document.getElementById('course_long').value = '< ?php echo $CourseLong; ?>';document.getElementById('course_short_img').value = '< ?php echo $CourseShortImage; ?>';document.getElementById('course_long_img').value = '< ?php echo $CourseLongImage; ?>';document.getElementById('coursefee').value = '< ?php echo $CourseFees; ?>';document.getElementById('course_duration').value = '< ?php echo $CourseDuration; ?>';document.getElementById('course_type').value = '< ?php echo $CourseType; ?>';"data-target="#myModa25">Details</button></td> -->
          </tr>
  <?php
}
    ?>
        
    </tbody>
  </table>
  <div class="container">
  

  <!-- The Modal -->
  <div class="modal fade" id="myModa25" >
    <div class="modal-dialog modal-lg">
      <div class="modal-content">
      
        <!-- Modal Header -->
        <div class="modal-header">
          <h4 class="modal-title">Course Information</h4>
          <button type="button" class="close" data-dismiss="modal">&times;</button>
        </div>
        
        <!-- Modal body -->
        <div class="modal-body" style="margin-top: 30%;">
          <div class="container">

          <form method="post" enctype="multipart/form-data">
            <div class="form-group has-warning" style="width:65%">
              <label for="day1">S.No </label>
              <input type="text" class="form-control" id="course_id11" placeholder="S.no" name="Course_sno">
            </div> 
			 <div class="form-group has-warning" style="width:65%">
            <label for="day1">Course Name </label>
            <input type="text" class="form-control" id="Course_name" placeholder="Course Name" name="Course_name">
            </div> 
            <div class="form-group has-warning" style="width:65%">
              <label for="Date">Course Category</label>
              <input type="text" class="form-control" id="Course_Category" placeholder="Course Category" name="Course_Category">
            </div>  
            <div class="form-group has-warning" style="width:65%">
              <label for="day1"> Course Short Detail</label>
              <textarea class="form-control" rows="2" name="course_short" id="course_short"></textarea>
            </div> 
            <div class="form-group has-error" style="width:65%">
              <label for="time1">Course Long Detail </label>
              <textarea class="form-control" rows="2" name="course_long" id="course_long"></textarea>
            </div>
            <div class="form-group has-error" style="width:65%">
              <label for="time1">Course Fees</label>
              <input type="text" class="form-control" id="coursefee" placeholder="Course Fees" name="course_fees">
            </div>
            <div class="form-group has-error" style="width:65%">
              <label for="time1">Course Duration</label>
              <input type="text" class="form-control" id="course_duration" placeholder="Course Duration" name="course_duration">
            </div>
            <div class="form-group has-error" style="width:65%">
              <label for="time1">Course Type</label>
              <input type="text" class="form-control" id="course_type" placeholder="Course Type" name="course_type">
            </div>
            <div class="form-group">
              <label for="Inputselect">Course short image : </label>

              <input type="file" name="course_short_img"  id="course_short_img" />
            </div> 
            <div class="form-group">
              <label for="Inputselect">Course Long image : </label>
              <input type="file"  id="course_long_img" name="course_long_img" />
            </div>  

            <button type="submit" class="btn btn-info" name="update7">Update Course</button>
            <button type="submit" class="btn btn-info" name="delete7">Delete Course</button>

            </form>
        </div>
        </div>
        
        <!-- Modal footer -->
        <div class="modal-footer">
          <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
        </div>

        </div>
      </div>
    </div>

  </div>

                                  </div>
                              </div>
                          </div>
                      </div>
                </div>
                    <div class="row">
                        <div class="col-lg-6">
                            <div class="footer">
                                <p>All right reserved by- <a href="">Final Hope Institute</a> 
                            </div>
                        </div>
                        <div class="col-lg-6">
                            <div class="footer" style="text-align: right;">
                                <p style="text-align: right;">Managed By- <a href="https://www.kiyanchsolutions.com/" target="_blank">Kiyan Ch Solutions</a> 
                            </div>
                        </div>
                    </div>
                </section>
            </div>
        </div>
    </div>
    
    <!-- jquery vendor -->
    <script src="assets/js/lib/jquery.min.js"></script>
    <script src="assets/js/lib/jquery.nanoscroller.min.js"></script>
    <!-- nano scroller -->
    <script src="assets/js/lib/menubar/sidebar.js"></script>
    <script src="assets/js/lib/preloader/pace.min.js"></script>
    <!-- sidebar -->
    
    <!-- bootstrap -->
    <!-- Select2 -->
    <script src="assets/js/lib/select2/select2.full.min.js"></script>
    <script src="assets/js/lib/form-validation/jquery.validate.min.js"></script>
    <script src="assets/js/lib/form-validation/jquery.validate-init.js"></script>
    <script src="assets/js/lib/bootstrap.min.js"></script><script src="assets/js/scripts.js"></script>
    <!-- scripit init-->
</body>

</html>