I have 8 rows/columns. They are;
Key (which will never repeat), Name, HireDate, Seniority, VacHrs, PTOhrs, username AND password.
After a successful login, this is my code;
<?php
$dbhost = '***7.000webhost.com';
$dbuser = 'a3674631_***';
$dbpass = 'm***';
$conn = mysql_connect("mysql17.000webhost.com", "a36***31_***n9", "****08");
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
$sql = 'SELECT Name, HireDate, Seniority, VacHrs, PTOhrs FROM att';
mysql_select_db('a3674631_test');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_NUM))
{
echo "Name :{$row[0]} <br> ".
"Hire Date : {$row[1]} <br> ".
"Seniority : {$row[2]} <br> ".
"Vacation Hours Remaining : {$row[3]} <br> ".
"PTO Hours Remaining : {$row[4]} <br> ".
"--------------------------------<br>";
}
mysql_free_result($retval);
echo "Fetched data successfully\n";
mysql_close($conn);
?>
The problem I’m having is it’s putting everyone’s data, all on one page together for everyone to see. This is private information, and Person A should not be able to see the values for person B. My table has 6 records(currently). If user A has a login of 111791, on a successful login, I would like it to say;
Name: First Last
HireDate: 04/04/2012
Seniority: 1 (dates that are sorted by earliest to latest)
VacHrs: 45
PTOhrs: 18
Key, username & password will never show.
Can someone tell me what I’m doing wrong. I know that I’m a noob, so please skip all the “I need read this book….or that tutorial”. I know I do, I’m going to, but in the mean time, I need to get this taken care of. I thank you sincerely for any help.