(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.9.0)
PDOStatement::debugDumpParams — 锟斤拷印一锟斤拷 SQL 预锟斤拷锟斤拷锟斤拷锟斤拷
直锟接达拷印锟斤拷一锟斤拷预锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷息锟斤拷锟结供锟斤拷锟斤拷使锟矫碉拷 SQL 锟斤拷询锟斤拷锟斤拷锟矫诧拷锟斤拷锟斤拷Params锟斤拷锟斤拷锟斤拷目锟斤拷锟斤拷锟斤拷锟斤拷锟藉单锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷示锟侥诧拷锟斤拷锟斤拷锟酵ｏ拷paramtype锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷位锟矫★拷值锟斤拷锟皆硷拷锟节诧拷询锟叫碉拷位锟矫ｏ拷锟斤拷锟斤拷锟角� POD 锟斤拷锟斤拷锟斤拷支锟街ｏ拷锟斤拷为-1锟斤拷锟斤拷
锟斤拷为一锟斤拷锟斤拷锟节碉拷锟皆的癸拷锟杰ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷直锟斤拷锟斤拷锟斤拷锟斤拷荨锟�
锟斤拷直锟接斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟绞癸拷锟�锟斤拷锟斤拷锟斤拷坪锟斤拷锟�锟斤拷锟斤拷锟斤拷前锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟饺伙拷锟�(锟斤拷锟斤拷)锟斤拷锟芥到一锟斤拷 string 锟叫★拷
只锟斤拷印锟斤拷时锟剿匡拷锟斤拷锟斤拷械牟锟斤拷锟斤拷锟斤拷锟斤拷锟侥诧拷锟斤拷锟斤拷锟芥储锟斤拷锟斤拷锟斤拷校锟揭诧拷筒锟斤拷岜伙拷锟斤拷锟斤拷
没锟叫凤拷锟斤拷值锟斤拷
Example #1 PDOStatement::debugDumpParams() 使锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
<?php
/* 通锟斤拷锟斤拷 PHP 锟斤拷锟斤拷执锟斤拷一锟斤拷预锟斤拷锟斤拷锟斤拷锟� */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < :calories AND colour = :colour');
$sth->bindParam(':calories', $calories, PDO::PARAM_INT);
$sth->bindValue(':colour', $colour, PDO::PARAM_STR, 12);
$sth->execute();
$sth->debugDumpParams();
?>
锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�
SQL: [96] SELECT name, colour, calories
FROM fruit
WHERE calories < :calories AND colour = :colour
Params: 2
Key: Name: [9] :calories
paramno=-1
name=[9] ":calories"
is_param=1
param_type=1
Key: Name: [7] :colour
paramno=-1
name=[7] ":colour"
is_param=1
param_type=2
Example #2 PDOStatement::debugDumpParams() 使锟斤拷未锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
<?php
/* 通锟斤拷锟斤拷 PHP 锟斤拷锟斤拷执锟斤拷一锟斤拷预锟斤拷锟斤拷锟斤拷锟� */
$calories = 150;
$colour = 'red';
$name = 'apple';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < ? AND colour = ?');
$sth->bindParam(1, $calories, PDO::PARAM_INT);
$sth->bindValue(2, $colour, PDO::PARAM_STR);
$sth->execute();
$sth->debugDumpParams();
?>
锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�
SQL: [82] SELECT name, colour, calories
FROM fruit
WHERE calories < ? AND colour = ?
Params: 2
Key: Position #0:
paramno=0
name=[0] ""
is_param=1
param_type=1
Key: Position #1:
paramno=1
name=[0] ""
is_param=1
param_type=2