PHP - Multi Level Referral System

I want to create an array from a file with this structure

TITLE1, HEADER1, key11, key12, key13, key14
TITLE2, HEADER2, key21, key22, key23, key24
.
.
.

How I can get a foreach with these elements:

$title="TITLE"
$header="HEADER"
$key="(one random key)"

If needed, I can change the file structure too.

$form_bonus = array(
"Attacker" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38),
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array(
"normal" => 1.195,
"rps" => 1.494),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
),
"Defender" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38),
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array(
"normal" => 1.15,
"rps" => 1.38),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
)
);
echo "<pre>".print_r($form_bonus)."</pre>";

output: 1

what am i missing here?

I want to have a multi level dropdown selection tool come out of an array (not database; almost all of available codes on the internet are based on mysql databse). I have an array as each element has this format: "Country | City | ID". Using explode, I want to make a dropdown to choose the country, then choosing the cities of the chosen country. Finally, in a simple search box make action="result.php" to lead to result.php?q=$id

Thanks for your kind attention 

Hi guys, I'm still not having any luck with coming up with an idea of how to make my multi-level drop down menu work with items from a database. I don't necessarily need code, but an idea of how to make it work, so any ideas are welcome.

The table:

Column Descriptions:
id       - The unique id
label    - The text to display
link     - The link to be used
relation - I cannot remember why I wanted that... just disregard it
parent   - The parent item's id (0 for no parent)
sort     - A sort number for the item (ascending)
active   - 0 for false, 1 for true (not implemented yet, will add a WHERE `active` = 1 into the sql later)
depth    - How many parent items there are

Now, here's what it has to do (the class):
Grab items from the database (sorted by depth, parent, and sort) Place the children in a child array of the parents (or however it can be sorted) Implode the array and turn it into an html menu with the below structure
Menu HTML Structure
Code: [Select]
<div id="menu">
  <ul>
    <li><h2>Level 1 A</h2>
      <ul>
        <li><a href="?r=level2/a">Level 2 A</a>
          <ul>
            <li><a href="?r=level3/a">Level 3 A</a></li>
            <li><a href="?r=level3/b">Level 3 B</a></li>
          </ul>
        </li>
      </ul>
    </li>
    <li><a href="?r=level1/b"><h2>Level 1 B</h2></a></li>
  </ul>
</div>
And here is the code I have so far, but I can't figure out how to get the children into the parent array, or at least sort it so that I can achieve the above HTML structure.

Thank you in advance for your help, and as I said above, I don't necessarily need code, but an idea of how to make it work, so any ideas are welcome.

Mmm i'm not sure if i'm approaching this correctly.

Anyways, I wanted to create a multi-level thread, Where the child thread would be after the parent thread.

Something like this:

Hello World
       - Hello World
               - Hi!
               - What's up?
       - Hi Bob!
Goodbye World
       - ....This guy got issues
       - Dude! You should watch Despicable Me! "It's so fuzzy i'm going to dieee!"


Anyways, so my table looks something along the line of this:

|    post id   |    parent_id    |            title            |      body    |   date      |
      1                |       NULL        |    Hello                  | Hi, i'm K    |   date
      2                |       NULL        |    Thread One       | Body One  |   date
      3                |          1           |    Hello World | Body One  |   date
      4                |          2           |    Thread post 4   | Body One  |   date
      5                |          1           |    Thread post 5   | Body One  |   date
      6                |          1           |    Thread post 6   | Body One  |   date
      7                |          3           |    Hi What's up    | Body One  |   date


And here's the PHP code, although it's not very neat I want to clean it up and make it neater.  I can only go two level deep so far.   Any suggestion or recommendations? 

Using while & for:


// Select * Threads
$q = "SELECT * FROM test_db ORDER BY post_id ASC";
$r = @mysql_query($q);



while ($pid_row = @mysql_fetch_object($r)) {

// Array
$pid_arr[] = $pid_row->post_id; // Assign Indexes to Post ID
$ppid_arr[] = $pid_row->parent_id; // Assign Indexes to ParentID
$md_arr = array($pid_arr, $ppid_arr);  // Create multi-dimensional array matrix

$parent_id = $pid_row->parent_id;




}

for ($i = 0; $i < count($pid_arr); $i++) {

for ($a = 0; $a < count($ppid_arr); $a++) {
$pid = $pid_arr[$i]; // pid = post id
$ppid = $ppid_arr[$i]; // ppid = parent id

//echo "<div>~~ PID $pid ~~ PPID $ppid ~~</div>";

if ($ppid === NULL) {
$ppid_is_null = " & parent_id is NULL";
} else {
$ppid_is_null = NULL;
}

// Select Top level Thread
$z = "SELECT * FROM test_db WHERE post_id = '$pid'";
$y = @mysql_query($z);

while ($t_row = @mysql_fetch_object($y)) 
{

$title = $t_row->title;  // title of child thread
$level = $t_row->level;  // level of child thread...is this useful?
}




// Display top level thread lvl 1
if ($ppid === NULL) {  // If the parent_id is NULL, display top level thread
echo '<div>PID: ' . $pid . ' || PPID: ' . $ppid . " || Title: " . $title . "</div><br>\n";

$post = $pid; // PostID = 1
$parent = $ppid; // Parent ID ex: [1]

// Get child id, where parent id = [1]
// trying to get the child thread here...but it's not working
$child_q = "SELECT * FROM test_db WHERE parent_id = '$post'";
$child_r = @mysql_query($child_q);

while($c_row = @mysql_fetch_object($child_r)) {
$c_arr[] = $c_row->post_id;
$c_ppid_arr[] = $c_row->parent_id;
}
for ($n = 0; $n < count($c_arr); $n++) {
if ($c_ppid_arr[$n] === $post) {
echo "<div>$c_arr[$n]</div>";



}

}
break;

//echo "<div>PID: $pid</div>";




} 




break;
}

}



Using While:

<?php 
require_once('db_connection');
echo '<hr><hr><br>';

// I just realized that selecting * where parent id is null might limit the amount of rows retrieved.

// Query to select threads
$n = NULL;
$q = "SELECT * FROM test_db WHERE (test_db.parent_id is NULL) Order By date ASC";
$r = @mysql_query($q);

while ($threads = @mysql_fetch_object($r)){
$pid = $threads->post_id;
$sid = $threads->subject_id;
$parent_id = $threads->parent_id;
$title = $threads->title;
$body = $threads->body;



echo '<div>PostID: ' . $pid . ' || Parent: ' . $parent_id . ' || SubjectID: ' . $sid . ' || Title: ' . $title . ' || Body: ' . $body . '</div>';

$q2 = "SELECT * FROM test_db WHERE parent_id = '$pid' Order by date DESC";
$r2 = @mysql_query($q2);

while ($level2 = @mysql_fetch_object($r2)) {
$level2_pid = $level2->post_id;
$level = 1.5 *($level2->level); // lvl 2: 3em


echo '<div style="text-indent:' . $level . 'em">' . 'PostID: ' . $level2->post_id . ' || ParentID: ' . $level2->parent_id . '</div>';


$q3 = "SELECT * FROM test_db WHERE parent_id = '$level2_pid'";
$r3 = @mysql_query($r3);
while ($level3 = @mysql_fetch_object($r3)) {

$level3 = 1.5 + $level;

echo '<div style="text-indent:' . $level3 . 'em">' . 'PostID: ' . $level3->post_id . ' || ParentID: ' . $level3->parent_id . '</div>';

}






}


}


?>


I'm not a comp. sci major or anything, so I'm learning this as I go.  Any help would be greatly appreciated.   It seems like the while & for is more practical, but i'm not quiet sure.  What am I doing wrong?

- K

I just joined this forum today ^_^  Hope to be good friends with you guys and gals

I am currently creating a multi-user login system, and I have created the database in MySQL, but the problem is that my PHP script is not working as expected. I would like it so that if the user enters in a correct username + password combination, then they are redirected to a webpage called "congrats.php" for example. However, with my current PHP code, if I include a redirection instruction based on the correct input, then when I run the script, then the user is instantly taken to the congrats.php page without filling in any login details. I'm quite sure that the database has been connected to, as due to the layout of my script at the moment, the text that reads "You did it!" appears 4 times, the same number of rows in my MySQL database. My PHP coding for this is:

Code: [Select]
<html><head><title>Multi-User Log In Form</title></head>
<body>
<?php
$self = $_SERVER['PHP_SELF'];
$username = $_POST['username'];
$password = $_POST['password'];
?>
<form action = "<?php echo $self; ?>" method = "post">
Username <input type = "text" name = "username" size = "8">
Password <input type = "password" name = "password" size = "8">
<input type = "submit" value="Submit">
</form>
<?php
$conn = @mysql_connect("localhost", "root", "") or die ("Err: Conn");
$rs = @mysql_select_db("test3", $conn) or die ("Err: Db");
$sql = "select * from users";
$rs = mysql_query($sql, $conn);
while ($row = mysql_fetch_array($rs)) {

$name = $row["uname"];
$pass = $row["pword"];
if ($username = $name && $password = $pass)
{
//CODE FOR REDIRECTION SHOULD GO HERE
//header("location:congrats.php");
echo "You did it!";
}
else
{
echo "Invalid username and password combination";
}
}
?></body>
</html>

Any help in trying to get it so that my PHP script will redirect only if a correct username + password combination is entered would be greatly appreciated

Hello friends.

I'm needing a bit of help with some code.

I have this code to show my users their referral link:
(this code goes in the reg.php file)
Code: [Select]
if($_COOKIE['referido'])
{
$ref = $_COOKIE['referido'];
} else {
$ref = $do->get_r_file_url();
$ref = str_replace(array(".html", "/"), "", $ref);
if(eregi('.php', $ref)) { $ref=false; }

setcookie("referido", $ref, time()+60*60*24*30);
}
And then this one on the user's profile to show their referral URL:
Code: [Select]
$dp = $do->get_loc()."reg.php/{$signin_username}.html";
So the result is "mysite.com/reg.php/referral.html" and I want it to be "mysite.com/reg.php?referral"
I just need to get rid of the "/"
I've seen sites like "thesite.com/?r=referral"

How can i do something like that?

Thanks!

Hello friends!
I just need the last help to have everything working ok.

I'm having an issue because the input won't show the referral ID.

Here is the .htaccess code:
/*This changes the URL mysite.com/reg.php/referral.html to mysite.com/reg.php?referral*/
Code: [Select]
Options +FollowSymlinks
RewriteEngine on
RewriteRule ^reg.php/(.*)\.html$ http://www.mysite/reg.php?$1

Then the code in the reg.php page:
Code: [Select]
if($_COOKIE['referido'])
{
$ref = $_COOKIE['referido'];
} else {
$ref = $do->get_r_file_url();
$ref = str_replace(array(".html", "/"), "", $ref);
if(eregi('.php', $ref)) { $ref=false; }
setcookie("referido", $ref, time()+60*60*24*30);
}



And then the input:
<input size='3' style='width:170px;' id='referral' type='hidden' name='6' value='{$ref}' >


So how do I do to make the input show the referral ID?


Thanks!

In the database, I have a table called 'users' inside that I have email, nick (aka username), and balance.  The individual aspects are set up, and work.  My site is also successfully connecting to and reading / writing info in the database.  So my question is:  How would I go about having a box on the register page called 'refer' where the person would enter their referrers email (or nickname, one or the other) then it finds that person, and puts a value of 10 in 'balance'.  Anyone with more experience than me have any ideas?  All help is greatly appreciated.

Good evening guys and gals,

for some reason I cant get my head around something quite simple, basically I am trying to work out a way of simply recording referrals to my site when the potential user registers.

This worded example is basically what I want:

registered user a with a username of smithy invites his friend western to become a member of a site he has joined:

I guess here I would basically use something like mysite.com?refid=smithy as the link he gives he's friend

Now this is where my brain refuses to work, what if western decides to have a look around the site before he decides to register and clicks on a few internal pages? Obviously the referral id will no longer be in the address bar.

So my 1st question is, how can I check to see if a referral is used when accessing the site? I could then store the username in a session or cookie.

If I had something like this:

<?php

$refid = $_GET('refid')

setcookie("user", $refid, time()+3600);
?> 

But how would I check that a refid exists in the url so it doesnt throw up a parse error?

I have more questions but 1 thing at a time!

Many Thanks

I have a site where the user must view a timed loader before playing an audio bible.  I'm noticing some direct linking to the bible player instead of sitting through the loader...

I need to check the previous page's url before actually loading the player. I through together a script last ween in javascript and people reported error, so I assumed it would be best server side anyway.

I haven't coded anything in PHP since PHP3.  So, I'm asking for your expert options and help...

I haven't tested this yet, but is this the best method and are they any problems with this method (if it works).



$realname = basename($_SERVER[loader], ".php");

if ($realname == 'loader.php')
{
   return();
}

else
{
 // rediret to a notice to user that this isn't allow
 header( 'Location: http://www.yoursite.com/new_page.html' ) ;
}

       Right now, the following PHP script claims to send an email for Google referrals, as your forum states.  I put it in the first few lines of index.php.  Is this wrong, because I still received zero emails, adding the site name to keywords below...?  And, of course, I searched the same keyword from Google without success.

<?php
// Script to email you when Google refers traffic to your site.
$name=""; // add your name here
$email_address="";
 // add your email address here
$keywords="";
$referrer=$_SERVER['HTTP_REFERER'];
if( (stristr($referrer, "google")) && (stristr($referrer, "search")) ) {
   
parse_str($referrer, $output);
   $keywords=$output['q'];
      $email_message="Hi $name, A visitor just arrived to your site after searching for '$keywords'. ($referrer)";   mail ("$email_address","Google referred a visitor","$email_message");
}
?>
    If this is wrong, how DO I use such a PHP within my phpmyadmin folder?  Need help.

hello dear PHP-Fans - greetings to you - and a happy new year!!


i set up a WAMP-System on my openSuse 11.4 system.  In order to learn as much as i can bout PHP i want to do some tests and write some scripts.

Well the WAMP is allready up and running.  Now i try to give the writing access to the folder

mkdir /srv/www/

where the php-scripts should go in...

i want  to give write permission to all to all files in /srv/www

As root I generally:

mkdir /srv/www/
chown <webmaster usrername> /srv/www/

/srv/www/ should be readable and traversable by all, but only writeable by it's owner (the user designated as the webmaster.)

can i do this like mentioned above,...

Love to hear from you

greetings
db1

Hi -
I've got a program to allow the user to upload a file and then select, for each column
of an existing table, the column from the new source table to insert.  However, what
I need to do is do the insert using the actual names, but show the user a drop-down
menu of the LABELS they've chosen for each of these real, target columns.  Is there
a "clean" or "tricky" way of doing this?  The code to do the inserts works by just reading
the translation table that has two columns --  source column fieldname and target column
(in the existing table) fieldnames (both real fieldnames, of course).

Here's what I've got:

<form action="index.php" method="post">
   <input type="hidden" id="unique" name="unique" value="<?php echo $unique_nm; ?>" />
   <input type="hidden" id="savetotable" name="savetotable" value="1" />
   <?php foreach($LabelList as $c_name){ ?>
      <div>
         <div style="float: left; width: 300px;"; >
            <?php echo $c_name; ?>
         </div>
         <div style="float: left; width: 400px;">
            <select id="<?php echo $c_name; ?>" name="<?php echo $c_name; ?>">
               <option value=""></option>
               <?php foreach($SourceColumns as $h_name){ ?>
                  <option value="<?php echo trim($h_name); ?>">
                     <?php echo trim($h_name); ?>
                  </option>
               <?php } ?>
            </select>
         </div>
         <div style="clear: both;"></div>
      </div>
   <?php } ?>
   <input type="submit" value="Save to Database" />
</form>

So, while I could load the data into the targetfile pretty easily using the
real target table column names, how can I present the user with a drop-down
menu of LABELS, but insert the data into the REAL target fields?

Here's the list of ACTUAL fields:
   $output = array();
   $gather = 'select FieldName from MapTable where User = UserID'
   $this->call($gather);
      foreach($this->data as $row){
         $ActualFields[] = $row['COLUMN_NAME'];
      }
      return $ActualFields;
   }

Here's the list of LABELS (phony field names):
   $output = array();
   $gather = 'select LabelName from MapTable where User = UserID'
   $this->call($gather);
      foreach($this->data as $row){
         $LabelList[] = $row['COLUMN_NAME'];
      }
      return $LabelList;
   }

The list of fields from the sourcefile the user is loading
are all actual, real names ($SourceColumns)

Hello everybody,

i am working on n level category tree structure, for your information the category tree structure image is attached with this post.

Let's consider, each of the category have hundreds( n level ) of category in each, i want to traverse each category without using recursive functions, reason being recursive functions are very slow,  is there any way to do this??

Thanks,
phpeid