Uncaught Error: Call to a member function fetch_assoc() on boolean

Asked Feb 04 '16 at 15:23

Active Feb 05 '16 at 12:53

Viewed 1,083 times

Im trying to learn php
Im using php 7.0.1
Im using php mysqli
I saw a lot of problem like this but their solutions doesnt help me i think its because im using latest version and others uses previous version
heres my php script:

<?php
session_start();
require_once '../../../db_connect.php';

$result = $db->query("select * from student where id = 1");

$personalinformation = $result->fetch_assoc();
echo $personalinformation['username'];
?>

heres my student table:

id | username | password
1  | user1    | pass1
2  | user2    | pass2
3  | user3    | pass3

edited Feb 05 '16 at 12:53

asked Feb 04 '16 at 15:23

Lorence Hernandez

1,189
12
23

not enough info/code to support the question. check for errors. – Funk Forty Niner Feb 04 '16 at 15:24
Basically, `$result` is `false` instead of a mysqli-object. This is because the query fails. Add error-reporting ([`$db->error`](http://php.net/manual/en/mysqli.error.php)) to your code. – Qirel Feb 04 '16 at 15:24
@Fred-ii- edited sorry – Lorence Hernandez Feb 04 '16 at 15:26
Where is `$id` defined? What does db_connect.php contain? – Qirel Feb 04 '16 at 15:26
the db error is my threads title – Lorence Hernandez Feb 04 '16 at 15:26
your query failed, you failed to check for failure, and are now trying to use the boolean false you got back as if it was an object. e.g. NEVER assume success with db calls. – Marc B Feb 04 '16 at 15:28
`db_connect.php` <= *Pandora's box*. `mysql_`? `mysqli_`? PDO? other? credentials good? right db chosen? etc. check if the row exists `if()` and `while()`. – Funk Forty Niner Feb 04 '16 at 15:29
@ me if you need me. I am moving on now. – Funk Forty Niner Feb 04 '16 at 15:34
The title says *Call to a member function **fetch_array()** on boolean* but in the code you're doing *->fetch_assoc()*? – Rajdeep Paul Feb 04 '16 at 16:08
@Fred-ii- I mentioned that im using mysqli – Lorence Hernandez Feb 05 '16 at 11:25
@RajdeepPaul what should i do? sorry im beginner – Lorence Hernandez Feb 05 '16 at 11:27
The error you specified in your title and the code have no corelation whatsoever. I think the problem is somewhere else in your code. Check that. – Rajdeep Paul Feb 05 '16 at 12:32
@RajdeepPaul I found it, the student table was empty, sorry :( i did put 3 rows in my thread's table because i thought my student table wasnt empty. – Lorence Hernandez Feb 05 '16 at 12:48
@RajdeepPaul i think the error appears because im trying to fetch an empty result. – Lorence Hernandez Feb 05 '16 at 12:50
@RajdeepPaul and i just notice that i put fetch_array() on my title, im really a pain in you guys sorry :( ill edit it. lol its embarassing i was wondering why you guys get upset with my title – Lorence Hernandez Feb 05 '16 at 12:52
1

@LorenceHernandez *Call to a member function fetch_assoc() on boolean* means `$result` is `false`, which means your query execution has failed. Use [`mysqli::$error`](http://php.net/manual/en/mysqli.error.php) to debug the issue. – Rajdeep Paul Feb 05 '16 at 12:58
@RajdeepPaul I see i get it, that was Qirel pointing to me. thanks guys :) – Lorence Hernandez Feb 05 '16 at 13:18
@LorenceHernandez Glad to know that the issue is resolved. :-) – Rajdeep Paul Feb 05 '16 at 13:53
1

@LorenceHernandez: just because the syntax is perfect doesn't mean it can't fail for OTHER reasons. there's exactly ONE way for a query to succeed, and a near infinite number of ways for it to fail. if you think you can beat 1:infinity odds, good luck... – Marc B Feb 05 '16 at 16:16

Uncaught Error: Call to a member function fetch_assoc() on boolean

0 Answers0