Cool
乂❤‿❤乂
<?php if(!$conn){ } ?>
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" name="viewport" content="width=device-width, initial-scale=1"/> <link rel="stylesheet" type="text/css" href="css/bootstrap.css"/> </head> <body> <nav class="navbar navbar-default"> <div class="container-fluid"> <a class="navbar-brand" href="https://sourcecodester.com">Sourcecodester</a> </div> </nav> <div class="col-md-3"></div> <div class="col-md-6 well"> <h3 class="text-primary">PHP - Validate Username Availability</h3> <hr style="border-top:1px dotted #ccc;"/> <div class="col-md-5"> <form method="POST" action=""> <div class="form-group"> <label>Username:</label> <input type="text" name="username" class="form-control" required="required"/> <?php include'validate.php'?> </div> <div class="form-group"> <label>Password:</label> <input type="password" name="password" class="form-control" required="required"/> </div> <div class="form-group"> <label>Firstname:</label> <input type="text" name="firstname" class="form-control" required="required"/> </div> <div class="form-group"> <label>Lastname:</label> <input type="text" name="lastname" class="form-control" required="required"/> </div> <div class="form-group"> <center><button class="btn btn-primary" name="save"><span class="glyphicon glyphicon-save"></span> Register</button></center> </div> </form> </div> </div> </body> </html>
<?php require_once 'conn.php'; $username = $_POST['username']; $password = $_POST['password']; $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $query = $conn->query("SELECT * FROM `user` WHERE `username` = '$username'"); $rows = $query->num_rows; if($rows > 0){ echo "<span class='text-danger'>Username is not available</span>"; } mysqli_query($conn, "INSERT INTO `user` VALUES('', '$username', '$password', '$firstname', '$lastname')") or die(mysqli_error()); } ?>