<?php
    $servername = "localhost";
    $username = "root";
    $password = "Chacal0328";
    $dbname = "chercheurs";

    if(isset($_GET['labo']) && $_GET['labo'] == 'default'){
        header('Location:pageCreationCompte.php?message="Choisissez un labo"');
    }


    $conn = new mysqli($servername, $username, $password, $dbname);

    if($conn->connect_error){
        die("Connection failed: " .$conn->connect_error);
    }

    echo "Connected successfully";


    //var du compte
    if($_GET['optSearch'] == 'dateCat'){

        $sql = "SELECT * FROM publication GROUP BY annee, categorie DESC";
        $result = $conn->query($sql);
        if ($result->num_rows > 0) {
            // output data of each row
            while($row = $result->fetch_assoc()) {
                echo "id: " . $row["id"]. " - titre: " . $row["titre"]. " -categorie " . $row["categorie"]. " -annee " . $row["annee"]." -lieu " . $row["lieu"]. "<br>";
            }
        } else {
            echo "0 results";
        }
    }
    else if($_GET['optSearch'] == 'labDate'){
        $annee = $_GET['annee'];
        $lab = $_GET['labo'];

        $sql = "SELECT * FROM publication WHERE annee >= '$annee' AND laboratoire = '$labo' GROUP BY annee";
        $result = $conn->query($sql);
        if ($result->num_rows > 0) {
            // output data of each row
            while($row = $result->fetch_assoc()) {
                echo "id: " . $row["id"]. " - titre: " . $row["titre"]. " -categorie " . $row["categorie"]. " -annee " . $row["annee"]." -lieu " . $row["lieu"]. "<br>";
            }
        } else {
            echo "0 results";
        }
    }
    else if($_GET['optSearch'] == 'chercheurDateCat'){

        $chercheur = $_GET['chercheur'];

        $sql = "SELECT * FROM publication";
        $result = $conn->query($sql);
        if ($result->num_rows > 0) {
            // output data of each row
            while($row = $result->fetch_assoc()) {
                if(parseAuteursExists($row['auteurs'],$chercheur)){
                echo "id: " . $row["id"]. " - titre: " . $row["titre"]. " -categorie " . $row["categorie"]. " -annee " . 			$row["annee"]." -lieu " . $row["lieu"]. "<br>";
                }

            }
        } else {
            echo "0 results";
        }
    }
    else if($_GET['optSearch'] == 'collabExte'){
        $cherheur = $_GET['chercheur'];
    }
    else if($_GET['optSearch'] == 'coAut'){
        $chercheur = $_GET['chercheur'];
        $listeCompleteAuteurs;
        $sql = "SELECT * FROM publication";
        $result = $conn->query($sql);
        if ($result->num_rows > 0) {
            // output data of each row
            $listeCompleteAuteurs=array();

            while($row = $result->fetch_assoc()) {

                array_push($listeCompleteAuteurs,addAuteurs($row['auteurs'],$chercheur));

            }
            $size = count($listeCompleteAuteurs);
            $final_array = array();
            for($x=0 ; $x<$size ; $x++){
                if()
            }
        } else {
            echo "0 results";
        }
    }



    if(!mysqli_query($conn,$sql)) {
      die('Error: ' . mysqli_error($conn));
    }
    header('Location: index.php');
    mysqli_close($conn);

?>

<script>

function parseAuteursExists(string1,string2){

    var auteurs = string1.split(',');
    var present = FALSE;
    for(var i = 0 ; i <=auteurs.length() ; i++){
        if(auteurs[i] == string2){
            present = TRUE;
        }
    }
    return present;

}
function addAuteurs(string1,string2){

    var auteurs = string1.split(',');
    var auteursFull;
    for(var i = 0 ; i <=auteurs.length() ; i++){
        if(auteurs[i] != string2){
            auteursFull.add(auteurs[i]);
        }
    }

    return auteursFull;

}


</script>