$yyyymmdd = $_REQUEST['year'] . $_REQUEST['month'] . $_REQUEST['day']; // $result = check_same_username($_POST['user_name']); // if ($result == "same_user_ng"){ // $result = error_MSG(9); // exit($result); // } $userpassword_1 = password_hash('1234', PASSWORD_DEFAULT); $result = regist_query("INSERT INTO user (user_name,user_password,user_email,user_birth) VALUES ('{$_POST['user_name']}','{$userpassword_1}','{$_POST['user_email']}',{$yyyymmdd})", $_POST['user_name']); if ($result == "checkok") { //die("good"); // header("Location: " . $_SERVER['PHP_SELF']); $result = success_MSG(4); } elseif ($result == "same_user_ng") { $result = error_MSG(9); } else { $result = success_MSG(4); } exi: } ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta name="description" content="A layout example that shows off a blog page with a list of posts."> <title>TOP – JIOSystem</title>
function regist_query($query, $username) { global $mySQLAddress; global $mainDbUserName; global $mainDbPass; global $mainDbName; global $rootURL; $mysqli = new mysqli($mySQLAddress, $mainDbUserName, $mainDbPass, $mainDbName); if ($mysqli->connect_error) { return error_MSG(1); $mysqli->close(); exit; } $result = $mysqli->query("SELECT * FROM user WHERE user_name = '{$username}';"); if (mysqli_num_rows($result) != 0) { return error_MSG(10); exit; } // $mysqli = new mysqli($mySQLAddress,$mainDbUserName,$mainDbPass,$mainDbName); // if ($mysqli->connect_error){ // return error_MSG(1); // $mysqli->close(); // exit(); // } $result = $mysqli->query($query); if (!$result) { return error_MSG(8); exit; } else { return success_MSG(3); } }