PHPStorm 8.0.3 : unable to resolve 'table_name' inspection fails

Hello all, new to PHP Sotrm, this is probably my not knowing how to configure the product. When I enter some SQL code in a prepared statement like below :

Screen Shot 2015-02-27 at 9.08.54 AM.png
the inspections cant resolve the table, and of course the column names.

What do i need to setup so that these inspections (and hopefully auto completes) may work ?

2 comments
Comment actions Permalink

Hi there,

https://confluence.jetbrains.com/display/PhpStorm/Databases+and+SQL+Editor+in+PhpStorm

You will definitely need a database connection defined in Database tool window and it must know about that table/columns.

0
Comment actions Permalink

Thank. I just did not see the button for Database ... i looked forever under 'view' , projects settings, and 'toops' menu, it never occured to me you would hide such a tool where you did. Am all set with DDL and database connections now, good to go :)

0

Please sign in to leave a comment.