korsygfhrfggfhfgfffgffg6655665dtggggggzangaiide
Elehhjhjjkjkfpf6df56fd65ffff
/
home2
/
sunpublicschools
/
public_html
/
SunShine_AdMin
/
Upload FileeE
HOME
<?php include 'header.php'; include 'config.php'; ?> <div class="content-wrapper"> <div class="page-title"> <div> <p><i class="fa fa-eye"></i> Videos</p> </div> </div> <div class="card"> <?php if(isset($_POST['submit'])) { $vid = $_POST['vid']; $c_int = "INSERT INTO gal_v (vid) VALUES ('$vid')"; $c_rty = mysqli_query($connect,$c_int); if($c_rty) { ?> <div class="alert msg" role="alert" style="text-align: center;color:green;font-size: 20px;margin-top: 21px;"> Inserted Successfully </div> <?php } } ?> <form action="" method="post" enctype="multipart/form-data"> <div class="row"> <div class="col-md-6"> <label>Add Video Url</label> <input type="text" name="vid" class="form-control"> </div> </div> <br> <div class="row"> <div class="col-md-4"> <input type="submit" name="submit" class="btn btn-success" value="Submit"> </div> </div> </form> </div> <div class="card"> <div class="row"> <div class="col-md-12"> <p style="font-weight: bold;color: #1ec351;">Videos</p> </div> </div> <div class="row"> <div class="table-responsive"> <table class="table table-bordered table-striped"> <tr> <th >Videos</th> <th >Edit</th> <th >Delete</th> </tr> <?php $start=0; $limit=10; if(isset($_GET['id'])) { $id=$_GET['id']; $start=($id-1)*$limit; } else { $id=1; $start=($id-1)*$limit; } $query = "SELECT * from gal_v LIMIT $start,$limit"; $result = mysqli_query($connect,$query); while($row = mysqli_fetch_array($result)) { ?> <tr> <td><iframe width="50%" height="200" src="<?php echo $row['vid'];?>" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> </td> <td> <a href="edit_videos.php?id=<?php echo $row['id'];?>"><button data-toggle="tooltip" title="Edit" class="btn btn-green btn-xs"><i class="fa fa-edit"></i></button></a> </td> <td> <a href="delete_videos.php?id=<?php echo $row['id'];?>"><button data-toggle="tooltip" title="Delete" Onclick="return ConfirmDelete()" class="btn btn-danger btn-xs"><i class="fa fa-trash"></i></button></a> </td> </tr> <?php } ?> </table> <?php echo "</ul style='display: inline;'>"; $rows=mysqli_num_rows(mysqli_query($connect,"SELECT * from gal_v")) ; $total=ceil($rows/$limit); if($id >1) { echo "<a href='?id=".($id-1)."' class='button'> PREVIOUS </a>"; } if($id != $total) { echo "<a href='?id=".($id+1)."' class='button'> NEXT </a>"; } echo "<ul class='page'>"; for($i=1;$i<=$total;$i++) { if($i==$id) { echo "<li class='current'>".$i."</li>"; } else { echo "<li><a href='?id=".$i."'>".$i."</a></li>"; } } echo "</ul>"; ?> </div> </div> </div> </div> <script> function ConfirmDelete() { return confirm("Are you sure you want to delete?"); } </script> <script src="js/jquery-2.1.4.min.js"></script> <script src="js/bootstrap.min.js"></script> <script src="js/plugins/pace.min.js"></script> <script src="js/main.js"></script> <script src="//cdn.ckeditor.com/4.9.2/standard/ckeditor.js"></script>