Untitled

<?php


include('../db_connect.php'); //login data for the database
date_default_timezone_set('Europe/Amsterdam');

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
$con = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if(isset($_POST['register'])){


        $testname = mysqli_real_escape_string($con, $_POST['username']);

        $testpass = mysqli_real_escape_string($con, $_POST['password']);

        $testemail = mysqli_real_escape_string($con, $_POST['email']);

        //$ID = mysqli_real_escape_string($con, $_POST['ID']);

        $testfirstname = mysqli_real_escape_string($con, $_POST['firstname']);

        $testlastname = mysqli_real_escape_string($con, $_POST['lastname']);

        $lastlogin = time();

    if ($_POST['username']==''  || $_POST['password']=='' || $_POST['email']==''  || $_POST['firstname']=='' || $_POST['lastname']=='') {
    echo "Please fill in all forms";
    }else{
        if ($conn->connect_error) {
            die("Connection failed.<br>");
        }
        $sql = "SELECT Username, Password, Email, Firstname, Lastname FROM users WHERE Username = '$testname' AND Password = '$testpass' AND Email = '$testemail' AND Firstname = '$testfirstname' AND Lastname = '$testlastname'";
        $result = $conn->query($sql);
        $resultcount = mysqli_num_rows($result);

        if ($resultcount == 0) {
            $registered = time();
            $sql = "INSERT INTO users (Username, Password, Email, Firstname, Lastname, Lastlogin, Registered) VALUES ('$testname', '$testpass', '$testemail', '$testfirstname' , '$testlastname', '$lastlogin', '$registered')";

            if ($conn->query($sql) === TRUE) {
                echo "New account created successfully<br>";
            }

        }else{
            $row = $result->fetch_assoc();

            $query = mysqli_query($con, "SELECT * FROM Email WHERE Email = '".$testemail. "'");


            if(mysqli_num_rows($query) > 0){
                echo "Email is already in use.<br>";
            }else{
                $query = mysqli_query($con, "SELECT * FROM Username WHERE Username = '".$testname. "'");
                if(mysqli_num_rows(  $query) > 0){
                    echo "Email is already in use.<br>";
                }else{

                    $sql = "INSERT INTO users (Username, Password, Email, Firstname, Lastname, Lastlogin, Registered) VALUES ('$testname', '$testpass', '$testemail', '$testfirstname' , '$testlastname', '$lastlogin', '$registered')";
                    if ($conn->query($sql) === TRUE) {
                    echo "New account created successfully<br>";

                    }
                }
            }


    //      if ($row["Username"]  == $testname){
    //          echo "Account name is already in use.<br>";
    //      }elseif($row["Email"]  == $testemail){
    //          echo "Email is already in use.<br>";
    //      }else{
    //          $sql = "INSERT INTO users (Username, Password, Email, Firstname, Lastname, Lastlogin) VALUES ('$testname', '$testpass', '$testemail', '$testfirstname' , '$testlastname', '$lastlogin')";
    //          if ($conn->query($sql) === TRUE) {
    //              echo "New account created successfully<br>";
    //          }
    //      }
        }
        $conn->close();
    }
        unset($_POST);
    $_POST = array();
        unset($row);
    $row = array();
        unset($con);
    $con = array();

}


?>


<!DOCTYPE html>
<html lang="en">


<head>

    <!-- Webbrowser icon-->
    <link rel="shortcut icon" href="img/site-icon.ico">

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="Simple site by Crecket, has a bunch of videos and coding projects">
    <meta name="keywords" content="Crecketgaming, youtube, battlefield 3, battlefield, call of duty, HTML, CSS, coding, projects, videos">
    <meta name="author" content="Crecketgaming">

    <title>Crecketgaming - Register</title>

    <!-- Bootstrap Core CSS -->
    <link href="css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom CSS -->
    <link href="css/clean-blog.min.css" rel="stylesheet">

    <!-- Custom Fonts -->
    <link href="http://maxcdn.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css" rel="stylesheet" type="text/css">
    <link href='http://fonts.googleapis.com/css?family=Lora:400,700,400italic,700italic' rel='stylesheet' type='text/css'>
    <link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800' rel='stylesheet' type='text/css'>

    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
        <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
        <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->

</head>


<body>


    <!-- Navigation -->
    <nav class="navbar navbar-default navbar-custom navbar-fixed-top">
        <div class="container-fluid">
            <!-- Brand and toggle get grouped for better mobile display -->
            <div class="navbar-header page-scroll">
                <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
                    <span class="sr-only">Toggle navigation</span>
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                </button>

            </div>

             <!-- Collect the nav links, forms, and other content for toggling -->
            <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
                <ul class="nav navbar-nav navbar-right">
                    <li>
                        <a href="index">Home</a>
                    </li>

                     <li>
                        <a href="vbprojects">Coding projects</a>
                        <ul>
                                <li><a href="spel1/index">Tic Tac Toe (dutch)</a></li>
                                <li><a href="vbprojects">Visualbasic Projects</a></li>
                                <li><a href="calculator">Calculator</a></li>
                        </ul>
                     </li>

                    <li>
                         <a href="teamspeak">Teamspeak</a>
                    </li>

                    <li>
                        <a href="youtube">Youtube</a>
                    </li>
                    <li>
                       <a href="games">Games</a>
                        <ul>
                                <li><a href="battlefield">Battlefield</a></li>
                                <li><a href="league">League of Legends</a></li>
                        </ul>
                    </li>
                    <li>
                        <a href="login">Login</a>
                        <ul>
                                <li><a href="register">Register</a></li>
                        </ul>
                    </li>
                </ul>
            </div>
            <!-- /.navbar-collapse -->
        </div>
        <!-- /.container -->
    </nav>

    <!-- Page Header -->
    <!-- Set your background image for this header on the line below. -->
    <header class="intro-header" style="background-image: url('img/home-bg.jpg')">
        <div class="container">
            <div class="row">
                <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1">
                    <div class="site-heading">
                        <h1>Crecketgaming</h1>
                        <hr class="small">
                        <span class="subheading">Register to Crecketgaming - Under construction</span>
                    </div>
                </div>
            </div>
        </div>
    </header>

    <!-- Main Content -->
    <div class="container">
        <div class="row">
            <div align="center" class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1">

            <form method="post" action="register.php" >
                <table style='padding: 0px;'>
                <tr>
                    <td class="login"><p >Username:</p></td><td class="login"> <input maxlength="32" type="text" name="username"><br></td>
                </tr>
                <tr>
                    <td class="login" ><p >Password:</p></td><td class="login"> <input maxlength="32" type="password" name="password"><br></td>
                </tr>
                <tr>
                    <td class="login"><p >First name:</p></td><td class="login"> <input maxlength="32" type="text" name="firstname"><br></td>
                </tr>
                                <tr>
                    <td class="login"><p >Last name:</p></td><td class="login"> <input maxlength="32" type="text" name="lastname"><br></td>
                </tr>
                                <tr>
                    <td class="login"><p >Email address:</p></td><td class="login"> <input maxlength="50"  type="email" name="email"><br></td>
                </tr>
                <tr>
                    <td class="login"><p style='float:left;'>Remember Me:</p><input style='float:left; margin-top:40px; margin-left:40px;' type="checkbox" name="rememberme" value="1"><br>
                    </td >
                    <td class="login" align="center" >
                    <input class="btnlogin" type="submit" name="register" value="Register"></td>
                </tr>
                </table>

            </form>

        </div>
    </div>
<div>

    <hr>

    <!-- Footer -->
<footer>
        <div class="container">
            <div class="row">
                <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1">
                    <ul class="list-inline text-center">
                        <li>
                            <a href="https://www.youtube.com/user/CrecketGaming"><img src="img/youtube-icon.jpg"></a>
                        </li>

                      </ul>
                    <p class="copyright text-muted">Copyright &copy; Crecketgaming 2015</p>

                </div>
            </div>
        </div>
    </footer>

    <!-- jQuery -->
    <script src="js/jquery.js"></script>

    <!-- Bootstrap Core JavaScript -->
    <script src="js/bootstrap.min.js"></script>

    <!-- Custom Theme JavaScript -->
    <script src="js/clean-blog.min.js"></script>

        <!-- Start of StatCounter Code for Default Guide -->
<script type="text/javascript">
var sc_project=10296953;
var sc_invisible=1;
var sc_security="011cd460";
var scJsHost = (("https:" == document.location.protocol) ?
"https://secure." : "http://www.");
document.write("<sc"+"ript type='text/javascript' src='" +
scJsHost+
"statcounter.com/counter/counter.js'></"+"script>");
</script>
<noscript><div class="statcounter"><a title="hit counter"
href="http://statcounter.com/" target="_blank"><img
class="statcounter"
src="http://c.statcounter.com/10296953/0/011cd460/1/"
alt="hit counter"></a></div></noscript>
<!-- End of StatCounter Code for Default Guide -->


</body>

</html>