Mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in

797    Asked by ElizabethJordan in SQL Server , Asked on Apr 3, 2021

I want to check if Facebook User_id already exists in my database (if it does not it should then accept the user as a new one and else simply load the canvas application). When I was running it on my hosting server ,their were no problem, but on my localhost, it gives me this error:

mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in

Here is my code:

<!--?

$fb_id = $user_profile['id'];
$locale = $user_profile['locale'];
if ($locale == "nl_NL") {
    // Checking User Data @ WT-Database
    $check1_task = "SELECT * FROM `users` WHERE `fb_id` = " . $fb_id . " LIMIT 0, 30 ";
    $check1_res = mysqli_query($con, $check1_task);
    $checken2 = mysqli_fetch_array($check1_res);
    print $checken2;
    // If the user does not exist @ WT-Database -> insert
    if (!($checken2)) {
        $add = "INSERT INTO users (fb_id, full_name, first_name, last_name, email) VALUES ('$fb_id', '$full_name', '$first_name', '$last_name', '$email')";
        mysqli_query($con, $add);
    }
    // Double-check, the user won't be able to load the app on failure inserting to the database
    if (!($checken2)) {
        echo "Excuse us " . $first_name . ". Something went wrong! Please try again later!";
        exit;
    }
} else {
    include ('sorrylocale.html');
    exit;
}

How can I resolve this issue?

Answered by Elizabeth Jordan

Your Answer

Interviews

Parent Categories