public function bindParams($params)
{
if ($this->placeholder == '?') {
$i = 1;
foreach ($params as $dbColumnName => $dbColumnValue) {
if (is_array($dbColumnValue)) {
foreach ($dbColumnValue as $dbColumnVal) {
${$dbColumnName} = $dbColumnVal;
$this->statement->bindParam($i, ${$dbColumnName});
$i++;
}
} else {
${$dbColumnName} = $dbColumnValue;
$this->statement->bindParam($i, ${$dbColumnName});
$i++;
}
}
} else {
if ($this->placeholder == ':') {
foreach ($params as $dbColumnName => $dbColumnValue) {
if (is_array($dbColumnValue)) {
$i = 1;
foreach ($dbColumnValue as $dbColumnVal) {
${$dbColumnName . $i} = $dbColumnVal;
$this->statement->bindParam(':' . $dbColumnName . $i, ${$dbColumnName . $i});
$i++;
}
} else {
${$dbColumnName} = $dbColumnValue;
$this->statement->bindParam(':' . $dbColumnName, ${$dbColumnName});
}
}
}
}
return $this;
}