<?php
session_start();
include_once 'dbconnection.php';
$permission = $_SESSION['permission'];
if (!isset($_SESSION['username'])) {
header("location: ../404.php");
die();
} else if ($permission == 'admin' || $permission == 'adminstration' || $permission == 'editor' || $permission == 'radwa' || $permission == 'adham') {
$res = mysqli_query($con, "SELECT * FROM admin WHERE username='$_SESSION[username]'");
$userRow = mysqli_fetch_array($res);
$admin = $userRow['username'];
if (isset($_POST['platform'])) {
$admin = $_POST['admin'];
$id = $_POST['name'];
$netflix = $_POST['netflix'];
$shahid = $_POST['shahid'];
$osn = $_POST['osn'];
$artify = $_POST['artify'];
$digitalvirgo = $_POST['digitalvirgo'];
$menassati = $_POST['menassati'];
$aflamuna = $_POST['aflamuna'];
$filmname = mysqli_query($con, "select * from `films` where `id`='{$id}' ");
$film_row = mysqli_fetch_array($filmname);
$film_name = $film_row['film_title'];
$film_name = mysqli_real_escape_string($con, $film_name);
$check = mysqli_query($con, "select * from film_platforms where film_id like '%{$id}%' ");
if (mysqli_num_rows($check) > 0) {
echo "<script>alert('This Film is already exists, please adding a new or update the exist film.. '); </script> ";
} else {
$links = mysqli_query($con, "INSERT INTO `film_platforms` (`id`, `filmname`, `film_id`, `netflix`, `shahid`, `osn`, `artify`, `digitalvirgo`, `menassati`, `aflamuna` ) VALUES (NULL, '$film_name', '$id', '$netflix', '$shahid', '$osn', '$artify', '$digitalvirgo', '$menassati', '$aflamuna');");
if ($links) {
echo " <script>alert(' Thank you ! The new film platforms has been inserted.. '); document.location.href='platform_edit.php';</script> ";
} else {
echo "<script>alert('The film platforms has not inserted!'); document.location.href='platform_edit.php';</script>";
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<link rel="shortcut icon" href="image/favicon.png">
<meta name="title" content=" ">
<meta name="ROBOTS" content="INDEX,FOLLOW">
<!-- Bootstrap -->
<link href="./css/bootstrap.css" rel="stylesheet">
<!-- Custom styles for this template -->
<link href="./css/stylesheets.css" rel="stylesheet">
<link href="./css/admin.css" rel="stylesheet">
<link href="./css/admin-responsive.css" rel="stylesheet">
</head>
<body>
<div class="container-fluid">
<div class="row">
<div style=" padding: 0px;">
<?php include_once('menu.php'); ?>
</div>
<div class="content" style="padding: 0px;">
<?php include_once('adminheader.php'); ?>
<div class="mainbg">
<div style=" float: right;"><a href="platform_edit.php" class="title2"><button>Back</button></a> </div>
<div class="text-left">
<div class="pagetitle"> Adding the film Platforms links: </div>
</div>
<div style="margin-bottom:40px; ">
<form name="form1" method="post" enctype="multipart/form-data">
<table width="100%" border="0" cellpadding="3" cellspacing="1">
<tr style="display:none">
<td class="titletextbold" style="padding-top:40px;">Name of admins</td>
</tr>
<tr style="display:none" align="left">
<td style="padding-top:5px;"><input name="admin" type="text" value="<?= $admin ?>" class="inboxstyle2"></td>
</tr>
<tr>
<td class="titletextbold" style="padding-top:20px;"> Film Title: </td>
</tr>
<tr align="left">
<td class="checkboxinput">
<select name="name" class="multi-choice" required>
<option class="submenu" value=""> Please select the Film </option>
<?php
$filmname = mysqli_query($con, "SELECT * FROM films order by film_title ");
while ($name_result = mysqli_fetch_array($filmname)) { ?>
<option class="submenu" value="<?= $name_result['id']; ?>"> <?= $name_result['film_title']; ?> </option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td class="titletextbold" style="padding-top:20px;"> Netflix Link: </td>
</tr>
<tr>
<td align="left"><input type="text" name="netflix" class="inboxstyle" /></td>
</tr>
<tr>
<td class="titletextbold" style="padding-top:20px;"> Shahid Link: </td>
</tr>
<tr>
<td align="left"><input type="text" name="shahid" class="inboxstyle" /></td>
</tr>
<tr>
<td class="titletextbold" style="padding-top:20px;"> OSN Link: </td>
</tr>
<tr>
<td align="left"><input type="text" name="osn" class="inboxstyle" /></td>
</tr>
<tr>
<td class="titletextbold" style="padding-top:20px;"> Artify Link: </td>
</tr>
<tr>
<td align="left"><input type="text" name="artify" class="inboxstyle" /></td>
</tr>
<tr>
<td class="titletextbold" style="padding-top:20px;"> Digital Virgo Link: </td>
</tr>
<tr>
<td align="left"><input type="text" name="digitalvirgo" class="inboxstyle" /></td>
</tr>
<tr>
<td class="titletextbold" style="padding-top:20px;"> Menassati Link: </td>
</tr>
<tr>
<td align="left"><input type="text" name="menassati" class="inboxstyle" /></td>
</tr>
<tr>
<td class="titletextbold" style="padding-top:20px;"> Aflamuna Link: </td>
</tr>
<tr>
<td align="left"><input type="text" name="aflamuna" class="inboxstyle" /></td>
</tr>
<tr>
<td style="height:30px;"></td>
</tr>
<tr style="padding-top:40px;">
<td align="left"><input type="submit" name="platform" value="Adding The Film Platform" class="loginstyle"></td>
</tr>
</table>
</form>
</div>
</div>
<?php include_once('footer.php'); ?>
</div>
</div>
</div>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="./js/jquery.1.11.3.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="./js/bootstrap.min.js"></script>
<script src='https://cloud.tinymce.com/stable/tinymce.min.js?apiKey=9k4mzrreu3zfafq4tt8xhg19xt6rt0gt05x4et7vqfpu2g5x'></script>
<script src="./js/index.js"></script>
</body>
</html>
<?php } else {
header("location: ../404.php");
die();
}
?>