private function model2view(&$model) { foreach ($model as $key => $value) { Coder::cleanData($model[$key]); } User::fillDisplayName($model); return $model; }
private function createFBUser($fields) { if (!isset($fields["fbID"]) || !isset($fields["fbName"]) || !isset($fields["fbEmail"])) { throw new Exception("incorrect parameters", -1); } User::fillDisplayName($fields); $keys = $values = "("; foreach ($fields as $key => $value) { $key = Coder::cleanXSS($this->db, $key); $value = Coder::cleanXSS($this->db, $value); $fields[$key] = $value; $keys .= "{$key}, "; $values .= "\"{$value}\", "; } $keys .= "pwd, userStatus, createdDateTime, updatedDateTime)"; $values .= "\"\", \"active\", now(), now())"; $query = "select count(*) from user_registration where fbEmail=\"" . $fields['fbEmail'] . "\""; if (0 < $this->db->query($query)) { throw new Exception("user exsits", -1); } $query = "insert into user_registration {$keys} values {$values}"; return $this->db->query($query); }