Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- define('OK, 0');
- define('SERVER_ERROR, 1');
- define('INVALID_USER_NAME, 2');
- define('INVALID_USER_PASS, 3');
- define('USER_NAME_ALREADY_EXISTS, 4');
- define('EMPTY_FIELDS, 5');
- $host = '192.168.101.53';
- $database = 'japven_weryfikator';
- $database_username = 'japven_werUser';
- $database_password = 't,vPxIc}Eg0^';
- function rejestruj($nickname, $password, $email)
- {
- global $host, $database, $database_username, $database_password;
- $userPassLength = strlen(utf8_decode($password));
- if($userPassLength < 6 || $userPassLength > 40)
- return INVALID_USER_PASS;
- if($email == "" || $nickname == "" || $password == "")
- return EMPTY_FIELDS;
- if(!preg_match("/^[a-zA-Z0-9_.]{3,20}$/", $nickname)){
- return INVALID_USER_NAME;
- };
- $db_obj = new mysqli($host, $database_username, $database_password, $database);
- if($db_obj->connect_errno){
- echo 'Wystąpił błąd podczas próby połączenia z serwerem MySQL.';
- $db_obj->connect_error;
- return SERVER_ERROR;
- }
- $nickname = $db_obj->real_escape_string($nickname);
- $password = $db_obj->real_escpae_string($password);
- $email = $db_obj->real_escape_string($email);
- $query = "SELECT COUNT(*) FROM Users WHERE Nazwa='$nickname' ";
- if(!$result = $db_obj->query($query)){
- echo 'Wystąpił błąd: nieprawidłowe zapytanie.'
- $db_obj->close();
- return SERVER_ERROR;
- }
- if(!$row = $result->fetch_row()){
- echo "Wystąpił błąd, nieprawidłowe wyniki zapytania.";
- $db_obj->close();
- return SERVER_ERROR;
- }
- else{
- if($row[0] > 0){
- $db_obj->close();
- return USER_NAME_ALREADY_EXISTS;
- }
- }
- $password = md5($password);
- $query = "INSERT INTO Users VALUES(";
- $query .= "NULL, '$nickname', '$password', '$email')";
- if(!$result = $db_obj->query($query)){
- echo 'Wystąpił błąd przy INSERT');
- $db_obj->close();
- return SERVER_ERROR;
- }
- $count = $db_obj->affected_rows;
- if($count <> 1){
- $db_obj->close();
- return SERVER_ERROR;
- }
- else{
- $db_obj->close();
- return OK;
- }
- }
- ?>
- <!DOCTYPE HTML>
- <html>
- <head>
- <link rel="stylesheet" href="css/style.css" type="text/css">
- <link rel="stylesheet" href="css/font-awesome/css/font-awesome.min.css">
- <link href='http://fonts.googleapis.com/css?family=Bad+Script' rel='stylesheet' type='text/css'>
- <link href="http://fonts.googleapis.com/css?family=PT+Sans:400,700" rel="stylesheet" type="text/css">
- <meta http-enquiv="Content-Type" content="text/html; charset=utf-8">
- <title>Rejestracja</title>
- </head>
- <body>
- <h2>
- </h2>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement