<?php
        $con=mysqli_connect("localhost","root","","database");
// kontrollime ühendust databaasiga
if (mysqli_connect_errno())
  {
  echo "Ei saanud ühenudust: " . mysqli_connect_error();
  }

$sql="SELECT * FROM users ";

if ($result=mysqli_query($con,$sql))
  {
  // toome andmed nähtavale lehele
  while ($row=mysqli_fetch_row($result))
    {
    printf ("%s (%s)\n",$row[0],$row[1]);
    }
  // Free result set
  mysqli_free_result($result);
}

mysqli_close($con);
?>