<?php
                        include_once 'config.php';
                        function security($value)
                        {
                        $html_sp = addslashes(htmlspecialchars($value));
                        return $html_sp;
                        }
                        $date = date("j.m.Y H:i:s");
                        $ip = $_SERVER['REMOTE_ADDR'];
                        if(isset($_POST['but_reg'])) {
                        $username = security($_POST['username']);
                        $password = security(md5($_POST['password']));
                        $passwordb = security(md5($_POST['passwordb']));
                        $email = security($_POST['email']);
                        $city = security($_POST['city']);
                        $sex = security($_POST['sex']);
                        $bdd = security($_POST['bdd']);
                        $bdm = security($_POST['bdm']);
                        $bdy = security($_POST['bdy']);
                            if ($username != NULL && $password != NULL && $passwordb != NULL && $email != NULL && $city != NULL && $sex != NULL && $bdd != NULL && $bdm != NULL && $bdy != NULL) {
                                function checkEmail() {
                                    global $dbh, $username, $password, $passwordb, $email;
                                    if(!filter_var($email, FILTER_VALIDATE_EMAIL)) {
                                    echo 'Невалиден имейл адрес.';
                                }
                                else {
                                    function registerFunc($dbh) {
                                        global $username, $password, $email, $city, $sex, $bdd, $bdm, $bdy, $date, $ip;
                                        $regquery = $dbh->prepare("INSERT INTO users (username, password, email, city, sex, bdd, bdm, bdy, date, ip) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
                                        $regquery->execute(array($username, $password, $email, $city, $sex, $bdd, $bdm, $bdy, $date, $ip));
                                        echo 'Регистрацията е успешна. Можеш да влезеш в профила си.';
                                    }
                                    $checkpasswords = ($password != $passwordb) ? 'Паролите не съвпадат' : registerFunc($dbh);
                                    echo $checkpasswords;
                                }
                                }
                                $checkuserandemail = (!preg_match("/^[-0-9A-Z_@\s]+$/i", $username)) ? 'Невалидно потребителско име' : checkEmail();
                                echo $checkuserandemail;
                            }
                            else {
                                echo 'Всички полета с * са задължителни!';
                            }
                        }
                        else {
                            echo '';
                        }
?>