//echo $sql;
if ($conn->query($sql) === TRUE) {
// echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$num = $_POST['create'];
// print_r($_POST);
if (empty($num)) {
// echo "No amount 1";
} else {
$i = 0;
while ($i < $num) {
createInfo($fnames, $lnames, $cities, $conn);
$i += 1;
}
}
}
//createInfo($fnames,$lnames,$cities, $conn);
//$conn->close();
?>
<div class="results">
<table id="results">
<tr>
<th>Name</th>
<th>Gender</th>
<th>Birthdate</th>
if (isset($_POST['page'])) {
$page = $_POST["page"];
$title = $_POST["title"];
$content = $_POST["content"];
$menu = $_POST["menu"];
$menuorder = (int) $_POST["menuorder"];
$template = $_POST["template"];
$pagecontent_id = $_POST["onder"];
if ($pagecontent_id == 'none') {
$pagecontent_id = 'NULL';
$pagecontent_id = mysql_real_escape_string($pagecontent_id);
$sql = "INSERT INTO `pagecontent`(`page`, `title`, `content`, `menu`, `menuorder`, `template`, `pagecontent_id`) VALUES ('{$page}','{$title}','{$content}','{$menu}','{$menuorder}','{$template}', NULL)";
} else {
$sql = "INSERT INTO `pagecontent`(`page`, `title`, `content`, `menu`, `menuorder`, `template`, `pagecontent_id`) VALUES ('{$page}','{$title}','{$content}','{$menu}','{$menuorder}','{$template}','{$pagecontent_id}')";
}
createInfo($page, $title, $content, $menu, $menuorder, $template, $pagecontent_id, $sql);
header("Location: index.php");
}
$db = new mysqli(SERVERNAME, USERNAME, PASSWORD, DBNAME);
$sql2 = "SELECT id, menu FROM pagecontent WHERE pagecontent_id IS NULL";
$menuitem = $db->query($sql2);
$onder = "<option value='none'>None</option>";
$menuitem = $menuitem->fetch_all(MYSQLI_ASSOC);
for ($i = 0; $i < count($menuitem); $i++) {
$onder .= "<option value='" . $menuitem[$i]['id'] . "'>" . $menuitem[$i]['menu'] . "</option>";
}
$allowed = false;
$allowed = checkCookie();
if ($allowed == true) {
} else {
header("Location: login.php");
