I have 2 files named login.php
and configDb.php
. I have a function named sql_query($query)
in configDb.php
somehow like this:
function sql_query($query) {
$link=mysqli_connect("localhost", "root", "", "basheer");
if (mysqli_connect_error()) {
echo mysqli_connect_errno();
}
$q= mysqli_query($link, $query);
while ($row=mysqli_fetch_array($q))
{
return $row['username']." ".$row['password'];
}
}
I included file in login.php
and I am able to fetch the result in an array variable:
$username = $_POST['user'];//
$password = $_POST['pass'];
$query="select * from tbladmin where username='Admin'";//Sql query
require 'include/config_db.php';
$user= sql_query($query);//passed the function result to an array var
print_r($user);//prints the result correctly
echo '<br/>';
if ($username == $user['username'] && $password == $user['password'])
//I am stuck here with $user['username] and $user['password']
{
header("location: index.php");
} else {
$message = "Invalid user name or password, please try again!";
}
How to compare $username
and $password
with $user
array variable ?