01.<?php
02.
03.
04.$db = new PDO('mysql:host=localhost;dbname=my_database', 'username', 'password');
05.
06.
07.$sql = 'SELECT * FROM my_table';
08.$results = $db->query($sql);
09.
10.
11.$filtered_results = [];
12.foreach ($results as $row) {
13. $filtered_row = [];
14. foreach ($row as $key => $value) {
15. if ($value != 0) {
16. $filtered_row[$key] = $value;
17. }
18. }
19. $filtered_results[] = $filtered_row;
20.}
21.
22.
23.print_r($filtered_results);
24.
25.?>
