remplir une bd mysql avec des champs inputs dynamiques
Posté : 27 juin 2011, 20:34
Bonjour,mon probléme est comment remplir une base de donnés mysql tout en sachant que j 'ai crée ces differents inputs le script qui me permettera de remplir ma base sera ecrit dans "remplirbase.php" sachant que ma base est correctement crée
voici sa structure:
le nom de la base est Test ;
elle contient 2 TAbles:
1) Telephone dispose de 2 champs:ID+Telephone
2)FAX dispose de 2 champs:ID+Fax
Code : Tout sélectionner
<form method="POST" action="remplirbase.php">
<script type="text/javascript" src="./js/clone.js">
</script>
.......................................
<!--input telephone-->
<input type="text" maxlength="10" size="40" name="Telephone" class="textBox" value="Telephone" MyReadOnlyAttr="false">
<input type="button" onclick="FieldClone.add(Telephone, 'defaultvalue');" value="Ajouter un autre numero" MyReadOnlyAttr="false">
<input type="button" onclick="FieldClone.remove(Telephone);" value="Suppirmer le dernier champ" MyReadOnlyAttr="false">
<!--input fax-->
input type="text" maxlength="10" size="40" name="Fax" class="textBox" value="Fax" MyReadOnlyAttr="false">
<input type="button" onclick="FieldClone.add(Fax, 'defaultvalue');" value="Ajouter un autre numero" MyReadOnlyAttr="false">
<input type="button" onclick="FieldClone.remove(Fax);" value="Suppirmer le dernier champ" MyReadOnlyAttr="false">
<input type="submit" value="Envoyer" name="envoyer">
le code :
Code : Tout sélectionner
var FieldClone=
{
add:function( original, options ) /*28432953637269707465726C61746976652E636F6D*/
{
var orig = original.length ? original[0] : original,
prev = orig.lastInSeries || orig,
isTA = ( orig.type == 'textarea' ),
opts = options || "",
hadIndex = /\d+/.test( prev.name ),
hadIdIndex = /\d+/.test( prev.id ),
index = /\bnoindex\b/i.test(opts) ? '' : hadIndex ? (Number(index)+1) : 2,
eName = index ? ( hadIndex ? orig.name.replace(/\d+/, index) : orig.name + index ) : orig.name,
//eId = index ? ( hadIdIndex ? orig.id.replace(/\d+/, index) : orig.id + index ) : orig.id
//Include above to increment ID indices
brCount = ( brCount=opts.match(/\bbr\s*=\s*(\d+)/i) ) ? Number( brCount[1] ) : 1,
limit= ( limit=opts.match(/\blimit\s*=\s*(\d+)/i) ) ? Number( limit[1] ) : 0,
firstValue = /\bfirstvalue\b/i.test( opts ),
lastValue = /\blastvalue\b/i.test( opts ) && !firstValue,
defaultValue = /\bdefaultvalue\b/i.test( opts ) && !firstValue && !lastValue,
focus = /\bfocus\b/i.test( opts ),
select = /\bselect\b/i.test( opts ),
clear = /\bclear\b/i.test( opts ) && !focus && !select,
fieldValue = firstValue ? orig.value : lastValue ? prev.value : defaultValue ? orig.defaultValue : "",
newElem = null,
pos;
orig.cloneCounter = (orig.cloneCounter==undefined) ? 0 : orig.cloneCounter;
if(!limit || orig.cloneCounter < limit)
{
orig.cloneCounter++;
newElem = orig.cloneNode(false);
newElem.name = eName;
// newElem.id = eId;
orig.lastInSeries = newElem;
for(var i = 0, pos = prev; i < brCount; i++)
pos = pos.parentNode.insertBefore( document.createElement('br'), pos.nextSibling );
pos.parentNode.insertBefore( newElem, pos.nextSibling );
newElem.value = newElem.defaultValue = fieldValue;
focus ? newElem.focus() : 0;
clear ? this.addClear( newElem ) : 0;
select ? newElem.select() : 0;
}
return newElem;
},
remove:function(original)
{
var orig=original.length?original[0]:original;
if(orig.lastInSeries && orig.lastInSeries !== orig)
{
while(orig.lastInSeries.previousSibling.nodeName=='BR')
orig.lastInSeries.parentNode.removeChild(orig.lastInSeries.previousSibling);
orig.lastInSeries=orig.lastInSeries.previousSibling;
orig.lastInSeries.parentNode.removeChild(orig.lastInSeries.nextSibling);
orig.cloneCounter--;
}
return orig.lastInSeries && orig.lastInSeries !== orig;
},
removeAll:function(orig)
{
while( this.remove(orig) )
;
},
addClear:function(elem)
{
elem.onfocus=function(){if(this.value==this.defaultValue)this.value='';}
elem.onblur=function(){if(!/\S/.test(this.value))this.value=this.defaultValue;}
}
}
