|
PDO::quoteQuotes a string for use in a query Description
public stringfalse PDO::quote(string
$string , int $type = PDO::PARAM_STR)PDO::quote places quotes around the input string (if required) and escapes special characters within the input string, using a quoting style appropriate to the underlying driver. If you are using this function to build SQL statements, you are strongly recommended to use PDO::prepare to prepare SQL statements with bound parameters instead of using PDO::quote to interpolate user input into an SQL statement. Prepared statements with bound parameters are not only more portable, more convenient, immune to SQL injection, but are often much faster to execute than interpolated queries, as both the server and client side can cache a compiled form of the query. Not all PDO drivers implement this method (notably PDO_ODBC). Consider using prepared statements instead. Caution
Security: the default character setThe character set must be set either on the server level, or within the database connection itself (depending on the driver) for it to affect PDO::quote. See the driver-specific documentation for more information. Parameters
Return Values
Returns a quoted string that is theoretically safe to pass into an
SQL statement. Returns Examples
Example #1 Quoting a normal string
The above example will output: Unquoted string: Nice Quoted string: 'Nice' Example #2 Quoting a dangerous string
The above example will output: Unquoted string: Naughty ' string Quoted string: 'Naughty '' string' Example #3 Quoting a complex string
The above example will output: Unquoted string: Co'mpl''ex "st'"ring Quoted string: 'Co''mpl''''ex "st''"ring' See Also
|