Untitled


<?php


if(isset($_POST['submit'])) {
    echo "Yes! We got the information";


    $username = $_POST['username'];
    $password = $_POST['password'];

//Connecting to database
    $connection = mysqli_connect('localhost', 'root', '', 'loginapp');

    if($connection) {
        echo "We are accesing the database";
    } else {
        die("You are far away from database");
    }

    if(strlen($username) == 5 && check($username) == true) {
        echo "Username is appropriate!!!Thanks ya for visiting!";
    }

    $query = "INSERT INTO 'users'('username','password') VALUES ($username, $password)";

    $result = mysqli_query($connection, $query);

    if(!$result) {
        die('Query failed');
    }
}
function check($username){
    for($i=0; $i<strlen($username);$i++)
    if($username[$i] == 'a' || $username[$i] == 'e' || $username[$i] == 'i' || $username[$i] == 'o' || $username[$i] == 'u'){
        return true;
    }
    return false;

}
?>


<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="UTF-8">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

        <title>This is my first php course</title>
    </head>
    <body>

        <div class="container">

            <div class="col-sm-6">
                <form action = "logi.php" method="post">
                    <div class="form-group">
                        <label for="username">Username</label>
                        <input type="text" class="form-control" name="username">
                    </div>

                    <div class="form-group">
                        <label for="password">Password</label>
                        <input type="password" class="form-control" name="password">
                    </div>

                    <input class="btn-primary" type="submit" name="submit" value="Submit">
                </form>
            </div>


        </div>
    </body>
</html>