<!DOCTYPE html> <html lang="en"> <head> <title>Sign Up</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css"> <link rel="stylesheet" href="../style.css" type="text/css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script> <script src="https://code.jquery.com/jquery-2.1.1.min.js" type="text/javascript"></script> <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script> <!-- <?php require_once "../register/membersite.php"; $dbLog = new Membersite(); $dbLog->InitiDB("localhost", "root", "", "testblog", "users"); $dbLog->DBLogin(); $dbLog->SaveToDatabase(); $dbLog->closeCon(); ?> --> <script> function checkAvailability(){ $("#loaderIcon").show(); jQuery.ajax({ url: "check_availability.php", data: 'username='+$("#username").val(), type: "POST", success:function(data){ $("#user-availability-status").html(data); $("#loaderIcon").hide(); },
<?php require_once "membersite.php"; $db_handle = new Membersite(); $db_handle->DBLogin(); // $conn = $db_handle->connectDB(); if (!isset($_POST['submit'])) { //Check username $sql_checkname = "SELECT * FROM users WHERE username='******'"; $result = mysqli_num_rows(mysqli_query($db_handle->conn, $sql_checkname)); if ($result == 0) { //insert to Database $sql_query = "INSERT INTO users (username,email,password)\n VALUES ('" . $_POST["username"] . "'" . "," . "'" . $_POST["email"] . "'" . ",'" . md5($_POST["pwd"]) . "');"; if (mysqli_query($db_handle->conn, $sql_query)) { echo "New record is created successfully."; } else { echo "Insert failed."; } } else { echo "record existed"; } } $db_handle->closeCon();