<?php
session_start();
if (!isset($_SESSION['compte_user']))
{
header('Location: erreur_surfing.html');
exit();
}
if (!isset($_SESSION['r_devis']))
{
header('Location: DEVIS.php');
exit();
}
$link = mysqli_connect("localhost", "invoices", "9rhJvEkV15jAhJD","invoices") or die("Impossible de se connecter : " . mysqli_error());

$reponse = "UPDATE  devis SET etat_devis = 'Valide' where ref_devis = '$_SESSION[r_devis]' ;";
mysqli_query($link,$reponse);

$b = date('H:i');
$c = date('d-m-Y');
$dt = $c . ' [ '. $b . ' ]';
$reponse = "select * from comptes_user where id_clt = $_SESSION[compte_user] ;";
$exec =mysqli_query($link,$reponse);
$row = mysqli_fetch_assoc($exec);
$a = $row['nom'].' vient de valider un DEVIS : '.$_SESSION['r_devis'];
$reponse = "INSERT INTO notification VALUES(id_notif ,'dripicons-user-group','$a' ,'$dt', 'ADMIN');";
mysqli_query($link,$reponse);

header('Location: Detail-DEVIS.php');
exit();

mysql_close($link);

 
?>