SQLite3::escapeString

Returns a string that has been properly escaped

Description

public static string SQLite3::escapeString(string $string)

Returns a string that has been properly escaped for safe inclusion in an SQL statement.

Warning

This function is not (yet) binary safe!

To properly handle BLOB fields which may contain NUL characters, use SQLite3Stmt::bindParam instead.

Parameters

string

The string to be escaped.

Return Values

Returns a properly escaped string that may be used safely in an SQL statement.

Notes

Warning

addslashes should NOT be used to quote your strings for SQLite queries; it will lead to strange results when retrieving your data.