<?php
    include 'header.php';

    $sql = "";
    $first_name = $_POST['first_name'];
    $last_name = $_POST['last_name'];
    $username = $_POST['username'];
    $email_address = $_POST['email_address'];
    $password = $_POST['password'];
    $gender = $_POST['gender'];
    $city = $_POST['city'];
    $country = $_POST['country'];

    if(isset($_POST['submit']))
    {
    $sql = "INSERT INTO users (first_name, last_name, username, email_address, password, gender, city, country, verification_code, verified, sign_up_date) VALUES (
    '$first_name',
    '$last_name',
    '$username',
    '$email_address',
    '$password',
    '$gender',
    '$city',
    '$country',
    '1234',
    'Y',
    '08/03/2017')";
        $result = mysqli_query($conn,$sql);
    }

    echo "
    <form action='signup.php' method='post'>
    <label id='first_name'> First name</label><br/>
    <input type='text' name='first_name'><br/>

    <label id='last_name'> Last name</label><br/>
    <input type='text' name='last_name'><br/>

    <label id='username'> Username</label><br/>
    <input type='text' name='username'><br/>

    <label id='email_address'>E-mail Address</label><br/>
    <input type='email' name='email_address'><br/>

    <label id='password'>Password</label><br/>
    <input type='password' name='password'><br/>

    <label id='gender'>Gender</label><br />
    <select name='gender'>
    <option value=''>Select...</option>
    <option value='M'>Male</option>
    <option value='F'>Female</option>
    <option value='N'>Non-binary</option>
    </select><br>

    <label id='city'> City</label><br/>
    <input type='text' name='city'><br/>

    <label id='country'> Country</label><br/>
    <input type='text' name='country'><br/>

    <button type='submit' name='submit'>Sign up</button>

    </form>

    ";