Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class authDelete {
- public function __construct(){
- $this->user_reg = mysql_real_escape_string(filter_input(INPUT_POST, 'user', FILTER_SANITIZE_SPECIAL_CHARS));
- $this->pass_reg = mysql_real_escape_string(filter_input(INPUT_POST, 'pass', FILTER_SANITIZE_SPECIAL_CHARS));
- $this->user_del = hex2bin(mysql_real_escape_string(filter_input(INPUT_POST, 'usr_del', FILTER_SANITIZE_SPECIAL_CHARS)));
- $this->pwd_del = hex2bin(mysql_real_escape_string(filter_input(INPUT_POST, 'pwd_del', FILTER_SANITIZE_SPECIAL_CHARS)));
- $this->mysql_host = "localhost";
- $this->mysql_usr = "root";
- $this->mysql_pwd = "";
- $this->mysql_db = "users";
- $this->error_mysql_connect = '<div class="alert alert-success animated fadeIn" style="border-radius: 0%; margin: auto; margin-top: 100px; width: 360px; height: 50px; text-align: center;" role="alert"> <span class="sr-only">Erfolgreich:</span> MySQL-Verbindung fehlgeschlagen. </div>';
- $this->error_mysql_database = '<div class="alert alert-success animated fadeIn" style="border-radius: 0%; margin: auto; margin-top: 100px; width: 367px; height: 50px; text-align: center;" role="alert"> <span class="sr-only">Erfolgreich:</span> MySQL-Datenbankverbindung fehlgeschlagen.</div>';
- $this->error_mysql_row_delete = ' <div id="err-warn" class="alert alert-danger animated wow fadeOutDown" data-wow-delay="5.3s" role="alert"> <span class="sr-only">Error:</span> Benutzer existiert bereits. </div>';
- $this->success_mysql_row_delete = '<div id="succ-del" class="alert alert-danger animated wow fadeOutDown" data-wow-delay="5.3s" role="alert"> <span class="sr-only">Erfolg:</span> Benutzer gelöscht. </div>';
- $this->success_mysql_row_insert = '<div id="succ-del" class="alert alert-danger animated wow fadeOutDown" data-wow-delay="5.3s" role="alert"> <span class="sr-only">Erfolg:</span> Benutzer hinzugefügt. </div>';
- echo $this->success_mysql_row_insert;
- }
- public function authCheck(){
- if(strlen($this->user_reg) > 20){
- exit();
- }
- }
- public function authConnect (){
- $this->mysql_connection = mysql_connect($this->mysql_host, $this->mysql_usr, $this->mysql_pwd) or die ($this->error_mysql_connect);
- $this->mysql_db = mysql_select_db($this->mysql_db) or die ($this->error_mysql_database);
- }
- public function authDelete (){
- $this->sql_1_query = mysql_query("SELECT * FROM login");
- $sql_1 = "DELETE FROM login WHERE username = '$this->user_del' AND password = '$this->pwd_del'";
- if($this->sql_1_query = mysql_query($sql_1)){
- echo '<meta http-equiv="refresh" content="0; URL=">';
- }
- }
- }
- class authRegister extends authDelete {
- public function checkExist(){
- $this->query_check = mysql_query("SELECT * FROM login WHERE username='".$this->user_reg."'");
- if(!mysql_num_rows($this->query_check) == 0){
- echo $this->error_mysql_row_delete;
- exit;
- }
- else{
- echo $this->success_mysql_row_delete;
- }
- }
- public function registerUser(){
- $this->query_reg = mysql_query("INSERT INTO login (username,password) VALUES('$this->user_reg','$this->pass_reg')");
- if(!$this->query_reg){
- echo $this->mysql_error_register;
- }
- else{
- echo '<meta http-equiv="refresh" content="0; URL=#insert-del">';
- }
- }
- }
- if(isset($_POST['submit-del'])){
- $authDelete = new authDelete;
- $authDelete->authCheck();
- $authDelete->authDelete();
- $authDelete->authConnect();
- }
- elseif(isset($_POST['submit'])){
- $authRegister = new authRegister;
- $authRegister->checkExist();
- $authRegister->registerUser();
- }
- else{
- exit;
- }
- include('logging.php');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement