I love Notepad++, partly because of its syntax highlighting: in a .php file, it will highlight
<style> blocks as css and
Now, I know Notepad++ has SQL highlighting as well (for example by default in .sql files), but now I wonder how I can get this "inside" my php file. The issue is of course that SQL queries don't exactly have opening and closing tags, they're just strings passed to a php function. But perhaps there is something built in that can be used, something like how
<editor-fold> in NetBeans will denote a collapsable block of code, but instead of that, something to denote a string as SQL. Could also be inside the SQL string itself, something like
$query = <<<END -- START_SQL SELECT `field` FROM `table` WHERE 1 -- STOP_SQL END;
Or better yet, by configuring at the top of the file in comments, or even in a Notepad++ setting, which functions take SQL strings as attributes (then you don't need it every time inside your code).
So anyway, there are ways, but does one of them already exist?