Need some help

dellrat · May 16, 2008

Hi guys,

Am new here and this is my first post.

I have 2 php file login and menu.

In login I have queried my dbase and if the user logs in, menu.php will be displayed. However, I am struggling to display session variables which were set originally in login.php in menu.php.

I would like to display the username in menu.php. Something like "Welcome (User)".

Would appreciate help on this as I am rather in PHP.

[attachment deleted by admin]

conker87 · May 16, 2008

Make sure you have session_start(); at the top of both pages.

Replace

<?php $_SESSION[username]; ?>

with

<?php echo $_SESSION[username]; ?>

Also, there's nothing in the login.php

dellrat · May 16, 2008

I had it at the start of the files.

Sorry it seems the login file was not uploaded properly. I have copied it below

login.php

<?php

session_start();

$_SESSION['db_is_logged_in'] = true;

include 'config.php';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

mysql_select_db($dbname);

if (isset($_POST['offline_folder'])){

$_SESSION['offline_folder'] = $_POST['offline_folder'];

}

$errorMessage = '';

if (isset($_POST['txtUserId']) && isset($_POST['txtPassword'])) {

include 'opendb.php';

$username = $_POST['txtUserId'];

$password = $_POST['txtPassword'];

// check if the user id and password combination exist in database

$sql = "SELECT Username, Password FROM test_user_login

WHERE Username = '$username' AND Password = ('$password')";

$result = mysql_query($sql) or die('Query failed. ' . mysql_error());

if (mysql_num_rows($result) == 1) {

// the user id and password match,

// set the session

$_SESSION['db_is_logged_in'] = true;

$row = mysql_fetch_row($result);

$user_id = $row[2];

$_SESSION['user_id'] = $user_id;

// retrieve first name from logged in user

$sql = "SELECT Surname, Given_Names

FROM test_user_login

WHERE Username = '$user_id'";

$result = mysql_query($sql) or die('Query failed. ' . mysql_error());

$row = mysql_fetch_row($result);

$_SESSION['Given_Names'] = $row[1];

// after login we move to the main page

header('Location: menu.php');

exit;

} else {

$errorMessage = 'Sorry, wrong user id / password';

print $errorMessage;

}

include 'closedb.php';

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>UCW Adelaide Client Information System</title>

<!--

.style1 {

font-family: Arial, Helvetica, sans-serif;

font-size: 55px;

font-weight: bold;

color: #AD2E25;

}

.style2 {

font-family: Arial, Helvetica, sans-serif;

font-size: 12px;

}

.style4 {

font-family: Arial, Helvetica, sans-serif;

font-weight: bold;

}

-->

</style>

</head>

<body>

<tr>

<td width="74%"><span class="style1">Client Information System</span></td>

</tr>

<tr>

</tr>

<div>

<tr>

<td width="150" class="Stil5 style4">Username:</td>

</tr>

<tr>

<td width="150" class="Stil5 style4">Password:</td>

</tr>

<tr>

</div></td>

</tr>

</table>

</form></td>

</tr>

</table>

</td>

</tr>

<tr>

<div align="center" class="style2">Tuesday, May 13, 2008 3:44 PM</div></td>

</tr>

</table>

</body>

</html>

Sign In

Need some help

Recommended Posts

dellrat

Link to comment

Share on other sites

conker87

Link to comment

Share on other sites

dellrat

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information