// get DATA from Login database
//*********************************************************************************
$sqllogin1 = "SELECT * FROM Login
WHERE familyTree = '$tableName'
ORDER BY Number DESC";
$rstlogin = mysqli_query($cxn,$sqllogin1)or die("Couldnt selectlogin1");
$numrowlogin = mysqli_num_rows($rstlogin);
?>
Photo |
Member Name |
Login Time |
Logout Time |
Visit Duration |
$n =1;
while (($rLogin = mysqli_fetch_assoc($rstlogin)) && $n<200)
{ $loginName = $rLogin["loginName"];
$loginTime = $rLogin["loginTime"];
$logoutTime = $rLogin["logoutTime"];
$visitTime = $rLogin["visitTime"];
$queryMember = "SELECT admin,MASTER_ID FROM Member WHERE loginName = '$loginName'
AND familyTree = '$tableName' ";
$resultMember = mysqli_query($cxn,$queryMember)or die("Couldn't queryMember1");
$numrows = mysqli_num_rows($resultMember);
while($recMember = mysqli_fetch_assoc($resultMember))
{
$memberADMIN = $recMember["admin"];
$memberMASTER_ID = $recMember["MASTER_ID"];
}
$querymemberPIC = "SELECT PIC FROM $tableName WHERE MASTER_ID = '$memberMASTER_ID' ";
$resultMemberPIC = mysqli_query($cxn,$querymemberPIC)or die("Couldn't queryMember2");
$numrows2 = mysqli_num_rows($resultMemberPIC);
while($recMemberPIC = mysqli_fetch_assoc($resultMemberPIC))
{
$MemberPic = $recMemberPIC["PIC"];
}
if ($memberADMIN == 'yes'){$MemberPic='images/Male.gif';}
if($n&1) { $bgcolor = '#CCCCCC';}
else { $bgcolor = '#FFFFFF';}
?>
![]() |
echo $loginName; ?> |
echo $loginTime; ?> |
echo $logoutTime; ?> |
echo $visitTime; ?> |
$n++; //echo $n;
} //end while
?>