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
| var requete ='insert into '+table+' (cle_occupation,cle_service,date_occupation,Lits_occupes) values(';
taille=montableau1.length;
for (i=0;i<taille-1;i++)
{
requete+="(0,";
requete+=document.getElementById(montableau1[i]).value;
requete+=",\'";
requete+=document.getElementById("date").value;
requete+="\',";
if (document.getElementById(montableau2[i]).value!='')
{
requete+=document.getElementById(montableau2[i]).value;
}
else
{
requete+="0";
}
requete+=")";
if (i<taille-2)
{
requete+=",";
}
}
requete+=")";
connectexec(urlfile,host,'',base,idconnect,passconnect,'',requete,typebase,navigateur);
requete=""; |
Partager