sars-scanner/html/admin-web.php

37 lines
1.3 KiB
PHP

<?php
include '../config.php';
session_start();
if (isset($_SESSION['login'])){
if (isset($_GET['activate'])){
$sql = "SELECT active FROM sites WHERE id=?";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(1, $_GET['activate']);
$stmt->execute();
if ($stmt->rowCount() > 0){
$sql = "UPDATE `sites` SET active=? WHERE id=?";
$stmt = $pdo->prepare($sql);
$status = $stmt->fetchAll(PDO::FETCH_ASSOC);
var_dump($status);
$stmt->bindParam(1, $status);
}
}
$sql = "SELECT * FROM sites";
echo '<table>';
foreach ($pdo->query($sql) as $row){
//var_dump($row);
echo '<tr><td><a href="admin-web.php?activate='.$row['id'].'">'.$row['title'].'</a></td><td><a href="'.$row['link'].'">'.$row['link'].'</a></td></tr>';
}
echo '</table>';
}else{
if (isset($_POST['password'])){
if ($_POST['password'] == 'pw2020covid'){
$_SESSION['login'] = true;
}else{
header("Location: index.php");
die();
}
}else{
echo '<form method="post" action="admin-web.php"><input type="password" name="password" placeholder="Password" required><button onclick="submit">Go</button></form>';
}
}