DaniWeb Forum Index > Web Development > PHP

How to find the UserID on logging time

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2008

Posts: 65

Reputation: vijaysoft1 is an unknown quantity at this point

Solved Threads: 0

vijaysoft1 vijaysoft1 is offline

Offline

Junior Poster in Training

How to find the UserID on logging time

Dec 14th, 2008

I trying to make small personal website in PHP + MYSQL . In my database there is a table named ' tblUsers ' . I am using this table for users Login .I displayed the username of the user after the login . But how to track the userID of the user .

in my table 3 fields

" intUserID (autoincrement ,primarykey) , txtPassword ,txtUsername"

how to record the userID as session value. please.......

•

Join Date: Dec 2008

Posts: 94

Reputation: sikka_varun is an unknown quantity at this point

Solved Threads: 11

sikka_varun sikka_varun is offline

Offline

Junior Poster in Training

Re: How to find the UserID on logging time

Dec 14th, 2008

Hi...
inorder to record the sessions, do the following:

login.php

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
session_start();
//most important line... as it marks the start of session
//suppose user submits the login button and redirects to this page
if($_POST['submit']=="submit")
{
//some condition above in if to detect user actually pressed login button
    //connect to database.. check username and password..
   //when done... user authenticated..
    $_SESSION['userid']=$row['intUserID']; //get this value from database
    $_SESSION['username']=$row['txtUsername'];
}
//thats it.. the userid and usrname stored in sessions
?>
<?php
session_start();
//most important line... as it marks the start of session
//suppose user submits the login button and redirects to this page
if($_POST['submit']=="submit")
{
//some condition above in if to detect user actually pressed login button
    //connect to database.. check username and password..
   //when done... user authenticated..
    $_SESSION['userid']=$row['intUserID']; //get this value from database
    $_SESSION['username']=$row['txtUsername'];
}
//thats it.. the userid and usrname stored in sessions
?>

To access these stored sessions in other page..

page_user.php

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
session_start();
//above line must on every page where you need to access the session value
echo $_SESSION['userid'];
echo $_SESSION['username'];
 
?>
<?php
session_start();
//above line must on every page where you need to access the session value
echo $_SESSION['userid'];
echo $_SESSION['username'];

?>

Apart from the above example.. refer the session tutorials by searching them on google..

http://tizag.com/phpT - Refer sessions tutorial here.. easy and simple..

VâRûN
---Happy to Help---
sikka_varun@yahoo.com

•

Join Date: Jun 2008

Posts: 65

Reputation: vijaysoft1 is an unknown quantity at this point

Solved Threads: 0

vijaysoft1 vijaysoft1 is offline

Offline

Junior Poster in Training

Re: How to find the UserID on logging time

Dec 15th, 2008

This is my dreamweavers code to find session variable and in this a session variable named ' MM_Username ' . And Using that i got the ' username' of the user , how to implement code to find ' UserID ' in to this please ...

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}
 
$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}
 
if (isset($_POST['txtUsername'])) {
  $loginUsername=$_POST['txtUsername'];
  $password=$_POST['txtPassword'];
  $MM_fldUserAuthorization = "intAccessLevel";
  $MM_redirectLoginSuccess = "home.php";
  $MM_redirectLoginFailed = "index.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_nydata2, $nydata2);
 
  $LoginRS__query=sprintf("SELECT txtUserName, txtPassword, intAccessLevel FROM tblusers WHERE txtUserName='%s' AND txtPassword='%s'",
  get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); 
 
  $LoginRS = mysql_query($LoginRS__query, $nydata2) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
 
    $loginStrGroup  = mysql_result($LoginRS,0,'intAccessLevel');
 
 
//declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	
 
 
    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>
<?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['txtUsername'])) {
  $loginUsername=$_POST['txtUsername'];
  $password=$_POST['txtPassword'];
  $MM_fldUserAuthorization = "intAccessLevel";
  $MM_redirectLoginSuccess = "home.php";
  $MM_redirectLoginFailed = "index.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_nydata2, $nydata2);
  	
  $LoginRS__query=sprintf("SELECT txtUserName, txtPassword, intAccessLevel FROM tblusers WHERE txtUserName='%s' AND txtPassword='%s'",
  get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); 
   
  $LoginRS = mysql_query($LoginRS__query, $nydata2) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
    
    $loginStrGroup  = mysql_result($LoginRS,0,'intAccessLevel');
    
    
//declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	
	

    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>

Last edited by vijaysoft1; Dec 15th, 2008 at 3:16 am.

•

Join Date: Jun 2008

Posts: 65

Reputation: vijaysoft1 is an unknown quantity at this point

Solved Threads: 0

vijaysoft1 vijaysoft1 is offline

Offline

Junior Poster in Training

Re: How to find the UserID on logging time

Dec 15th, 2008

pla reply.....

•

Join Date: Apr 2008

Posts: 296

Reputation: Aamit has a little shameless behaviour in the past

Solved Threads: 11

Aamit

Offline

Posting Whiz in Training

Re: How to find the UserID on logging time

Dec 15th, 2008

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$user_fname=$_SESSION['MM_Username'];
 $sql=mysql_query("SELECT * FROM table where user_fname='$user_fname'");
		while( $row = mysql_fetch_array($sql))
		{
                  $user_fname=$row['user_fname'];
		  $pass=$row['user_pass'];
		  $user_id=$row['user_id'];
		  $gender=$row['user_sex'];
                }
$user_fname=$_SESSION['MM_Username'];
 $sql=mysql_query("SELECT * FROM table where user_fname='$user_fname'");
		while( $row = mysql_fetch_array($sql))
		{
                  $user_fname=$row['user_fname'];
		  $pass=$row['user_pass'];
		  $user_id=$row['user_id'];
		  $gender=$row['user_sex'];
                }

Change the column name according to your column id ...
fetch sql result in array..from that you take the value of whatever you want...

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
echo $user_id;//check data using echo
echo $user_id;//check data using echo

Last edited by Aamit; Dec 15th, 2008 at 7:00 am.

•

Join Date: Jun 2008

Posts: 65

Reputation: vijaysoft1 is an unknown quantity at this point

Solved Threads: 0

vijaysoft1 vijaysoft1 is offline

Offline

Junior Poster in Training

Re: How to find the UserID on logging time

Dec 15th, 2008

•

Originally Posted by Aamit

Help with Code Tags

PHP Syntax (Toggle Plain Text)
$user_fname=$_SESSION['MM_Username'];
 $sql=mysql_query("SELECT * FROM table where user_fname='$user_fname'");
		while( $row = mysql_fetch_array($sql))
		{
                  $user_fname=$row['user_fname'];
		  $pass=$row['user_pass'];
		  $user_id=$row['user_id'];
		  $gender=$row['user_sex'];
                }
$user_fname=$_SESSION['MM_Username']; $sql=mysql_query("SELECT * FROM table where user_fname='$user_fname'"); while( $row = mysql_fetch_array($sql)) { $user_fname=$row['user_fname']; $pass=$row['user_pass']; $user_id=$row['user_id']; $gender=$row['user_sex']; }
Change the column name according to your column id ...
fetch sql result in array..from that you take the value of whatever you want...
Help with Code Tags

PHP Syntax (Toggle Plain Text)
echo $user_id;//check data using echo
echo $user_id;//check data using echo

this is not working in my Dreamweaver , please help me to correct . U checked it . please..........

•

Join Date: Apr 2008

Posts: 296

Reputation: Aamit has a little shameless behaviour in the past

Solved Threads: 11

Aamit

Offline

Posting Whiz in Training

Re: How to find the UserID on logging time

Dec 15th, 2008

In your query, you are not selecting userid

only
txtUserName, txtPassword, intAccessLevel FROM tblusers

select UserID

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}
 
$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}
 
if (isset($_POST['txtUsername'])) {
  $loginUsername=$_POST['txtUsername'];
  $password=$_POST['txtPassword'];
  $MM_fldUserAuthorization = "intAccessLevel";
  $MM_redirectLoginSuccess = "home.php";
  $MM_redirectLoginFailed = "index.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_nydata2, $nydata2);
 
  $LoginRS__query=sprintf("SELECT txtUserName, txtPassword, intAccessLevel,UserID FROM tblusers WHERE txtUserName='%s' AND txtPassword='%s'",
  get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); 
 
  $LoginRS = mysql_query($LoginRS__query, $nydata2) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  while( $row = mysql_fetch_array($LoginRS))
		{
		$user_fname=$row['txtUserName'];
		  $pass=$row['txtPassword'];
		  $user_id=$row['UserID'];
echo $user_fname;
echo $pass;		  
echo $user_id;
		}
 
 
  if ($loginFoundUser) {
 
    $loginStrGroup  = mysql_result($LoginRS,0,'intAccessLevel');
 
 
//declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	
 
 
    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>
<?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['txtUsername'])) {
  $loginUsername=$_POST['txtUsername'];
  $password=$_POST['txtPassword'];
  $MM_fldUserAuthorization = "intAccessLevel";
  $MM_redirectLoginSuccess = "home.php";
  $MM_redirectLoginFailed = "index.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_nydata2, $nydata2);
  	
  $LoginRS__query=sprintf("SELECT txtUserName, txtPassword, intAccessLevel,UserID FROM tblusers WHERE txtUserName='%s' AND txtPassword='%s'",
  get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); 
   
  $LoginRS = mysql_query($LoginRS__query, $nydata2) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  while( $row = mysql_fetch_array($LoginRS))
		{
		$user_fname=$row['txtUserName'];
		  $pass=$row['txtPassword'];
		  $user_id=$row['UserID'];
echo $user_fname;
echo $pass;		  
echo $user_id;
		}
			
  
  if ($loginFoundUser) {
    
    $loginStrGroup  = mysql_result($LoginRS,0,'intAccessLevel');
    
    
//declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	
	

    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>

•

Join Date: Aug 2007

Posts: 10

Reputation: flagbarton is an unknown quantity at this point

Solved Threads: 0

flagbarton flagbarton is offline

Offline

Newbie Poster

Re: How to find the UserID on logging time

Dec 15th, 2008

you are using code generated by dreamweaver, i suggest to create our own log in form since code generated by dreamweaver is not flexible.
try to experiment the code posted by sikka_varun