Code Duplication    Length = 7-7 lines in 2 locations

class/SmallWorldDB.php 1 location

@@ 36-42 (lines=7) @@
33
        $new    = [];
34
        $sql    = 'SELECT employer,position,jobstart,jobstop,description  FROM ' . $xoopsDB->prefix('smallworld_user') . " WHERE userid ='" . $id . "'";
35
        $result = $xoopsDB->query($sql);
36
        while ($row = $xoopsDB->fetchArray($result)) {
37
            $employer    = unserialize($row['employer']);
38
            $position    = unserialize($row['position']);
39
            $jobstart    = unserialize($row['jobstart']);
40
            $jobstop     = unserialize($row['jobstop']);
41
            $description = unserialize($row['description']);
42
        }
43
        $start = 0;
44
        $end   = count($employer) - 1;
45
        while ($start <= $end) {

class/SwDatabase.php 1 location

@@ 49-55 (lines=7) @@
46
        $msg    = [];
47
        $sql    = 'SELECT employer,position,jobstart,jobstop,description  FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_user') . " WHERE userid ='" . $id . "'";
48
        $result = $GLOBALS['xoopsDB']->query($sql);
49
        while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {
50
            $employer    = unserialize($row['employer']);
51
            $position    = unserialize($row['position']);
52
            $jobstart    = unserialize($row['jobstart']);
53
            $jobstop     = unserialize($row['jobstop']);
54
            $description = unserialize($row['description']);
55
        }
56
        $start = 0;
57
        $end   = count($employer) - 1;
58
        while ($start <= $end) {