account.PHP
Код: Выделить всё
[i]
CEO & Founder
[list]
[*][url=#!][/i]dakota@gmail.com[/url]
[*][url=#!][i][/i]+012 (345) 6789[/url]
[*][url=#!][i][/i]205 Main Street, USA[/url]
[/list]
[list]
[*][url=#!][i][/i][/url]
[*][url=#!][i][/i][/url]
[*][url=#!][i][/i][/url]
[*][url=#!][i][/i][/url]
[/list]
[url=#]Edit Profile[/url]
Код: Выделить всё
function registerUser($fname, $surname, $email, $password, $confirm_password, $username){
$mysqli = connect();
$args = func_get_args();
$args = array_map(function($value){
return trim($value);
}, $args);
foreach ($args as $value) {
if (empty($value)) {
return "All fields are required";
}
}
foreach ($args as $value) {
if (preg_match("/([])/", $value)) {
return " characters are not allowed";
}
}
$stmt = $mysqli->prepare("SELECT email FROM users WHERE email = ?");
$stmt->bind_param("s", $email);
$stmt->execute();
$result = $stmt->get_result();
$data = $result->fetch_assoc();
if ($data != NULL) {
return "Email already exists";
}
if (strlen($username) > 50) {
return "Username is to long";
}
$stmt = $mysqli->prepare("SELECT username FROM users WHERE username = ?");
$stmt->bind_param("s", $username);
$stmt->execute();
$result = $stmt->get_result();
$data = $result->fetch_assoc();
if ($data != NULL) {
return "Username already exists, please use a different username";
}
if (strlen($fname) > 50) {
return "First name is to long";
}
if (strlen($surname) > 50) {
return "Surname is to long";
}
if (strlen($password) > 50) {
return "Password is to long";
}
if ($password != $confirm_password) {
return "Password don't match";
}
$hashed_password = password_hash($password, PASSWORD_DEFAULT);
$stmt = $mysqli->prepare("INSERT INTO users(fname, surname, email, password, username) VALUES(?, ?, ?, ?, ?)");
$stmt->bind_param("sssss", $fname, $surname, $email, $hashed_password, $username);
$stmt->execute();
if ($stmt->affected_rows != 1) {
return "An error occurred. Please try again";
}else{
return "success";
}
}
Код: Выделить всё
function loginUser($username, $password){
$mysqli = connect();
$username = trim($username);
$password = trim($password);
if ($username == "" || $password == "") {
return "Both fields are required";
}
$username = filter_var($username, FILTER_SANITIZE_STRING);
$password = filter_var($password, FILTER_SANITIZE_STRING);
$sql = "SELECT username, password FROM users WHERE username = ?";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("s", $username);
$stmt->execute();
$result = $stmt->get_result();
$data = $result->fetch_assoc();
if ($data == NULL) {
return "Wrong username or password";
}
if (password_verify($password, $data["password"]) == FALSE) {
return "Wrong username or password";
}else{
$_SESSION['user'] = $username;
header("location: account.php");
exit();
}
}
Заранее спасибо.
Подробнее здесь: https://stackoverflow.com/questions/787 ... nformation