Jump to content

[SOLVED] Catchable fatal error: Object of class mysqli_result could not be converted to s


cluce
 Share

Recommended Posts

can someone tell me how to get rid of this error.......

 

Catchable fatal error: Object of class mysqli_result could not be converted to string in C:\wamp\www\fail.php on line 21

 

here is my code.........

<?php

$mysqli = mysqli_connect("localhost", "root", "", "test");

$sql = ("SELECT failed_logins FROM auth_users WHERE username = 'me'");
$attempts = mysqli_query($mysqli, $sql);

//disables user
if ($attempts >= 3){
echo ("login disabled");

} else {
    echo ("its good");
echo ("$attempts");
}
?>

 

when I ran this I got his...

its good

Catchable fatal error: Object of class mysqli_result could not be converted to string in C:\wamp\www\fail.php on line 21

 

Link to comment
Share on other sites

<?php

$mysqli = mysqli_connect("localhost", "root", "", "test");

$sql = ("SELECT failed_logins FROM auth_users WHERE username = 'me'");
$result = mysqli_query($mysqli, $sql);
$resultarr = mysqli_fetch_assoc($result);
$attempts = $resultarr["failed_logins"];

//disables user
if ($attempts >= 3){
echo ("login disabled");

} else {
    echo ("its good");
echo ("$attempts");
}
?>

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.