PHP » Strings » addslashes()

Syntax:
string addslashes(string query)
query
SQL string.

Adds slashes to SQL queries.

addslashes() prepares query strings for SQL servers by adding backslash where needed for quotes and backslashes.

Examples

Code:
<?php

$msg = "Don't do it";
$query = "SELECT * FROM table WHERE msg = '" . addslashes($msg) . "'";
print $query;

?>
Output:
SELECT * FROM table WHERE msg = 'Don\'t do it'
Explanation:

A backslash is added to the query.

See Also: