Login page that leads to different URLs

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
thedark_master
Forum Newbie
Posts: 8
Joined: Fri Feb 13, 2009 6:22 pm

Login page that leads to different URLs

Post by thedark_master »

I am not experienced with PHP at all and I need help with something very simple. I want to have a login page where as the user logs in, it takes them to the URL that is associated with their username and password. Here is the PHP code that checks the login and password. As it is right now, when the user logs in it takes them to page.php. How do I make it so it takes them to the URL tied to their name? The field name for the URL will be: url.

Code: Select all

<?php
ob_start();
$host="myhostname"; // Host name
$username="myusername"; // Mysql username
$password="mypass"; // Mysql password
$db_name="mydbname"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Define $myusername and $mypassword
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

// To protect MySQL injection (more detail about MySQL injection)
$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);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:page.php");
}
else {
echo "Wrong Username or Password";
}

ob_end_flush();
?>
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: Login page that leads to different URLs

Post by John Cartwright »

You never specified your url structure for members, so I can only guess.

Perhaps,

Code: Select all

header("Location: /member/". $myusername);
thedark_master
Forum Newbie
Posts: 8
Joined: Fri Feb 13, 2009 6:22 pm

Re: Login page that leads to different URLs

Post by thedark_master »

thanks, thats exactly what I was looking for.
Post Reply