php多个参数绑定,多次使用绑定参数

我创建了两个函数来通过重命名重复使用的术语来解决该问题。一种用于重命名SQL，另一种用于重命名绑定。

/**

* Changes double bindings to seperate ones appended with numbers in bindings array

* example: :term will become :term_1, :term_2, .. when used multiple times.

*

* @param string $pstrSql

* @param array $paBindings

* @return array

*/

private function prepareParamtersForMultipleBindings($pstrSql, array $paBindings = array())

{

foreach($paBindings as $lstrBinding => $lmValue)

{

// $lnTermCount= substr_count($pstrSql, ':'.$lstrBinding);

preg_match_all("/:".$lstrBinding."\b/", $pstrSql, $laMatches);

$lnTermCount= (isset($laMatches[0])) ? count($laMatches[0]) : 0;

if($lnTermCount > 1)

{

for($lnIndex = 1; $lnIndex <= $lnTermCount; $lnIndex++)

{

$paBindings[$lstrBinding.'_'.$lnIndex] = $lmValue;

}

unset($paBindings[$lstrBinding]);

}

}

return $paBindings;

}

/**

* Changes double bindings to seperate ones appended with numbers in SQL string

* example: :term will become :term_1, :term_2, .. when used multiple times.

*

* @param string $pstrSql

* @param array $paBindings

* @return string

*/

private function prepareSqlForMultipleBindings($pstrSql, array $paBindings = array())

{

foreach($paBindings as $lstrBinding => $lmValue)

{

// $lnTermCount= substr_count($pstrSql, ':'.$lstrBinding);

preg_match_all("/:".$lstrBinding."\b/", $pstrSql, $laMatches);

$lnTermCount= (isset($laMatches[0])) ? count($laMatches[0]) : 0;

if($lnTermCount > 1)

{

$lnCount= 0;

$pstrSql= preg_replace_callback('(:'.$lstrBinding.'\b)', function($paMatches) use (&$lnCount) {

$lnCount++;

return sprintf("%s_%d", $paMatches[0], $lnCount);

} , $pstrSql, $lnLimit = -1, $lnCount);

}

}

return $pstrSql;

}

用法示例：

$lstrSqlQuery= $this->prepareSqlForMultipleBindings($pstrSqlQuery, $paParameters);

$laParameters= $this->prepareParamtersForMultipleBindings($pstrSqlQuery, $paParameters);

$this->prepare($lstrSqlQuery)->execute($laParameters);

有关变量命名的说明：

p：参数，l：函数

str：字符串中的局部，n：数字，a：数组，m：混合