<?php
  $host = 'localhost';
  $user =  'root';
  $password = '';
  $database = 'prospech';
  $db_con = mysql_connect($host,$user,$password,$database);
  if ($db_con){
    echo 'Connected with MySQL';
    echo '<br />';
  }  else  {
    echo 'Failed to connect';
    echo '<br />';
    mysqli_connect_error();
    exit();
  }
  $sql = "SELECT * FROM student";
  $result = $db->query($sql);
  if (mysqli_num_rows($result) > 0)
  {
    while($cyka = mysqli_fetch_assoc())
    {
      echo "id: " . $cyka["id"]. " - Name: " . $cyka["firstname"]. " " . $cyka["lastname"]. "<br>";
    }
  }


?>