<?php
session_start();
if (!isset($_SESSION['compte_user']))
{
header('Location: erreur_surfing.html');
exit();
}
$link = mysqli_connect("localhost", "c0adveryinvoices", "hwvTZJ7_4","c0adveryinvoices") or die("Impossible de se connecter : " . mysqli_error());
$b = date('H:i');
$c = date('d-m-Y');
$dt = $c . ' [ '. $b . ' ]'; 
$rep = $_POST['desc'];
$rep = str_replace("\n", '<br>', $rep);
$rep = addslashes($rep);
$nom =  $_POST['nom'];
$nom = addslashes($nom);
$tel = !empty($_POST[tel]) ? "$_POST[tel]" : "-";
$mail_clt = !empty($_POST[mail_clt]) ? "$_POST[mail_clt]" : "-";
$adresse = !empty($_POST[adresse]) ? "$_POST[adresse]" : "-";
$gouv = !empty($_POST[gouv]) ? "$_POST[gouv]" : "-";
$cd_postal = !empty($_POST[cd_postal]) ? "$_POST[cd_postal]" : "-";
$mat_fisc = !empty($_POST[mat_fisc]) ? "$_POST[mat_fisc]" : "-";

$a = rand(1,10000); 
$pw = 'SGC-'. $a ;
$reponse = "INSERT INTO comptes_user VALUES(id_clt ,'$nom' ,'$tel' ,'$mail_clt' ,'$pw' ,'$adresse' ,'$gouv' , '$cd_postal' ,'$mat_fisc' ,'Vide' , 'Client Part' , '$rep' ,'$dt' , 'Initiation' ,0 );";
 
  
mysqli_query($link,$reponse);

 
$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 creer un nouveau Client Particulier : '.$_POST['nom'];
$reponse = "INSERT INTO notification VALUES(id_notif ,'dripicons-user-group','$a' ,'$dt', 'ADMIN');";
mysqli_query($link,$reponse);
mysqli_close($link);
header('Location: ClientsPart.php');
exit();
?>