Advertisement
Guest User

Untitled

a guest
Mar 6th, 2016
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.09 KB | None | 0 0
  1. class authDelete {
  2.         public function __construct(){
  3.  
  4.            $this->user_reg = mysql_real_escape_string(filter_input(INPUT_POST, 'user', FILTER_SANITIZE_SPECIAL_CHARS));
  5.            $this->pass_reg = mysql_real_escape_string(filter_input(INPUT_POST, 'pass', FILTER_SANITIZE_SPECIAL_CHARS));
  6.  
  7.            $this->user_del = hex2bin(mysql_real_escape_string(filter_input(INPUT_POST, 'usr_del', FILTER_SANITIZE_SPECIAL_CHARS)));
  8.            $this->pwd_del = hex2bin(mysql_real_escape_string(filter_input(INPUT_POST, 'pwd_del', FILTER_SANITIZE_SPECIAL_CHARS)));
  9.            $this->mysql_host = "localhost";
  10.            $this->mysql_usr = "root";
  11.            $this->mysql_pwd = "";
  12.            $this->mysql_db = "users";
  13.          
  14.            $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>';
  15.            $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>';
  16.            $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>';
  17.            $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>';
  18.            $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>';
  19.             echo $this->success_mysql_row_insert;
  20.         }
  21.         public function authCheck(){
  22.             if(strlen($this->user_reg) > 20){
  23.                 exit();
  24.             }
  25.         }
  26.         public function authConnect (){
  27.             $this->mysql_connection = mysql_connect($this->mysql_host, $this->mysql_usr, $this->mysql_pwd) or die ($this->error_mysql_connect);
  28.             $this->mysql_db =  mysql_select_db($this->mysql_db) or die ($this->error_mysql_database);
  29.         }        
  30.    
  31.         public function authDelete (){
  32.             $this->sql_1_query = mysql_query("SELECT * FROM login");
  33.             $sql_1 = "DELETE FROM login WHERE username = '$this->user_del' AND password = '$this->pwd_del'";
  34.             if($this->sql_1_query = mysql_query($sql_1)){
  35.                 echo '<meta http-equiv="refresh" content="0; URL=">';
  36.             }
  37.  
  38.         }
  39.     }
  40.  
  41.     class authRegister extends authDelete {
  42.         public function checkExist(){
  43.             $this->query_check = mysql_query("SELECT * FROM login WHERE username='".$this->user_reg."'");
  44.             if(!mysql_num_rows($this->query_check) == 0){
  45.                 echo $this->error_mysql_row_delete;
  46.                 exit;
  47.             }
  48.             else{
  49.                 echo $this->success_mysql_row_delete;
  50.             }
  51.         }
  52.         public function registerUser(){
  53.             $this->query_reg = mysql_query("INSERT INTO login (username,password) VALUES('$this->user_reg','$this->pass_reg')");
  54.             if(!$this->query_reg){
  55.                 echo $this->mysql_error_register;
  56.             }
  57.             else{
  58.                 echo '<meta http-equiv="refresh" content="0; URL=#insert-del">';
  59.             }
  60.         }
  61.     }
  62.  
  63.    
  64.    
  65.     if(isset($_POST['submit-del'])){    
  66.         $authDelete = new authDelete;
  67.         $authDelete->authCheck();
  68.         $authDelete->authDelete();
  69.         $authDelete->authConnect();
  70.     }
  71.     elseif(isset($_POST['submit'])){
  72.         $authRegister = new authRegister;
  73.         $authRegister->checkExist();
  74.         $authRegister->registerUser();
  75.     }
  76.     else{
  77.         exit;
  78.     }
  79. include('logging.php');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement