Log-In Code Doesn't Work

Question

Hi! The objective of this code is to log-in to a website. This code has no error but still doesn't redirect to a profile page. Please, help. Thank you!

<?php

include("dbconnect.php");
session_start();
if($_SERVER["REQUEST_METHOD"] == "post")
{
$username = $_POST['student'];
$password = $_POST['password'];

$query=mysqli_query($dbconfig,"SELECT * FROM members WHERE sn=$username AND pw=$password");
$row=mysqli_fetch_array($query,MYSQLI_ASSOC);
$count=mysqli_num_rows($query);
if($count==1)
{
$_SESSION['login_user']=$username;

header("location: main.php");
}
else
{
$error="Username or Password is invalid";
}
}
?>

Also use exit after header `header("location: main.php");exit;` — Niklesh Raut, Jun 02 '16 at 12:06
Change `$_SERVER['REQUEST_METHOD'] == 'post'` to `$_SERVER['REQUEST_METHOD'] == 'POST'`. Note that `POST` is uppercase. — Peter, Jun 02 '16 at 12:08

score 2 · Answer 1 · answered Jun 02 '16 at 12:00

2

You need to write you query like this

 $query=mysqli_query($dbconfig,"SELECT * FROM members WHERE sn='".$username."' AND pw='".$password."'");

answered Jun 02 '16 at 12:00

Bindesh Pandya

193
3
14

Thanks but it still doesn't work. – DarkArrow29 Jun 02 '16 at 12:11
Is it showing any errors? – Bindesh Pandya Jun 02 '16 at 12:37
No error. Nothing happens when I input username and password. The webpage reloads. – DarkArrow29 Jun 02 '16 at 12:59
put your html form code in question – Bindesh Pandya Jun 02 '16 at 13:35
Thank you very much! I've found out the problem. I haven't assigned the a user to the database. Thanks and sorry! – DarkArrow29 Jun 15 '16 at 12:18

score 0 · Answer 2 · answered Jun 02 '16 at 12:00

0

Your query doesn't work. Try with SELECT * FROM members WHERE sn='$username' AND pw='$password'

And also after you execute the query check if the are some errors with

if(!$query)
 die(mysqli_error($dbconfig));

P.S. sanitize username and password before inserting them in a query

answered Jun 02 '16 at 12:00

Riccardo Bonafede

610
1
9
17

Thank you very much! I've found out the problem. I haven't assigned the a user to the database. Thanks and sorry! – DarkArrow29 Jun 15 '16 at 12:18

Log-In Code Doesn't Work

2 Answers2