Untitled

<!DOCTYPE html>
<html>
<head>
    <title></title>
</head>
<body>
<?php
$nb=(int) $_GET['nb'];
$pro=(String) $_GET['pro'];
$civil=(String) $_GET['civil'];
$adresse=(String) $_GET['adresse'];
$nom=(String) $_GET['nom'];
$prenom=(String) $_GET['prenom'];
$cp=(String) $_GET['cp'];
$ville=(String) $_GET['ville'];
$email=(String) $_GET['email'];
$newsletter=(String) $_GET['newsletter'];


$pdo = new PDO('mysql:host=localhost;dbname=billeterie', 'root', 'root');
$requette = $pdo->query('SELECT id_client FROM client');
while(true){
    $b=0;
    $idcl=rand (10000 , 99999);
    foreach($requette as $a){
        if($a==$idcl){
            $b=1;
        }
    }
    if($b==0){
        break;
    }
}


$requette = $pdo->query('SELECT no_facture FROM facture');
while(true){
    $b=0;
    $no_facture=rand (10000 , 99999);
    foreach($requette as $a){
        if($a==$idcl){
            $b=1;
        }
    }
    if($b==0){
        break;
    }
}

$requette = $pdo->query('SELECT no_commande FROM facture');
while(true){
    $b=0;
    $no_commande=rand (10000 , 99999);
    foreach($requette as $a){
        if($a==$idcl){
            $b=1;
        }
    }
    if($b==0){
        break;
    }
}

echo $no_facture;
echo $no_commande;
date_default_timezone_set('Europe/Paris');
$date_fact = date('Y').'-'.date('m').'-'.date('d');
echo "<br>";
echo $date_fact;

$pdo->query('INSERT INTO no_facture VALUES ("'.$no_facture.'", "'.$no_commande.'", "'.$date_fact.'")');

/*$pdo->query('INSERT INTO client VALUES ("'.$idcl.'", "'.$nb.'", "'.$nom.'","'.$prenom.'","'.$adresse.'","'.$cp.'","'.$ville.'",'.$email.'","'.$newsletter.'","'.$civil.'","'.$pro.'",""'.$no_facture.'",)');

$valide=0;$prix=8;$prixr=4;
$y=(int) ($nb/2);
$z= (int) ($nb-$y);
for($i=0;$i<$y;$i++){
    $requette = $pdo->query('SELECT id_ticket FROM ticket');
    while(true){
        $b=0;
        $id_ticket=rand (1000000000000 , 9999999999999);
        foreach($requette as $a){
            if($a==$idcl){
                $b=1;
            }
        }
        if($b==0){
            break;
        }
    }
    $pdo->query('INSERT INTO ticket VALUES ("'.$id_ticket.'", "'.$prix.'", "'.$date_fact.'","'.$idcl.'","'.$valide.'")');
}
for($i=0;$i<$z;$i++){
    $requette = $pdo->query('SELECT id_ticket FROM ticket');
    while(true){
        $b=0;
        $id_ticket=rand (1000000000000 , 9999999999999);
        foreach($requette as $a){
            if($a==$idcl){
                $b=1;
            }
        }
        if($b==0){
            break;
        }
    }
    $pdo->query('INSERT INTO ticket VALUES ("'.$id_ticket.'", "'.$prixr.'", "'.$date_fact.'","'.$idcl.'","'.$valide.'")');
}*/

?>
</body>
</html>