How to change the field names for output from the database by condition?

Question

PHP

Tell

try {
            $this->db_iniciate_connect();
            $this->generateSearchString($filters);

            $rs = $this->db->query($this->strSql);
            $suggestions = array();
            while($row = $rs->fetch_assoc())
            {
                $suggestions[] = array
                (
                'id' => $row['id'],
                'frm' => $row['frm']
                );
            }
            echo json_encode(array('rows' => $suggestions));
        }

I need to change the number of fields and the names of the fields depending on the conditions... What is the best way to implement this. I want to make one template for all tables. Those. if this is a different table and there will be other fields for output, respectively.

Answer 1

- $suggestions[] = array
- (
- 'id' => $row['id'],
- 'frm' => $row['frm']
- );
+ $suggestions[] = $row;