Jump to content

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


cluce

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

 

<?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");
}
?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.