private function generateSelectQuery()
{
$this->selectQuery = 'SELECT ';
$this->selectQuery .= implode(', ', $this->tableSelectedFields);
$this->selectQuery .= ' FROM ' . $this->tableName;
if ($this->conditions != NULL) {
$eqConditions = ' WHERE ';
for ($i = 0; $i < count($this->conditions); $i++) {
$value = $this->conditions[$i];
$eqConditions .= $value['field'] . '=' . DBUtils::getActiveConnection()->quote($value['value']);
if ($i < count($this->conditions) - 1) {
$eqConditions .= ' AND ';
}
}
$this->selectQuery .= $eqConditions . ';';
}
$data = DBUtils::executeQuery($this->selectQuery, DBUtils::$PDO_MODE_ASSOC);
foreach ($data as $dkey => $entry) {
foreach ($entry as $key => $value) {
$oldVal = $value;
$data[$dkey][$key] = array('value' => $value, 'tag' => $this->fields[$key]['tag'], 'mode' => $this->fields[$key]['mode'], 'type' => $this->fields[$key]['type']);
}
}
return $data;
}
if ($_POST['action'] === 'update') {
$query = 'UPDATE ' . $_POST['tableName'] . ' SET ' . $r . $w;
} else {
if ($_POST['action'] === 'delete') {
$query = 'DELETE FROM ' . $_POST['tableName'] . $w;
} else {
if ($_POST['action'] === 'insert') {
if (isset($_POST['insert'])) {
$query = 'INSERT INTO ' . $_POST['tableName'];
$keys = '(';
$values = '(';
for ($i = 0; $i < count($_POST['insert']); $i++) {
$value = $_POST['insert'][$i];
if (isset($value['value'])) {
$keys .= $value['key'];
$values .= DBUtils::getActiveConnection()->quote($value['value']);
if ($i < count($_POST['insert']) - 1) {
$keys .= ',';
$values .= ',';
}
}
}
$keys .= ')';
$values .= ')';
$query .= $keys . ' VALUES ' . $values;
}
}
}
}
DBUtils::executeQuery($query);
$response = array('status' => 'success', 'query' => $query);
