Advertisement
Skorpius

MySQLI Function

Feb 5th, 2023
738
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.72 KB | None | 0 0
  1. function AdminUsersDetails($dbc){
  2.        
  3.         $sql = "SELECT first, last, email,status FROM adminusers;";
  4.        
  5.         $result = $dbc -> query($sql);
  6.  
  7.         // Associative array
  8.         $row = $result -> fetch_assoc();
  9.  
  10.         $name = $row["first"].' ' . $row["last"];
  11.         $email = $row["email"];
  12.         $status = $row["status"];
  13.        
  14.         if($status == 1){
  15.             echo 'Status: Admin Level: '.$status;
  16.         }elseif($status == 2){
  17.             echo 'Status: Admin Level: '.$status;
  18.         }
  19.        
  20.         echo "<br>";
  21.         echo $name."<br>";
  22.         echo $email."<br>";
  23.  
  24.         // Free result set
  25.         $result -> free_result();
  26.  
  27.         $dbc -> close();
  28.        
  29.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement