php8.5
Home/ Manual/ sqlite3 / sqlite3/ SQLite3::escapeString

SQLite3::escapeString

PHP function Edit on GitHub ✎

(PHP 5 >= 5.3.0, PHP 7, PHP 8)

Returns a string that has been properly escaped

Description

SQLite3::escapeString(string $string): string

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

Not-bin-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.

Source: reference/sqlite3/sqlite3/escapestring.xml · from the official PHP manual (php/doc-en)