<?php
$LINK = mysqli_connect('127.0.0.1','pisjo950','vjPRjFTxDVIoG7)t','pisjo950');
//Error display
ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);
//check the databank pages that exist
$query="SELECT *
FROM pages";
$result = mysqli_query($LINK, $query);
$files=[];
// define the pages
for($i=0;$i<mysqli_num_rows($result);$i++)
{
$row=mysqli_fetch_array($result);
$files[]=$row['pagename'];
}
if(!isset($_POST['DATA_page']))
{
$_POST['DATA_page']=$files[0] ?? '';
}
// check if no page has been selected, when no one is selected show first
if(!in_array($_POST['DATA_page'],$files))
$_POST['DATA_page']=$files[0];
//save on this point
if(isset($_POST['BUTTON_save']))
{
//take the new content we just entered
$newContent = mysqli_real_escape_string($LINK, $_POST['DATA_content']);
//update the DB in here
$updateQuery ="UPDATE pages
SET content = '$newContent'
WHERE pagename = '".$_POST['DATA_page']."'";
$result = mysqli_query($LINK, $updateQuery);
}
// //delete selected
// (strange issue with the option)
// if(isset($_POST['BUTTON_delete']))
// {
// $deleteQuery = "DELETE FROM pages WHERE pagename = '".$_POST['DATA_page']."'";
// $result = mysqli_query($LINK, $deleteQuery);
// }
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>CMS</title>
</head>
<body>
<?php
$title = "This is my CMS";
$description = "This is the description of my CMS";
echo "<h1>$title</h1>";
echo "<p>$description</p>";
?>
<!-- display dropdown menu with pages inside, to edit pages -->
<form id="form" action="cms.php" method="POST">
<nav>
<select name="DATA_page" onchange="document.getElementById('form').submit();">
<?php
// display the select box
foreach($files as $file)
{
echo $files;
echo '<option';
// select the actual page
if($_POST['DATA_page'] == $file)
echo ' selected="selected"';
echo '>'.$file.'</option>';
}
?>
</select>
</nav>
<!-- <button type="submit" name="BUTTON_edit">Edit</button> -->
<div id="main">
<?php
//get the page we wanted first and display it
$query="SELECT content
FROM pages
WHERE pagename = '".$_POST['DATA_page']."'";
$result = mysqli_query($LINK, $query);
$row=mysqli_fetch_array($result);
$content = $row['content'] ?? 'No content available';
?>
<textarea name="DATA_content" cols="30" rows="10"><?php echo $content ?></textarea>
<br>
<button type="submit" name="BUTTON_save">Save</button>
</div>
<!-- <div id="delete"> (I tried to put in a delet button but unfortunately it was not working as expected)
<select name="DATA_page" onchange="document.getElementById('form').submit();">
<h1>Delete:</h1>
<?php
// display the select box
foreach($files as $file)
{
echo $files;
echo '<option';
// select the actual page
if($_POST['DATA_page'] == $file)
echo ' selected="selected"';
echo '>'.$file.'</option>';
}
?>
</select>
<button type="submit" name="BUTTON_delete">Delete</button>
</div> -->
</form>
</body>
</html>