samedi 23 octobre 2021

mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool [duplicate]

Hello I want to make a simple login page using php and sql but i receive the following error.

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in D:\xampp\htdocs\authentication.php on line 14

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in D:\xampp\htdocs\authentication.php on line 15

Help!

This is my connection.php

<?php      
    $host = "localhost";  
    $user = "root";  
    $password = '';  
    $db_name = "db_project";  
      
    $con = mysqli_connect($host, $user, $password, $db_name);  
    if(mysqli_connect_errno()) {  
        die("Failed to connect with MySQL: ". mysqli_connect_error());  
    }  
?>  

This is authentication.php

<?php      
    include('connection.php');  
    $username = $_POST['user'];  
    $password = $_POST['pass'];  
      
        //to prevent from mysqli injection  
        $username = stripcslashes($username);  
        $password = stripcslashes($password);  
        $username = mysqli_real_escape_string($con, $username);  
        $password = mysqli_real_escape_string($con, $password);  
      
        $sql = "select *from login where fldemail = '$username' and fldpassword = '$password'";  
        $result = mysqli_query($con, $sql);  
        $row = mysqli_fetch_array($result, MYSQLI_ASSOC);  
        $count = mysqli_num_rows($result);  
          
        if($count == 1){  
            echo "<h1><center> Login successful </center></h1>";  
        }  
        else{  
            echo "<h1> Login failed. Invalid username or password.</h1>";  
        }     
?>

this is phpmyadmin database phpmyadmin database




Aucun commentaire:

Enregistrer un commentaire