Mysql Question posted in
The official MySQL documentation can be found here.

Mysql – Return the team array in php in single function

what happens here is we find referral ids from database by step by step
here is the database

enter image description here

this is how i call my function 

referralincome($uid, [], 1);

And here is the output. You can add pre tag to check

Array ( 
    [0] => Array ( 
        [0] => Array ( [uid] => 32143 [name] => Uzumaki Naruto ) 
        [1] => Array ( [uid] => 32145 [name] => Sasuke Uchiha ) 
        [2] => Array ( [uid] => 54321 [name] => Uzui Tengen ) 
    ) 
    [1] => Array ( 
        [0] => Array ( [uid] => 42234 [name] => Tanjiro Kamado ) 
    ) 
    [2] => Array ( 
        [0] => Array ( [uid] => 53523 [name] => Bakugo ) 
    ) 
) 
Array ( 
    [0] => Array ( 
        [0] => Array ( [uid] => 32143 [name] => Uzumaki Naruto ) 
        [1] => Array ( [uid] => 32145 [name] => Sasuke Uchiha ) 
        [2] => Array ( [uid] => 54321 [name] => Uzui Tengen ) 
    ) 
    [1] => Array ( 
        [0] => Array ( [uid] => 42234 [name] => Tanjiro Kamado ) 
    ) 
) 
Array ( 
    [0] => Array ( 
        [0] => Array ( [uid] => 32143 [name] => Uzumaki Naruto ) 
        [1] => Array ( [uid] => 32145 [name] => Sasuke Uchiha ) 
        [2] => Array ( [uid] => 54321 [name] => Uzui Tengen ) 
    ) 
    [1] => Array ( 
        [0] => Array ( [uid] => 43545 [name] => Mikey ) 
    ) 
) 
Array ( 
    [0] => Array ( 
        [0] => Array ( [uid] => 32143 [name] => Uzumaki Naruto ) 
        [1] => Array ( [uid] => 32145 [name] => Sasuke Uchiha ) 
        [2] => Array ( [uid] => 54321 [name] => Uzui Tengen ) 
    ) 
)

This is the referral income function don’t mind the name for now.

function referralincome($uid, $team, $level) {
    global $conn;
    $sql = "SELECT uid, name from users WHERE referral='$uid'";
    $result = mysqli_query($conn, $sql);
    $directs = [];
    if (mysqli_num_rows($result) > 0) {
        while($row = mysqli_fetch_assoc($result)){
            array_push($directs, $row);
        }
        array_push($team, $directs);
        foreach ($directs as  $row) {
           referralincome($row['uid'], $team, $level+1);
           $team;
        }
        print_r($team);
    }
}

All i want is return $team once after all referrals completed someone please check it

I will also add MySQL import table code

CREATE TABLE `users` (
  `sno` int(255) NOT NULL,
  `date` date NOT NULL,
  `referral` int(5) NOT NULL,
  `uid` int(5) NOT NULL,
  `password` int(4) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` int(255) NOT NULL,
  `binance` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `users` (`sno`, `date`, `referral`, `uid`, `password`, `name`, `email`, `phone`, `binance`) VALUES
(1, '2022-08-31', 0, 12345, 7272, 'Luffy', '[email protected]', 2147483647, '0'),
(4, '2022-08-31', 12345, 32143, 7272, 'Uzumaki Naruto', '[email protected]', 2147483647, '0'),
(3, '2022-08-31', 12345, 32145, 7272, 'Sasuke Uchiha', '[email protected]', 2147483647, '0'),
(5, '2022-08-31', 32143, 42234, 7272, 'Tanjiro Kamado', '[email protected]', 2147483647, '0'),
(6, '2022-08-31', 54321, 43545, 7272, 'Mikey', '[email protected]', 2147483647, '0'),
(7, '2022-08-31', 42234, 53523, 7272, 'Bakugo', '[email protected]', 2147483647, '0'),
(2, '2022-08-31', 12345, 54321, 7272, 'Uzui Tengen', '[email protected]', 2147483647, '0');


ALTER TABLE `users`
  ADD PRIMARY KEY (`uid`),
  ADD UNIQUE KEY `sno` (`sno`);
Tags:

2

Answers


  1. 0

    You should return the array from the function. And when you make the recursive call, append that result to the array you created from the current level.

    There’s also no need for $team to be a function parameter, since you overwrite it in the function.

    function referralincome($uid, $level) {
    global $conn;
    $sql = "SELECT uid, name from users WHERE referral=?";
    $stmt = mysqli_prepare($conn, $sql);
    mysqli_stmt_bind_param($stmt, "i", $uid);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    $team = [];
    if (mysqli_num_rows($result) > 0) {
        while($row = mysqli_fetch_assoc($result)){
            array_push($team, $row);
        }
        array_push($team, $team);
        foreach ($team as  $row) {
           $indirects = referralincome($row['uid'], $team, $level+1);
           $team = array_merge($team, $indirects);
        }
    }
    return $team;
}

print_r(referralincome($uid, 1));
    Login or Signup to reply.
  2. 0

    How about this simple one request, non-recursive solution ?
    I use the referral ID as the key in the resulting array.

    <?
    $sql = "SELECT * FROM users";
    $result = mysqli_query($conn, $sql);
    $team = [];
    while ($row = mysqli_fetch_assoc($result))
        $team[$row['referral']][] = array('uid' => $row['uid', 'name' => $row['name']);
    print_r($team);
?>

    which will produce :

    Array ( 
    [0] => Array ( 
        [0] => Array ( [uid] => 12345 [name] => Luffy ) 
    ) 
    [12345] => Array ( 
        [0] => Array ( [uid] => 32143 [name] => Uzumaki Naruto ) 
        [1] => Array ( [uid] => 32145 [name] => Sasuke Uchiha ) 
        [2] => Array ( [uid] => 54321 [name] => Uzui Tengen ) 
    ) 
    [32143] => Array ( 
        [0] => Array ( [uid] => 42234 [name] => Tanjiro Kamado ) 
    ) 
    [42234] => Array ( 
        [0] => Array ( [uid] => 53523 [name] => Bakugo ) 
    ) 
    [54321] => Array ( 
        [0] => Array ( [uid] => 43545 [name] => Mikey ) 
    ) 
)

    if you really want sequential keys you’ll only need a small modification.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search