[SOLVED] Displaying table info based on session variable

derekbelcher · April 22, 2009

I am trying to display the first and last name of the person that is logged into my site. I am using the following Code to try to do this. Can someone point out what I am missing as nothing is displayed (first / last name) when you log in. It worked when I was using session_is_registered, but I was told that I should get away from that and use $_SESSION. Thanks for any info...

Code:

<?

ini_set("session.cookie_lifetime", "60");

session_save_path();

session_start();

if (isset($_SESSION['myusername'])) {

header("location:officerLogin.php");

}

?>

<?php $host="localhost"; // Host name

$username="athens"; // Mysql username

$password="avfd1179"; // Mysql password

$db_name="athens_officerArea"; // Database name

$tbl_name="officers"; // Table name

// Connect to server and select databse.

mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");

?>

<html>

<head>

<title>Officer's Area</title></head>

<body>

<tr>

<td height="19" colspan="3" valign="top">Welcome <?PHP

$firstname = $_POST['firstname'] ;

$lastname = $_POST['lastname'] ;

$user = $_POST['username'] ;

$sql = "SELECT * FROM `officers` WHERE username = '".$user."'";

$result = mysql_query($sql) ;

while($row = mysql_fetch_array($result, MYSQL_ASSOC))

{

$dbfname = $row['firstname'] ;

$dblname = $row['lastname'] ;

$dbuser = $row['username'] ;

}

echo "$dbfname $dblname" ;

?></td>

</tr>

<tr>

When a man becomes a fireman his greatest act of

bravery has been accomplished. What he does after that is all in the

line of work. ~Edward F. Croker

</td>

</tr>

<tr>

<td width="479" height="130" valign="top" bordercolor="#000080" style="border-style: double; border-width: 5px; padding: 1px">Evaluations are now available. To complete the evaluation packet, <a href="http://www.surveymonkey.com/s.aspx?sm=yucw0wu1q3O1I_2b18iRUtug_3d_3d">Click Here</a> The Password is: ffeval09

This evaluations will be available until March 20, 2009. Please complete before that date. </td>

</td>

<tr>

</tr>

<tr>

News and such...

<hr>

Don't forget to complete your evaluations by March 20, 2009

<hr>

We are starting strong with the Relay for Life with several ideas in the planning process. We have set a goal of $3,000 this year and we need as much participation as possible to help us reach that goal.

<hr>

</td>

</tr>

<tr>

</tr>

</table> </td>

</tr>

<tr>

</tr>

<tr>

Training Info...</td>

</tr>

<tr>

Training is progressing. Brian has implemented a new training calendar, and we have had decent turn out each Thursday. All officers are encouraged to attend each training session as this shows leadership and committment to the firefighters.

<a href="officer_memberfiles.htm">Officer Memberfiles </a>

</blockquote> </td>

</tr>

<tr>

</tr>

<tr>

<td height="42" colspan="3" align="center" valign="top"><a href="logout.php">Log Out of Officers Area </a></td>

</tr>

<tr>

</tr>

</table>

</body>

</html>

radi8 · April 22, 2009

Well, my first thoughts on the highlighted section of code is that the database field for first name and last name is probably not the names passed in from the POST elements.

in the database, what are the column names being retrieved?

In mine, I have:

userName

fName

lName

accessLevel

password (encrypted)

etc...

so if you are doing a:

<?PHP
/*
$firstname = $_POST['firstname'] ;
$lastname = $_POST['lastname'] ;
$password=$_POST['password'];
*/
$user = $_POST['username'] ;

$sql = "SELECT * FROM `officers` WHERE userName = '".$user."'";// and password=md5($password)

$result = mysql_query($sql) ;

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{

   $dbfname = $row['fName'] ; // ALT usage by column position: $row[1]
   $dblname = $row['lName'] ; // ALT usage by column position: $row[2]
   $dbuser = $row['username'] ; // ALT usage by column position: $row[0]
}

echo "$dbfname $dblname" ;

?>

This should yield the proper output

Sign In

[SOLVED] Displaying table info based on session variable

Recommended Posts

derekbelcher

Link to comment

Share on other sites

radi8

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information