the reg
Published: 2021-03-19 18:31:46

FORM
```
<?php
include_once('header.php');
include('../validate/register.php');
?>




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

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="stylesheet" href="./styles/nubastyle.css">
    <link rel="stylesheet" href="../styles/flick/flickity.css">
    <script src="../styles/flick/flickity.pkgd.min.js"></script>
    <script src="../styles/jquery/jquery.min.js"></script>
    <link rel="stylesheet" href="../public/styles/style.css">
    <title>LIBRARY SIGNUP</title>
</head>
<style>

</style>

<body>

    <br>
    <div class="container ml-lg-5 mr-lg-5">


        <div class="row  ml-lg-5 mr-lg-5 p-lg-5">
            <div class="col  ml-lg-5 mr-lg-5 p-lg-5 shadow">
                <form action="" method="POST">

                    <label for="username"><i class="fa fa-user"></i>User Name</label>
                    <input type="text" name="username" class="form-control">
                    <div class="text-danger"><?php echo $username_err?></div><br>


                    <label for="regno">Reg No</label>
                    <input type="text" name="regno" class="form-control">
                    <div class="text-danger"><?php echo $regno_err?></div><br>

                    <label for="email"><i class="fas fa-envelope"></i>Email </label>
                    <input type="email" name="email" class="form-control" required>

                    <label for="department"> <i class="fa fa-house-user"></i> Department</label>
                    <input type="text" name="department" class="form-control">

                    <label for="password"><i class="fa fa-key"></i> Password</label>
                    <input type="password" name="password" class="form-control" required>

                    <input type="submit" value="SUBMIT" class="btn btn-outline-primary">
                </form>
            </div>
        </div>
    </div>


    <?php include_once('../public/bottom.php')?>

</body>


</html>
```

PHP CODE
```
<?php 
$regno_err=$username_err="";
if($_SERVER["REQUEST_METHOD"] == "POST"){
if (preg_match('/^[a-zA-Z0-9]+$/', $_POST['username']) == 0) {
    $username_err='Username is not valid!';
}
    if(empty(trim($_POST['regno']))){
        $regno_err="please fill in this field";
    }elseif($stmt = $conn->prepare('SELECT id, username FROM user WHERE regno = ?')) {
        // Bind parameters (s = string, i = int, b = blob, etc), hash the password using the PHP password_hash function.
        $stmt->bind_param('s', $_POST['regno']);
        $stmt->execute();
        $stmt->store_result();
        // Store the result so we can check if the account exists in the database.
        if ($stmt->num_rows > 0) {
            // Username already exists
            $regno_err= 'regno exists, please choose another!';


            
        } else {
            $sql="INSERT INTO user(username,regno,email,password,department) VALUES(?,?,?,?,?)";
            if($stmt=$conn->prepare($sql)){
                $password=password_hash($password,PASSWORD_DEFAULT);
                $username=mysqli_real_escape_string($conn,$_POST['username']);
                $regno=mysqli_real_escape_string($conn,$_POST['regno']);
                $email=mysqli_real_escape_string($conn,$_POST['email']);
                $department=mysqli_real_escape_string($conn,$_POST['department']);

                $stmt->bind_param('sssss',$username,$regno,$email,$password,$department);
                if($stmt->execute()){
                    ECHO '<script>alert("SUCCESSFULLY REGISTERED")</script>';
                }
            }else{
                echo "something went wrong";
            }
        }
        
    } else {
        // Something is wrong with the sql statement, check to make sure accounts table exists with all 3 fields.
        echo 'Could not prepare statement!';
    }
}$conn->close();
?>
```