Script php

<?php       
//******** FONCTIONS Jordane *******************//
// => Idéalement.. fonctions à placer dans un fichier
// dont tu feras un INCLUDE ....
//------------------------------------------------//

// Petite fonction de debogage bien pratique..
 function debug($value,$title=NULL){
  echo "<pre>";
   echo "--> debug:";
     if ($title){
       echo "<b>".$title." : </b>";
     }       
    if(is_array($value)){
      echo "<br>";
      print_r($value);
    }else{
      echo $value;
    }  
		echo "<br>";
		var_dump(debug_backtrace());
    echo "</pre>";  
 
 }

 // Fonction pour récupérer les variables POST /SESSION / GET / COOKIE .
  function getParams($name,$type="POST",$default=''){  
     switch ($type){
     case "POST":
         $var = isset($_POST[$name])?$_POST[$name]:$default;
         break;
     case "GET":
          $var = isset($_GET[$name])?$_GET[$name]:$default;
         break;
     case "SESSION":
          $var = isset($_SESSION[$name])?$_SESSION[$name]:$default;
         break;
     case "COOKIE":
          $var = isset($_COOKIE[$name])?$_COOKIE[$name]:$default;
         break;
     }
     return $var;
 }
//********************************** FIN DES FONCTIONS ********************************// 
 
 
 
 

debug($_POST,"Variables POST");
if(isset($_POST['ok'])) {
   echo "<div class='alert alert-danger'>
				 <strong>Erreur:</strong> Vérifier les codes! ( <a href='starpass.php'>Retour</a> )
				 </div>";
   exit(); 
}

if(isset($_POST){
 $codes = getParams('codes');
 $offre = getParams('offre');
 $username = getParams('username','SESSION');
 $arrParam = array(':pseudo' => $username, ':codes' => $codes, ':offre' => $offre);
 
 debug($arrParam,'Paramètres de la requete');
 
 try{
	 $sql= "INSERT INTO `starpass` VALUES(:pseudo, :codes, :offre, '0', UNIX_TIMESTAMP())";
	 $insertLogSQL = $odb->prepare($sql);
	 $insertLogSQL->execute($arrParam);
  } catch(Exception $e){
     debug($e," ERREUR dans la requête !");
		 exit();
  }

?>
<div class="alert alert-success"><button type="button" class="close" data-dismiss="alert">×</button>
 Bravo, votre demande a l'abonnement <?php echo htmlentities($offre); ?> est actuellement en attente ! Elle sera activée sous 12 heures
 </div>

 <?php
}
?>        
  <div class="row">
 <div class="col-sm-6">
  <div class="panel panel-primary" id="charts_env">
  
   <div class="panel-heading">
    <div class="panel-title"><i class="entypo-phone"></i> Achat par appels</div>
     <div class="panel-options">
			<a href="#" data-rel="collapse"><i class="entypo-down-open"></i></a>
    </div>
	 </div>

		 <div class="panel-body">
			<form action='' method='post'>
				<input type="text" class="form-control" placeholder="<?php echo $_SESSION['username']; ?>" disabled><br><br>
				<input type="text" class="form-control" name="codes" placeholder="Exemple : 0y45sd7d456456456hkhgkghk ">
				<br><br>
				<button  class="btn btn-info btn-icon icon-left" name="ok" type="submit"><i class="entypo-check"></i> Valider mes codes</button>
			</form>
		</div>
	</div>
</div>
                        
<section>
  <table class="table grid table-striped table-bordered table-condensed">
		<thead>
			<tr>
				<th>Pseudo</th>
				<th>Codes</th>
				<th>Offre</th>
				<th>Date & Heure</th>
				<th>Etat de la demande</th>
			</tr>
		</thead>
		<tbody>
				<?php
				$sql = "SELECT * 
							 FROM `starpass` 
							 WHERE `pseudo` = '".$_SESSION['username']."' 
							 ORDER BY `id` DESC ";
				$SQLGetLogs = $odb->query($sql);
				{
				$user = $getInfo['pseudo'];
				$IP = $getInfo['codes'];
				$IP2 = $getInfo['offre'];
				$IP3 = $getInfo['date'];
				$id = $getInfo['id'];

				 if($getInfo['fait'] == "1") { $etat = '<span class="label label-success">Accepté.</span>'; }
						 if($getInfo['fait'] == "0") { $etat = '<span class="label label-info">En attente.</span>'; }
						 if($getInfo['fait'] == "2") { $etat = '<span class="label label-danger">Refusé.</span>.'; }
						 if($getInfo['fait'] == "3") { $etat = '<span class="label label-warning">Code(s) manquant.</span>'; }
						 $date = date("d/m/Y" ,$getInfo['date']);

				echo '<tr class="odd gradeX"><td>'.$user.'</td><td>'.$IP.'</td><td>'.$IP2.'<br></td><td>'.$date.'<br></td><td>'.$etat.'<br></td></tr>';
				}

				?> 
			</tbody>
	</table>
</section>

quand les gens son sur mon site il remplise un formulaire et que quand il envoie le formulaire sa m'enregistre tout sur ma table

INSERT INTO table VALUES ('valeur 1', 'valeur 2', ...)

INSERT INTO table  (champ1,champ2,champ3...) VALUES ('valeur 1', 'valeur 2','valeur 3' ...)

 <?php 
if(isset($_POST['ok'])) {
  $codes = ($_POST['offre']); { 
    ?>
 <div class="alert alert-danger">
 <strong>Erreur:</strong> Vérifier les codes! ( <a href="starpass.php">Retour</a> )
 </div>
 <?php
    die; }
 $offre = $_POST['offre'];

$insertLogSQL = $odb -> prepare("INSERT INTO `starpass` VALUES(NULL, :pseudo, :codes, :offre, '0', UNIX_TIMESTAMP())");
  $insertLogSQL -> execute(array(':pseudo' => $_SESSION['username'], ':codes' => $_POST['codes'], ':offre' => $offre));

?>

<div class="alert alert-success"><button type="button" class="close" data-dismiss="alert">×</button>
 Bravo, votre demande a l'abonnement <?php echo htmlentities($offre); ?> est actuellement en attente ! Elle sera activée sous 12 heures
 </div>

  <?php
}
?>        
  <div class="row">
 <div class="col-sm-6">
  <div class="panel panel-primary" id="charts_env">
  
   <div class="panel-heading">
    <div class="panel-title"><i class="entypo-phone"></i> Achat par appels</div>
                
                         <div class="panel-options">
     <a href="#" data-rel="collapse"><i class="entypo-down-open"></i></a>
    </div>
   </div>

   <div class="panel-body">
 
<form action='' method='post'>
  <input type="text" class="form-control" placeholder="<?php echo $_SESSION['username']; ?>" disabled><br><br>

 <input type="text" class="form-control" name="codes" placeholder="Exemple : 0y45sd7d456456456hkhgkghk ">


<br><br>

          <button  class="btn btn-info btn-icon icon-left" name="ok" type="submit"><i class="entypo-check"></i> Valider mes codes</button>

</form>
</div>
</div></div>
                        
     <section>
  <table class="table grid table-striped table-bordered table-condensed">
<thead>
<tr>
<th>Pseudo</th>
<th>Codes</th>
<th>Offre</th>
<th>Date & Heure</th>
<th>Etat de la demande</th>
</tr>
</thead>
<tbody>
<?php
$SQLGetLogs = $odb -> query("SELECT * FROM `starpass` WHERE `pseudo` = '".$_SESSION['username']."' ORDER BY `id` DESC ");
{
$user = $getInfo['pseudo'];
$IP = $getInfo['codes'];
$IP2 = $getInfo['offre'];
$IP3 = $getInfo['date'];
$id = $getInfo['id'];

 if($getInfo['fait'] == "1") { $etat = '<span class="label label-success">Accepté.</span>'; }
     if($getInfo['fait'] == "0") { $etat = '<span class="label label-info">En attente.</span>'; }
     if($getInfo['fait'] == "2") { $etat = '<span class="label label-danger">Refusé.</span>.'; }
     if($getInfo['fait'] == "3") { $etat = '<span class="label label-warning">Code(s) manquant.</span>'; }
     $date = date("d/m/Y" ,$getInfo['date']);

echo '<tr class="odd gradeX"><td>'.$user.'</td><td>'.$IP.'</td><td>'.$IP2.'<br></td><td>'.$date.'<br></td><td>'.$etat.'<br></td></tr>';
}

?> </tbody></table>
</section>
    </fieldset>
                      <footer>




                  </footer>
  </div>
            </div>
 </div>