<?php
header("Access-Control-Allow-Origin: *");
header("Content-Type: Application/json");
session_start();
if(isset($_GET['nome']) && isset( $_GET['password'])){
    $nome = $_GET['nome'];
    $password= $_GET['password'];
    $servername="127.0.0.1";
    $dbname="my_portalsdragon";
    $username="portalsdragon";
    $pass="";
    try{
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $pass);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
   function conNom ($conn,$nome){
        $stmt = $conn->prepare("SELECT count(*) FROM studente where username = :nome");
        $stmt->bindParam(':nome', $nome);
        $stmt->execute();
        return $stmt->fetchColumn();



    }
     if(conNom($conn,$nome)!=0){
        $stmt = $conn->prepare("SELECT nome, cognome, username, pass, cod_fis FROM studente where username = :nome and pass = password(:password)");
        $stmt->bindParam(':nome', $nome);
        $stmt->bindParam(':password', $password);
        $stmt->execute();

    // set the resulting array to associative
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
    /*foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) {
        echo $v;
    }*/
    echo json_encode($result);
    $_SESSION["JSONSTUDENTE"]=$result;

     }
   else {
       $coso='errore';
       echo json_encode($coso);

    }}
catch(PDOException $e)
    {
    echo "Error: " . $e->getMessage();
    }

}else{
    echo "setta il nome";
}

?>