note 98804 added to pdostatement.execute
| From: | TonyCasparro at osu1 dot php dot net | Date: | Thu, 08 Jul 2010 17:09:58 +0000 |
| Subject: | note 98804 added to pdostatement.execute | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-170799@lists.php.net to get a copy of this message | ||
We know that you can't see the final raw SQL before its parsed by the DB, but if you want to
simulate the final result, this may help.
<?php
public function showQuery($query, $params)
{
$keys = array();
$values = array();
# build a regular expression for each parameter
foreach ($params as $key=>$value)
{
if (is_string($key))
{
$keys[] = '/:'.$key.'/';
}
else
{
$keys[] = '/[?]/';
}
if(is_numeric($value))
{
$values[] = intval($value);
}
else
{
$values[] = '"'.$value .'"';
}
}
$query = preg_replace($keys, $values, $query, 1, $count);
return $query;
}
?>
----
Server IP: 69.147.83.197
Probable Submitter: 71.84.107.47
----
Manual Page -- http://www.php.net/manual/en/pdostatement.execute.php
Edit -- https://master.php.net/note/edit/98804
Del: integrated -- https://master.php.net/note/delete/98804/integrated
Del: useless -- https://master.php.net/note/delete/98804/useless
Del: bad code -- https://master.php.net/note/delete/98804/bad+code
Del: spam -- https://master.php.net/note/delete/98804/spam
Del: non-english -- https://master.php.net/note/delete/98804/non-english
Del: in docs -- https://master.php.net/note/delete/98804/in+docs
Del: other reasons-- https://master.php.net/note/delete/98804
Reject -- https://master.php.net/note/reject/98804
Search -- https://master.php.net/manage/user-notes.php