note 46061 added to function.ocibindbyname
| From: | mdATopencubeDOTorg at osu1 dot php dot net | Date: | Tue, 28 Sep 2004 13:03:11 +0000 |
| Subject: | note 46061 added to function.ocibindbyname | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-77516@lists.php.net to get a copy of this message | ||
I changed the Method below - all without comments:
function getBindVars($statement){
$regExp = "/(:[_a-z0-9]+)/i";
$statement = preg_replace('/\'[^\']*?\'/i', "", $statement);
// --- Kommentare raus:
$statement = preg_replace('/--[^(\n)]*?\n/i', "", $statement."\n");
// /* */ Kommentare raus:
$statement = preg_replace('/(\/\*)([^\*]|[^\*](\*)[^\/])+?(\*\/)/i', "",
$statement);
$statement = preg_replace('/[^s]el([^t](t)[^s])+?(ts)/i', "", $statement);
$test = preg_match_all($regExp, $statement, $return);
if (isset($return[1]) && count($return[1]) > 0)
return($return[1]);
else return array();
}
for this statement:
$testStatement = " select * from /* Komm \n* :v_comment /asdf */ elements := [asdf]||test
where\n elements_id = :v_test;".
"(:value-1) ':text[not]text'||:test123 --test 'diesen:auch_nicht'
:v_not\n asdf";
we get this Array:
Array
(
[0] => :v_test
[1] => :value
[2] => :test123
)
----
Manual Page -- http://www.php.net/manual/en/function.ocibindbyname.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+46061
Delete -- http://master.php.net/manage/user-notes.php?action=delete+46061&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+46061&report=yes
Search -- http://master.php.net/manage/user-notes.php