コード例 #1
0
<!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();
          },
コード例 #2
0
<?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();