PhpStorm 2019.1 Help

Injected SQL statements

Temporarily inject a language

  1. Place the cursor inside a string literal, tag, or attribute, in which you want to inject a language and press Alt+Enter (or use the intention action icon (Intention action icon)).

  2. Select Inject language or reference and choose the language you want to inject.

Temporarily inject a language

Open a code fragment in the dedicated editor section

  1. Position the caret within the injected code piece and press Alt+Enter (or use the intention action icon (Intention action icon)).

  2. Select Edit <language ID> Fragment.

    PhpStorm will open a dedicated editor section for editing the code with the injected language. This editor provides full code assistance, including code completion, inspections, intentions and code style actions.

    Open a code fragment in the dedicated editor section

Cancel injections

  1. Place the cursor to the code fragment and press Alt+Enter (or use the intention action icon the Intention action button).

  2. Select Un-inject language/reference.

Configuring sprintf Format References

You can have PhpStorm recognize sprintf format references in injected SQL strings:

  1. Open the Settings / Preferences Dialog by pressing Ctrl+Alt+S or by choosing File | Settings for Windows and Linux or PhpStorm | Preferences for macOS. Expand the Tools node, and then click User Parameters under Database.

  2. Select the Enable in console and SQL files and Enable in string literals with SQL injection checkboxes.

  3. In the Parameter Patterns list:
    1. Click the %w+ pattern. PhpStorm expands a hidden area with the configuration settings for the pattern.

    2. Select the In scripts and In literals checkboxes.

    3. Click the <Language> link and select PHP in the list.

Configure injection rules

You can configure language injection rules on the Editor | Language Injections page of PhpStorm settings (Ctrl+Alt+S).

All pre-defined injection rules are configured for the Built-in scope. In other words, they are global (and therefore available in all PhpStorm projects). Custom rules can be configured for the IDE or for one project only. To change the scope of custom injections, use the Move to Project/IDE Scope icon (the Move to Project/IDE Scope icon).

To configure custom injection rules, click the Add icon (the Add icon) to add a new rule, or copy a predefined rule and change its settings.

Language injections settings
Last modified: 24 June 2019

See Also