Code Duplication    Length = 9-10 lines in 3 locations

source/MySQLiByDanielGP.php 3 locations

@@ 779-788 (lines=10) @@
776
            for ($counter = 0; $counter < $parameters['NoOfRows']; $counter++) {
777
                $line = $parameters['QueryResult']->fetch_row();
778
                switch ($parameters['returnType']) {
779
                    case 'array_first_key_rest_values':
780
                        $finfo         = $parameters['QueryResult']->fetch_fields();
781
                        $columnCounter = 0;
782
                        foreach ($finfo as $value) {
783
                            if ($columnCounter != 0) {
784
                                $aReturn['result'][$line[0]][$value->name] = $line[$columnCounter];
785
                            }
786
                            $columnCounter++;
787
                        }
788
                        break;
789
                    case 'array_key_value':
790
                        $aReturn['result'][$line[0]]                  = $line[1];
791
                        break;
@@ 809-817 (lines=9) @@
806
                            $columnCounter++;
807
                        }
808
                        break;
809
                    case 'full_array_key_numbered':
810
                        $finfo         = $parameters['QueryResult']->fetch_fields();
811
                        $columnCounter = 0;
812
                        foreach ($finfo as $value) {
813
                            $aReturn['result'][$counter2][$value->name] = $line[$columnCounter];
814
                            $columnCounter++;
815
                        }
816
                        $counter2++;
817
                        break;
818
                    case 'full_array_key_numbered_with_record_number_prefix':
819
                        $parameters['prefix'] = 'RecordNo';
820
                    // intentionally left open
@@ 821-829 (lines=9) @@
818
                    case 'full_array_key_numbered_with_record_number_prefix':
819
                        $parameters['prefix'] = 'RecordNo';
820
                    // intentionally left open
821
                    case 'full_array_key_numbered_with_prefix':
822
                        $finfo                = $parameters['QueryResult']->fetch_fields();
823
                        $columnCounter        = 0;
824
                        foreach ($finfo as $value) {
825
                            $aReturn['result'][$parameters['prefix']][$counter2][$value->name] = $line[$columnCounter];
826
                            $columnCounter++;
827
                        }
828
                        $counter2++;
829
                        break;
830
                }
831
            }
832
        }