public function __construct(PDOStatement $statement, $param_values = array(), $param_data_types = array(), $fetch_style = moojon_db::FETCH_ASSOC)
{
$this->iterator = $this->getIterator();
$query_string = $statement->queryString;
$log = $query_string;
if (ENVIRONMENT == 'development' || ENVIRONMENT == 'cli') {
$values = 'Param values(';
$parsed_query = $log;
foreach ($param_values as $key => $value) {
$values .= "{$key} = {$value}, ";
$apos = array_key_exists($key, $param_data_types) && $param_data_types[$key] == moojon_db::PARAM_STR ? "'" : '';
$parsed_query = str_replace($key, "{$apos}{$value}{$apos}", $parsed_query);
}
$parsed_query = "Parsed query: {$parsed_query}";
if (count($param_values)) {
$values = substr($values, 0, -2);
}
$values .= ')';
$data_types = 'Param data types(';
foreach ($param_data_types as $key => $value) {
$data_types .= "{$key} = {$value}, ";
}
if (count($data_types)) {
$data_types = substr($data_types, 0, -2);
}
$data_types .= ')';
$log .= "\n\n{$parsed_query}\n\n{$values}\n\n{$data_types}";
moojon_base::log($log);
}
foreach ($param_values as $key => $value) {
if ($value !== null) {
$data_type = array_key_exists($key, $param_data_types) ? $param_data_types[$key] : moojon_db::PARAM_STR;
if (strpos($query_string, $key) !== false) {
$statement->bindValue($key, $value, $data_type);
}
}
}
$this->affected = $statement->execute();
$this->non_query = $statement->columnCount() > 0;
if ($this->non_query) {
foreach ($statement->fetchAll($fetch_style) as $record) {
$this[] = $record;
}
}
}
