Insertion données tableau html dans la bdd avec PDO

	<?php
		include_once('connect.php');
		if (isset($_POST['Enregistrer'])){ // execution apres envoi du formulaire
		// obetention des inputs de l'utilisateur	

		$insert = $bdd->prepare('
						  INSERT INTO facture VALUES(null, :designation, :Qte, :pu, :tot)
						  ');
						  $insert->execute(array(
							'designation' => "echo <script> document.getElementById(getProducts).value </script>",
							'Qte' => "echo <script> document.getElementById(price).value </script>",
							'pu' => "echo <script> document.getElementById(qtecom).value </script>",
							'tot' => "echo <script> document.getElementById(getProducts).value </script>",
							));	
			if ($insert){
			$_GET['message']="succes";
			}else{
			$_GET['erreur']="login";	
			}	

		}
    ?>

function addRow() {
"use strict";
 
var tableBody = document.getElementById("table-body");
var td1 = document.createElement("td");
var td2 = document.createElement("td");
var td3 = document.createElement("td");   
var td4 = document.createElement("td");   
var td5 = document.createElement("td");   
var td6 = document.createElement("td");   
var td7 = document.createElement("td");   
var row = document.createElement("tr");
 
td1.innerHTML = document.getElementById("ID").value;
td2.innerHTML  = document.getElementById("NAME").value;
td3.innerHTML  = document.getElementById("PASSWORD").value;
td4.innerHTML  = document.getElementById("CREDITS").value;
td5.innerHTML  = document.getElementById("EMAIL_ID").value;
td6.innerHTML  = document.getElementById("CREATED_ON").value;
td7.innerHTML  = document.getElementById("MODIFIED_ON").value;
 
row.appendChild(td1);
row.appendChild(td2);
row.appendChild(td3);
row.appendChild(td4);
row.appendChild(td5);
row.appendChild(td6);
row.appendChild(td7);
 
tableBody.appendChild(row);
 
}

<table id="table" border="1">
<thead id="table-head">
<tr>
    <th>Item</th>
    <th>Item</th>
    <th>Item</th>
    <th>Item</th>
    <th>Item</th>
    <th>Item</th>
    <th>Total</th>
</tr>
</thead>
<tbody id="table-body">
</tbody>
</table>

$("#btn_submit").click(function(){
    //get the form values
var arrayLignes = document.getElementById("table-body").rows; //on récupère les lignes du tableau
var longueur = arrayLignes.length;//on peut donc appliquer la propriété length
var valeurc = arrayColonnes.val;
 
for(var i=0; i<longueur; i++)//on peut directement définir la variable i dans la boucle
{
    var arrayColonnes[] = arrayLignes;//on récupère les cellules de la ligne
}
 
 var ID  = $('#ID').val();    
 var NAME = $('#NAME').val();    
 var PASSWORD = $('#PASSWORD').val();
 var CREDITS = $('#CREDITS').val();
 var EMAIL_ID = $('#EMAIL_ID').val();
 var CREATED_ON = $('#CREATED_ON').val();
 var MODIFIED_ON = $('#MODIFIED_ON').val();
 var valeurligne = $('arrayLignes[1]');
  
 // make the postdata
 // var postData = '&ID='+ID+'&NAME='+NAME+'&PASSWORD='+PASSWORD+'&CREDITS'+CREDITS+'&EMAIL_ID'+EMAIL_ID+'&CREATED_ON'+CREATED_ON+'&MODIFIED_ON'+MODIFIED_ON;
 // alert(postData);
 var myData={"IDN":ID,"NAMEN":NAME,"PASSWORDN":PASSWORD,"CREDITSN":CREDITS,"EMAIL_IDN":EMAIL_ID,"CREATED_ONN":CREATED_ON,"MODIFIED_ONN":MODIFIED_ON,"largeur":longueur,"valeur":valeurligne};
 //call your .php script in the background,
 //when it returns it will call the success function if the request was successful or
 //the error one if there was an issue (like a 404, 500 or any other error status)
 $.ajax({
    url : "Form_Data.php",
    type: "POST",
    data : myData,
    success: function(data,status,xhr)
     {
        //if success then just output the text to the status div then clear the form inputs to prepare for new data
        $("#status_text").html(data);
        $('#ID').val();
        $('#NAME').val('');
        $('#PASSWORD').val('');
        $('#EMAIL_ID').val('');
        $('#CREATED_ON').val('');
        $('#MODIFIED_ON').val('');
         }
 
});
});

include 'connect.php';
   mysql_set_charset('utf8');
   //query for insert data into tables
 
   $ID = $_POST['valeur'];
   $NAME =$_POST['valeur'];
   $EMAIL_ID =$_POST['valeur'];
   $PASSWORD =$_POST['valeur'];
   $CREDITS =$_POST['valeur'];
   $CREATED_ON=$_POST['valeur'];
   $MODIFIED_ON=$_POST['valeur'];
    
   $largeur = $_POST['largeur'];
    
    var_dump($_POST['largeur']);
     
   for($i=0; $i<$largeur; $i++)
    {
 
$query = "INSERT INTO `user_table`
         (`NAME`,`EMAIL_ID`,`PASSWORD`,`CREDITS`,`CREATED_ON`,`MODIFIED_ON`)
         VALUES
         ('$NAME','$EMAIL_ID','$PASSWORD','$CREDITS','$CREATED_ON','$MODIFIED_ON')";
         $query_run= mysql_query($query);
        // $retval=mysql_query($query,$conn);
          if ($query_run)
          {
                echo 'It is working';
          }
    }
 
   mysql_close($con);

<?php
include 'connect.php';
   mysql_set_charset('utf8');
   //query for insert data into tables

   $ID = $_POST['IDN'];
   $NAME =$_POST['NAMEN'];
   $EMAIL_ID =$_POST['EMAIL_IDN'];
   $PASSWORD =$_POST['PASSWORDN'];
   $CREDITS =$_POST['CREDITSN'];
   $CREATED_ON=$_POST['CREATED_ONN'];
   $MODIFIED_ON=$_POST['MODIFIED_ONN'];
   
   $largeur = $_POST['largeur'];
   
   //var_dump($_POST['largeur']);
	
   for($i=0; $i<$largeur; $i++)
	{

     $insert = $bdd->prepare('
                  INSERT INTO user_table (NAME,EMAIL_ID,PASSWORD,CREDITS,CREATED_ON,MODIFIED_ON) VALUES(:NAME, :EMAIL_ID, :PASSWORD, :CREDITS, :CREATED_ON,:MODIFIED_ON)
                  ');
                  $insert->execute(array(
                    'NAME' => htmlspecialchars($ID),
                    'EMAIL_ID' => htmlspecialchars($NAME),
                    'PASSWORD' => htmlspecialchars($EMAIL_ID),
                    'CREDITS' => htmlspecialchars($CREDITS),
                    'CREATED_ON' => htmlspecialchars($CREATED_ON),
                    'MODIFIED_ON' => htmlspecialchars($MODIFIED_ON),
                    ));	
	if ($insert){
	echo "OK";
	}

   mysql_close($con);
?>

$("#btn_submit").click(function(){
    //get the form values
var arrayLignes = document.getElementById("table-body").rows; //on récupère les lignes du tableau
var longueur = arrayLignes.length;//on peut donc appliquer la propriété length

for(var i=0; i<longueur; i++)//on peut directement définir la variable i dans la boucle
{
 //var arrayColonnes[1,i] = arrayLignes;//on récupère les cellules de la ligne
}

 var ID  = $('#ID').val();     
 var NAME = $('#NAME').val();     
 var PASSWORD = $('#PASSWORD').val();
 var CREDITS = $('#CREDITS').val();
 var EMAIL_ID = $('#EMAIL_ID').val();
 var CREATED_ON = $('#CREATED_ON').val();
 var MODIFIED_ON = $('#MODIFIED_ON').val();
 
 // make the postdata
 // var postData = '&ID='+ID+'&NAME='+NAME+'&PASSWORD='+PASSWORD+'&CREDITS'+CREDITS+'&EMAIL_ID'+EMAIL_ID+'&CREATED_ON'+CREATED_ON+'&MODIFIED_ON'+MODIFIED_ON;
 // alert(postData);
 var myData={"IDN":ID,"NAMEN":NAME,"PASSWORDN":PASSWORD,"CREDITSN":CREDITS,"EMAIL_IDN":EMAIL_ID,"CREATED_ONN":CREATED_ON,"MODIFIED_ONN":MODIFIED_ON,"largeur":longueur};
 //call your .php script in the background, 
 //when it returns it will call the success function if the request was successful or 
 //the error one if there was an issue (like a 404, 500 or any other error status)
 $.ajax({
    url : "Form_Data.php",
    type: "POST",
    data : myData,
    success: function(data,status,xhr)
     {
        //if success then just output the text to the status div then clear the form inputs to prepare for new data
        $("#status_text").html(data);
        $('#ID').val();
        $('#NAME').val('');
        $('#PASSWORD').val('');
        $('#EMAIL_ID').val('');
        $('#CREATED_ON').val('');
        $('#MODIFIED_ON').val('');
         },
 error : function(data, status, erreur){

       }

}); 
})

include 'connect.php';
   mysql_set_charset('utf8');
   //query for insert data into tables

   $ID = $_POST['IDN'];
   $NAME =$_POST['NAMEN'];
   $EMAIL_ID =$_POST['EMAIL_IDN'];
   $PASSWORD =$_POST['PASSWORDN'];
   $CREDITS =$_POST['CREDITSN'];
   $CREATED_ON=$_POST['CREATED_ONN'];
   $MODIFIED_ON=$_POST['MODIFIED_ONN'];
   
   $largeur = $_POST['largeur'];
   
   //var_dump($_POST['largeur']);
	
   for($i=0; $i<$largeur; $i++)
	{

     $insert = $bdd->prepare('
                  INSERT INTO user_table (NAME,EMAIL_ID,PASSWORD,CREDITS,CREATED_ON,MODIFIED_ON) VALUES(:NAME, :EMAIL_ID, :PASSWORD, :CREDITS, :CREATED_ON,:MODIFIED_ON)
                  ');
                  $insert->execute(array(
                    'NAME' => htmlspecialchars($ID),
                    'EMAIL_ID' => htmlspecialchars($NAME),
                    'PASSWORD' => htmlspecialchars($EMAIL_ID),
                    'CREDITS' => htmlspecialchars($CREDITS),
                    'CREATED_ON' => htmlspecialchars($CREATED_ON),
                    'MODIFIED_ON' => htmlspecialchars($MODIFIED_ON),
                    ));	
					 if ($insert)
          { 
                echo 'It is working';
          }
	}