Advertisement
Guest User

aaaaaaaaaaaaaaaaaaaaaaaaa

a guest
Feb 25th, 2019
225
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.95 KB | None | 0 0
  1. <?php
  2.     $msg = "";
  3.     if(isset($_POST['submit'])) {
  4.         $con = new mysqli("localhost", "root", "Spenger1EHIFGET", "Registration");
  5.  
  6.         $name = $con->real_escape_string(htmlentities($_POST['username'], ENT_QUOTES));
  7.         $email = $con->real_escape_string(htmlentities($_POST['mail'],
  8. ENT_QUOTES));
  9.         $password = $con->real_escape_string(htmlentities(md5($_POST['password']), ENT_QUOTES));
  10.         $cPassword = $con->real_escape_string(htmlentities(md5($_POST['password_again']), ENT_QUOTES));
  11.         $surname = $con->real_escape_string(htmlentities($_POST['surname'], ENT_QUOTES));
  12.         $group = $con->real_escape_string($_POST['group']);
  13.  
  14.         if($name == ""  $email == ""  $password != $cPassword  $surname == ""  strlen($name) > 8) {
  15.             if($group != "x" && $group != "y") {
  16.                 $msg = "Please check your inputs again!";
  17.             }
  18.             $msg = "Please check your inputs again!";
  19.         }
  20.         else {
  21.             $sql = "SELECT * FROM usr WHERE mail ='$email'";
  22.             $res = $con->query($sql);
  23.             if($res->num_rows == 1) {
  24.                 $msg = "Email already exists in the database!";
  25.             } else {
  26.                 $sql = "SELECT * FROM usr WHERE username ='$name'";
  27.                 $res = $con->query($sql);
  28.                 if($res->num_rows == 1) {
  29.                     $msg = "Username already exists in the database!";
  30.                 } else {
  31. $token = 'qwertzuiopasdfghjklyxcvbnmQWERTZUIOPASDFGHJKLYXCVBNM!$/()*';
  32.                 $token = str_shuffle($token);
  33.                 $token = substr($token, 0, 10);
  34.  
  35.                 $sql = "INSERT INTO usr (permission, username, password, mail, surname, grou, isMailConfirmed, token) VALUES ('0', '$name', '$password', '$email', '$surname', '$group', '0', '$token')";
  36.                 if($con->query($sql) === TRUE) {
  37.  
  38.                     require("/var/www/html/PHPMailer/PHPMailer.php");
  39.                     require("/var/www/html/PHPMailer/SMTP.php");
  40.                     require("/var/www/html/PHPMailer/Exception.php");
  41.  
  42.                     $msg = "You have been registered! Please verify your e-mail!";
  43.                     $mail = new PHPMailer\PHPMailer\PHPMailer();
  44.                     $mail->setFrom('ehif@testmail.com');
  45.                     $mail->addAdress($email, $name);
  46.                     $mail->Subject = "Please verify e-mail!";
  47.                     $mail->body = "
  48.                      Please click on the link below:<br><br>
  49.                      <a href='http://ehifspengergasse.ddns.net/confirmedEmail.php%27%3E</a>
  50.                    ";
  51.                 }
  52.  
  53.             }
  54.         }
  55.     }
  56. }
  57. ?>
  58. <!DOCTYPE html>
  59. <html>
  60. <head>
  61.     <title>1EHIF - Registration</title>
  62.     <link rel="stylesheet" type="text/css" href="style.css" media="screen" />
  63. </head>
  64. <body bgcolor="#333333">
  65.     <form action="" method="post">
  66.     <div class="box">
  67.     <div id="font3">
  68.     <font color="white">Register</font>
  69.     <hr>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement