<?php
#usersReg.php?registar&username=user&psw=123
if(isset($_GET['registar'])){
require_once("connection.php");
$username=addslashes($_GET['username']);
$table="users";
$sql="SELECT id FROM $table WHERE username LIKE '$username'";
$query=mysqli_query($connect, $sql);
$total=mysqli_num_rows($query);
if($total==0){
// regista
$sql="INSERT INTO $table (username, idPrivilegio) VALUES ('$username',1)";
mysqli_query($connect, $sql);
$idUser=mysqli_insert_id($connect);
$psw=md5(addslashes($_GET['psw']));
$table="passwords";
$sql="INSERT INTO $table (psw) VALUES ('$psw')";
mysqli_query($connect, $sql);
$idPassword=mysqli_insert_id($connect);
$table="users_passwords";
$sql="INSERT INTO $table (idUser,idPassword) VALUES ($idUser, $idPassword)";
mysqli_query($connect, $sql);
$caminho="?sucesso";
} else {
// não regista
$caminho="?fracasso";
}
header("Location:$caminho");
}
?>
<!DOCTYPE html>
<html lang="pt">
<head>
<meta charset="UTF-8">
<title>Registar utilizador</title>
</head>
<body>
<form>
<label>Username: </label><br>
<input type="text" name="username" required autofocus>
<br>
<label>Password: </label><br>
<input type="text" name="psw" required>
<br>
<input type="submit" name="registar">
</form>
</body>
</html>
Sem comentários:
Enviar um comentário