Uncaught Error: Call to undefined function sql_regcase() [duplicate]

Question

I know that using PHP functions to avoid anti-sql injections is a bad idea, but I'm trying solve this function issue for custom purposes

function anti_injection($sql){
   $sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"), "" ,$sql);
   $sql = trim($sql);
   $sql = strip_tags($sql);
   $sql = (get_magic_quotes_gpc()) ? $sql : addslashes($sql);
   return $sql;
}

I'm getting this error: Uncaught Error: Call to undefined function sql_regcase()

How can I solve this?

Thank you.

This code is useless and will not protect you

John Conde
– John Conde

2019-04-13 18:58:36 +00:00
Commented Apr 13, 2019 at 18:58 — John Conde
– John Conde, Commented Apr 13, 2019 at 18:58

Rob Kwasowski · Accepted Answer · 2019-04-13 18:58:21Z

1

sql_regcase was deprecated in PHP 5.3.0, and removed in PHP 7.0.0.

https://www.php.net/manual/en/function.sql-regcase.php

answered Apr 13, 2019 at 18:58

Rob Kwasowski

2,7903 gold badges16 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

paki leonel · Accepted Answer · 2019-04-13 19:01:38Z

1

This function was DEPRECATED in PHP 5.3.0, and REMOVED in PHP 7.0.0.

Alternatives to this function include:

preg_match() preg_quote() source https://www.php.net/manual/en/function.sql-regcase.php

answered Apr 13, 2019 at 19:01

paki leonel

12 bronze badges

Collectives™ on Stack Overflow

Uncaught Error: Call to undefined function sql_regcase() [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related