From be0c036f89724e1d88764425ec0af1fead8e4b8a Mon Sep 17 00:00:00 2001
From: Katrina Grace <kat@swordglowsblue.com>
Date: Sat, 11 Jun 2022 16:54:26 -0600
Subject: Add support for SQL strings to language_php

---
 plugins/language_php.lua | 81 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 81 insertions(+)

(limited to 'plugins')

diff --git a/plugins/language_php.lua b/plugins/language_php.lua
index 83bd901..d00ea8f 100644
--- a/plugins/language_php.lua
+++ b/plugins/language_php.lua
@@ -24,6 +24,87 @@ syntax.add {
     { pattern = "//.-\n",                    type = "comment"  },
     { pattern = "#.-\n",                     type = "comment"  },
     { pattern = { "/%*", "%*/" },            type = "comment"  },
+    -- SQL strings
+    {
+        pattern = { '"[cC][rR][eE][aA][tT][eE]%s+', '"', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '\'[cC][rR][eE][aA][tT][eE]%s+', '\'', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '"[sS][eE][lL][eE][cC][tT]%s+', '"', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '\'[sS][eE][lL][eE][cC][tT]%s+', '\'', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '"[iI][nN][sS][eE][rR][tT]%s+', '"', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '\'[iI][nN][sS][eE][rR][tT]%s+', '\'', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '"[uU][pP][dD][aA][tT][eE]%s+', '"', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '\'[uU][pP][dD][aA][tT][eE]%s+', '\'', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '"[rR][eE][pP][lL][aA][cC][eE]%s+', '"', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '\'[rR][eE][pP][lL][aA][cC][eE]%s+', '\'', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '"[dD][eE][lL][eE][tT][eE]%s+', '"', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '\'[dD][eE][lL][eE][tT][eE]%s+', '\'', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '"[dD][rR][oO][pP]%s+', '"', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '\'[dD][rR][oO][pP]%s+', '\'', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '"[aA][lL][tT][eE][rR]%s+', '"', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
+    {
+        pattern = { '\'[aA][lL][tT][eE][rR]%s+', '\'', '\\' },
+        syntax  = '.sql',
+        type    = "keyword"
+    },
     -- The '\\' is for escaping to work on " or '
     { pattern = { '"', '"', '\\' },          type = "string"   },
     { pattern = { "'", "'", '\\' },          type = "string"   },
-- 
cgit v1.2.3