Advertisement
Skorpius

MySQLI Function array

Feb 6th, 2023
721
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.32 KB | None | 0 0
  1. function AdminUsersDetails($dbc){
  2.        
  3.         $sql = "SELECT first, last, email,username,status FROM adminusers;";
  4.        
  5.         $result = $dbc -> query($sql);
  6.  
  7.         // Associative array
  8.         $row = $result -> fetch_assoc();
  9.  
  10.         $fname = $row["first"];
  11.         $lname = $row["last"];
  12.         $email = $row["email"];
  13.         $username = $row["username"];
  14.         $status = $row["status"];
  15.        
  16.         if($status == 1){
  17.             $_SESSION['status'] = $status;
  18.             echo 'Status: Admin Level: '.$status;
  19.         }elseif($status == 2){
  20.             $_SESSION['status'] = $status;
  21.             echo 'Status: Admin Level: '.$status;
  22.         }elseif($status == 0){
  23.             echo '<p class="text-center"><strong>Your Admin Account Has Been Suspended.<br>Please log out.</strong></p>';
  24.             $status = '<p class="text-center text-light bg-dark pt-3 pb-3 mt-5"><strong>Status: Suspended</strong></p>';
  25.             $_SESSION['status'] = $status;
  26.             echo $_SESSION['status'];
  27.         }
  28.        
  29.        
  30.        
  31.         echo "<br>";
  32.         echo $fname . ' ' . $lname . "<br>";
  33.         echo $username . "<br>";
  34.         echo $email."<br>";
  35.         echo $status . "<br>";
  36.  
  37.         // Free result set
  38.         $result -> free_result();
  39.  
  40.         $dbc -> close();
  41.        
  42.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement