Advertisement
Guest User

Insert

a guest
Jul 22nd, 2018
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.79 KB | None | 0 0
  1.     <?php
  2.     if(count($_POST) > 0){
  3.         $servername = "localhost:3306";
  4.         $username = "root";
  5.         $password = "";
  6.         $dbname = "fredle";
  7.         $conn = new mysqli($servername, $username, $password, $dbname);
  8.         if ($conn->connect_error) {
  9.             die("Connection failed: " . $conn->connect_error);
  10.         }
  11.         date_default_timezone_set("Brazil/East");
  12.         $sql = "SELECT * FROM login WHERE login='".md5($_POST['user'])."' AND password='".md5($_POST['pass'])."'"; 
  13.         $_SESSION['result'] = $conn->query($sql);
  14.         if($_SESSION['result']->num_rows>0){
  15.             //Econtrado
  16.             $hash=md5(rand());
  17.             $sql = "INSERT INTO login ticket VALUES \"".$hash."\" WHERE login='".md5($_POST['user'])."' AND password='".md5($_POST['pass'])."'";
  18.             $conn->query($sql);
  19.             echo $hash;
  20.            
  21.         }else{
  22.             //invalido
  23.             echo "Fail";
  24.         }
  25.     }  
  26.     ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement