Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class autenticacao extends conexao {
- private $conexao;
- public function __construct(){
- parent::__construct();
- }
- public function signIn($email,$senha) {
- $sql = $this->conexao->query("SELECT * FROM usuarios WHERE email = '$email' AND senha = '$senha'");
- if ($sql->num_rows==1){
- while($linha = $sql->fetch_array()) {
- $email = $linha['nome'];
- $acessos = $linha['acessos']+1;
- }
- $ip=$_SERVER["REMOTE_ADDR"];
- $sql = $this->conexao->prepare("UPDATE usuarios SET acessos = ?, ip = ? WHERE email = ?");
- $sql->bind_param('iss',$acessos,$ip,$email);
- $sql->execute();
- $_SESSION["autenticado"]=$email;
- $_SESSION["usuario"]=$email;
- header('location:index.php');
- }
- else {
- echo '<div class="warning">O usuário ou senha inserido é inválido(a)</div>';
- }
- }
- public function signOut() {
- session_destroy();
- header('location:index.php');
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement