PhpStorm - How to force a string to be handled as such?
How can I force to be handle just as a string and not be interpreted by the IDE as something that it is not?
Granted the following string is rather unusual and gets identified as SQL by the IDE.
'SELECT {$selectors} FROM `{$table}`{$where}{$order}{$limit}{$offset}'
As you probably guessed by now, the placeholders are seen as invalid SQL code, and give me a slew of error in the IDE.
Already attempted to "fix" those issues via @noinspection, but there are multiple warnings and errors detected in that one line of code, that it is not feasible to suppress those "issues" one by one.
Another drawback is that some errors require me to disable some really useful inspections and I really don't want that.
So, is there a way just force PhpStorm to treat that one string as an actual string and not, in this case, SQL?
You may disable SQL Language Injection into all strings. Downside: it affects whole project (or even ALL projects, considering the fact that it's a built-in rule and therefore it's an IDE-wide setting).
This can be done at Settings/Preferences | Editor | Language Injections.
An option just for that string is to forcibly inject Plain Text language by placing /** @lang Text */ just before the string:
$s2 = /** @lang Text */'SELECT {$selectors} FROM `{$table}`{$where}{$order}{$limit}{$offset}';
See the difference:
P.S. Notice the difference between interpolated string (HEREDOC in this case; but the same is for sting using "" as delimiters) vs '' (single quotes/NOWDOC). It still sees it as SQL but shows no warnings (which means that IDE understand that $table is something dynamic). But it could be just my settings -- checking it in my few-years-old Test project...
- Build a string by repeating a character N times
- Validate an array as "empty" if it has no elements or if all elements have no length
- phpunit runs test twice - gets two answers. Why?
- How can I make Laravel return a custom error for a JSON REST API
- regex for checking URL's wildcard for both subdomain and top level domain?
- Use Simple HTML Dom to parse HTML and generate an array of href values and plain text
- Generate an array of href strings from all <a> tags in an HTML document using Simple HTML DOM Parser
- Making POST application/json request with file_get_contents
- Woocommerce add to cart button redirect to checkout
- PHP form send email to multiple recipients
- How to loop over json-encoded data?
- Fill array with numbers adding up to a nominated total without exceeding item maximum
- Iterate over all last-day-of-the-month dates in a year
- Generate an associative 2d array with incremented column values using a flat array as first level keys
- Debug a single PHP file with $_GET parameters in NetBeans/Eclipse/PHPstorm (AJAX API)
- Put Values in Multidimensional Array keys
- Laravel queued jobs processed immediately even with a delay
- Error when calling function it self, VCS say="undefined function"
- How to truncate number 3 decimals
- PHP - How to get OAuth 2.0 Token
- Consume API endpoint from Laravel + Inertia App
- Generate real US street addresses for Selenium RC script
- Hour difference between 2 DateTime objects in Decimal Format
- Php update database if checkbox is not checked
- Group data from lines of a log file by one column and create subarrays from another column
- Use values of a flat array as the keys in every row of a 2d array
- Redis keys are not expiring - Laravel, Predis
- WooCommerce order status hook not triggering
- Execute a function on each element of an array
- Group a 2d array by year-month of a date column, add column of counts and create a subarray from a column of ids in each group