Php Login Screen Not Authenticate

Question

Php Login Screen Not Authenticate

Asked 4 years, 4 months ago

Viewed 61 times

0

I’m starting programming with PHP, Since My Login screen is not Receiving the User and password, this and the code of my Verification page, you can see what’s wrong please.

<?php
include('conexao.php');
if (empty($_POST['usuario']) || empty($_POST['senha'])){
    header('Location: index.php');
    exit();
}

$usuario = mysqli_real_escape_string($conexao, $_POST['usuario']);
$senha = mysqli_real_escape_string($conexao, $_POST['senha']);

$query = "SELECT * from cad.usuario where usuario = '{$usuario}' and senha = '{$senha}'";

$result = mysqli_query($conexao, $query);

$row = mysqli_num_rows($result);

if($row > 0){
    $_SESSION['usuario'] = $usuario;
    header('Location: principal.php');
    exit();
}else{
    $_SESSION['não_autenticado'] = true;
    header('Location: index.php');
    exit();
}

What error is happening? Enter the first if?

– Benilson

2020/02/19 at 12:13
the error is that it does not log in, when I inform the user and password that is registered in the Database, it goes back to login screen and stays like this, I already cleared the browser cache more

– LUIZ AUGUSTO SURF

2020/02/19 at 12:44
session_start is missing, sessions only work with session_start

– Guilherme Nascimento

2020/02/19 at 12:50
In case you’re entering the first if (empty($_POST['usuario']) || empty($_POST['senha'])){ the data may be arriving via get $_GET by forgetting the definition of the method="post" attribute in the tag <form>.

– Benilson

2020/02/19 at 13:25

1 answer

Browser other questions tagged php

You are not signed in. Login or sign up in order to post.

by Guilherme Nascimento • **98,651** points · Answer 1 · 2020-02-19T12:51:05+00:00

session_start is missing, sessions only work with session_start, so:

<?php
include('conexao.php');
if (empty($_POST['usuario']) || empty($_POST['senha'])){
    header('Location: index.php');
    exit();
}

$usuario = mysqli_real_escape_string($conexao, $_POST['usuario']);
$senha = mysqli_real_escape_string($conexao, $_POST['senha']);

$query = "SELECT * from cad.usuario where usuario = '{$usuario}' and senha = '{$senha}'";

$result = mysqli_query($conexao, $query);

$row = mysqli_num_rows($result);

session_start();

if($row > 0){
    $_SESSION['usuario'] = $usuario;
    header('Location: principal.php');
    exit();
}else{
    $_SESSION['não_autenticado'] = true;
    header('Location: index.php');
    exit();
}

All pages that need to be "logged in", after the login of course, will have to have session_start at the beginning, something like:

<?php
session_start();