PHPhulp.nl PHPhulp.nl
35k+ leden Over PHPhulp Offerte opdracht Contact
M

van input array naar insert database

Door Murti Aydogdu op 02-03-2015 10:54 gewijzigd op 02-03-2015 11:00
654 views
Hallo allemaal ik werk aan een project waar bij in factuur kunt maken maar ik kan het alleen niet inserten in de database dit is de uitkomst in 

The Key is 0 with a value of Hardware
The Key is 1 with a value of Software
The Key is 0 with a value of reperatie
The Key is 1 with a value of website maken
The Key is 0 with a value of 1
The Key is 1 with a value of 1
The Key is 0 with a value of 30
The Key is 1 with a value of 500
string(126) "INSERT into hulptabel (ID, FactuurNR, Product,ProdOms,Aantal, Prijs) VALUES ('11','113' ,'Software','website maken','1','500')"


het zet het in een array dat werkt prima alleen met het inserten lukt het niet helemaal het insert alleen de laatst ingevulde tekstvak
Ariën
02-03-2015 10:59
Kom eens met relevante code aan, dan kunnen we wat meer vertellen.
M
Murti Aydogdu
02-03-2015 11:03 gewijzigd op 02-03-2015 11:04
Oke Aar dit is mijn html code

<div class="input_fields_wrap">
<button id="remove_field">x</button>
<?php $query = mysql_query("SELECT * FROM producten"); ?>
<select name="Producten[]" id="Producten">
<div><?php while($row = mysql_fetch_array($query)){
echo "<option>" . $row['Producten'] . "</option>";
}?>
</div><input type="text" name="ProdOms[]">
<input type="text" size="3" name="Aantal[]">
<input type="text" size="3" name="Prijs[]">
<a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
</select>
</div>

van dit heb ik er 15 in totaal en dit is de php code 

foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}[code]

[size=xsmall][i]Toevoeging op 02/03/2015 11:06:49:[/i][/size]

[quote="Murti Aydogdu op 02/03/2015 11:03:46"]
Oke Aar dit is mijn html code 

<div class="input_fields_wrap">
						<button  id="remove_field">x</button>		 	
						<?php $query = mysql_query("SELECT * FROM producten"); ?>
						<select name="Producten[]" id="Producten">
						<div><?php while($row = mysql_fetch_array($query)){
										echo "<option>" . $row['Producten'] . "</option>";
									}?>
						</div><input type="text" name="ProdOms[]">
							  <input type="text" size="3" name="Aantal[]">
							  <input type="text" size="3" name="Prijs[]">
							  <a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
						</select>
					</div>

van dit heb ik er 15 in totaal en dit is de php code 

[code]foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}[code]
[/quote]

ik moet de Produten, ProdOms, Aantal, Prijs inserten in de database 


[size=xsmall][i]Toevoeging op 02/03/2015 11:07:23:[/i][/size]

[quote="Murti Aydogdu op 02/03/2015 11:03:46"]
Oke Aar dit is mijn html code 

<div class="input_fields_wrap">
						<button  id="remove_field">x</button>		 	
						<?php $query = mysql_query("SELECT * FROM producten"); ?>
						<select name="Producten[]" id="Producten">
						<div><?php while($row = mysql_fetch_array($query)){
										echo "<option>" . $row['Producten'] . "</option>";
									}?>
						</div><input type="text" name="ProdOms[]">
							  <input type="text" size="3" name="Aantal[]">
							  <input type="text" size="3" name="Prijs[]">
							  <a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
						</select>
					</div>

van dit heb ik er 15 in totaal en dit is de php code 

[code]foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}[code]

[size=xsmall][i]Toevoeging op 02/03/2015 11:06:49:[/i][/size]

[quote="Murti Aydogdu op 02/03/2015 11:03:46"]
Oke Aar dit is mijn html code 

<div class="input_fields_wrap">
						<button  id="remove_field">x</button>		 	
						<?php $query = mysql_query("SELECT * FROM producten"); ?>
						<select name="Producten[]" id="Producten">
						<div><?php while($row = mysql_fetch_array($query)){
										echo "<option>" . $row['Producten'] . "</option>";
									}?>
						</div><input type="text" name="ProdOms[]">
							  <input type="text" size="3" name="Aantal[]">
							  <input type="text" size="3" name="Prijs[]">
							  <a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
						</select>
					</div>

van dit heb ik er 15 in totaal en dit is de php code 

[code]foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}

[/quote]

ik moet de Produten, ProdOms, Aantal, Prijs inserten in de database

[/quote]



[size=xsmall]Toevoeging op 02/03/2015 11:08:13:[/size]


Oke Aar dit is mijn html code

<div class="input_fields_wrap">
<button id="remove_field">x</button>
<?php $query = mysql_query("SELECT * FROM producten"); ?>
<select name="Producten[]" id="Producten">
<div><?php while($row = mysql_fetch_array($query)){
echo "<option>" . $row['Producten'] . "</option>";
}?>
</div><input type="text" name="ProdOms[]">
<input type="text" size="3" name="Aantal[]">
<input type="text" size="3" name="Prijs[]">
<a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
</select>
</div>

van dit heb ik er 15 in totaal en dit is de php code 

foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}


ik moet de Produten, ProdOms, Aantal, Prijs inserten in de database





[size=xsmall]Toevoeging op 02/03/2015 11:08:59:[/size]

Oke Aar dit is mijn html code

<div class="input_fields_wrap">
<button id="remove_field">x</button>
<?php $query = mysql_query("SELECT * FROM producten"); ?>
<select name="Producten[]" id="Producten">
<div><?php while($row = mysql_fetch_array($query)){
echo "<option>" . $row['Producten'] . "</option>";
}?>
</div><input type="text" name="ProdOms[]">
<input type="text" size="3" name="Aantal[]">
<input type="text" size="3" name="Prijs[]">
<a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
</select>
</div>

van dit heb ik er 15 in totaal en dit is de php code 

foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}


ik moet de Produten, ProdOms, Aantal, Prijs inserten in de database







[size=xsmall]Toevoeging op 02/03/2015 13:58:13:[/size]

iemand die het weet het moet

[size=xsmall]Toevoeging op 02/03/2015 13:58:41:[/size]

Murti Aydogdu op 02/03/2015 11:03:46

Oke Aar dit is mijn html code

<div class="input_fields_wrap">
<button id="remove_field">x</button>
<?php $query = mysql_query("SELECT * FROM producten"); ?>
<select name="Producten[]" id="Producten">
<div><?php while($row = mysql_fetch_array($query)){
echo "<option>" . $row['Producten'] . "</option>";
}?>
</div><input type="text" name="ProdOms[]">
<input type="text" size="3" name="Aantal[]">
<input type="text" size="3" name="Prijs[]">
<a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
</select>
</div>

van dit heb ik er 15 in totaal en dit is de php code 

foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}[code]

[size=xsmall][i]Toevoeging op 02/03/2015 11:06:49:[/i][/size]

[quote="Murti Aydogdu op 02/03/2015 11:03:46"]
Oke Aar dit is mijn html code 

<div class="input_fields_wrap">
						<button  id="remove_field">x</button>		 	
						<?php $query = mysql_query("SELECT * FROM producten"); ?>
						<select name="Producten[]" id="Producten">
						<div><?php while($row = mysql_fetch_array($query)){
										echo "<option>" . $row['Producten'] . "</option>";
									}?>
						</div><input type="text" name="ProdOms[]">
							  <input type="text" size="3" name="Aantal[]">
							  <input type="text" size="3" name="Prijs[]">
							  <a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
						</select>
					</div>

van dit heb ik er 15 in totaal en dit is de php code 

[code]foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}[code]
[/quote]

ik moet de Produten, ProdOms, Aantal, Prijs inserten in de database 


[size=xsmall][i]Toevoeging op 02/03/2015 11:07:23:[/i][/size]

[quote="Murti Aydogdu op 02/03/2015 11:03:46"]
Oke Aar dit is mijn html code 

<div class="input_fields_wrap">
						<button  id="remove_field">x</button>		 	
						<?php $query = mysql_query("SELECT * FROM producten"); ?>
						<select name="Producten[]" id="Producten">
						<div><?php while($row = mysql_fetch_array($query)){
										echo "<option>" . $row['Producten'] . "</option>";
									}?>
						</div><input type="text" name="ProdOms[]">
							  <input type="text" size="3" name="Aantal[]">
							  <input type="text" size="3" name="Prijs[]">
							  <a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
						</select>
					</div>

van dit heb ik er 15 in totaal en dit is de php code 

[code]foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}[code]

[size=xsmall][i]Toevoeging op 02/03/2015 11:06:49:[/i][/size]

[quote="Murti Aydogdu op 02/03/2015 11:03:46"]
Oke Aar dit is mijn html code 

<div class="input_fields_wrap">
						<button  id="remove_field">x</button>		 	
						<?php $query = mysql_query("SELECT * FROM producten"); ?>
						<select name="Producten[]" id="Producten">
						<div><?php while($row = mysql_fetch_array($query)){
										echo "<option>" . $row['Producten'] . "</option>";
									}?>
						</div><input type="text" name="ProdOms[]">
							  <input type="text" size="3" name="Aantal[]">
							  <input type="text" size="3" name="Prijs[]">
							  <a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
						</select>
					</div>

van dit heb ik er 15 in totaal en dit is de php code 

[code]foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}



ik moet de Produten, ProdOms, Aantal, Prijs inserten in de database

[/quote]



[size=xsmall]Toevoeging op 02/03/2015 11:08:13:[/size]


Oke Aar dit is mijn html code

<div class="input_fields_wrap">
<button id="remove_field">x</button>
<?php $query = mysql_query("SELECT * FROM producten"); ?>
<select name="Producten[]" id="Producten">
<div><?php while($row = mysql_fetch_array($query)){
echo "<option>" . $row['Producten'] . "</option>";
}?>
</div><input type="text" name="ProdOms[]">
<input type="text" size="3" name="Aantal[]">
<input type="text" size="3" name="Prijs[]">
<a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
</select>
</div>

van dit heb ik er 15 in totaal en dit is de php code 

foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}


ik moet de Produten, ProdOms, Aantal, Prijs inserten in de database





[size=xsmall]Toevoeging op 02/03/2015 11:08:59:[/size]

Oke Aar dit is mijn html code

<div class="input_fields_wrap">
<button id="remove_field">x</button>
<?php $query = mysql_query("SELECT * FROM producten"); ?>
<select name="Producten[]" id="Producten">
<div><?php while($row = mysql_fetch_array($query)){
echo "<option>" . $row['Producten'] . "</option>";
}?>
</div><input type="text" name="ProdOms[]">
<input type="text" size="3" name="Aantal[]">
<input type="text" size="3" name="Prijs[]">
<a href="javascript:void(0)" onclick="toggle_visibility('popup-box1');"><img src="../img/icons/info.png" height="16" width="16"></a>
</select>
</div>

van dit heb ik er 15 in totaal en dit is de php code 

foreach($_POST['Producten'] as $key => $Producten) {
					echo 'The Key is '.$key. ' with a value of '.$Producten.'<br/>';
				}
				foreach($_POST['ProdOms'] as $key => $ProdOms){
					echo 'The Key is '.$key. ' with a value of '.$ProdOms.'<br/>';
				}
				foreach($_POST['Aantal'] as $key => $Aantal){
					echo 'The Key is '.$key. ' with a value of '.$Aantal.'<br/>';
				}
				foreach($_POST['Prijs'] as $key => $Prijs){
					echo 'The Key is '.$key. ' with a value of '.$Prijs.'<br/>';
				}


ik moet de Produten, ProdOms, Aantal, Prijs inserten in de database







[size=xsmall]Toevoeging op 02/03/2015 13:58:13:[/size]

iemand die het weet hoe moet
[/quote]

Reageren

Inloggen om te reageren