alert('Please Select a User');");
}
else {
$User = $_POST['Users'];
}
if ($Error == 0) {
//Create Connection
$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword, $dbName);
if ($conDataBase->connect_error) {
die ("Connection failed: " . $conDataBase->connect_error);
}
$sql = "SELECT id, password, email FROM users where username='".$User."'";
$result = $conDataBase->query($sql);
echo ("
| # | UserName | Password | Email |
");
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo ("| ".$row['id']." | ".$User." | ".$row['password']." | ".$row['email']." |
");
}
}
else {
echo ("0 Results1
");
}
echo ("
");
$sql = "SELECT id, status, ipaddress, reg_data FROM activitylog where username='".$User."' order by id desc";
$result = $conDataBase->query($sql);
echo ("
| # | Status | IP Address | Time Stamp |
");
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo ("| ".$row['id']." | ".$row['status']." | ".$row['ipaddress']." | ".$row['reg_data']." |
");
}
}
else {
echo ("0 Results2
");
}
$conDataBase->close();
echo ("
");
}
}
?>
alert('Please Select a User');");
}
else {
$User = $_POST['Users2'];
}
if ($Error == 0) {
//Create Connection
$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword, $dbName);
if ($conDataBase->connect_error) {
die ("Connection failed: " . $conDataBase->connect_error);
}
$sql = "SELECT id, password, firstname, lastname, email, phone, reg_data FROM users where username='".$User."'";
$result = $conDataBase->query($sql);
echo ("
| # | UserName | Password | First Name | Last Name | Email | phone | Time Stamp |
");
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo ("| ".$row['id']." | ".$User." | ".$row['password']." | ".$row['firstname']." | ".$row['lastname']." | ".$row['email']." | ".$row['phone']." | ".$row['reg_data']." |
");
}
}
else {
echo ("0 Results1
");
}
echo ("
");
$sql = "SELECT id, status, ipaddress, reg_data FROM activitylog where username='".$User."' order by id desc";
$result = $conDataBase->query($sql);
echo ("
| # | Status | IP Address | Time Stamp |
");
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo ("| ".$row['id']." | ".$row['status']." | ".$row['ipaddress']." | ".$row['reg_data']." |
");
}
}
else {
echo ("0 Results2
");
}
$conDataBase->close();
echo ("
");
}
}
?>