ERROR syntax error, unexpected '& quot; pr_employees.doctype_id, pr_e' (T_CONSTANT_ENCAPSED_STRING)

0

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.

    
asked by YohaBR 23.01.2018 в 05:21
source

0 answers