Bookmark this on Delicious Share on Facebook

PHP : Function Reference : PDO Functions : PDO->quote()

PDO->quote()

Quotes a string for use in a query. ()

Example 1766. Quoting a normal string

copy to clipboard

<?php

$conn = new PDO('sqlite:/home/lynn/music.sql3');

/* Simple string */
$string = 'Nice';

print "Unquoted string: $string\n";

print "Quoted string: " . $conn->quote($string) . "\n";
?>

The above example will output:

copy to clipboard

Unquoted string: Nice

Quoted string: 'Nice'

Example 1767. Quoting a dangerous string

copy to clipboard

<?php

$conn = new PDO('sqlite:/home/lynn/music.sql3');

/* Dangerous string */
$string = 'Naughty \' string';

print "Unquoted string: $string\n";

print "Quoted string:" . $conn->quote($string) . "\n";
?>

The above example will output:

copy to clipboard

Unquoted string: Naughty ' string

Quoted string: 'Naughty '' string'

Example 1768. Quoting a complex string

copy to clipboard

<?php

$conn = new PDO('sqlite:/home/lynn/music.sql3');

/* Complex string */
$string = "Co'mpl''ex \"st'\"ring";

print "Unquoted string: $string\n";

print "Quoted string: " . $conn->quote($string) . "\n";
?>

The above example will output:

copy to clipboard

Unquoted string: Co'mpl''ex "st'"ring

Quoted string: 'Co''mpl''''ex "st''"ring'

Change Language

Follow Navioo On Twitter

PDO->beginTransaction()
PDO->commit()
PDO->__construct()
PDO->errorCode()
PDO->errorInfo()
PDO->exec()
PDO->getAttribute()
PDO->getAvailableDrivers()
PDO->lastInsertId()
PDO->prepare()
PDO->query()
PDO->quote()
PDO->rollBack()
PDO->setAttribute()
PDOStatement->bindColumn()
PDOStatement->bindParam()
PDOStatement->bindValue()
PDOStatement->closeCursor()
PDOStatement->columnCount()
PDOStatement->errorCode()
PDOStatement->errorInfo()
PDOStatement->execute()
PDOStatement->fetch()
PDOStatement->fetchAll()
PDOStatement->fetchColumn()
PDOStatement->fetchObject()
PDOStatement->getAttribute()
PDOStatement->getColumnMeta()
PDOStatement->nextRowset()
PDOStatement->rowCount()
PDOStatement->setAttribute()
PDOStatement->setFetchMode()

hits counter