phpStorm: Method 'error' not found in class mysqli

Question

I am learning PHP and was working with MySQL upto this point. When I started using prepared statements, I switched over to MySQLi instead, but I got an error in my IDE(phpStorm): Method error not found in class mysqli.

I looked at the related questions here on SO and found an answer in the question Fatal error: Class 'MySQLi' not found. I used the sudo apt-get install php5-mysqlnd command, and from the terminal commands it appeared that mysqlnd package was installed successfully.

Here's a screen grab:

After it completed, I ran this command (from a post I found somewhere): php -m | grep -i mysql and got the output mysql mysqli mysqlnd pdo_mysql.

It appeared that the package was installed, but I still get the same error in phpstorm, as it says in this screen grab:

Ultimately, is MySQLi finally installed? Do I need to re-configure PHPStorm somehow? I went to "language and frameworks" under settings, but didn't find anything new there to configure.

My PHP version is (I think) PHP version: 5.5.9-1ubuntu4.11.

Your Common Sense · Accepted Answer · 2015-08-30 11:58:16Z

2

Do I need to re-configure PHPStorm somehow?

All you actually need is to read the error message.
It doesn't say that mysqli is not installed. It rather says that mysqli itself is all right, but there is a problem accessing a non-existent method. Which is indeed never existed.

When I started using prepared statements, I switched over to MySQLi instead

You should have switched to PDO instead.

Was that the problem?

The problem is the book you are reading. Which is using non-existent methods and full of typos. If you want to learn some PHP extension, learn it from manual page.

edited Aug 30, 2015 at 11:58

answered Aug 30, 2015 at 11:31

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dust_In_The_Wind Over a year ago

Apologies for not being clearer earlier. I am just following the sequence as is followed in the book, which goes from using MySQL to MySQLi to PDO. Also, the book uses $mysqli->error() instead of $link->error(). As $mysqli seemed like an undeclared variable, I figured it would've been a typo and used $link instead. Was that the problem?

Dust_In_The_Wind Over a year ago

Thanks, it's good advice. I'll switch to the manual. I could not understand even a line of how PDOs were explained in the book.

axiac · Accepted Answer · 2015-08-30 12:25:17Z

0

Your code reads:

if (! $link) {
    die("Connection failed: ".$link->error());
}

The class mysqli doesn't have any method named error(). It has a property named $error but that's is a totally different thing.

But wait! There is more!

When is the die() statement executed in the code above? When $link is NULL. Does NULL have a method named error()? I sincerely doubt.

Ultimately, is MySQLi finally installed?

The answer is in the question, in the php -m part. If you see mysqli in the output of php -m | grep -i mysql then it is installed and ready to work.

edited Aug 30, 2015 at 12:25

answered Aug 30, 2015 at 11:50

axiac

73.4k11 gold badges120 silver badges150 bronze badges

Collectives™ on Stack Overflow

phpStorm: Method 'error' not found in class mysqli

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related