Escaping dangerous characters in a string

< ‌ index Query >

Escaping potential dangerous characters in a string before using it in a query can help protect your script against SQL injection attacks.

The function:

function escape($s){
  return mysql_escape_string($s);
}

To use

$string = $modx->db->escape($string);

Example

$string = "This is Joe's Page";
$string = $modx->db->escape($string);

This will result in the string "This is Joe\'s Page".

< ‌ index Query >