Buenas noches Tengo la siguiente consulta en phalcon y me arroja este 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
codigo:
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]); }
y la verdad no encuentro que e echo mal, gracias por su ayuda.