Gotharious

hello, what I made is, each user joins in, he enters a recruitment ID of another user who recruited him, so I can calculate the commission of each. and It's working great but now what I want to do, is to make each user take comission of the people he recruited, and the people they recruited and so on here is my code for the first, don't know how to make the second <?php $result = mysql_query("select * from users where id = '{$_GET['id']}'"); $row = @mysql_fetch_array($result); $rid = $row['id']; $sql = mysql_query("select * from users where recruiteris = $rid"); $num_rows = mysql_num_rows($sql); $var3 = '10'; $commission = $num_rows * $var3; ?>

no, I'm not following now ok here is the code, what do I need to add? <?php if (isset($_POST['email'])) { $email = $_POST['email']; $password = $_POST['password']; //Query $results = mysql_query("SELECT * FROM users WHERE email = '$email' AND password = '$password' "); $row = mysql_fetch_assoc($results); $count=mysql_num_rows($results); if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("email"); session_register("password"); header("location:index.php"); $_SESSION['id'] = $row['id']; } else { echo "Wrong Username or Password, Please click back and try again"; } mysql_close($con); } ?>

ok thanks, that's great now what if I want to redirect based on the user type I mean it looks up the database, and check the column type, and if this user is admin it redirects to admin.php, if staff then to staff.php and if client, then to client.php I tried header but didn't work at all

hello all, What I want to do is, make the session ID clickable in a url here Login Successful <a href="user.php">Conitnue</a> so when a user logs in, his ID gets in the link of Continue so he can only see his information so for example, if his id is 10, then the url would be ....user.php?id=10

DonE fixed the problem in my last reply was that I forgot to add the line that counts the number of rows <?php $count=mysql_num_rows($results); ?> When I added that line, it worked perfectly

Ok I tried using session_register, but now, instead of always unable to login, it now always logged in, then after a few tried it's always wrong username and password if (isset($_POST['email'])) { $email = $_POST['email']; $password = $_POST['password']; //Query $results = mysql_query("SELECT * FROM users WHERE email = '$email' AND password = '$password' "); if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("email"); session_register("password"); header("location:index.php"); } else { echo "Wrong Username or Password"; } mysql_close($con); } ?> index.php <? session_start(); if(!session_is_registered(password)){ header("location:logout.php"); } ?> Login Successful <a href="Users.php">Conitnue</a>

Hello All, I have this problem, no matter if I typed the wrong or right email and password, I always get Login failed message here is my code index.php <td class="white-text">Email: <form name="form1" method="post" action="/admin/Login.php"> <label for="user"></label> <input type="text" name="email" /> </td> </tr> <tr> <td><p><strong class="white-text">Password:</strong></p> <label for="sdf"></label> <input type="password" name="password" /> <p class="sdf"><strong></strong><a href="#" class="white-link-underline"><strong></strong></a> <input type="submit" name="submit" id="submit" value="Submit" /> </p> </form> </td> Login.php <?php session_start(); $con = mysql_connect("localhost","123","123"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("123", $con); if (isset($_POST['email'])) { $email = mysql_real_escape_string($_POST['email']); $password = mysql_real_escape_string($_POST['password']); //Query $results = mysql_query("SELECT * FROM users WHERE 'email' = '$email' AND password = '$password' "); if(!$result) { $_SESSION['error'] = '<span style="color: red">Login Failed. Email or Password is Incorrect <br/>'; } else { $row = mysql_fetch_assoc($results); $_SESSION['userid'] = $row['id']; $_SESSION['email'] = $email; $_SESSION['error'] = 'Login Successful<br/>. Welcome,'. $email; } mysql_close($con); } header('Location: ./index.php') ?>

Hello all, I've made this for users login, and now I want the user to only be able to see his info so how can I use the $_SESSION['userid'] to search the database for it's value and echo results? here is my code, I want to use the session value instead of get <? if (isset($_GET['id'])) { $con = mysql_connect("supremecenter14.co.uk","teko_waw","tmisabro77"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("teko_waw", $con); $result = mysql_query("select * from users where id = '{$_GET['id']}'"); $row = @mysql_fetch_array($result); echo "<table width=98%>"; echo "<tr>"; echo "<td valign=\"top\" width=\"120px\">"; $rowid = $row['id']; echo "<td valign=\"top\">"; echo "<table> <tr> <td valign=\"top\" class=\"searchtitle\"> ".$row['fname']. ' ' .$row['mname']. ' ' .$row['lname']." </td> </tr>"; ?> and here is where they're set if (isset($_POST['email'])) { $email = mysql_real_escape_string($_POST['email']); $password = mysql_real_escape_string($_POST['password']); //Query $results = mysql_query("SELECT * FROM users WHERE email = $email AND password = $password"); if(!result) { $_SESSION['error'] = '<span style="color: red">Login Failed. Email or Password is Incorrect <br/>'; } else { $row = mysql_fetch_assoc($results); $_SESSION['userid'] = $row['id']; $_SESSION['email'] = $email; $_SESSION['error'] = 'Login Successful<br/>. Welcome,'. $email; }

Worked, Thanks a lot guys

It's not defined, that's what I'm saying, I want to define it to the user ID in the first line of code i posted so I can use it in the second page to display details of a user, I just don't know how to define it between those two pages I was following a blog post, and they used that return, but no luck following their instructions anyway

Thanks a lot Thorpe, will give that a try

Hello there, I'm trying to make when you click on a record, it opens another page with full details about this record the code for it is <td><a href=\"user.php?id=".$row['id']."\">".$row['id']."</a></td> and it's working right, but when it opens the other page, no records is shown about the user with that ID So I figure the problem that I need to pass $row['id'] to my second page and make it search for it in the database how can I do that? here is the code from the second page (details of the record) $dbObj = new DB(); $result = mysql_query("select * from users where id = '$userID'"); return $result; $row = @mysql_fetch_array($result); echo "<table width=98%>"; echo "<tr>"; echo "<td valign=\"top\" width=\"120px\">"; $rowid = $row['id']; echo "<td valign=\"top\">"; echo "<table> <tr> <td valign=\"top\" class=\"searchtitle\"> ".$row['fname']. ' ' .$row['mname']. ' ' .$row['lname']." </td> </tr> <tr> <td class=\"text\" valign=\"top\"> ".$row['mobile']." </td> </tr> <tr> <td> <a href=\"user.php?id=".$row['recruiterid']."\" class=\"link\">".$row['recruiterid']."</a> </td> </tr> </table>"; echo "</td>"; echo "</tr>"; echo "</table>";

I would really be grateful for any help about this, a link perhaps to a code, cause I don't know the keywords to search for in google about this

Hello all, Many questions from me today, I know, but this is the last one How to make a login system where a user can only see his information, and his followers information (it's a network marketing website). like a tree with A->B->c->d->e A can see all, B can see all except A, C can see all except A and B and so on and also making one admin that can add, remove and modify users

Hello All, I'm making a website, the same idea like Qnet and what not, now what I want to do, is display the members in a structure like a tree how can I do that? here is an image from google search for what I mean http://networkmarketingteam.org/wp-content/uploads/2011/08/matrix-tree.png

Hello there, I'm making this website, it is some kind of multi level marketing company, the point is, I want two things 1. When adding a new member, I want php to check if there are 2 users with the same recruiter ID or not, so if there is 2, the member can't be added, if there is less, then it can be added 3. when doing an echo, I want it to search for members associated with a certain member and calculate a commission.. I was thinking about making it by ID of a member, but that would mean only people who has his ID as a recruiter ID will be counted, and not the people they recruited Example: A recruited B, and B recruited C, and C recruited D the commission is $10 per recruit then A would get $30 and B would get $20 and C gets $10 is that possible?

I'm making a login area for the hotels in a booking system, where they enter their hotels' information, policy, and room rates but I want to make the room rates when it appears for clients, it appears with a percentage (commission) added to what the Hotel representative will enter So what's better? it should be added in the admin area of the hotels and gets saved in the database with the commission or I should add it in the booking form so the code grab the rate from the database, multiply it by the percentage and echo the result?

Thanks Dave, but which variable are you talking about?

I don't thing I'm following what you're saying... Sorry, I know I'm annoying sometimes, but I really don't get anything from what you said

Ok, now it posts the roomID but not the selected one, because I selected room that has ID 6 and the outcome was 4, Also, it doesn't echo it here when I echo $roomID and the nrooms now gives an array instead of the number of rooms check-in Date: 17 Oct 2011 check-out Date: 20 Oct 2011 Total Price: 0 Total Nights: 3 Total Rooms: Total Rooms: room id: Rooms id: Array Array ( [roomid] => [roomnum] => [hotelid] => 13 [datein] => 17 Oct 2011 [dateout] => 20 Oct 2011 [roomID] => Array ( [4] => 4 [5] => 5 [6] => 6 ) [\"nrooms] => Array ( [$roomID] => 4 ) [bookroom] => book )

Ok, here is the outcome I got For RoomID 4 the person booked For RoomID 5 the person booked For RoomID 6 the person booked Dar Al Masyaf Hotel Jumeirah, in Jumeirah Beach Road check-in Date: 3 Oct 2011 check-out Date: 7 Oct 2011 Total Price: 12 Total Nights: 4 Total Rooms: Total Rooms: room id: Rooms id: Array Array ( [roomid] => [roomnum] => [hotelid] => 13 [datein] => 3 Oct 2011 [dateout] => 7 Oct 2011 [roomID] => Array ( [4] => 4 [5] => 5 [6] => 6 ) [nrooms] => 3 [bookroom] => book )

Ok, maybe I'm a bit mixed up now So this foreach, I should post it in the confirmation page, right?

any thoughts?

Ok good, but still I can't solve the problem now, I'm not sure what should I do next

Well, It gives me Array now when I echo roomID