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);