<?php 
include ("include/makeSession.php");
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
	$dovalue="";
	$doid=$_REQUEST['did'];
	mysqli_query($con,"delete from studentcorner where id='$doid'");
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=studentcorner.php">';
	exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="EditStudentCorner";
	  $doid=$_REQUEST['upid'];
	  $Query=mysqli_query($con,"select * from studentcorner where id='".$_REQUEST['upid']."'");
	  $Row=mysqli_fetch_array($Query);
}else{
 	  $dovalue="StudentCorner";
	  $doid='';  
}
?>
<style>
    
    
</style>
<div class="content-wrapper">
  <!-- Content About Us (Page header) -->
  <section class="content-header">
    <h1> Student Corner <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Student Corner</a></li>
    </ol>
  </section>
  <!-- Main content -->
  <section class="content">
    <div class="row">
      <div class="col-md-12">
	   <?php if(!empty($_SESSION['msg'])){
			  $msg=$_SESSION["msg"];
           echo '<div class="col-md-12">
			<div class="alert alert-success alert-dismissible">
  <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  '.$msg.'
		  </div>'; $_SESSION["msg"]='';} ?>
        <div class="box box-info">
          <div class="box-header">
            <h3 class="box-title"> Student Corner <small></small></h3>
            <!-- tools box -->
            <!--div class="pull-right box-tools">
              <button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>
              <button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>
            </div-->
            <!-- /. tools --> 
          </div>
          <!-- /.box-header -->
          <div class="box-body pad">
            <div class="col-md-8">
              <form method="post" action="action.php" enctype="multipart/form-data"  role="form">
                <input type="hidden"  name="do" value="<?php echo $dovalue;?>" />
                <input type="hidden"  name="doid" value="<?php echo $doid;?>" />
        			  <div class="row">
        			    <div class="col-md-4">
        	          <div class="form-group">
                      <label>Course Name</label>   <br>   
                      <input required type="text" placeholder="Enter Course"  class="form-control" name="coursename" value="" />             
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Year</label>   <br>                                 
                      <input required type="text" placeholder="Enter year"  class="form-control" name="year" value="<?php if(isset($_REQUEST['upid'])){ echo $Row['year'];}?>" />                 
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Semester</label>   <br>                                 
                      <input required type="text" placeholder="Enter semester"  class="form-control" name="semester" value="<?php if(isset($_REQUEST['upid'])){ echo $Row['semester'];}?>" />                 
                    </div>
                  </div>
                </div>
                <div class="row">
                  <div class="col-md-4">
                    <div class="form-group">
                      <label>Paper Code</label>   <br>                                 
                      <input required type="text" placeholder="Enter papercode"  class="form-control" name="papercode" value="<?php if(isset($_REQUEST['upid'])){ echo $Row['papercode'];}?>" />                 
                    </div>
                  </div>
        			    <div class="col-md-4">
          			    <div class="form-group">
                      <label>Title</label>   <br>                                 
                      <input required type="text" placeholder="Enter Heading tag line"  class="form-control" name="title" value="<?php if(isset($_REQUEST['upid'])){ echo $Row['title'];}?>" />                 
                    </div>
                  </div>
                  <div class="col-md-4">
                      <div class="form-group">
                        <label for="image" class="col-sm-6 control-label">Study Material:</label>
                          <input required type="file" name="image"  class="form-control" />
                      </div>                                               
                  </div>
                </div>
                <div class="row"> 
                  <div class="col-md-6">
                    <?php if(isset($_REQUEST['upid'])){ ?>
                      <img src="images/<?php echo $Row['image']; ?>" height="70" width="70"/>           
                    <?php } ?>             
                  </div>
                </div>
                <div class="box-footer">
                  <input type="submit" class="btn btn-primary" value="Save"/>
                  <a href="http://jcboseedu.org/admin/studentcorner.php" class="btn btn-primary">Reset</a>
                </div>
              </form>
            </div>
          </div>
        </div>
        <!-- /.box --> 
      </div>
      <!-- /.col--> 
    </div>
    <!-- ./row --> 
  </section>
  <!-- /.content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">Student Corner - Study Materials</h3>
          </div>
          <!-- /.box-header -->
          <div class="box-body">
            <table id="example1" class="table table-bordered table-striped">
              <thead>
              <tr>                   
                    <th scope="col">Sr no</th>
                    <th scope="col">Course Name</th>
                    <th scope="col">Title</th>
                    <th scope="col">File Name</th>
                    <th scope="col">Action</th>
                  </tr>                
              </thead>
              <tbody> 
                <?php $q=mysqli_query($con,"select * from studentcorner order by id desc");
			  		$i = 1;
	  				  while($r=mysqli_fetch_array($q)){ //echo "<pre>"; print_r($r); ?>
                <tr>
			
                  <td><?php echo $i; ?></td>
                  <td><?=$r['coursename'];?></td> 
                  <td><?=$r['title'];?></td> 
                  <td><?=$r['filename'];?></td> 
                  
                  <td>
                        <a href="?upid=<?php echo $r["id"]; ?>" class="btn btn-primary btn-sm"><i class="fa fa-pencil "></i></a>&nbsp;&nbsp; 
                        <a href="?did=<?php echo $r["id"]; ?>"  class="btn btn-danger btn-sm"><i class="fa fa-times "></i></a></td>
                </tr>
                <?php $i++;} ?>
              </tbody>
            </table>
          </div>
          <!-- /.box-body --> 
        </div>
        <!-- /.box --> 
      </div>
      <!-- /.col --> 
    </div>
    <!-- /.row --> 
  </section>
</div>
<?php include('include/footer.php');?>

<script src="plugins/datatables/jquery.dataTables.min.js"  type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.colVis.min.js"  type="text/javascript"></script>


<script  type="text/javascript">
$(document).ready(function() {
    $('#example1').DataTable( {
    } );
} );
	//$(function () {
	//$("#example1").DataTable();
	
	//});
</script>