ParagonIE\EasyDB\EasyDB::escapeLikeValue PHP Method

escapeLikeValue() public method

Input: ("string_not%escaped") Output: "string\_not\%escaped" WARNING: This function always escapes wildcards using backslash!
public escapeLikeValue ( string $value ) : string
$value string
return string
    public function escapeLikeValue(string $value) : string
    {
        // Standard wildcards are underscore and percent sign.
        $value = str_replace('%', '\\%', $value);
        $value = str_replace('_', '\\_', $value);
        if ($this->dbEngine === 'mssql') {
            // MSSQL also includes character ranges.
            $value = str_replace('[', '\\[', $value);
            $value = str_replace(']', '\\]', $value);
        }
        return $value;
    }

Usage Example

Example #1
0
 /**
  * @dataProvider dataMSSQLValues
  */
 public function testMSSQLEscapeLike($input, $expected)
 {
     $easydb = new EasyDB($this->getMockPDO(), 'mssql');
     $output = $easydb->escapeLikeValue($input);
     $this->assertSame($expected, $output);
 }