Advertisement
Guest User

Untitled

a guest
Mar 18th, 2017
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.59 KB | None | 0 0
  1. function getSQLResultsAsTable($sql) {
  2.     $servername = "localhost";
  3.     $username = "root";
  4.     $password = "";
  5.     $dbname = "sessioner";
  6.  
  7.     // Create connection
  8.     $conn = new mysqli($servername, $username, $password, $dbname);
  9.     // Check connection
  10.  
  11.     if ($conn->connect_error) {
  12.         die("Connection failed: " . $conn->connect_error);
  13.     }
  14.  
  15.     $result = $conn->query($sql);
  16.  
  17.     if ($result === false) {
  18.         die(mysqli_error($conn));
  19.     }
  20.  
  21.     for ($set = array (); $row = $result->fetch_assoc(); $set[] = $row);
  22.  
  23.     $conn->close();
  24.  
  25.     return $set;
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement