<?php
include("connection.php");
$query="select * from tbl_result order by res_id desc";
$res=mysqli_query($dbCon,$query);
?>


	<?php include 'header.php';?>

<div class="page-header page-header-light">
    <div class="breadcrumb-line breadcrumb-line-light header-elements-md-inline">
        <div class="d-flex">          
            <a href="#" class="header-elements-toggle text-default d-md-none"><i class="icon-more"></i></a>
        </div>
    </div>
</div>
<!-- /page header -->
<div class="content">
    <!-- Main charts -->
    <div class="row">
        <div class="col-xl-12">
            <!-- Traffic sources -->
            <div class="card">
                <div class="card-header header-elements-inline">
                    <h5 class="card-title">Add Result Link</h5>
                    <h5 class="card-title" id="msg" style="color:orangered;"></h5>
                    <div class="header-elements">
                        <div class="list-icons">
                            <a class="list-icons-item" data-action="collapse"></a>
                            <a class="list-icons-item" data-action="reload" onclick="formrest()"></a>                            
                        </div>
                    </div>
                </div>
                <form action="all.php" method="post" enctype="multipart/form-data" >
                    <div class="card-body">
                       
						
							<div class="form-group">
                            <div class="row">
                                <div class="col-md-12">
								    <label>URL<span class="clcl"> *</span></label>
                                    <input type="url" class="form-control" placeholder="Enter Url" name="link" required />
                                </div>
                            </div>
                        </div>
					
					


                        <div class="text-left">
                            <button type="submit" name="ressubmit" class="btn btn-primary">Save Link</button>
                        </div>
                    </div>
                </form>


                <table class="table datatable-button-init-basic datatable-reorder">
                    <thead>
                        <tr>
                            <th>S.No.</th>
                            <th>Result Link</th>
                            <th>Date</th>
                            <th>Delete</th>
                            
                        </tr>
                    </thead>
                    <tbody>
					<?php
					$a=1;
					while($row=mysqli_fetch_array($res))
					{
					?>
                        <tr>
                            <td><?php echo $a;$a++;?></td>
                            <td><a href="<?php echo $row['link'] ?>" target="_blank"><?php echo $row['link'] ?></a></td>
                            <td><?php echo $row['date']; ?></td>
                            <td><a href="delresult.php?id=<?php echo $row['res_id'];?>" id="del"> Delete</a></td>
							</tr>
							<?php
					        }
							?>                                  
                    </tbody>
                </table>
                <!-- /traffic sources -->
            </div>
        </div>
    </div>
    <!-- /main charts -->
    <!-- Dashboard content -->
    <!-- /dashboard content -->
</div>





<!-- Modal -->
<div class="modal fade" id="editvideomodal" tabindex="-1" role="dialog" aria-labelledby="editvideomodal" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Update Video Info</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <form method="post" action="all.php" enctype="multipart/form-data">
      <div class="modal-body">

		  					<input type="hidden" name="editvid" id="editv_id"/>
                        <div class="form-group">
                            <div class="row">
                                <div class="col-md-6">
                                    <label>Title<span class="clcl"> *</span></label>
                                    <input type="text" class="form-control" name="titleedit" id="title" placeholder="Title"  autocomplete="off" required />
                                </div>
								
                                <div class="col-md-6">
                                     
									 <label>URL<span class="clcl"> *</span></label>
                                    <input type="text" class="form-control" name="urledit" id="url" placeholder="URL"  autocomplete="off" required />	
                                    
                                </div>
								    <div class="col-md-6">
                                     
									 <label>Subject<span class="clcl"> *</span></label>
                                    <input type="text" class="form-control" name="subedit" id="subject" placeholder="subject"  autocomplete="off" required />	
                                    
                                </div>
								<div class="col-md-6">
								 <label>Branch<span class="clcl"> *</span></label>
                                    <select name="branchedit" class="form-control" required>
                                        <option  disabled selected hidden id="bselected" value=""></option>
                                        <!-----PHP CODE----->
										 <?php
										 $q="select * from tbl_department";
										 $resdep=mysqli_query($dbCon,$q);
										 while($v=mysqli_fetch_array($resdep))
										 {
										 
										 ?>
			
										 <option value="<?php echo $v['dept_id'];?>"><?php echo $v['dept_name'] ?></option>
											
										<?php 
										 }
										?>
										
										

                                    </select>
								
								</div>
								<div class="col-md-6">
								<label>Year<span class="clcl"> *</span></label>
                                   	<select name="yearedit" class="form-control" required>
                                        <option  disabled selected hidden id="yselected" value=""></option>
                                        <option value="1st">1st</option>
                                        <option value="2nd">2nd</option>
                                        <option value="3rd">3rd</option>
                                    </select>
								</div>
								
                            </div>
                        </div>
                       

                  
                 
               
      </div>
      <div class="modal-footer">
        <button type="reset" class="btn btn-secondary" data-dismiss="modal">Reset</button>
        <button type="Submit" class="btn btn-primary" name="EditVideo">Save changes</button>
      </div>
      </form>
    </div>
  </div>
</div>















<script>
    jQuery(document).ready(function () {

        jQuery("#msg").fadeIn("fast");
        jQuery("#msg").fadeOut(20000);
    });
</script>
<script>
    function deluser(p) {
        var id = jQuery(p).next().text();
        var status = confirm("Do you want to delete record?");
        if (status == true) {
            window.location.href = '../Admin/delnotice?id=' + id;
        }
    }
	
	
	    function editvideo(p){
    
      var a=p.value;
      // alert(a);
       jQuery.ajax({
           url:"fetchrecord.php",
           method:"post",
           data:{t:'videoupdate',id:a},    //edit
           
           beforeSend:function(){
               p.innerText="Please Wait....";
           },
           success:function(v){
              //alert(v);
               var a=JSON.parse(v);
               p.innerText="Edit";
              console.log(a);
           $('#editv_id').val(a.v_id);
			$('#title').val(a.title);
			$('#url').val(a.url);
			$('#subject').val(a.subject);
			
			$('#bselected').text(a.dept_name);
			
			$('#yselected').text(a.year);
               $('#editvideomodal').modal('toggle');
           }
       });
    }
	
	
	
	
	
	
	
	
	
</script>           
          	<?php include 'footer.php';?>