I have this PHP script working in conjuction with mysql which delivers the user to a general landing page after they log in. However, I need to create a unique landing page that is specific to each user that logs in using mysql. Can anyone show me how to change the PHP generated code to so when user A logs in they will be forwarded to
http://mywebsite.com/usera, and when user B logs in they will be forwarded to
http://mywebsite.com/userb? I added a User Specific Landing Page (USLP) column in mysql named "uslp_value" without quotes but not sure how to inject into the PHP script.
Below is an example of the PHP I have generated with the general landing page, anything you can do will be much appreciated.
CODE
<?php
require 'init.php';
require 'mysqlvars.php';
require 'lib/form_functions.php';
require 'lib/db.php';
unset($error);
$dbConn = connectDB($dbHost, $dbUser, $dbPass, $dbDB);
if (!$dbConn) {
die('Database is currently down...please try again later');
}
if (isset($_POST['login'])) {
if (empty($_POST['username']) || empty($_POST['password'])) {
$error = 'Please enter your username and password';
}
else {
$result = mysql_query("SELECT email FROM wsd_members WHERE username = '" . prepareData($_POST['username']) . "' and password = MD5('" . prepareData($_POST['password']) . "')");
if ($result) {
if ($frow = mysql_fetch_row($result)) {
$email = $frow[0];
mysql_query("UPDATE wsd_members SET last_logged_on = NOW() WHERE username = '" . prepareData($_POST['username']) . "'");
session_start('MEMBERS');
$_SESSION['username'] = stripData($_POST['username']);
$_SESSION['email'] = $email;
session_write_close();
// landing page after login
header("Location: http://www.mywebsiteaddress.com");
exit();
}
else {
$error = 'Invalid username or password';
}
}
else {
$error = mysql_error();
}
}
}
include 'includes/header.php';
?>
<tr>
<td>
<table class="fg">
<tr>
<td class="title"><?php echo $APP->name ?> Login</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table class="nb">
<tr>
<td><DIV>Please ensure cookies and Javascript are enabled in your browser</DIV></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table class="nb">
<?php if (isset($error)) { echo "<tr><td class=\"error\">$error</td></tr>"; } ?>
</table>
</td>
</tr>
<tr>
<td>
<table class="fg">
<form method="POST" action="<?php echo $_SERVER['PHP_SELF'] ?>">
<tr>
<td class="label">Username:</td>
<td class="field">
<input type="text" name="username" size="20" maxlength="20" value="<?php if (isset($_POST['username'])) { echo htmlChars($_POST['username']); } ?>">
</td>
</tr>
<tr>
<td class="label">Password:</td>
<td class="field">
<input type="password" name="password" size="16" maxlength="16" value="<?php if (isset($_POST['password'])) { echo htmlChars($_POST['password']); } ?>"> <a href="forgotten_password.php">Forgotten?</a>
</td>
</tr>
<tr><td class="label"> </td><td class="field"><input type="Submit" name="login" value="Login"></td></tr>
</form>
</table><br>
<DIV>Content you put here will appear below the members login box</DIV></td>
</tr>
<?php include 'includes/footer.php' ?>
use a redirect. Still, I think keeping it all on one page is the best. Here's the redirect code:
| 