<?php
    $hostname='127.0.0.1';
    $user = 'user';
    echo "Hello2";
    $password = 'user1234';
    echo "Hello3";
    $mysql_database = 'test';
    echo "Hello4";
    $con = new mysqli($hostname, $user, $password,$mysql_database) or die ("Failed to connect to MySQL: " . mysql_error());
    echo "Hello5";
    //mysql_select_db("test", $con) or die("Failed to connect to MySQL: " . mysql_error());
    echo "Hello6";
    /*if (mysqli_connect_errno($con))
     {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
     }
     else {
        echo “Successfully connected to your database…”;
     }*/

     $sql = 'Select * From users';
     echo "Hello7";
     $result = $con->query($sql);
      echo "Hello8";
     if ($result->num_rows > 0) {
         echo "Hello9";
         while($row = $result->fetch_assoc()) {
             echo "Firstname: " . $row["firstname"]. "<br>";
        }
    }
    else {
        echo "0 results";
    }
    $conn->close();
     echo "Hello10";

?>