PHP arr::array_to_hash_id Examples

Example #1

File: stats_controller.php Project: horror/interview

 public function get_interviews_list_action($params)
 {
     $i_meta = db::exec($this->db, "SELECT m.*, DATE(m.date) as date_only, COUNT(i.id) as ans_cnt FROM i_interview_meta m RIGHT JOIN i_interview i ON m.id = i.meta_id GROUP BY i.meta_id", null);
     $q = db::exec($this->db, "SELECT * FROM i_questions", null);
     $i = arr::array_to_hash_id(db::exec($this->db, "SELECT * FROM i_interview", null));
     $u = arr::array_to_hash_id(db::exec($this->db, "SELECT * FROM i_users", null));
     $this->view->render('json', ['interviews_list' => $i_meta, 'interview_logs' => $i, 'users' => $u, 'questions' => $q]);
 }