storing data in an array and for each loop

[ztron]

hello, i am trying to create a script to generate a downline report for a multilevel marketing system. i was capable of pulling the personally sponsored distributors, but all the other ones are processed on the fly within the program which is called Market Power. there are no distinct fields to just pull the other distributors out and i was wondering if anyone could possibly help me out with this. the other guy who was helping me work on this project just went on vacation. he gave me a basic layout of what needs to be done, but i am fairly new to php and do not understand all of his terminology.

basically he told me to run a query on all users who have the logged in distributors ID in the sponsor field. he said to store only the IDs and put it in an array called next_level. So, I am running a query(quite simple) like this:

$query1 = "SELECT dm_id FROM distributor_main
				   WHERE (dm_sponsor2_id) ='".$valid_user."'";

his next step is...before running a query on $next_level set $current_level to $next_level and then repeat (for...each loop) going through all $current_level WITHOUT removing $next_level values. the for...each loop must run a total of 6 times (6
levels) and stop.

after those queries are run, then pull out the ID#s from the $next_level
array and display the appropriate fields needed (name, monthly sales, etc...)

the only parts i am confused with is the array and the placement of the for each loop. i've never used a for each loop and i am not sure how it works. here is the code i was using for diplaying just the personally sponsored distributors:

<?
session_start();
// include function files for this application
require_once("candle_fns.php"); 


if ($username && $passwd)
// they have just tried logging in
{
    if (login($username, $passwd))
    {
      // if they are in the database register the user id
      $valid_user = $username;
      session_register("valid_user");
    }  

    else
    {
      // unsuccessful login
      do_html_header("Problem:");
      echo "You could not be logged in. 
            Your password was probably entered incorrectly.<BR>
			(Passwords are case sensitive.) Please try again.";
      do_html_url("login.php", "Login");
      do_html_footer();
      exit;
    }      

}
check_valid_user();
// get the bookmarks this user has saved
//if ($url_array = get_user_urls($valid_user));
//  display_user_urls($url_array);
userdbConnect();

function display_search_results($query)

{
    $result = userdbExec($query);
     if(!odbc_fetch_into($result, $row))
         echo "No match found!<HR>";
     else
        {

    ?>
  <TABLE cellspacing="5" cellpadding="5"><tr><td><b><u>ID</u></b></TD><td><b><u>Distributor Name</u></b></TD><td><b><u>Title</u></b></TD><td><b><u>Phone</u></b></TD><td><b><u>Start Date</u></b></TD><td><b><u>Period Sales</u></b></TD></TR>
<?

     do{
         print("<tr><td>" . $row[0] . "</td>");
         print("<td>" . $row[1] . " " . $row[2] . "</td>");
         print("<td>" . $row[3] . "</td>");
		 print("<td>" . $row[4] . "</td>");
		 print("<td>" . $row[5] . "</td>");
		 print("<td>$".number_format($row[6],2)."</td></tr>");
         }
     while(odbc_fetch_into($result, $row));

     }
}

function display_total($query2)

{
    $result = userdbExec($query2);
     if(!odbc_fetch_into($result, $row))
         echo "No match found!<HR>";
     else
        {

     do{
		 print("<tr><td><td><td><td><td><b>Total</b> <td>$".number_format($row[7],2)."</td></td></td></td></td></td></tr></table>");
         }
     while(odbc_fetch_into($result, $row));

	  print("</table><HR>");
     }

}


do_unlinked_html_header("Downline Genealogy Report");


/* Search */ 
         echo "Genealogy Downline Report Search for Distributor ID <b>" . $valid_user . "</b><BR>"; 
         $query = "SELECT dm_id, dm_first_name, dm_last_name, di_pay_title, dm_phone, di_start_date, di_period_sales FROM distributor_main, distributor_sales
				   WHERE (dm_sponsor2_id) ='".$valid_user."' AND distributor_sales.di_id = distributor_main.dm_id";
         display_search_results($query);


	 $query2 = "SELECT dm_id, dm_first_name, dm_last_name, di_pay_title, dm_phone, di_start_date, di_period_sales, SUM(di_period_sales) FROM distributor_main, distributor_sales
			   WHERE (dm_sponsor2_id) ='".$valid_user."' AND distributor_sales.di_id = distributor_main.dm_id";
     display_total($query2);

do_html_URL("member.php", "Return to the Main Menu");
do_html_footer();
userdbClose();
?>

if anyway could help me out, i would greatly appreciate it.

[JUMC_Webmaster]

Being a MLMer myself, I can see what you are trying to do. Generating downline reports requires the use of a recursive function to traverse the entire network. What you need is a data structure called a tree to store a user-defined object. I wrote a program that can do what you want to do in C++ while I was in college. Basically for each person in the network, you need to keep track of

• Their distributor number (IBO number as it may be referred to)
• IBO numbers of each person on their frontline
• The data to be used in the report

When generating the report, your recursive function needs to build an array with the person's frontline, then iterate through the array, calling itself using the IBO number for each person. Your function should include a check condition for IBOs who do not have frontlines, otherwise your recursive function will run infinitely when it hits the first person in the network that did not sponsor anybody.

Hopefully this will get you going in the right direction.

[ztron]

alright, maybe i wasn't too clear in the first post. basically what i am trying to do is run a query and get all the distributor ids that are sponsored by the distributor id that is logged in. after that, i want to go down a level for each of the already stored ids and get all the ids that are sponsored by each one of them and keep storing all of these ids in the same array. it has to loop through it 6 times to go through all the levels and keep storing all the ids in one main array. then i can run a query on that main array to display whatever fields i want based on the ids stored in the array. anyone have any suggestions?

[ztron]

i really just don't understand the foreach loop. i read the manual and still don't fully understand it. also, would i be able to control the iterations because i only need it to loop through 6 times? here is what i have and i am pretty much stuck. i just need it to loop through $current_level and search through dm_sponsor2_id for the ids in $current_level and 6 more levels down. i need all the ids for all 6 levels stored in the $next_level array so i can then run a query and display whatever fields i want. if someone could explain the foreach to me i'd greatly appreciate it.

/* Search */ 
         echo "Genealogy Downline Report Search for Distributor ID <b>" . $valid_user . "</b><BR>"; 
         $query = "SELECT dm_id FROM distributor_main
				   WHERE (dm_sponsor2_id) ='".$valid_user."'";
		 $next_level = userdbExec($query);
		 $current_level = $next_level;
		 foreach(something as something)

[JUMC_Webmaster]

The foreach() loop in PHP will iterate through all elements in the array. In your example, I'm assuming the network only has six levels in it. In this case, the following code would work (C++ version, requires a rewrite to function in PHP.)

void
Tree::print_tree(Tree temp)
{
	current = root;
	int depth = 0;
	temp.print_node(current, depth);
}

void
Tree::print_node(Node *temp, int depth)
{
	for (int i = 0; i < depth; i++)
	{
		cout << '\t';
	}
	temp->print(temp->info);
	vector<Node *>::iterator x = temp->next.begin();

while (x != temp->next.end())
{
	depth++;
	if (*x != NULL)
	{
		print_node(*x, depth);
	}
	x++;
	depth--;
}
}

In print_node(), you are passing the current node and the depth you are presently at (first call to print_tree sets the depth to 0, since you're starting at the top of the network). In your situation, print_node would run your DB query and append the resulting data to the downline report. Please note that the vector of pointers is similar to the array object in PHP.

[ztron]

alright, thanks for the sample c++ code. i'm still just experimenting with the foreach loop. i'm trying this code and it's not displaying any results for me even though it should be.

/* Search */ 
         echo "Genealogy Downline Report Search for Distributor ID <b>" . $valid_user . "</b><BR>"; 
         $query = "SELECT dm_id FROM distributor_main
				   WHERE (dm_sponsor2_id) ='".$valid_user."'";
		 $next_level = userdbExec($query); 
		 $current_level = $next_level;
		 foreach($current_level as $result) { 
    	 extract($result); 
         echo $dm_id; 
         }

[ztron]

also, how would i be able to limit the foreach loop to only 6 iterations?

[ztron]

is my last example of code correct for the foreach loop? anyone know why it wouldn't be displaying any results?

[ztron]

I took another stab at this project, but it's still not working correctly. I think a problem lies in my loops and in the storing the data in the arrays. My original code that just pulled the personally sponsored ids for a distributor works fine, so right now I'm trying to implement some of my new code into that. Here is the code I have now. If anyone could examine the loops and the rest of the code I'd greatly appreciate it. Right now it seems to be stuck in an infinite loop.

<?php
function display_dist_line_info($dist_id)
{
    $query = "SELECT dm_id, dm_first_name, dm_last_name, di_pay_title, dm_phone, di_start_date, di_period_sales FROM distributor_main, distributor_sales
WHERE dm_sponsor2_id=$dist_id AND distributor_sales.di_id = distributor_main.dm_id";
    $result = userdbExec($query);
    ?>
<TABLE cellspacing="5" cellpadding="5"><tr><td><b><u>ID</u></b></TD><td><b><u>Distributor Name</u></b></TD><td><b><u>Title</u></b></TD><td><b><u>Phone</u></b></TD><td><b><u>Start Date</u></b></TD><td><b><u>Period Sales</u></b></TD></TR>
<?
    print("<tr><td>" . $row[0] . "</td>");
    print("<td>" . $row[1] . " " . $row[2] . "</td>");
    print("<td>" . $row[3] . "</td>");
    print("<td>" . $row[4] . "</td>");
    print("<td>" . $row[5] . "</td>");
    print("<td>$" . number_format($row[6], 2) . "</td></tr>");
    }

session_start();
// include function files for this application
require_once("candle_fns.php");

check_valid_user();
// get the bookmarks this user has saved
// if ($url_array = get_user_urls($valid_user));
// display_user_urls($url_array);
userdbConnect();

do_unlinked_html_header("Downline Genealogy Report");
extract($_SESSION);
/**
 * Search
 */
echo "Genealogy Downline Report Search for Distributor ID <b>" . $valid_user . "</b><BR>";
$query = "SELECT dm_id FROM distributor_main 
WHERE dm_sponsor2_id='$valid_user'";
$result = userdbExec($query);
while (odbc_fetch_into($result, $next_level[]));
foreach($next_level as $cur_id){
    display_dist_line_info($cur_id);
    }
// put infomation display code here... to be shown to user
for($i = 0;$i < 6;$i++){
    $current_level = $next_level;
    foreach($current_level as $tmpid){
        $query2 = "SELECT dm_id FROM distributor_main
WHERE dm_sponsor2_id='$tmpid'";
        $result = userdbExec($query2);
        $result = userdbExec($query);
        while (odbc_fetch_into($result, $next_level[]));
        foreach($next_level as $cur_id){
            display_dist_line_info($cur_id);
            }
        }
    }

do_html_URL("member.php", "Return to the Main Menu");
do_html_footer();
userdbClose();

?>

[ztron]

After a few hours of banging my head and some help from the php master Brian, I was able to get what I wanted done. Here is the code:

<?php
function display_dist_line_info($dist_id)
{
     $query = "SELECT dm_first_name, dm_last_name, di_pay_title, dm_phone, di_start_date, di_period_sales FROM distributor_main, distributor_sales
WHERE dm_id='$dist_id' AND distributor_sales.di_id = distributor_main.dm_id";
     $result = userdbExec($query);
     odbc_fetch_into($result, $next_level);

 // print("<tr><td>" . $next_level[0] . "</td>");
print("<tr><td>" . $dist_id . "</td>");
 print("<td>" . $next_level[0] . " " . $next_level[1] . "</td>");
 print("<td>" . $next_level[2] . "</td>");
 print("<td>" . $next_level[3] . "</td>");
 print("<td>" . $next_level[4] . "</td>");
 print("<td>$" . number_format($next_level[5], 2) . "</td></tr>");
 }

session_start();
// include function files for this application
require_once("candle_fns.php");

check_valid_user();
// get the bookmarks this user has saved
// if ($url_array = get_user_urls($valid_user));
// display_user_urls($url_array);
userdbConnect();

do_unlinked_html_header("Downline Genealogy Report");
extract($_SESSION);
/**
 * Search
 */
echo "Genealogy Downline Report Search for Distributor ID <b>" . $valid_user . "</b><BR>";
?>
<TABLE cellspacing="5" cellpadding="5"><tr><td><b><u>ID</u></b></TD><td><b><u>Distributor Name</u></b></TD><td><b><u>Title</u></b></TD><td><b><u>Phone</u></b></TD><td><b><u>Start Date</u></b></TD><td><b><u>Period Sales</u></b></TD></TR>
<?

$query = "SELECT dm_id FROM distributor_main 
WHERE dm_sponsor_id='$valid_user' order by dm_id";
$result = userdbExec($query);
while (odbc_fetch_into($result, $row))
 $next_level[] = intval(trim($row[0]));
 sort($next_level);
 reset($next_level);
// print_r($next_level);
foreach($next_level as $cur_id){
     if(!is_numeric($cur_id) || $cur_id <= 1)
         continue;
     display_dist_line_info($cur_id);
     }
// put infomation display code here... to be shown to user
for($i = 0;$i < 6;$i++){
     $current_level = $next_level;
     unset($next_level); //erases variable
     foreach($current_level as $tmpid){
         if(!is_numeric($tmpid) || $tmpid <= 1)
             continue;
         $query2 = "SELECT dm_id FROM distributor_main
WHERE dm_sponsor_id='$tmpid' order by dm_id";
         $result = userdbExec($query2);
         while (odbc_fetch_into($result, $row))
         $next_level[] = trim($row[0]);
         sort($next_level);
         reset($next_level);
         // print_r($next_level);
    }
     foreach($next_level as $cur_id){
         display_dist_line_info($cur_id);
         }
     }
print("</TABLE>") ;
do_html_URL("member.php", "Return to the Main Menu");
do_html_footer();
userdbClose();
?>