Lines Matching refs:query
57 …db->query('SELECT language FROM submission_test_case WHERE submit_id = ' . $row["submit_id"] . ';'…
110 $query = array();
112 $query[] = 'problem_name = "' . $data["problem_name"] . '"';
115 $query[] = 'username = "' . $data["user"] . '"';
118 $query[] = 'type = "' . $data["type"] . '"';
122 $query = 'SELECT * FROM submissions ORDER BY "' . $sort . '" ASC ;';
124 …$query = 'SELECT * FROM submissions WHERE ' . join($query, " AND ") . ' ORDER BY "' . $sort . '" A…
130 $results = $this->db->query($query);
152 …$valid = $this->db->query('SELECT "valid" FROM submission_test_case WHERE submit_id = ' . $id . ';…
194 …$this->db->query('DELETE FROM submission_test_case WHERE submit_id ="' . $row["submit_id"] . '";');
197 … $this->db->query('DELETE FROM submissions WHERE submit_id ="' . $row["submit_id"] . '";');