<?php
session_start();
include "functions.php";
$sql = "SELECT id FROM slide";
$psql = $conn->prepare($sql);
$psql->execute();
$row = $psql->fetchAll();
foreach ($row as $thing) {
$idArray[] = $thing['id'];
}
do {
if ($_SESSION['previous_index'] >= 0 && $_SESSION['previous_index'] < count($idArray) - 1) {
$_SESSION['previous_index']++;
$id = $idArray[$_SESSION['previous_index']];
} else {
$id = $idArray[0];
$_SESSION['previous_index'] = 0;
}
$slide = getSlideById($id);
$expired = expired($slide[0]);
} while ($slide[0]['enabled'] == null || $expired);
$message = "FAILED";
if ($slide != false) {
$message = "Success";
}
echo json_encode(array("id" => $id, "expired" => $expired, "message" => $message, "slide" => $slide));
function publicCoursePanelDispatch($op)
{
switch ($op) {
case "savepanel":
savePanel();
break;
case "coursepanel":
coursePanel();
break;
case "expired":
expired();
break;
case "required":
required();
break;
}
}
<?php
include "includes/header.php";
?>
<!-- function to test for expiring pages -->
<?php
$expired1 = expired("coming_soon_expiry.txt");
$expired2 = expired("coming_soon_expiry2.txt");
function expired($file)
{
$fh = fopen($file, 'r');
$expiry_date = fgets($fh);
fclose($fh);
list($expiry_day, $expiry_month, $expiry_year) = split("/", $expiry_date);
$year = date('Y');
$mon = date('m');
$mday = date('j');
// routine to check if coming soon section expired or not
$expired = 1;
if ($year < $expiry_year) {
$expired = 0;
} else {
if ($year == $expiry_year) {
if ($mon < $expiry_month) {
$expired = 0;
} else {
if ($mon == $expiry_month) {
if ($mday < $expiry_day) {
$expired = 0;
}
}
echo 'checked';
}
?>
>
</div>
<div class='one columns small' style="float: right; margin-right: 30px;">
<input type='submit' class='slide_form button-primary' value='Update'/>
</div>
<div class='one columns medium'>
<?php
if (isFuture($row)) {
echo "<h3 class='yellow'>Future</h3>";
} else {
if (expired($row)) {
echo "<h3 class='red'>Expired</h3>";
} else {
echo "<h3 class='green'>Active</h3>";
}
}
?>
</div>
<div class='one columns small' style="float: right; margin-right: 30px;">
<input type='hidden' name='id' value="<?php
echo $row['id'];
?>
"/>
<input type='button' onclick="deleteSlideById(event,<?php
