real_escape_string($_POST['page_name']);
$content = $con->real_escape_string($_POST['content']);
// Check if the page with the same name already exists
$chk = $con->query("SELECT * FROM his_page WHERE page_name = '$pageName'");
if($chk->num_rows === 0) {
// Insert new page
$con->query("INSERT INTO `his_page` (`id`, `timestamp`, `page_name`, `content`) VALUES (NULL, CURRENT_TIMESTAMP, '$pageName', '$content')");
$lastPageId = $con->query('SELECT `id` FROM `his_page` ORDER BY id DESC LIMIT 1')->fetch_assoc()['id'];
// Insert into web_schema
$con->query("INSERT INTO `web_schema` (`id`, `type`, `page_id`) VALUES (NULL, 'content', '$lastPageId')");
echo '';
} else {
echo '';
}
}
?>