1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| $id = mysql_real_escape_string($_POST["id_fiche"]);
mysql_query("DELETE FROM locuteurs WHERE id_fiche=".$id);
for ($i=0 ; $i < count($_POST["id"]) ; $i++ ) {
$id_loc = addslashes($_POST["id"][$i]);
$nbre_tour_parole = addslashes($_POST["nbre_tour_parole"][$i]);
$Loc_principal = addslashes($_POST["Loc_principal"][$i]);
$age = addslashes($_POST["age"][$i]);
$sex = addslashes($_POST["sex"][$i]);
$etude = addslashes($_POST["etude"][$i]);
$formation = addslashes($_POST["formation"][$i]);
$occupation = addslashes($_POST["occupation"][$i]);
$occupationAnt = addslashes($_POST["occupationAnt"][$i]);
$role = addslashes($_POST["role"][$i]);
$degre_planification = addslashes($_POST["degre_planification"][$i]);
$statut_francais = addslashes($_POST["statut_francais"][$i]);
$autre_langue = addslashes($_POST["autre_langue"][$i]);
$Lieu_naissance = addslashes($_POST["Lieu_naissance"][$i]);
$app_regionale = addslashes($_POST["app_regionale"][$i]);
$local = addslashes($_POST["local"][$i]);
$Particularites = addslashes($_POST["Particularites"][$i]);
//requete 2 : table locuteurs
$sql2 = "INSERT INTO locuteurs(id_fiche,session_login,Statut_corpus,NomFichierSource,id,nbre_tour_parole,Loc_principal,age,sex,etude,formation,occupation,occupationAnt,role,degre_planification,statut_francais,autre_langue,Lieu_naissance,app_regionale,local,Particularites)";
$sql2 .= "VALUES('$id','$session_login','$Statut_corpus','$NomFichierSource','$id_loc','$nbre_tour_parole','$Loc_principal','$age','$sex','$etude','$formation','$occupation','$occupationAnt','$role','$degre_planification','$statut_francais','$autre_langue','$Lieu_naissance','$app_regionale','$local','$Particularites')";
$requete2 = mysql_query($sql2);
} |
Partager