<?php
    session_start();

    require_once('config.php');

    $errmsg_arr = array();

    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
        die('Kon niet verbinden: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {
        die("Kon geen database selecteren");
    }

    function clean($str) {
        $str = @trim($str);
        if(get_magic_quotes_gpc()) {
            $str = stripslashes($str);
        }
        return mysql_real_escape_string($str);
    }

    $fname = clean($_POST['fname']);
    $lname = clean($_POST['lname']);
    $adress = clean($_POST['adress']);
    $place = clean($_POST['place']);
    $email = clean($_POST['email']);
    $mobile = clean($_POST['mobilenumber']);

    if($fname == '') {
        $errmsg_arr[] = 'Voornaam mist';
        $errflag = true;
    }
    if($lname == '') {
        $errmsg_arr[] = 'Achternaam mist';
        $errflag = true;
    }
    if($adress == '') {
        $errmsg_arr[] = 'Adres mist';
        $errflag = true;
    }
    if($place == '') {
        $errmsg_arr[] = 'Woonplaats mist';
        $errflag = true;
    }
    if($email == '') {
        $errmsg_arr[] = 'E-mailadres mist';
        $errflag = true;
    }
    if($mobile == '') {
        $errmsg_arr[] = 'Telefoonnummer mist';
        $errflag = true;
    }
    if($login != '') {
        $qry = "SELECT * FROM members WHERE login='$login'";
        $result = mysql_query($qry);
        if($result) {
            if(mysql_num_rows($result) > 0) {
                $errmsg_arr[] = 'Login ID bestaat al';
                $errflag = true;
            }
            mysql_free_result($result);
        }
        else {
            die("Query mislukt");
        }
    }

    if($errflag) {
        $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
        session_write_close();
        header("location: register-form.php");
        exit();
    }

    $qry = "INSERT INTO members(firstname, lastname, adress, place, email, mobilenumber) VALUES('$fname','$lname','$adress','$place', '$email', '$mobile')";
    $result = mysql_query($qry);

    if($result) {
        header("location: register-success.php");
        exit();
    }else {
        die("Query mislukt");
    }
?>