(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.2.1)
PDO::quote — 为 SQL 锟斤拷询锟斤拷锟斤拷址锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
$string
[, int $parameter_type = PDO::PARAM_STR
] ) : stringPDO::quote() 为锟斤拷锟斤拷锟斤拷址锟斤拷锟斤拷锟斤拷锟斤拷锟脚ｏ拷锟斤拷锟斤拷锟斤拷锟揭拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷址锟斤拷锟斤拷锟阶拷澹拷锟斤拷锟斤拷诺姆锟斤拷偷撞锟斤拷锟斤拷锟斤拷锟斤拷洹�
锟斤拷锟绞癸拷么撕锟斤拷锟斤拷锟斤拷锟� SQL 锟斤拷洌�强锟斤拷锟斤拷锟斤拷使锟斤拷 PDO::prepare() 锟斤拷喜锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟� PDO::quote() 锟斤拷锟矫伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟狡达拷咏锟� SQL 锟斤拷洹� 使锟斤拷 prepare 锟斤拷浯︼拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷植锟皆革拷锟矫ｏ拷锟斤拷锟揭革拷锟斤拷锟姐、锟斤拷锟斤拷 SQL 注锟诫；锟斤拷锟斤拷锟狡达拷锟� SQL 锟斤拷锟届，锟酵伙拷锟剿和凤拷锟斤拷锟斤拷锟斤拷锟杰伙拷锟斤拷锟斤拷锟斤拷锟� SQL 锟斤拷询锟斤拷
锟斤拷锟斤拷锟斤拷锟叫碉拷 PDO 锟斤拷锟斤拷锟斤拷实锟斤拷锟剿此癸拷锟杰ｏ拷锟斤拷锟斤拷 PDO_ODBC锟斤拷锟斤拷 锟斤拷锟斤拷使锟斤拷 prepare 锟斤拷锟芥。
锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷要锟斤拷锟斤拷锟捷匡拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷茫锟揭惨拷锟斤拷菘锟斤拷锟斤拷锟斤拷锟斤拷茫锟饺★拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟接帮拷锟斤拷锟� PDO::quote()锟斤拷 锟斤拷锟斤拷锟斤拷息锟缴参匡拷PDO 锟斤拷锟斤拷锟侥碉拷锟斤拷
string要锟斤拷锟斤拷锟斤拷诺锟斤拷址锟斤拷锟斤拷锟�
parameter_type为锟斤拷锟斤拷锟斤拷示锟斤拷锟斤拷锟斤拷锟酵ｏ拷锟皆憋拷选锟斤拷锟斤拷锟脚凤拷锟�
锟斤拷锟截硷拷锟斤拷锟脚碉拷锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟较匡拷锟皆帮拷全锟斤拷锟斤拷 SQL 锟斤拷洹� 锟斤拷锟斤拷锟斤拷锟斤拷锟街э拷锟斤拷锟斤拷址锟绞斤拷锟斤拷锟斤拷锟斤拷锟� FALSE 锟斤拷
Example #1 锟斤拷通锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷
<?php
$conn = new PDO('sqlite:/home/lynn/music.sql3');
/* 锟斤拷锟街凤拷锟斤拷 */
$string = 'Nice';
print "Unquoted string: $string\n";
print "Quoted string: " . $conn->quote($string) . "\n";
?>
锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�
Unquoted string: Nice Quoted string: 'Nice'
Example #2 危锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷
<?php
$conn = new PDO('sqlite:/home/lynn/music.sql3');
/* 危锟斤拷锟街凤拷锟斤拷 */
$string = 'Naughty \' string';
print "Unquoted string: $string\n";
print "Quoted string:" . $conn->quote($string) . "\n";
?>
锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�
Unquoted string: Naughty ' string Quoted string: 'Naughty '' string'
Example #3 锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷
<?php
$conn = new PDO('sqlite:/home/lynn/music.sql3');
/* 锟斤拷锟斤拷锟街凤拷锟斤拷 */
$string = "Co'mpl''ex \"st'\"ring";
print "Unquoted string: $string\n";
print "Quoted string: " . $conn->quote($string) . "\n";
?>
锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�
Unquoted string: Co'mpl''ex "st'"ring Quoted string: 'Co''mpl''''ex "st''"ring'