<?php
session_start();

if ($_SESSION["fidx"] == "" || $_SESSION["fidx"] == NULL) {
	header('Location:facultylogin');
}

$userid = $_SESSION["fidx"];
$fname = $_SESSION["fname"];
?>
<?php include('fhead.php');  ?>
<div class="container">
	<div class="row">
		<div class="col-md-12">
			<h3> Welcome Teacher: <a href="welcomefaculty.php"><span style="color:#FF0004"> <?php echo $fname; ?></span></a> </h3>

			<?php
			include("database.php");
			if (isset($_REQUEST['deleteid'])) {

				//getting data from another page
				$deleteid = $_GET['deleteid'];
				$sql = "DELETE FROM `video` WHERE V_id = $deleteid";
				if (mysqli_query($connect, $sql)) {
					echo "
						<br><br>
						<div class='alert alert-success fade in'>
						<a href='#' class='close' data-dismiss='alert' aria-label='close'>&times;</a>
						<strong>Success!</strong> Videos details deleted.
						</div>
						";
				} else {
					//error message if SQL query fails
					echo "<br><Strong>Videos Details Updation Faliure. Try Again</strong><br> Error Details: " . $sql . "<br>" . mysqli_error($connect);
				}
			}
			//close the connection
			mysqli_close($connect);
			?>

			<?php

			include('database.php');
			$sql = "SELECT * FROM video";
			$rs = mysqli_query($connect, $sql);
			echo "<h2 class='page-header'>Videos Details</h2>";
			echo "<table class='table table-striped' style='width:100%'>
				<tr>
					<th>#</th>
					<th>Video Title</th>
					<th>Video URL</th>
					<th>Description</th>
					<th>Actions</th>		
				</tr>";
			$count = 1;
			while ($row = mysqli_fetch_array($rs)) {
			?>
				<tr>
					<td>
						<?PHP echo $count; ?>
					</td>
					<td>
						<?PHP echo $row['V_Title']; ?>
					</td>
					<td>
						<?PHP echo $row['V_Url']; ?>
					</td>
					<td>
						<?PHP echo $row['V_Remarks']; ?>
					</td>

					<td><a href="managevideos.php?deleteid=<?php echo $row['V_id']; ?>"> <input type="button" Value="Delete" class="btn btn-danger btn-sm" style="border-radius:0%" data-toggle="modal" data-target="#myModal"></a>
						<a href="managevideos2.php?editassid=<?php echo $row['V_id']; ?>"> <input type="button" Value="Edit" class="btn btn-success btn-sm" style="border-radius:0%" data-toggle="modal" data-target="#myModal"></a>

					</td>
				</tr>
			<?php
				$count++;
			}
			?>
			</table>

		</div>
	</div>
	<?php include('allfoot.php');  ?>