throw new Exception("HEADERS ALREADY SENT", 3141592);
}
}
function get_header()
{
include_once '/php/header.php';
}
function get_footer()
{
include_once '/php/footer.php';
}
date_default_timezone_set("Europe/Amsterdam");
session_start();
if (isset($_POST[FORMNAME])) {
include_once '/php/formhandler.php';
handleForm($_POST);
}
$page = array("home");
$original_url = "home";
if (isset($_GET['url'])) {
$page = explode("/", $_GET['url']);
$original_url = $_GET['url'];
}
$page_count = count($page);
$_GET = array();
$_GET['url'] = array();
for ($i = 1; $i < $page_count; $i++) {
if ($page[$i] != "") {
array_push($_GET['url'], $page[$i]);
}
}
$db = mysqli_connect('localhost', 'root', 'password', 'virunee');
if (!$db) {
die("Unable to connect to database: " . mysqli_connect_error());
}
?>
<html>
<head><title>Accessing mySQL Databases</title></head>
<body>
<h1>Accessing mySQL Databases</h1>
<?php
if (isset($_POST['_handle_'])) {
handleForm();
} else {
printForm("", "", "", "");
}
function handleForm()
{
global $db;
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$role = $_POST['role'];
$f = $s = $e = $r = "";
if (isset($_POST['save'])) {
//save one record
$statement = "INSERT INTO users (firstname, lastname, email, type) VALUES\n ('{$firstname}','{$lastname}','{$email}','{$role}')";
if ($result = mysqli_query($db, $statement)) {
