Advertisement
Guest User

Untitled

a guest
Mar 6th, 2015
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.49 KB | None | 0 0
  1. <?php
  2. define('OK, 0');
  3. define('SERVER_ERROR, 1');
  4. define('INVALID_USER_NAME, 2');
  5. define('INVALID_USER_PASS, 3');
  6. define('USER_NAME_ALREADY_EXISTS, 4');
  7. define('EMPTY_FIELDS, 5');
  8.  
  9. $host = '192.168.101.53';
  10. $database = 'japven_weryfikator';
  11. $database_username = 'japven_werUser';
  12. $database_password = 't,vPxIc}Eg0^';
  13.  
  14. function rejestruj($nickname, $password, $email)
  15. {
  16.     global $host, $database, $database_username, $database_password;
  17.  
  18.     $userPassLength = strlen(utf8_decode($password));
  19.     if($userPassLength < 6 || $userPassLength > 40)
  20.         return INVALID_USER_PASS;
  21.     if($email == "" || $nickname == "" || $password == "")
  22.         return EMPTY_FIELDS;
  23.     if(!preg_match("/^[a-zA-Z0-9_.]{3,20}$/", $nickname)){
  24.         return INVALID_USER_NAME;
  25.     };
  26.  
  27.     $db_obj = new mysqli($host, $database_username, $database_password, $database);
  28.     if($db_obj->connect_errno){
  29.         echo 'Wystąpił błąd podczas próby połączenia z serwerem MySQL.';
  30.         $db_obj->connect_error;
  31.         return SERVER_ERROR;
  32.     }
  33.  
  34.     $nickname = $db_obj->real_escape_string($nickname);
  35.     $password = $db_obj->real_escpae_string($password);
  36.     $email = $db_obj->real_escape_string($email);
  37.  
  38.     $query = "SELECT COUNT(*) FROM Users WHERE Nazwa='$nickname' ";
  39.  
  40.     if(!$result = $db_obj->query($query)){
  41.         echo 'Wystąpił błąd: nieprawidłowe zapytanie.'
  42.         $db_obj->close();
  43.         return SERVER_ERROR;
  44.     }
  45.  
  46.     if(!$row = $result->fetch_row()){
  47.         echo "Wystąpił błąd, nieprawidłowe wyniki zapytania.";
  48.         $db_obj->close();
  49.         return SERVER_ERROR;
  50.     }
  51.     else{
  52.         if($row[0] > 0){
  53.             $db_obj->close();
  54.             return USER_NAME_ALREADY_EXISTS;
  55.         }
  56.     }
  57.     $password = md5($password);
  58.  
  59.     $query = "INSERT INTO Users VALUES(";
  60.     $query .= "NULL, '$nickname', '$password', '$email')";
  61.  
  62.     if(!$result = $db_obj->query($query)){
  63.         echo 'Wystąpił błąd przy INSERT');
  64.         $db_obj->close();
  65.         return SERVER_ERROR;
  66.     }
  67.     $count = $db_obj->affected_rows;
  68.     if($count <> 1){
  69.         $db_obj->close();
  70.         return SERVER_ERROR;
  71.     }
  72.     else{
  73.         $db_obj->close();
  74.         return OK;
  75.     }
  76. }
  77. ?>
  78. <!DOCTYPE HTML>
  79. <html>
  80. <head>
  81. <link rel="stylesheet" href="css/style.css" type="text/css">
  82. <link rel="stylesheet" href="css/font-awesome/css/font-awesome.min.css">
  83. <link href='http://fonts.googleapis.com/css?family=Bad+Script' rel='stylesheet' type='text/css'>
  84. <link href="http://fonts.googleapis.com/css?family=PT+Sans:400,700" rel="stylesheet" type="text/css">
  85. <meta http-enquiv="Content-Type" content="text/html; charset=utf-8">
  86. <title>Rejestracja</title>
  87. </head>
  88. <body>
  89. <h2>
  90. </h2>
  91. </body>
  92. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement