<?php
session_start();
if (!isset($_SESSION['compte_user']))
{
header('Location: erreur_surfing.html');
exit();
}
$link = mysqli_connect("localhost",  "advery", "EoM6IJlnirGIfcu","factures") 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);
$rep1 = $_POST['nom'];
$rep1 = addslashes($rep1);
$a = rand(1,10000); 
$pw = 'SGC-'. $a ;
$reponse = "INSERT INTO comptes_user VALUES(id_clt ,'$rep1' ,'$_POST[tel]' ,'$_POST[mail_clt]' ,'$pw' ,'$_POST[adresse]' ,'$_POST[gouv]' , $_POST[cd_postal] ,'$_POST[mat_fisc]' ,'Vide' , 'Client Pro' , '$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 Pro : '.$_POST['nom'];
$reponse = "INSERT INTO notification VALUES(id_notif ,'dripicons-user-group','$a' ,'$dt', 'ADMIN');";
mysqli_query($link,$reponse);
mysqli_close($link);
header('Location: ClientsPro.php');
exit();
?>