Mysql and Php user redirection.

Anon

Hi ,

How could using a PHP script "Login/Password" when a user conect redirect him to a specific page ?

Like , im my page has a part that has enter your login/password .
Then the user put his informations there , ok , then the system check into the Mysql database first to see if user exist second to redirect him to the apropriate page .

How could i make the second option ? Redirect the user to one apropriate page when he conect base in mysql database.

Thanks .

Anon

Let myself answer that .

I think that i just need put into the same database one array with the user informations and into there i specific the area .
Like this :

Username: carlos
Password: blablabla

Area😛HPDummys

In my php script i just need to put the way to after user enter his login/password the sistem check if it's true and using the area information send him to the apropriate page .

But i now have two problem ! .

First how make this page only open to the right area users. (The others areas or someone that don't have area can't enter).

How make this php script ????

Thanks .

slug58

use session variables to hold the area the user is permitted to enter and then on each page for this area check this session variable and make sure it is the proper value for the area.

hope this is clear enough!

good luck!!

Anon

Axley i think that using this will be more better:

into mysql database:

username
password
area
companypage

Then into the login page i put a script in php that check this infos and send the user using the companypage area .
That has something like this:
companypage:phpdummy.php

obvious that in the phpdymmy.php i need i way to check if the user have the flag area with the same name .
If not send to sorry page . If yes he enter.

Area:dummydummy.

I put the ideas i just don't know how make it , someone can help here ?

Thanks .

Anon

protect restricted pages like this:

//first decide whether the user is valid.
//you might do this by comparing
//their hashed password in a cookie
//against the password in the DB,
//or by checking some session variables,
//or through another means
//then set $user_valid to either true
//or false.

if (!$user_valid){

header("location: must_login.php\n");

}

//note that this must be done before any
//output to the screen, including whitespace

hope this helps,
Regards,
Alex

Anon

Yep this really helps =).

But people did anyone know here find a similar code that do this ?

I really lost here to bagin make all this stuff =(

I think that using a example will be more easy to learn =).

Thanks .

Anon

Can someone help-here with this script i think will be more easy now =)

In my Mysqldatabase will have this :

username
password
area
pagetosend

Login Code Written by Matt Slavin

Email Me At neophite17@hotmail.com for questions or comments.

if((!$Username) | (!$Password)) {
print ("Please Enter In THe Correct Name");
}

mysql_connect("localhost","User_Name_here","Password_Here");
mysql_select_db("My_Database_Here");

This part is sort if ya want to. I would suggest it.

Make your login page have the main value of Password

#Comment Out if you Want too
$Password = md5($Password);

$sql = "select * from My_Table where Password=$Password and Username=$Username";

I think that need put here to him check and put into a variable the page name.

Like: phpbuilder.php

#
$result = mysql_query($sql);
$num = mysql_numrows($result);

If Login Is Okay Do What You Want TO DO to Them

if ($num == "1") {
print ("Logged in okay");
#Or you can send them somwhere nice like hawaii

I think that i put here below the variable to take from the Mysqldatabase to the right page.

header("Location: http://www.hawii");
exit;

or even fetch feild about them or save sessions

Here i can put to save under a session the area name ! To the other php check if the users it's the right one.

session_start();
session_register(Username);
}

And we must a have a default error message if login fails

if ($num == "0"){
print ("Sorry Bub You can't enter here!!");
}

In the other page the phpbuilder.php
i just put to him check if the user has the right session register if not the bye bye.