Good evening I have the following query in phalcon and I get this error:
Parse error: syntax error, unexpected '"pr_employees.doctype_id, pr_e' (T_CONSTANT_ENCAPSED_STRING) in /var/www/html/apiabacus/app/controllers/EmployeesController.php on line 27
code:
public function getAction () { $ id = $ this- > request- > getQuery ('id'); $ fieldString = ''; $ joinString = ''; $ whereString = ''; $ sql = ''; $ params = [': id' = > $ id];
$sql = "SELECT" "pr_employees.doctype_id, pr_employees.id, pr_employees.last_name,
pr_employees.last_name2, pr_employees.name, pr_employees.bod, pr_employees.gender,
pr_employees.address, pr_employees.phone, pr_employees.cell_phone, pr_employees.email,
pr_employees.city_birth, pr_employees.city_life, pr_employees.cost_center_id,
pr_employees.cesantias_id, pr_employees.afp_id, pr_employees.eps_id, pr_employees.ccf_id,
pr_employeespr_cost_centers.provision_group_id, pr_employees.bank, pr_employees.bank_account,
pr_employees.relationship_id, pr_employees.status, pr_employees.doa, pr_employees.dor,
pr_cities.city, c.city,
pr_cost_centers.cost_center,
pr_relationship.relationship,
pr_funds.fund, f.fund, u.fund, n.fund,
pr_provision_groups.provision_group";
$sql .= " FROM pr_employees";
$sql .= " INNER JOIN pr_relationship ON pr_relationship.id = pr_employees.relationship_id ";
$sql .= " INNER JOIN pr_cities ON pr_cities.id = pr_employees.city_birth ". $joinString;
$sql .= " INNER JOIN pr_cities AS c ON pr_employees.city_life = c.id ". $joinString;
$sql .= " INNER JOIN pr_cost_centers ON pr_cost_centers.id = pr_employees.cost_center_id ". $joinString;
$sql .= " INNER JOIN pr_funds ON pr_employees.cesantias_id = pr_funds.id ". $joinString;
$sql .= " INNER JOIN pr_funds AS f ON pr_employees.afp_id = f.id ". $joinString;
$sql .= " INNER JOIN pr_funds AS u ON pr_employees.eps_id = u.id ". $joinString;
$sql .= " INNER JOIN pr_funds AS n ON pr_employees.ccf_id = n.id ". $joinString;
$sql .= " INNER JOIN pr_provision_groups ON pr_provision_groups.id = pr_employees.provision_group_id ". $joinString;
$sql .= " WHERE pr_employees.id = 35523859 ". $whereString;
$result = $this->db->fetchAll($sql, Phalcon\Db::FETCH_ASSOC, $params);
$this->jsonResponseAction(['data' => $result]);
}
and I really do not find that I miss it, thanks for your help.