<?php include("header.php");
include("left-menu.php");?>
  <noscript>
            <div class="alert alert-block col-md-12">
                <h4 class="alert-heading">Warning!</h4>

                <p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a>
                    enabled to use this site.</p>
            </div>
        </noscript>

        <div id="content" class="col-lg-10 col-sm-10">
            <!-- content starts -->
            <div>
    <ul class="breadcrumb">
        <li>
            <a href="#">Home</a>
        </li>
        <li>
            <a href="#">SSRG International Journal of Computer Science and Engineering </a>
        </li>
    </ul>
</div>

<div class=" row">
    <div class="col-md-4 col-sm-4 col-xs-12">
        <a data-toggle="tooltip" title="" class="well top-block" href="#">
            <i class="glyphicon glyphicon-home blue"></i>

            <div>2016 Journals</div>
          <?php
              include("config.php");                                     
                                                    $sql = mysqli_query($conn,"select count(sno) as total from `ijcse` where year='2016' ");
                                                        while ($row = mysqli_fetch_array($sql)) {
                                                              
                                                    ?>
													<div><?php echo $row['total']; ?></div>
                     <?php }?>
        </a>
    </div>

    <div class="col-md-4 col-sm-4 col-xs-12">
        <a data-toggle="tooltip" title="" class="well top-block" href="#">
            <i class="glyphicon glyphicon-star green"></i>

            <div>2017 Journals</div>
           <?php
                         
                                                    $sql = mysqli_query($conn,"select count(sno) as total from `ijcse` where year='2017' ");
                                                        while ($row = mysqli_fetch_array($sql)) {
                                                              
                                                    ?>
													<div><?php echo $row['total']; ?></div>
                     <?php }?>
        </a>
    </div>

    <div class="col-md-4 col-sm-4 col-xs-12">
        <a data-toggle="tooltip" title="" class="well top-block" href="#">
            <i class="glyphicon glyphicon-star yellow"></i>

            <div>2018 Journals</div>
             <?php
                                                  
                                                   $sql = mysqli_query($conn,"select count(sno) as total from `ijcse` where year='2018' ");
                                                        while ($row = mysqli_fetch_array($sql)) {
                                                              
                                                    ?>
													<div><?php echo $row['total']; ?></div>
                     <?php }?>
        </a>
    </div>

  
</div>

<div class="row">
    <div class="box col-md-12">
       
 <div class="box-inner">
    <div class="box-header well" data-original-title="">
        <h2><i class="glyphicon glyphicon-home"></i> View D S Journal of Engineering</h2>

        <div class="box-icon">
            <a href="#" class="btn btn-setting btn-round btn-default"><i class="glyphicon glyphicon-cog"></i></a>
            <a href="#" class="btn btn-minimize btn-round btn-default"><i
                    class="glyphicon glyphicon-chevron-up"></i></a>
            <a href="#" class="btn btn-close btn-round btn-default"><i class="glyphicon glyphicon-remove"></i></a>
        </div>
    </div>
    <div class="box-content">
    <div class="alert alert-info"><a class="btn btn-success" href="add_ijcse.php"><i class="glyphicon glyphicon-plus icon-white"></i> Add New IJCSE Information</a></div>
    <table class="table table-striped table-bordered bootstrap-datatable datatable responsive">
    <thead>
    <tr><th>S.NO</th>
	<th>Paper ID</th>
        <th>Volume & Issue</th>
		 <th>Month & Year</th>
        <th>Registered Date </th>
       
        <th>Status</th>
        <th>Actions</th>
    </tr>
    </thead>
    <tbody>
	 <?php   
			
	
		$i=0;
        $sqls = mysqli_query($conn,"select * from `ijcse`  ");
         while ($row = mysqli_fetch_array($sqls)) {
			 $i++;
        	
		 ?>                                      
    <tr> <td class="center"><?php echo $i ?></td>
	<td class="center"><?php echo $row['paperid'] ?></td>
        <td class="center"><?php echo $row['volume']."  ".$row['issue'] ?></td>
        <td class="center"><?php echo $row['month']." - ".$row['year'] ?></td>
		<td class="center"><?php echo $row['reg_date'] ?></td>
		
        <td class="center">
            <span class="label-success label label-default"><?php echo $row['status'] ?></span>
        </td>
        <td class="center">
          <!--  <a class="btn btn-success" href="#">
                <i class="glyphicon glyphicon-zoom-in icon-white"></i>
                View
            </a>-->
            <a class="btn btn-success" href="edit_ijcse.php?pid=<?php echo $row['sno'] ?>">
                <i class="glyphicon glyphicon-edit icon-white"></i>
                Edit
            </a>
			
            <a class="btn btn-success"  onclick='confirmationDelete(this);return false;' href="delete_ijcse.php?pid=<?php echo $row['sno'] ?>" >
                <i class="glyphicon glyphicon-trash icon-white"></i>
                Delete
            </a>
        </td>
    </tr><?php }?>
 
    </tbody></table>
    </div>
    </div>
  </div>
    </div>  
<?php include("footer.php"); ?>