CODEWITHSUNDEEP
phppdophpstorm
Scott Taylor
Scott Taylor

Reputation: 103

PhpStorm does not recognize PDO methods from class

Not sure exactly how to ask this question. But I'm using PhpStorm as my IDE.

I created a class that will handle my database retrieval and manipulation. In it I have this connect method:

private function connect() {

        $dsn = 'mysql:host=' . $this->host . ';dbname=' . $this->db;
        $options = [
            PDO::ATTR_PERSISTENT => true,
            PDO::ATTR_ERRMODE    => PDO::ERRMODE_EXCEPTION
        ];
        try {
            $this->conn = new PDO($dsn, $this->user, $this->pass, $options);
        } catch(PDOException $e) {
            $this->error = $e->getMessage();
        }

    }

The method works fine, but when I go to use $this->conn in other methods PhpStorm does not recognize $this->conn as a PDO object.

Using this method:

private function insert() {
        $insert = $this->conn->prepare($sql);
        $insert->execute();
    }

PhpStorm says that it can't find the method prepare or execute.

If I pass $this->conn into the method and use a PHPDoc block on the parameter it works fine:

/**
 * @param $conn pdo
 */
private function insert($conn) {
    $insert = $conn->prepare($sql);
    $insert->execute();
}

I'm curious as to why it won't let me use $this->conn? While it's not that much more code to pass $this->conn to the method, just seems a bit redundant.

Any ideas on what I need to do differently?

Upvotes: 5

Views: 4109

Answers (3)

Yury Fedorov
Yury Fedorov

Reputation: 14928

Use @var before the definition of the property:

/**
 * @var PDO
 */
private $conn;

That way you tell PhpStorm, that the following variable (property) is of type PDO. Note that private here depends on your code, this is here just an example.

Take a look at this to learn more about PHP Documentation Comments in PhpStorm.

Upvotes: 12

Christophe ROUXEL
Christophe ROUXEL

Reputation: 21

have the same problem in my code.

It seem's that's not the only thing you have to add in your source :

<?php
  /**
   * Created by PhpStorm.
   * User: zac
   * Date: 26/09/2017
   * Time: 12:52
   */

  namespace POO;

  use \PDO;  // <--- need by PhpStorm to find Methods of PDO

  class PersonnagesManager
  {
    /**
     * @var PDO   <--- need by PhpStorm to find Methods of PDO
     */
    private $_db;

    public function __construct($db) {
      $this->setDb($db);
    }

    public function add(Personnage $perso) {
      $q = $this->_db->prepare('INSERT INTO personnages(nom) VALUES(:nom)');
      $q->bindValue(':nom', $perso->nom());
      $q->execute();
      ....

So:

use \PDO;

and

/**
* @var PDO
*/

are both needed !

Work fine for me on version 2017.2.4

Upvotes: 2

edmondscommerce
edmondscommerce

Reputation: 2011

The correct thing to do here is declare the $conn class property and put your annotation there

eg 

myClass {

/**
* @var PDO
*/
private $conn;

Upvotes: 6

Related Questions