function sign_in()
{
session_start();
if (!empty($_POST['user'])) {
$query = mysql_query("SELECT * FROM UserName where userName = '******'user']}' AND pass = '******'pass']}'") or die(mysql_error());
$row = mysql_fetch_array($query) or die(mysql_error());
if (!empty($row['userName']) and !empty($row['pass'])) {
$_SESSION['userName'] = $row['pass'];
echo "SUCCESSFULLY LOGIN TO USER PROFILE PAGE...";
} else {
echo "SORRY... YOU ENTERD WRONG ID AND PASSWORD... PLEASE RETRY...";
}
if (isset($_POST['submit'])) {
SignIn();
}
}
}
}
$row = mysqli_fetch_array($result);
$userid = $row['id'];
$sql = "SELECT * FROM user natural join attendance where id='" . $userid . "'";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_array($result)) {
echo "<h3>{$row['email']}</h3>: " . "<p> {$row['isPresent']}</p> <br> " . "<p> {$row['comments']}</p> <br> " . "<hr><br>";
}
mysqli_close($conn);
} else {
if ($row['role'] == "teacher") {
redirect("teacher.php?email={$email}");
} else {
redirect("login.php");
}
}
} else {
echo "SORRY... YOU ENTERD WRONG ID AND PASSWORD... PLEASE RETRY...";
}
}
}
if (isset($_POST['submit'])) {
SignIn();
}
function redirect($url)
{
ob_start();
header('Location: ' . $url);
ob_end_flush();
die;
}
<p class="submit"> <input type="submit" name="Submit" value="Login" class="button"> </p>
</form>
</div>
</body>
</html>
<?php
if (isset($_POST['Submit'])) {
SignIn($mysqli);
}
?>
function PHPOperation($Action)
{
switch ($Action) {
case "UnitTest":
UnitTest($Action);
break;
case "AddAccount":
AddAccount($Action);
break;
case "SignIn":
SignIn($Action);
break;
case "SignInPet":
SignInPet($Action);
break;
case "SignOut":
SignOut($Action);
break;
case "FetchErrors":
FetchErrors($Action);
break;
case "AddError":
AddError($Action);
break;
case "FetchActivities":
FetchActivities($Action);
break;
case "FetchSignInPet":
FetchSignInPet($Action);
break;
case "FetchBreeds":
FetchBreeds($Action);
break;
case "ValidateSession":
ValidateSession($Action);
break;
case "ResetPassword":
ResetPassword($Action);
break;
case "UpdatePassword":
UpdatePassword($Action);
break;
case "AddPet":
AddPet($Action);
break;
case "AddBreed":
AddBreed($Action);
break;
case "FetchUsers":
FetchUsers($Action);
break;
case "FetchUserPets":
FetchUserPets($Action);
break;
case "FetchUserStatus":
FetchUserStatus($Action);
break;
case "FetchPetStatus":
FetchPetStatus($Action);
break;
case "FetchPet":
FetchPet($Action);
break;
case "UpdateAccountStatus":
UpdateAccountStatus($Action);
break;
case "UpdatePetStatus":
UpdatePetStatus($Action);
break;
case "UpdatePetName":
UpdatePetName($Action);
break;
case "UpdatePetBreed":
UpdatePetBreed($Action);
break;
case "UpdatePetGender":
UpdatePetGender($Action);
break;
case "UpdateBreed":
UpdateBreed($Action);
break;
case "FetchPetNameCount":
FetchPetNameCount($Action);
break;
case "FetchUserEmail":
FetchUserEmail($Action);
break;
}
}
