note 46061 added to function.ocibindbyname

From: 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

« previous php.notes (#77516) next »