[Resolved] different users and different pages

jaims

Hi,

I'm new to PHP and I need a help in coding a script. I have actually a mysql database that's got 5 different users and I want each to be redicted to their respective pages after password validation. Each of this 5 users have their own corresponding page and I don't know how to redirect them to it. I know how to do it, if given just the same page, but this one is complicated for me. I tried two days to solved it but didn't succeed. Now I need somebody to really help me. I would very much appreciate if you can give me a generic code for this. Thanks a lot.

Jaims

Trs2988

I think I understand your problem, and here is what I'd do. Assume that your 5 users were named user1-5, and their pages were page1-5, respectively, and the current username is stored in $username.


// Stuff here that validates pass, etc.

$pages = array
("user1" => "page1.php",
"user2" => "page2.php",
"user3" => "page3.php",
"user4" => "page4.php",
"user5" => "page5.php");
$redirectPage = $pages["$username"];
header("Location: $redirectPage");

As you can see, it makes an array of users, pages, and then finds the correct page for the current user. Then, it redirects them there.

I hope that helps.

Trs2988

Actually, I just thought of another way to do it that might be even simpler. Instead, just add a column to your DB called redirectPage. Then, once they log in and stuff, you get the redirectPage from the database and redirect them there.

jaims

I made the following code by trying the page array you gave me.

<?php

$db=mysql_connect("localhost","root") or die ("cant connect");
mysql_select_db("Users",$db) or die ("cant change");

$result=mysql_query("select * from user where username='".$_POST['username']."'", $db) or die ("cant do it");

$row=mysql_fetch_array($result);

if ($row["password"] == $_POST['password']) {
$pages = array
("jaims" => "jaims.php",
"test" => "page1.php",
"user3" => "page3.php",
"user4" => "page4.php",
"user5" => "page5.php");
$redirectPage = $pages["$username"];
header("Location: $redirectPage");

}

I got this as error:

Warning: Cannot add header information - headers already sent by (output started at f:\program files\easyphp\www\successlog.php:3) in f:\program files\easyphp\www\successlog.php on line 21

I made another one by redirecting the user directly to his corresponding page by adding a column page in my mysql, as you said.

$db=mysql_connect("localhost","root") or die ("cant connect");
mysql_select_db("Users",$db) or die ("cant change");

$result=mysql_query("select * from user where username='".$_POST['username']."'", $db) or die ("cant do it");

$row=mysql_fetch_array($result);

if ($row["password"] == $_POST['password']) {

?>
<html>
<head>
<meta http-equiv="refresh" content="0;URL=<?$row["page"]?>.php">
</head>
<body>
</body>
</html>

<?
}

//
?>

This second code seems to make an unending request but would not load the page of the corresponding user. When I change the url into a normal page, it works (ex. download.htm).

I can feel that I'm not too far from the solution, I just need your expertise by identifying what's wrong with my code.

Thanks again

johnassis

You can only send headers once.

it looks like the included file "successlog.php" (which i assume is included, but it could also be the same file you are working on, and since you did not post enough code here i don't know). Has already sent the headers.

However there appears to be a workarround here.

http://www.devshed.com/Server_Side/PHP/OutputBuffering/page2.html

jaims

Thanks for the help. Actually the first code works, is just that there's white space before my php code starts, when I erased it and tried, I got good results.

A lot of thanks to Trs2988 for the good code and to Johnassis for the trouble shooting idea.

😃