I am trying to successfully make my login form work. this is my activation.php file. little help here pelase :).
This is my code (sorry about not creating the snippet code as I couldn't find the website to create it with):
   <?php
   $servername = "localhost";
   $dbname = "dbtechnerdzzz";
   // Create connection
   $conn = new mysqli($servername, $dbname);
   //Check connection
   if ($conn->connect_error) {
      die("Connection failed: " . $conn->connect_error);
   } 
   $sql = "SELECT * FROM accounts";
   $result = $conn->query($sql);
   if ($result->num_rows > 0) {
   // output data of each row
   while($row = $result->fetch_assoc()) {
     echo "id: " . $row["UserID"]. " - Name: " . $row["Username"]. " " . $row["Password"]. $row["Email"]. " - Name: " . $row["CreatedOn"]. " " . $row["DateOfBirth"]. "<br>";
       }
    } else {
       echo "0 results";
    }
    $conn->close();
    ?>