Jump to content

Login problem

mpatel

By mpatel
in PHP Coding Help

 Share

Recommended Posts

mpatel Newbie

mpatel

Posted
Posted

i want help as i cant find that the reason that why registered members cant login, when user pass entered it does not process any thing any help will be appreciated

 

<?php
  session_start();
  session_register("id_session");
  session_register("password_session");
include "header.php";
include "config.php";
$a="";
$b="";
if ($_POST) {
$a=trim($_POST["id"]);
$b=trim($_POST["password"]);
$a=str_replace("'","",$a);
$b=str_replace("'","",$b);
$a=str_replace("\"","",$a);
$b=str_replace("\"","",$b);
}
if ($a=="" || $b=="")
{

  if ($_SESSION["id_session"]=="" || $_SESSION["password_session"]=="")
  {

?>
		<form action=members.php method=post>

<br><br><Center><table><tr><td colspan=2 align=center><h3>Members Login Area</h3></td></tr>
<tr><td>Member's ID</td><td><input type=text name=id></td></tr>
<tr><td>Password</td><td><input type=password name=password></td></tr>
<tr><td> </td><td>
<a href="forgot.php" onclick="doexit=false;"><font face="Verdana,Arial,Helvetica" size="1" color="#000000"><b>Forgot Your Password?</b></font></a></td></tr>
<tr><td colspan=2 align=center><input type=submit value="Log In"></td></tr>			
</table></form>


<?
  }
  else
  {
  middle();
  }
}
else
{
$check=0;

$id=$_POST["id"];
$rs = mysql_query("select * from members where ID='$id'");

if ($rs) {
$arr=mysql_fetch_array($rs);
$n2=$arr['Password'];
if ($n2==$b) {
	$check=1;
	$_SESSION["id_session"]=$arr[0];
	$_SESSION["password_session"]=$arr[9];
	middle();
}
}
if ($check==0)
{
  print "<h2>Invalid User Id or Password</h2>";
?>
		<form action=members.php method=post>

<br><br><Center><table><tr><td colspan=2 align=center><h3>Members Login Area</h3></td></tr>
<tr><td>Member's ID</td><td><input type=text name=id></td></tr>
<tr><td>Password</td><td><input type=password name=password></td></tr>
<tr><td> </td><td>
<a href="forgot.php" onclick="doexit=false;"><font face="Verdana,Arial,Helvetica" size="1" color="#000000"><b>Forgot Your Password?</b></font></a></td></tr>
<tr><td colspan=2 align=center><input type=submit value="Log In"></td></tr>			
</table></form>
<? 
} 
}

function middle()
{
$id=$_SESSION["id_session"];
$rs = mysql_query("select * from members where ID=$id");
$arr=mysql_fetch_array($rs);
$check=1;
$id=$arr[0];
$password=$arr[9];
        $name=$arr[1];
       	$address=$arr[2];
$city=$arr[3];
$state=$arr[4];
$zip=$arr[5];
$country=$arr[6];
$phone=$arr[7];
$email=$arr[8];
$password=$b;
$paymentoption=$arr[10];
$refby=$arr[11];
$l1=$arr[12];
$l2=$arr[13];
$l3=$arr[14];
$l4=$arr[15];
$l5=$arr[16];
$l6=$arr[17];
$l7=$arr[18];
$l8=$arr[19];
$l9=$arr[20];
$l10=$arr[21];
$leader=$arr[22];
$total=$arr[23];
$unpaid=$arr[24];
$paid=$arr[25];

?>
<table border="0" width="650">
   <tr>
   <td width="150" valign="top">
     <table width="140">
     <tr>
       <td align="left"><br><br><br><br>
        <ul><font face="verdana" size="1">
		<a href="stats.php">Statistics</a><br><br>
		<a href="update_pf.php">Edit Personal Information</a><br><br>
		<a href="sample_e.php">Referral Code & Links</a><br><br>
     	 	        <a href="logout.php">Logout</a><br><br>
</td></tr></table>
     </td>
     <td VALIGN="top">
     <table>
	<tr> 
		<td>
		<font face="verdana" size="3"><b>
		<p>Account Center</b></font></p>
<br>
</td> 
</tr>
<tr>
<td>

	<div align="center">
	<table border="0" cellpadding="3" cellspacing="0" width="400">
	     
	      <tr> 
	        <td colspan="2"><b>
	         <hr><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><center> Account Details for <?echo $name;?></font></center></b><hr>
	        </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Total Commisions Earned: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $total;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Commisions Due: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $unpaid;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Commisions Paid: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $paid;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2> </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Direct Referrals: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1"><?
$rsd=mysql_query("select * from members where Leader=".$id);
echo mysql_num_rows($rsd); ?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2> </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2><strong><font face="Verdana" size="3">Downline Information </font></strong><br></td>
	      </tr>

	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Total Downline Size: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1"><?     echo ($l1+$l2+$l3+$l4+$l5+$l6+$l7+$l8+$l9+$l10); ?></font><br></td>
	      </tr>
		<tr><td colspan=2>

		<Table width=100%>
		<tr><td bgcolor=#000000><strong><font face="Verdana" size="-1" color=#ffffff>Level</font></strong></td>
		<td bgcolor=#000000><strong><font face="Verdana" size="-1" color=#ffffff>Number of Members</font></strong></td>	</tr>
<? include "config.php"; ?>
		<? for($i=1;$i<=$levels;$i++) { ?>
		<tr><td><strong><font face="Verdana" size="-1"><? echo $i; ?></font></strong></td>
		<td ><font face="Verdana" size="-1">
		<?
		if($i==1) {
			echo $l1; 
		}
		elseif($i==2) {
			echo $l2; 
		}
		elseif($i==3) {
			echo $l3; 
		}
		elseif($i==4) {
			echo $l4; 
		}
		elseif($i==5) {
			echo $l5; 
		}
		elseif($i==6) {
			echo $l6; 
		}
		elseif($i==7) {
			echo $l7; 
		}
		elseif($i== {
			echo $l8; 
		}
		elseif($i==9) {
			echo $l9; 
		}
		elseif($i==10) {
			echo $l10; 
		}
		?>
		</font></td>	</tr>
		<? } ?>
		</table>
		</td></tr>
	      <tr><td colspan=4><hr></td><tr>
	     </table>
		</div>

		</td>
	</tr>

</table>
		<font face="verdana" size="3"><b>
		<p>Download Center</b></font></p>

<?
include "download.php";
?>
  </td>
  </tr>
</table>
<br><br>
<?
}
include "footer.php";
?>

 

edit: added 



 blocks 



			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					






					
					
					
				

					

					
					







	

	

	

		

			

				


	
		JasonLewis
	

				
				
					
						
Member
					
				
			

		

		

			

				


JasonLewis
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

As well as that, I suggest you use better names for your variables. Also this:






if($_POST)







Will always be fired, you're better off using the name of your submit button in there.



Example:






<input type="submit" name="login" value="Log me in!" />

// Then for your if statement
if(isset($_POST['login']))







			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
			

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1260110
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					






					
					
					
				

					

					
					







	

	

	

		

			

				


	
		voip03
	

				
				
					
						
Member
					
				
			

		

		

			

				


voip03
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

You are missing two parts



1. Submit button name



2. Submit post






<?php  
session_start();  
session_register("id_session");  
session_register("password_session");
include "header.php";
include "config.php";

$a="";
$b="";

if(isset($_POST['Submit'])) // <-- if Submit  ** please check the enclose link
{	
	$a=trim($_POST["id"]);	

	$b=trim($_POST["password"]);	
	$a=str_replace("'","",$a);	
	$b=str_replace("'","",$b);	
	$a=str_replace("\"","",$a);	
	$b=str_replace("\"","",$b);
}

if ($a=="" || $b==""){  if ($_SESSION["id_session"]=="" || $_SESSION["password_session"]=="")  
{
?>			
<form action=members.php method=post>
<br><br><Center>
<table><tr><td colspan=2 align=center>
<h3>Members Login Area</h3>
</td></tr>
<tr><td>Member's ID</td>
<td><input type=text name=id></td></tr>
<tr><td>Password</td><td><input type=password name=password></td></tr>
<tr><td> </td><td>
<a href="forgot.php" onclick="doexit=false;"><font face="Verdana,Arial,Helvetica" size="1" color="#000000">
<b>Forgot Your Password?</b>
</font></a>
</td></tr>
<tr><td colspan=2 align=center>
<input type=submit name="Submit" value="Log In"> !<-- Submit buttoon need a name -->

</td></tr>			
</table>
</form>

Link for isset

[url]http://php.net/manual/en/function.isset.php[/url]








			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1260219
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					







	

	

	

		

			

				


	
		voip03
	

				
				
					
						
Member
					
				
			

		

		

			

				


voip03
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

You are missing two parts



1. Submit button name



2. Submit post






<?php  
session_start();  
session_register("id_session");  
session_register("password_session");
include "header.php";
include "config.php";

$a="";
$b="";

if(isset($_POST['Submit'])) // <-- if Submit  ** please check the enclose link
{	
	$a=trim($_POST["id"]);	

	$b=trim($_POST["password"]);	
	$a=str_replace("'","",$a);	
	$b=str_replace("'","",$b);	
	$a=str_replace("\"","",$a);	
	$b=str_replace("\"","",$b);
}

if ($a=="" || $b==""){  if ($_SESSION["id_session"]=="" || $_SESSION["password_session"]=="")  
{
?>			
<form action=members.php method=post>
<br><br><Center>
<table><tr><td colspan=2 align=center>
<h3>Members Login Area</h3>
</td></tr>
<tr><td>Member's ID</td>
<td><input type=text name=id></td></tr>
<tr><td>Password</td><td><input type=password name=password></td></tr>
<tr><td> </td><td>
<a href="forgot.php" onclick="doexit=false;"><font face="Verdana,Arial,Helvetica" size="1" color="#000000">
<b>Forgot Your Password?</b>
</font></a>
</td></tr>
<tr><td colspan=2 align=center>
<input type=submit name="Submit" value="Log In"> !<-- Submit buttoon need a name -->

</td></tr>			
</table>
</form>









Link for isset


 



http://php.net/manual/en/function.isset.php


 



			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1260227
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					






					
					
					
				

					

					
					







	

	

	

		

			

				


	
		Muddy_Funster
	

				
				
					
						
Regular Member
					
				
			

		

		

			

				


Muddy_Funster
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			




thanks for your precious effort i tried but still it wont work  :'( i cant understand this why this script dont work  :shrug: am i missing something  :confused:








 



Every time you change code could you please upload your up to date code for us to see what changes have been made?



			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
			

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1260452
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					







	

	

	

		

			

				


	
		mpatel
	

				
				
					
						
Newbie
					
				
			

		

		

			

				


mpatel
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
						
  • Author
    • 
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

when i run test it shows the following result that i wanna show you so you can figure it out the problem.


 






array(6) {
  ["__utma"]=>
  string(53) "55614265.351789400.1313879250.1313879250.1313879250.1"
  ["__utmc"]=>
  string( "55614265"  
  ["__utmz"]=>
  string(69) "55614265.1313879250.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)"
  ["PHPSESSID"]=>
  string(32) "451adbe95069908ba81c9946ad563de9"
  ["acopendivids"]=>
  string(4) "nada"
  ["acgroupswithpersist"]=>
  string(4) "nada"
}
array(11) {
  ["refid_session"]=>
  NULL
  ["id_session"]=>
  NULL
  ["password_session"]=>
  NULL
  ["admin_session"]=>
  string(4) "test"
  ["totalusercount_session"]=>
  NULL
  ["usercount_session"]=>
  NULL
  ["sub_admin_privileges"]=>
  NULL
  ["admin"]=>
  array(4) {
    ["user_name"]=>
    string(7) "purvasp"
    ["id"]=>
    string(1) "1"
    ["name"]=>
    string(13) "Administrator"
    ["admin_mail"]=>
    string(25) "[email protected]"
  }
  ["adminid"]=>
  string(1) "1"
  ["intro_name"]=>
  string(0) ""
  ["error_message"]=>
  string(0) ""
}
array(0) {
}








muddy_funster now hope you have solution for my errors. i think youre expert after running test i got above error, you asked what code i used, i used below code to find the error reply soon with solution thank you in advance 






error_reporting(E_ALL);
echo "<pre>";
var_dump($_COOKIE);
var_dump($_SESSION);
var_dump($_POST);
echo "</pre>";







any member with solution are invited and their effort will be appreciated and the voip03 i need your help the most here thank you



			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1260634
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					







	

	

	

		

			

				


	
		Muddy_Funster
	

				
				
					
						
Regular Member
					
				
			

		

		

			

				


Muddy_Funster
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

The code I was asking for was the revised page that is giving you the problem, howerver, you will need to add quotes to the following:


<form action=members.php method=post>  
// becomes
<form action="members.php" method="post">






 



add the quotes, and then if it's still not working please post up your full revised code so we are both working off the same page (literaly).  Also, if there are any errormessages or other bits of information they would be helpfull too


 



P.S. I'm so far from being an expert it's not even on the horizon



			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
			

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1260736
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					






					
					
					
				

					

					
					






					
					
					
				

					

					
					






					
					
					
				

					

					
					






					
					
					
				

					

					
					






					
						
    
							
							
								
  • 
									2 weeks later...
								
    • 
							
						

					
					
					
				

					

					
					







	

	

	

		

			

				


	
		mpatel
	

				
				
					
						
Newbie
					
				
			

		

		

			

				


mpatel
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
						
  • Author
    • 
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

i have change the script have a look


<?php 
//Create a session
session_start(); 
//Make a connection to the database
$dbh=mysql_connect ("localhost", "", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("");
include "header.php";
include "config.php";
$id="";
$password="";
//Retrieve the form elements values
if (isset($_POST['id']))
  $id = $_POST['id'];

  if (isset($_POST['password']))
{
  $password = $_POST['password'];
}
if (isset($_GET['id']))
{
  $id = $_GET['id'];
}
if (isset($_GET['password']))
{
  $password = $_GET['password'];
}
//If login is not blank retrieve id information
if($id!="" || $password !="")
{
$query = sprintf("SELECT * FROM users WHERE userName='".$id."' AND password='".$password."'",
mysql_real_escape_string($id),
mysql_real_escape_string($password));
//If match found then login succeeded. Set session
if($affected_rows==1)
{
  $_SESSION['id'] = $id;
  print "<center>Login successful, you can redirect to another web site using header variable of php if the login is validated like know.<br>I am sure You can figure out that.</center>";
}
else
{
//If match not found, inform the id
  print "<center><font color=red>Incorrect username or password or both. Try again.</fon></center>";
}
}
else
{
  print "<center><b>Please Login</b></center>";
}
?>
<form name="Members Login Area" action="members.php" method="post">
<table width="100%">
<tr>
<td align="center" class="text">Username:</td>
</tr>
<tr>
<td align="center" class="text"><input type="text" name="id" size="15" maxlenght="20"></td>
</tr>
<tr>
<td align="center" class="text">Password:</td>
</tr>
<tr>
<td align="center" class="text"> <input type="password" name="password" size="15" maxlenght="20"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="Login" value="Login"></td>
</tr>
</table>
</form>
<?
function middle()
{
$id=$_SESSION["id_session"];
$rs = mysql_query("select * from members where ID=$id");
$arr=mysql_fetch_array($rs);
$check=1;
$id=$arr[0];
$password=$arr[9];
        $name=$arr[1];
       	$address=$arr[2];
$city=$arr[3];
$state=$arr[4];
$zip=$arr[5];
$country=$arr[6];
$phone=$arr[7];
$email=$arr[8];
$password=$b;
$paymentoption=$arr[10];
$refby=$arr[11];
$l1=$arr[12];
$l2=$arr[13];
$l3=$arr[14];
$l4=$arr[15];
$l5=$arr[16];
$l6=$arr[17];
$l7=$arr[18];
$l8=$arr[19];
$l9=$arr[20];
$l10=$arr[21];
$leader=$arr[22];
$total=$arr[23];
$unpaid=$arr[24];
$paid=$arr[25];

?>
<table border="0" width="650">
   <tr>
   <td width="150" valign="top">
     <table width="140">
     <tr>
       <td align="left"><br><br><br><br>
        <ul><font face="verdana" size="1">
		<a href="stats.php">Statistics</a><br><br>
		<a href="update_pf.php">Edit Personal Information</a><br><br>
		<a href="sample_e.php">Referral Code & Links</a><br><br>
     	 	        <a href="logout.php">Logout</a><br><br>
</td></tr></table>
     </td>
     <td VALIGN="top">
     <table>
	<tr> 
		<td>
		<font face="verdana" size="3"><b>
		<p>Account Center</b></font></p>
<br>
</td> 
</tr>
<tr>
<td>

	<div align="center">
	<table border="0" cellpadding="3" cellspacing="0" width="400">
	     
	      <tr> 
	        <td colspan="2"><b>
	         <hr><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><center> Account Details for <?echo $name;?></font></center></b><hr>
	        </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Total Commisions Earned: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $total;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Commisions Due: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $unpaid;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Commisions Paid: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $paid;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2> </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Direct Referrals: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1"><?
$rsd=mysql_query("select * from members where Leader=".$id);
echo mysql_num_rows($rsd); ?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2> </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2><strong><font face="Verdana" size="3">Downline Information </font></strong><br></td>
	      </tr>

	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Total Downline Size: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1"><?     echo ($l1+$l2+$l3+$l4+$l5+$l6+$l7+$l8+$l9+$l10); ?></font><br></td>
	      </tr>
		<tr><td colspan=2>

		<Table width=100%>
		<tr><td bgcolor=#000000><strong><font face="Verdana" size="-1" color=#ffffff>Level</font></strong></td>
		<td bgcolor=#000000><strong><font face="Verdana" size="-1" color=#ffffff>Number of Members</font></strong></td>	</tr>
<? include "config.php"; ?>
		<? for($i=1;$i<=$levels;$i++) { ?>
		<tr><td><strong><font face="Verdana" size="-1"><? echo $i; ?></font></strong></td>
		<td ><font face="Verdana" size="-1">
		<?
		if($i==1) {
			echo $l1; 
		}
		elseif($i==2) {
			echo $l2; 
		}
		elseif($i==3) {
			echo $l3; 
		}
		elseif($i==4) {
			echo $l4; 
		}
		elseif($i==5) {
			echo $l5; 
		}
		elseif($i==6) {
			echo $l6; 
		}
		elseif($i==7) {
			echo $l7; 
		}
		elseif($i== {
			echo $l8; 
		}
		elseif($i==9) {
			echo $l9; 
		}
		elseif($i==10) {
			echo $l10; 
		}
		?>
		</font></td>	</tr>
		<? } ?>
		</table>
		</td></tr>
	      <tr><td colspan=4><hr></td><tr>
	     </table>
		</div>

		</td>
	</tr>

</table>
		<font face="verdana" size="3"><b>
		<p>Download Center</b></font></p>

<?
include "download.php";
?>
  </td>
  </tr>
</table>
<br><br>
<?
}
include "footer.php";
?>





 in this new script i am getting following error 



Undefined variable: affected_rows in D:\xampp\htdocs\members.php on line 34



			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1264675
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					






					
					
					
				

					

					
					







	

	

	

		

			

				


	
		mpatel
	

				
				
					
						
Newbie
					
				
			

		

		

			

				


mpatel
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
						
  • Author
    • 
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			



<?php 
//Create a session
session_start(); 
//Make a connection to the database
$dbh=mysql_connect ("localhost", "root", "7425") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("1");
include "header.php";
include "config.php";
$id="";
$password="";
//Retrieve the form elements values
if (isset($_POST['id']))
  $id = $_POST['id'];

  if (isset($_POST['password']))
{
  $password = $_POST['password'];
}
if (isset($_GET['id']))
{
  $id = $_GET['id'];
}
if (isset($_GET['password']))
{
  $password = $_GET['password'];
}
//If login is not blank retrieve id information
if($id!="" || $password !="")
{
$query = sprintf("SELECT * FROM users WHERE userName='".$id."' AND password='".$password."'",
mysql_real_escape_string($id),
mysql_real_escape_string($password));
//If match found then login succeeded. Set session
if($affected_rows==1)
{
  $_SESSION['id'] = $id;
  print "<center>Login successful, you can redirect to another web site using header variable of php if the login is validated like know.<br>I am sure You can figure out that.</center>";
}
else
{
//If match not found, inform the id
  print "<center><font color=red>Incorrect username or password or both. Try again.</fon></center>";
}
}
else
{
  print "<center><b>Please Login</b></center>";
}
?>
<form name="Members Login Area" action="members.php" method="post">
<table width="100%">
<tr>
<td align="center" class="text">Username:</td>
</tr>
<tr>
<td align="center" class="text"><input type="text" name="id" size="15" maxlenght="20"></td>
</tr>
<tr>
<td align="center" class="text">Password:</td>
</tr>
<tr>
<td align="center" class="text"> <input type="password" name="password" size="15" maxlenght="20"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="Login" value="Login"></td>
</tr>
</table>
</form>
<?
function middle()
{
$id=$_SESSION["id_session"];
$rs = mysql_query("select * from members where ID=$id");
$arr=mysql_fetch_array($rs);
$check=1;
$id=$arr[0];
$password=$arr[9];
        $name=$arr[1];
       	$address=$arr[2];
$city=$arr[3];
$state=$arr[4];
$zip=$arr[5];
$country=$arr[6];
$phone=$arr[7];
$email=$arr[8];
$password=$b;
$paymentoption=$arr[10];
$refby=$arr[11];
$l1=$arr[12];
$l2=$arr[13];
$l3=$arr[14];
$l4=$arr[15];
$l5=$arr[16];
$l6=$arr[17];
$l7=$arr[18];
$l8=$arr[19];
$l9=$arr[20];
$l10=$arr[21];
$leader=$arr[22];
$total=$arr[23];
$unpaid=$arr[24];
$paid=$arr[25];

?>
<table border="0" width="650">
   <tr>
   <td width="150" valign="top">
     <table width="140">
     <tr>
       <td align="left"><br><br><br><br>
        <ul><font face="verdana" size="1">
		<a href="stats.php">Statistics</a><br><br>
		<a href="update_pf.php">Edit Personal Information</a><br><br>
		<a href="sample_e.php">Referral Code & Links</a><br><br>
     	 	        <a href="logout.php">Logout</a><br><br>
</td></tr></table>
     </td>
     <td VALIGN="top">
     <table>
	<tr> 
		<td>
		<font face="verdana" size="3"><b>
		<p>Account Center</b></font></p>
<br>
</td> 
</tr>
<tr>
<td>

	<div align="center">
	<table border="0" cellpadding="3" cellspacing="0" width="400">
	     
	      <tr> 
	        <td colspan="2"><b>
	         <hr><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><center> Account Details for <?echo $name;?></font></center></b><hr>
	        </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Total Commisions Earned: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $total;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Commisions Due: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $unpaid;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Commisions Paid: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $paid;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2> </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Direct Referrals: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1"><?
$rsd=mysql_query("select * from members where Leader=".$id);
echo mysql_num_rows($rsd); ?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2> </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2><strong><font face="Verdana" size="3">Downline Information </font></strong><br></td>
	      </tr>

	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Total Downline Size: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1"><?     echo ($l1+$l2+$l3+$l4+$l5+$l6+$l7+$l8+$l9+$l10); ?></font><br></td>
	      </tr>
		<tr><td colspan=2>

		<Table width=100%>
		<tr><td bgcolor=#000000><strong><font face="Verdana" size="-1" color=#ffffff>Level</font></strong></td>
		<td bgcolor=#000000><strong><font face="Verdana" size="-1" color=#ffffff>Number of Members</font></strong></td>	</tr>
<? include "config.php"; ?>
		<? for($i=1;$i<=$levels;$i++) { ?>
		<tr><td><strong><font face="Verdana" size="-1"><? echo $i; ?></font></strong></td>
		<td ><font face="Verdana" size="-1">
		<?
		if($i==1) {
			echo $l1; 
		}
		elseif($i==2) {
			echo $l2; 
		}
		elseif($i==3) {
			echo $l3; 
		}
		elseif($i==4) {
			echo $l4; 
		}
		elseif($i==5) {
			echo $l5; 
		}
		elseif($i==6) {
			echo $l6; 
		}
		elseif($i==7) {
			echo $l7; 
		}
		elseif($i== {
			echo $l8; 
		}
		elseif($i==9) {
			echo $l9; 
		}
		elseif($i==10) {
			echo $l10; 
		}
		?>
		</font></td>	</tr>
		<? } ?>
		</table>
		</td></tr>
	      <tr><td colspan=4><hr></td><tr>
	     </table>
		</div>

		</td>
	</tr>

</table>
		<font face="verdana" size="3"><b>
		<p>Download Center</b></font></p>

<?
include "download.php";
?>
  </td>
  </tr>
</table>
<br><br>
<?
}
include "footer.php";
?>








if($affected_rows==1)


 



			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1264699
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					







	

	

	

		

			

				


	
		voip03
	

				
				
					
						
Member
					
				
			

		

		

			

				


voip03
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

before









	//If login is not blank retrieve id information



	if($id!="" || $password !=""){



		$query = sprintf("SELECT * FROM users WHERE userName='".$id."' AND password='".$password."'",



		mysql_real_escape_string($id),



		mysql_real_escape_string($password));


 


 



		//If match found then login succeeded. Set session



		if($affected_rows==1)


 









 after adding code


 






                               mysql_real_escape_string($password));

                 $res=mysql_query($query);
	$affected_rows = mysql_num_rows($res);

                                 //If match found then login succeeded. Set session
	if($affected_rows==1)









			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1264708
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					







	

	

	

		

			

				


	
		mpatel
	

				
				
					
						
Newbie
					
				
			

		

		

			

				


mpatel
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
						
  • Author
    • 
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

i am getting following error



Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\members.php on line 32($affected_rows =mysql_num_rows($result);)






<?php 
//Create a session
session_start(); 
//Make a connection to the database
$dbh=mysql_connect ("localhost", "", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("1");
include "header.php";
include "config.php";
$id="";
$password="";
//Retrieve the form elements values
if (isset($_POST['id']))
  $id = $_POST['id'];

  if (isset($_POST['password']))
{
  $password = $_POST['password'];
}
if (isset($_GET['id']))
{
  $id = $_GET['id'];
}
if (isset($_GET['password']))
{
  $password = $_GET['password'];
}
//If login is not blank retrieve id information
mysql_real_escape_string($password);
$result = mysql_query($query, $dbh);
$affected_rows =mysql_num_rows($result);
//If match found then login succeeded. Set session
if($affected_rows==1)
{
  $_SESSION['id'] = $id;
  print "<center>Login successful, you can redirect to another web site using header variable of php if the login is validated like know.<br>I am sure You can figure out that.</center>";
}
else
{
//If match not found, inform the id
  print "<center><font color=red>Incorrect username or password or both. Try again.</fon></center>";
}
}
else
{
  print "<center><b>Please Login</b></center>";
}
?>
<form name="Members Login Area" action="members.php" method="post">
<table width="100%">
<tr>
<td align="center" class="text">Username:</td>
</tr>
<tr>
<td align="center" class="text"><input type="text" name="id" size="15" maxlenght="20"></td>
</tr>
<tr>
<td align="center" class="text">Password:</td>
</tr>
<tr>
<td align="center" class="text"> <input type="password" name="password" size="15" maxlenght="20"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="Login" value="Login"></td>
</tr>
</table>
</form>
<?
function middle()
{
$id=$_SESSION["id_session"];
$rs = mysql_query("select * from members where ID=$id");
$arr=mysql_fetch_array($rs);
$check=1;
$id=$arr[0];
$password=$arr[9];
        $name=$arr[1];
       	$address=$arr[2];
$city=$arr[3];
$state=$arr[4];
$zip=$arr[5];
$country=$arr[6];
$phone=$arr[7];
$email=$arr[8];
$password=$b;
$paymentoption=$arr[10];
$refby=$arr[11];
$l1=$arr[12];
$l2=$arr[13];
$l3=$arr[14];
$l4=$arr[15];
$l5=$arr[16];
$l6=$arr[17];
$l7=$arr[18];
$l8=$arr[19];
$l9=$arr[20];
$l10=$arr[21];
$leader=$arr[22];
$total=$arr[23];
$unpaid=$arr[24];
$paid=$arr[25];

?>
<table border="0" width="650">
   <tr>
   <td width="150" valign="top">
     <table width="140">
     <tr>
       <td align="left"><br><br><br><br>
        <ul><font face="verdana" size="1">
		<a href="stats.php">Statistics</a><br><br>
		<a href="update_pf.php">Edit Personal Information</a><br><br>
		<a href="sample_e.php">Referral Code & Links</a><br><br>
     	 	        <a href="logout.php">Logout</a><br><br>
</td></tr></table>
     </td>
     <td VALIGN="top">
     <table>
	<tr> 
		<td>
		<font face="verdana" size="3"><b>
		<p>Account Center</b></font></p>
<br>
</td> 
</tr>
<tr>
<td>

	<div align="center">
	<table border="0" cellpadding="3" cellspacing="0" width="400">
	     
	      <tr> 
	        <td colspan="2"><b>
	         <hr><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><center> Account Details for <?echo $name;?></font></center></b><hr>
	        </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Total Commisions Earned: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $total;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Commisions Due: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $unpaid;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Commisions Paid: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $paid;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2> </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Direct Referrals: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1"><?
$rsd=mysql_query("select * from members where Leader=".$id);
echo mysql_num_rows($rsd); ?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2> </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2><strong><font face="Verdana" size="3">Downline Information </font></strong><br></td>
	      </tr>

	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Total Downline Size: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1"><?     echo ($l1+$l2+$l3+$l4+$l5+$l6+$l7+$l8+$l9+$l10); ?></font><br></td>
	      </tr>
		<tr><td colspan=2>

		<Table width=100%>
		<tr><td bgcolor=#000000><strong><font face="Verdana" size="-1" color=#ffffff>Level</font></strong></td>
		<td bgcolor=#000000><strong><font face="Verdana" size="-1" color=#ffffff>Number of Members</font></strong></td>	</tr>
<? include "config.php"; ?>
		<? for($i=1;$i<=$levels;$i++) { ?>
		<tr><td><strong><font face="Verdana" size="-1"><? echo $i; ?></font></strong></td>
		<td ><font face="Verdana" size="-1">
		<?
		if($i==1) {
			echo $l1; 
		}
		elseif($i==2) {
			echo $l2; 
		}
		elseif($i==3) {
			echo $l3; 
		}
		elseif($i==4) {
			echo $l4; 
		}
		elseif($i==5) {
			echo $l5; 
		}
		elseif($i==6) {
			echo $l6; 
		}
		elseif($i==7) {
			echo $l7; 
		}
		elseif($i== {
			echo $l8; 
		}
		elseif($i==9) {
			echo $l9; 
		}
		elseif($i==10) {
			echo $l10; 
		}
		?>
		</font></td>	</tr>
		<? } ?>
		</table>
		</td></tr>
	      <tr><td colspan=4><hr></td><tr>
	     </table>
		</div>

		</td>
	</tr>

</table>
		<font face="verdana" size="3"><b>
		<p>Download Center</b></font></p>

<?
include "download.php";
?>
  </td>
  </tr>
</table>
<br><br>
<?
}
include "footer.php";
?>








			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1264745
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					







	

	

	

		

			

				


	
		voip03
	

				
				
					
						
Member
					
				
			

		

		

			

				


voip03
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

yes  you will get this error. cox you are not quearing the db.






//If login is not blank retrieve id informationif($id!="" || $password !=""){$query = sprintf("SELECT * FROM users WHERE userName='".$id."' AND password='".$password."'",mysql_real_escape_string($id),mysql_real_escape_string($password));

//If match found then login succeeded. Set session

$res=mysql_query($query);		
$affected_rows = mysql_num_rows($res);		                                
//If match found then login succeeded. Set session		
if($affected_rows==1)








			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1264748
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					







	

	

	

		

			

				


	
		mpatel
	

				
				
					
						
Newbie
					
				
			

		

		

			

				


mpatel
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
						
  • Author
    • 
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

after applying above code i get two errors



Notice: Undefined variable: query in D:\xampp\htdocs\members.php on line 31($result=mysql_query($query);)


 



Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\members.php on line 32($affected_rows = mysql_num_rows($result);)


 






<?php 
//Create a session
session_start(); 
//Make a connection to the database
$dbh=mysql_connect ("localhost", "", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("1");
include "header.php";
include "config.php";
$id="";
$password="";
//Retrieve the form elements values
if (isset($_POST['id']))
  $id = $_POST['id'];

  if (isset($_POST['password']))
{
  $password = $_POST['password'];
}
if (isset($_GET['id']))
{
  $id = $_GET['id'];
}
if (isset($_GET['password']))
{
  $password = $_GET['password'];
}
//If login is not blank retrieve id informationif($id!="" || $password !=""){$query = sprintf("SELECT * FROM users WHERE userName='".$id."' AND password='".$password."'",mysql_real_escape_string($id),mysql_real_escape_string($password));

//If match found then login succeeded. Set session

$result=mysql_query($query);		
$affected_rows = mysql_num_rows($result);		                                
//If match found then login succeeded. Set session		
if($affected_rows==1)
{
  $_SESSION['id'] = $id;
  print "<center>Login successful, you can redirect to another web site using header variable of php if the login is validated like know.<br>I am sure You can figure out that.</center>";
}
else
{
//If match not found, inform the id
  print "<center><font color=red>Incorrect username or password or both. Try again.</fon></center>";
}

?>
<form name="Members Login Area" action="members.php" method="post">
<table width="100%">
<tr>
<td align="center" class="text">Username:</td>
</tr>
<tr>
<td align="center" class="text"><input type="text" name="id" size="15" maxlenght="20"></td>
</tr>
<tr>
<td align="center" class="text">Password:</td>
</tr>
<tr>
<td align="center" class="text"> <input type="password" name="password" size="15" maxlenght="20"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="Login" value="Login"></td>
</tr>
</table>
</form>
<?
function middle()
{
$id=$_SESSION["id_session"];
$rs = mysql_query("select * from members where ID=$id");
$arr=mysql_fetch_array($rs);
$check=1;
$id=$arr[0];
$password=$arr[9];
        $name=$arr[1];
       	$address=$arr[2];
$city=$arr[3];
$state=$arr[4];
$zip=$arr[5];
$country=$arr[6];
$phone=$arr[7];
$email=$arr[8];
$password=$b;
$paymentoption=$arr[10];
$refby=$arr[11];
$l1=$arr[12];
$l2=$arr[13];
$l3=$arr[14];
$l4=$arr[15];
$l5=$arr[16];
$l6=$arr[17];
$l7=$arr[18];
$l8=$arr[19];
$l9=$arr[20];
$l10=$arr[21];
$leader=$arr[22];
$total=$arr[23];
$unpaid=$arr[24];
$paid=$arr[25];

?>
<table border="0" width="650">
   <tr>
   <td width="150" valign="top">
     <table width="140">
     <tr>
       <td align="left"><br><br><br><br>
        <ul><font face="verdana" size="1">
		<a href="stats.php">Statistics</a><br><br>
		<a href="update_pf.php">Edit Personal Information</a><br><br>
		<a href="sample_e.php">Referral Code & Links</a><br><br>
     	 	        <a href="logout.php">Logout</a><br><br>
</td></tr></table>
     </td>
     <td VALIGN="top">
     <table>
	<tr> 
		<td>
		<font face="verdana" size="3"><b>
		<p>Account Center</b></font></p>
<br>
</td> 
</tr>
<tr>
<td>

	<div align="center">
	<table border="0" cellpadding="3" cellspacing="0" width="400">
	     
	      <tr> 
	        <td colspan="2"><b>
	         <hr><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><center> Account Details for <?echo $name;?></font></center></b><hr>
	        </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Total Commisions Earned: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $total;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Commisions Due: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $unpaid;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Commisions Paid: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1">$<? echo $paid;?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2> </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Direct Referrals: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1"><?
$rsd=mysql_query("select * from members where Leader=".$id);
echo mysql_num_rows($rsd); ?></font><br></td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2> </td>
	      </tr>
	      <tr> 
	        <td valign="center" align="left" colspan=2><strong><font face="Verdana" size="3">Downline Information </font></strong><br></td>
	      </tr>

	      <tr> 
	        <td valign="center" align="left"><strong><font face="Verdana" size="-1">Total Downline Size: </font></strong><br></td>
	        <td valign="center"> <font face="Verdana" size="-1"><?     echo ($l1+$l2+$l3+$l4+$l5+$l6+$l7+$l8+$l9+$l10); ?></font><br></td>
	      </tr>
		<tr><td colspan=2>

		<Table width=100%>
		<tr><td bgcolor=#000000><strong><font face="Verdana" size="-1" color=#ffffff>Level</font></strong></td>
		<td bgcolor=#000000><strong><font face="Verdana" size="-1" color=#ffffff>Number of Members</font></strong></td>	</tr>
<? include "config.php"; ?>
		<? for($i=1;$i<=$levels;$i++) { ?>
		<tr><td><strong><font face="Verdana" size="-1"><? echo $i; ?></font></strong></td>
		<td ><font face="Verdana" size="-1">
		<?
		if($i==1) {
			echo $l1; 
		}
		elseif($i==2) {
			echo $l2; 
		}
		elseif($i==3) {
			echo $l3; 
		}
		elseif($i==4) {
			echo $l4; 
		}
		elseif($i==5) {
			echo $l5; 
		}
		elseif($i==6) {
			echo $l6; 
		}
		elseif($i==7) {
			echo $l7; 
		}
		elseif($i== {
			echo $l8; 
		}
		elseif($i==9) {
			echo $l9; 
		}
		elseif($i==10) {
			echo $l10; 
		}
		?>
		</font></td>	</tr>
		<? } ?>
		</table>
		</td></tr>
	      <tr><td colspan=4><hr></td><tr>
	     </table>
		</div>

		</td>
	</tr>

</table>
		<font face="verdana" size="3"><b>
		<p>Download Center</b></font></p>

<?
include "download.php";
?>
  </td>
  </tr>
</table>
<br><br>
<?
}
include "footer.php";
?>








			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/245344-login-problem/#findComment-1264750
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				
			
			



		

	


	
	
	
	
	
		
	
      
This thread is more than a year old. Please don't revive it unless you have something important to add.

			
				
				

	
		

			
Join the conversation

			

	
				
					You can post now and register later.
				
				If you have an account, sign in now to post with your account.
				
			

	
		

	




	
	
		
	
		
	
		
	
	
		
		
	
	

		

		


	
		Guest
	


		

			
				
					
				
					
						
    
							
  • 
								


	
	
	
	

								
							
    • 
						

					
				
					
				
			
			
				
					
						
							
						
						



    

		
		

			
		

		
			
 Reply to this topic...

		
		

			

				
					×
					  Pasted as rich text.   Restore formatting
				
			

		

		

			

				  Only 75 emoji are allowed.
			

		

		

			

				×
				  Your link has been automatically embedded.   Display as a link instead
			

		

		

			

			

		

		

			

				×
				  Your previous content has been restored.   Clear editor
			

		

		

			

				×
				  You cannot paste images directly. Upload or insert images from URL.
			

		

		
	

		
	

	

	

		

			×
			
		

		

	



						
					
				
					
				
					
				
			
			
    
				
					
						
					
						
					
						
							
  • 
								


    
	

    

								
							
    • 
						
					
				
				
					
  • 

	

    • 
				
			

		

	



			
		

	

	
		

			

				
					


    
          Share
    

    

				
				
                

                


				
			

		

	







	

		
			
				Go to topic listing
			
		
	

	




						


					

					


					

				

			

			
		

		
		


	

		×
		

			
				

					
				

			

			

			

			
		

	






	

		×
		

			
    
				
  • Create New...
    • 
				
			

		

	



		






















	

		

			
Important Information

			
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.