so i have been having some trouble binding my array parameters to my query string i have try'ed using the default pdo bindParams but i could not seem to get it to work right from within a foreach loop. so i currently tried using str_replace and preg_replace but in both cases the params seem to replace then revert back on the second iteration.

im really lost on what else to try or maybe a different way to go about this task.

PHP Code:
public function execute(){
$statement $this->_statements[$this->_query_count][0];
$params    $this->_statements[$this->_query_count][1];
count($params) > 0){
// currently where im trying to replace the found placeholders in the query string
                        // with the an assoc array that identifies the the placeholder with the value.
foreach($params as $k => $v){
$k str_replace(':' '' $k);
$qs preg_replace('/\:['.$k.']+/i' $v $statement);
            //$this->_columns_count = $transaction->columnCount();
            //$this->_affected_rows = $transaction->rowCount();    
$transaction $this->_lid->prepare($statement);
$this->_columns_count $transaction->columnCount();
$this->_affected_rows $transaction->rowCount();    
//$this->_statements[$this->_query_count] = $transaction;
        //return $this;