Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $msg = "";
- if(isset($_POST['submit'])) {
- $con = new mysqli("localhost", "root", "Spenger1EHIFGET", "Registration");
- $name = $con->real_escape_string(htmlentities($_POST['username'], ENT_QUOTES));
- $email = $con->real_escape_string(htmlentities($_POST['mail'],
- ENT_QUOTES));
- $password = $con->real_escape_string(htmlentities(md5($_POST['password']), ENT_QUOTES));
- $cPassword = $con->real_escape_string(htmlentities(md5($_POST['password_again']), ENT_QUOTES));
- $surname = $con->real_escape_string(htmlentities($_POST['surname'], ENT_QUOTES));
- $group = $con->real_escape_string($_POST['group']);
- if($name == "" $email == "" $password != $cPassword $surname == "" strlen($name) > 8) {
- if($group != "x" && $group != "y") {
- $msg = "Please check your inputs again!";
- }
- $msg = "Please check your inputs again!";
- }
- else {
- $sql = "SELECT * FROM usr WHERE mail ='$email'";
- $res = $con->query($sql);
- if($res->num_rows == 1) {
- $msg = "Email already exists in the database!";
- } else {
- $sql = "SELECT * FROM usr WHERE username ='$name'";
- $res = $con->query($sql);
- if($res->num_rows == 1) {
- $msg = "Username already exists in the database!";
- } else {
- $token = 'qwertzuiopasdfghjklyxcvbnmQWERTZUIOPASDFGHJKLYXCVBNM!$/()*';
- $token = str_shuffle($token);
- $token = substr($token, 0, 10);
- $sql = "INSERT INTO usr (permission, username, password, mail, surname, grou, isMailConfirmed, token) VALUES ('0', '$name', '$password', '$email', '$surname', '$group', '0', '$token')";
- if($con->query($sql) === TRUE) {
- require("/var/www/html/PHPMailer/PHPMailer.php");
- require("/var/www/html/PHPMailer/SMTP.php");
- require("/var/www/html/PHPMailer/Exception.php");
- $msg = "You have been registered! Please verify your e-mail!";
- $mail = new PHPMailer\PHPMailer\PHPMailer();
- $mail->setFrom('ehif@testmail.com');
- $mail->addAdress($email, $name);
- $mail->Subject = "Please verify e-mail!";
- $mail->body = "
- Please click on the link below:<br><br>
- <a href='http://ehifspengergasse.ddns.net/confirmedEmail.php%27%3E</a>
- ";
- }
- }
- }
- }
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title>1EHIF - Registration</title>
- <link rel="stylesheet" type="text/css" href="style.css" media="screen" />
- </head>
- <body bgcolor="#333333">
- <form action="" method="post">
- <div class="box">
- <div id="font3">
- <font color="white">Register</font>
- <hr>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement