[SOLVED] Getting variables from a session

almystersv · January 7, 2008

Hi Guys,

I am currently using sessions on all of my pages using the username field. But how do I retrieve the empID of the person logged in?!

my session code is

<?php

session_start();

if (isset($_SESSION['username']) == false){

header("Location: login.php");

exit();

}

require "connect.php";

$query = "select * from employee where username = '".$_SESSION['username']."'";

$result = mysql_query($query, $connection) or die ("Unable to perform query<br>$query");

?>

Thanks

revraz · January 7, 2008

Use a mysql_fetch command and put it into an array.

almystersv · January 7, 2008

any chance of elaborating on that please...

revraz · January 7, 2008

You're not pulling the ID from the Session, you are pulling it from the Database with your Query command. What are you doing after this line?

$result = mysql_query($query, $connection) or die ("Unable to perform query $query");

almystersv · January 7, 2008

This is what follows that...

It is a form asking the user to fill in the details of the meeting room they wish to book, i also want it to write into the table their empID which is not requested on the form but want it to be carried through to my query page (shown after).

<body>

<?php

include ("header.php");

?>

<h2>Book a Meeting Room</h2>

<h3>

<tr>

<td width="29%">Select a building:</td>

<option >[select a Building]</option>

<option >North</option>

<option >South</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

<td>Select a Meeting Room: </td>

<option >[select Meeting Room Number]</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

<td>Select a Date: </td>

<td><p><script>DateInput('bkgDate', true, 'DD-MON-YYYY')</script></p></td>

<td>Select a Time: </td>

<option >[select Meeting Time]</option>

</select></td>

</tr>

<tr>

</tr>

<tr>

<td><?php

if(isset($_GET['message1']))

{

echo $_GET['message1'];

}

else if(isset($_GET['message2']))

{

echo $_GET['message2'];

}

else if(isset($_GET['message3']))

{

echo $_GET['message3'];

}

?></td>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

</body>

</html>

QUERY PAGE

<?php

require "connect.php";

$roomID = $_GET['roomID'];

$building = $_GET['building'];

$bkgDate = $_GET['bkgDate'];

$empID = $_GET['empID'];

if($building == "[select a Building]")

{

$message1 = "Please select a building you wish to have the meeting in";

header("Location: MeetingMain.php?message1=$message1");

exit();

}

if($roomID == "[select Meeting Room Number]")

{

$message2 = "Please select a Room Number";

header("Location: MeetingMain.php?message2=$message2");

exit();

}

if($bkgTime == "[select Meeting Time]")

{

$message3 = "Please select a Meeting Time";

header("Location: MeetingMain.php?message3=$message3");

exit();

}

else if($building == !null || $roomID == !null)

{

$query = "insert into booking ('','".$roomID."','".$empID."','".$bkgDate."','".$bkgTime."')";

$result = mysql_query($query, $connection) or die ("Unable to perform query<br>$query");

//$message7 = "'".$fName."' '".$sName."' added successfully. ";

//header("Location: UserADD.php?message7=$message7");

exit();

}

?>

revraz · January 7, 2008

So you are really not doing anything with that query.

http://us3.php.net/mysql_fetch_array

almystersv · January 7, 2008

Will that auto fill the empID in the table with the empID of the person currently logged in?

almystersv · January 7, 2008

...sorry i meant will that auto fill the text box in the form with the empID of the person currently logged in!??

revraz · January 7, 2008

How are you storing the username now into a session? You just have to do the same for the userid.

almystersv · January 7, 2008

I've shown u my session code. thats all im using!?

revraz · January 7, 2008

This is all you've shown

if (isset($_SESSION['username']) == false)

Where do you assign $_SESSION['username']?

It's probably in your login.php file

almystersv · January 7, 2008

Ye, my session is declared in my logincheck.php page.

This is it...

<?php

session_start();

require "connect.php";

$username = $_POST['username'];

$password = $_POST['password'];

$query = "select * from employee WHERE active ='y' AND username='".$username."' AND password='".$password."'";

$result = mysql_query($query, $connection) or die ("Unable to perform query<br>$query");

$row=mysql_fetch_array($result);

if($row!=null)

{

$_SESSION['username'] = $row['username'];

header("Location: welcome.php");

exit();

}

else if($username == "")

{

$message2 = "Please enter your Username";

header("Location: login.php?message2=$message2");

exit();

}

else if($password == "")

{

$message3 = "Please enter your Password";

header("Location: login.php?message3=$message3");

exit();

}

/*else if(active = "n")

{

$message4 = "Sorry, this users account has been de-activated. Please contact the system administrator."

header("Location: login.php?message4=$message4");

exit();

}*/

else

{

$message = "Invalid user name or password, please try again";

header("Location: login.php?message=$message");

exit();

}

?>

revraz · January 7, 2008

$_SESSION['username'] = $row['username'];

header("Location: welcome.php");

exit();

to

$_SESSION['username'] = $row['username'];

$_SESSION['empID'] = $row['empID'];

header("Location: welcome.php");

exit();

almystersv · January 7, 2008

Just changed that, thank you.

Now what do i modify on this to auto fill the text box on the meeting room booking form?

revraz · January 7, 2008

If short tags are enabled, then nothing. But if not, change to

almystersv · January 7, 2008

Thank you very much for your time!

Sign In

[SOLVED] Getting variables from a session

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information