161-15-7093 web 20/3/19


<?php
$servername = "localhost";
$database = "weblab";
$username = "root";
$password = "";


$conn =  mysqli_connect($servername, $username, $password,$database);


if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} else {
    #header("Location: reg.php");
}
//echo "Connected successfully";
?>


<?php

include("connection.php");


if (isset($_POST['submit_form'])) {
    # code...
    $username = $_POST['username'];
    $email = $_POST['email'];
    $password = $_POST['password'];

    $sql = "INSERT INTO `weblab`.`user` (`username`, `email`, `password`) VALUES ('$username', '$email', '$password');";

    if (mysqli_query($conn, $sql)) {
    echo '<div class="alert alert-success">Added To Database</div>';
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);

}


?>


<!DOCTYPE html>
<html>
<head>
    <title>Registration</title>


<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">


</head>
<body>

    <div class="container">

        <h2 class="text-muted">The Great Registration</h2>

        <div class="col-sm-8">

<form class="form-group" method="POST">

    <input class="form-control" type="text" name="username" placeholder="username"><br>
    <input class="form-control" type="email" name="email" placeholder="email"><br>
    <input class="form-control" type="text" name="password" placeholder="password"><br>
    <input class="btn btn-primary" type="submit" name="submit_form" placeholder="submit">

    </form>

</div>
</div>


<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
</body>
</html>