JSFiddle - React, Tailwind, and code Playground

by bilbobaggins

JavaScript

let searchparampayloadSQLSanitize = function(res,a){

 a.forEach(function (g, i) {
    g[Object.keys(g)].forEach(function (k) {
      var re=/ALTER|alter|CREATE|create|DELETE|delete|DROP|drop|EXECUTE|execute|INSERT|insert|MERGE|merge|select|SELECT|update|UPDATE|UNION|union/
      let vali = new RegExp(re);
console.log(vali.test(k))
      if (vali.test(k)) {
        console.log("403")
      }
    })
    })

}
 
 
  let searchparam=[
    {
      "gender": [
        "f  DROP TABLE STUDENTS; --"
      ]
    },
    {
      "last_name": [
        "lyonns"
      ]
    }
  ]
searchparampayloadSQLSanitize("",searchparam)