How to fix this error in PHPStorm 8?

Question

PHP

There is a simple line in the project (PHP):

$stmt = $db->prepare("SELECT * FROM " . $table . " WHERE Value=?");

Today I updated PHPStorm and after FROM it began to show an error:
<coma join expression> expected, got ':'
Is this a bug or am I missing something? If a bug, then what is the name of this inspector to cut him down?

Answer 1

$stmt = $db->prepare(sprintf('SELECT * FROM %s WHERE Value=?', $table));

To my knowledge, sprintf is much faster than string concatenation/interpretation.
And, personally, in my opinion, much more readable.

Answer 2

they added the sql parsing directly to the strings, as it used to be with html. Try to
insert $table into the string, you use " "

Answer 3

If you still need it, then in the settings I cleared SQL Dialect, and in Inspections -> SQL-> SQL dialect detection unchecked

Answer 4

PhpStorm lets us customize SQL parameters! From the settings under Tools | Databases, we can tell PhpStorm which tokens the SQL analyzer should recognize as being valid.
blog.jetbrains.com/phpstorm/2014/11/database-langu...