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)) {