pdo->query showing an error

MurrayCollingwood

Hello

Here is a screenshot that is worth about 1000 descriptive words.

The PHP manual shows a number of different options for the pdo->query function:

Is there a way I can make PHP Tools stop reporting errors like this?

JakubMisek

MurrayCollingwood Thank you for the question.

Is it really the same method - PDO::query() ? If you navigate to the definition of "query", or mouse hover over "query", is it the one defined in PDO class?

MurrayCollingwood

Hi Jakub

No, it's a Propel ORM interface.

    /**
     * @inheritDoc
     *
     * @return \PDOStatement|false
     */
    #[\Override]
    public function query(string $statement)
    {
        return $this->pdo->query($statement);
    }

However, in the instance where there are two parameters we are executing to this one:

    /**
     * Forward any calls to an inaccessible method to the proxied connection.
     *
     * @param string $method
     * @param mixed $args
     *
     * @return mixed
     */
    public function __call(string $method, $args)
    {
        return $this->pdo->$method(...$args);
    }

My work around at this stage is to do this:

	$pdofunc = "query";
	$result = $pdo->$pdofunc("SELECT $table.* FROM $table $joins WHERE $selection", PDO::FETCH_ASSOC);

Are there options to turn off certain checks like PHP0443?

Cheers
Murray

JakubMisek

MurrayCollingwood, so the editor does not resolve the correct function? I'll be happy to improve the type inferring, so it finds the correct query function, if the rest of the code is annotated correctly.

If the code is not annotated properly, so getReadConnection() returns something different than the editor thinks it is, I suggest annotating the $pdo variable:

/** @var \PDO */
$pdo = ...

Anyways; Yes, you can turn it off using various options https://docs.devsense.com/vscode/problems/suppressing-diagnostics/

Or with quick code action: