MySQL &amp; PHP??

MySQL & PHP??

russellbcv

Hi - I wonder if anbody can help me or point me the right direction?

I have created a database in MySQL which contains a list of registered customers i.e Firstname, Lastname, Username & password.

I have also created a login script which the customer can enter their username & password and if correct they get a successful login page.

Does anybody know how to make it so that each customer are redirected to their own private page?

This is my current php code:-

<?php $username = $POST['username'];
$password = $POST['password'];
$self = $SERVER['PHP_SELF'];
$referer = $SERVER['HTTP_REFERER'];

if( ( !$username ) or ( !$password ) )
{ header( "Location:$referer" ); exit(); }

$conn = @mysql_connect( "localhost", "devin", "password" )
or die ( "Could not connect" );
$rs = @mysql_select_db( "my_database", $conn )
or die( "Could not select database" );
$sql="select * from users where user_name=\"$username\"
and password = password( \"$password\" )";
$rs = mysql_query( $sql, $conn )
or die( "Could not execute query" );
$num = mysql_numrows( $rs );

if( $num != 0 )
{ $msg = "Welcome $username - your log-in succeeded!"; }
else
{ header( "Location:$referer" ); exit(); }
?>
<html> <head><title>Log-In Authenticated</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css">

</style></head>
<body> <?php echo( $msg ); ?> </body> </html>

moty66

ok
It is simple if you think
just add a new field to the table of the customers with the link to the private page

when the use login successfuly send him to that link
header("Locatio: thepage address");

moty

russellbcv

Hi Moty

If I were to add a new field in the customer database table i.e

Link,FirstName,LastName,Username,Password
?,russell,ben,russellb,password

If the page ? was saved within the root directory i.e c:\apache\htdocs\russellb.html what would I need to put within the php file?

header("Locatio: thepage address");

Where would I place your above code in my php file?

Russ

moty66

let add to the table the field page
and when you add a new client
you have the filename which is "russellb.html"

so the code will be

<?php $username = $_POST['username']; 
$password = $_POST['password']; 
$self = $_SERVER['PHP_SELF']; 
$referer = $_SERVER['HTTP_REFERER']; 

if( ( !$username ) or ( !$password ) ) 
{ header( "Location:$referer" ); exit(); } 

$conn = @mysql_connect( "localhost", "devin", "password" ) 
or die ( "Could not connect" ); 
$rs = @mysql_select_db( "my_database", $conn ) 
or die( "Could not select database" ); 
$sql="select * from users where user_name=\"$username\" 
and password = password( \"$password\" )"; 
$rs = mysql_query( $sql, $conn ) 
or die( "Could not execute query" ); 
$num = mysql_numrows( $rs ); 
$row  = mysql_fetch_row($rs);
if( $num != 0 ) 
{ 
// WHEN THE USE IS LOGGED WE SEND HIM TO THE PAGE
header("Location: ".$row[page]);
exit();
 } 
else 
{ header( "Location:$referer" ); exit(); } 
?> 
<html> <head><title>Log-In Authenticated</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> 
<!-- 
body,td,th { 
font-family: Arial, Helvetica, sans-serif; 
font-size: 12px; 
color: #000000; 
} 
body { 
background-color: #FFFFFF; 
margin-left: 1cm; 
margin-right: 0cm; 
} 
--> 
</style></head> 
<body> <?php echo( $msg ); ?> </body> </html>

moty

russellbcv

Hi Moty

Just read your post.

I will give the script ago and let you know how I get on!

Thanks

Russ

russellbcv

Hi Moty

I have just tried your script and I get my "Locahost" homepage.

I have set-up a new field within the database table called "Link" and in one particular customer I have put the following into "value":-

C:\Apache\htdocs\russellb.html

Is this correct?

Am I missing anything?

Russ