<!DOCTYPE html>
<html>
<head>
</head>
<body>
<form method="POST" action="rejestracja.php">
Sign up:</br>
Login:</br>
<input type="text" name="login1">
</br>Password:</br>
<input type="text" name="pass1">
</br>Email:</br>
<input type="text" name="email">
<input type="submit" value="submit">
</form>
<form method="POST" action="loguj.php">
Sign in:</br>
Login:</br>
<input type="text" name="login2">
</br>Password:</br>
<input type="text" name="pass2">
<input type="submit" value="submit">
</form>
</body>
</html>
<?php
$db= new PDO("mysql:host=localhost;dbname=spr;charset=utf8","root","");
if(isset($_POST['login1']) && isset($_POST['pass1']) && isset($_POST['email']) && preg_match('@^[A-Za-z0-9]{1,20}$@',$_POST['login1']) && preg_match('@^.{8,20}$@',$_POST['pass1']) && preg_match('@.{1,15}\@.{1,5}$@',$_POST['email'])){
$rlogin1=$_POST['login1'];
$rpass1=$_POST['pass1'];
$remail=$_POST['email'];
$query=$db-> prepare('SELECT * from logowanie');
$query-> execute();
$checkarray=array();
while($check=$query-> fetch(PDO::FETCH_ASSOC)){
$checkarray[]=$check['login'];
}
if(in_array($rlogin1,$checkarray)) {
echo 'istnieje juz uzytkownik o takim loginie';
}else{
$rpass1=md5($rpass1);
$query=$db-> prepare("INSERT INTO `logowanie` (`id`, `login`, `password`, `email`) VALUES (NULL,:login,:pass,:email)");
$query->bindParam(':login',$rlogin1,PDO::PARAM_STR,20);
$query->bindParam(':pass',$rpass1,PDO::PARAM_STR,20);
$query->bindParam(':email',$remail,PDO::PARAM_STR,20);
$query-> execute();
echo 'zarejestrowales sie';
}
}
else echo 'wprowadz dane';
?>
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}