Help with different users login and directing to location

Expand Post »

So I want the code to allow the user to login and then direct them to their page, I'm just not sure how I can do that. Here's the table and code I have, is there a way to make "header("location:/instacp.htm");" pull the location from the table in the database?

Table:
id username password location
1 12345 123456 /instacp.htm

PHP Syntax (Toggle Plain Text)
<?php
$host="localhost";
$username="blaa";
$password="blaa";
$db_name="blaa_members";
$tbl_name="members";
 
 
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
 
 
$myusername=$_POST['myusername']; 
$mypassword=$_POST['mypassword']; 
 
 
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
 
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
 
 
$count=mysql_num_rows($result);
 
 
if($count==1){
session_register("myusername");
session_register("mypassword"); 
header("location:/instacp.htm");
}
else {
echo "Wrong Username or Password";
}
?>
<?php
$host="localhost";
$username="blaa";
$password="blaa";
$db_name="blaa_members";
$tbl_name="members";


mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");


$myusername=$_POST['myusername']; 
$mypassword=$_POST['mypassword']; 


$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);


$count=mysql_num_rows($result);


if($count==1){
session_register("myusername");
session_register("mypassword"); 
header("location:/instacp.htm");
}
else {
echo "Wrong Username or Password";
}
?>

bdcd

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Jul 2008

Permalink

Sep 8th, 2008

Re: Help with different users login and directing to location

Hi bdcd,

Click to Expand / Collapse Quote originally posted by bdcd ...

So I want the code to allow the user to login and then direct them to their page, I'm just not sure how I can do that. Here's the table and code I have, is there a way to make "header("location:/instacp.htm");" pull the location from the table in the database?

Table:
id username password location
1 12345 123456 /instacp.htm

This should do the trick (note: this code is untested):

php Syntax (Toggle Plain Text)
<?php
$host="localhost";
$username="blaa";
$password="blaa";
$db_name="blaa_members";
$tbl_name="members";
 
 
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
 
 
$myusername=$_POST['myusername']; 
$mypassword=$_POST['mypassword']; 
 
 
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
 
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
 
$row=mysql_fetch_assoc($result);
 
if($row!=false){
	session_register("myusername");
	session_register("mypassword"); 
	header("location: ".$row['location']);
}
else {
	echo "Wrong Username or Password";
}
?>
<?php
$host="localhost";
$username="blaa";
$password="blaa";
$db_name="blaa_members";
$tbl_name="members";


mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");


$myusername=$_POST['myusername']; 
$mypassword=$_POST['mypassword']; 


$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

$row=mysql_fetch_assoc($result);

if($row!=false){
	session_register("myusername");
	session_register("mypassword"); 
	header("location: ".$row['location']);
}
else {
	echo "Wrong Username or Password";
}
?>

More information on using mysql_fetch_assoc() can be found here - http://www.php.net/manual/en/functio...etch-assoc.php

Adnan

tgbyhn

Reputation Points: 15

Solved Threads: 1

Newbie Poster

Offline

8 posts
since Sep 2008

Permalink

Sep 8th, 2008

Re: Help with different users login and directing to location

Thank you it works now, thanks for the link as well.

Last edited by bdcd; Sep 8th, 2008 at 2:36 pm.

bdcd

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Jul 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: creating RSS for forum

Next Thread in PHP Forum Timeline: Trying to display an image rom mysql: whats wrong

DaniWeb Message

Cancel Changes

User Name
Password