<?php

session_start();
include '../database.php';


$database = new Database();
$connexion = $database->getConnection();

if ($connexion) {
    
    if(isset($_SESSION['login'])){
        $username = $_SESSION['login'];
    }
    
    $sql = "SELECT * from users where pseudo = '$username'";
    $statement = $connexion->prepare($sql);
    $statement->execute();
                
    $results = $statement->fetchAll(PDO::FETCH_ASSOC);
    foreach ($results as $row) {
        $id = $row['id_user'];
    }
    
    $sql2 = "DELETE FROM `inv` WHERE id_user = '$id'";
    $statement2 = $connexion->prepare($sql2);
    $statement2->execute();
    
}