Home > PHP > Function > SQLite > sqlite_escape_string()

sqlite_escape_string()

sqlite_escape_string - Escapes a string for use as a query parameter

Syntax

string sqlite_escape_string (string $item)

Arguments

  • item - The string being quoted. If the item contains a NULcharacter, or if it begins with a character whose ordinal value is 0x01, PHP will apply a binary encoding scheme so that you can safely store and retrieve binary data.

Description

sqlite_escape_string() will correctly quote the string specified by item for use in an SQLite SQL statement. This includes doubling up single-quote characters ( ') and checking for binary-unsafe characters in the query string.

Version

PHP 5, PECL sqlite >= 1.0.0

Return value

Returns an escaped string for use in an SQLite SQL statement.