Karl-Arne Gjersøyen
2013-08-09 10:25:28 UTC
In my HTML5/PHP form I have this two rows..
<tr> <td align="left" valign="top">0082</td> <td align="left"
valign="top">Exan E</td> <td align="left"
valign="top">LEXE25NO</td> <td align="left" valign="top">200</td>
<td align="center" valign="top"> <input type="hidden"
name="leverandor" value="Orica"> <input type="hidden"
name="valgt_lager" value="Sviland"> <input type="hidden"
name="un_nr" value="0082"> <input type="hidden" name="varenavn"
value="Exan E"> <input type="hidden" name="varenr[]"
value="LEXE25NO"> <input type="hidden" name="adr_vekt_kg[]"
value="200"> <input type="checkbox" name="varenr_inn_pa_lager[]"
value="LEXE25NO"> </td></tr><tr> <td align="left"
valign="top">0081</td> <td align="left" valign="top">Dynamit -
papirpatron - 22x180</td> <td align="left"
valign="top">EDY22X180K</td> <td align="left" valign="top">100</td>
<td align="center" valign="top"> <input type="hidden"
name="leverandor" value=""> <input type="hidden" name="valgt_lager"
value="Sviland"> <input type="hidden" name="un_nr" value="0081">
<input type="hidden" name="varenavn" value="Dynamit - papirpatron -
22x180"> <input type="hidden" name="varenr[]"
value="EDY22X180K"> <input type="hidden" name="adr_vekt_kg[]"
value="100"> <input type="checkbox" name="varenr_inn_pa_lager[]"
value="EDY22X180K"> </td></tr>
Then I have this in PHP source to handle it...
$antall_varenr = count($varenr_inn_pa_lager);
$i = 0;
if($i < $antall_varenr){
foreach($varenr_inn_pa_lager as $vnr){
echo "$vnr<br />";
}
}
++$i;
This source code get the serialnumber ($varenr_inn_pa_lager).
The problem I struggling with is that it is two different products.
The product with serialnumber "LEXE25NO" is named Exan and the other
product with serialnumber "EDY22X180K" is Dynamite.
I need a way to extract products and put them into their own table.
The database have one table for Exan and another table for Dynamite,
and I recive products for both at the same time. I do not know where
to start for put product in their own table knowing by their own
serialnumber.
I think this is a list problem but need some help to understand this stuff.
Thank you very much. I am very thankful for all your help.
Karl
<tr> <td align="left" valign="top">0082</td> <td align="left"
valign="top">Exan E</td> <td align="left"
valign="top">LEXE25NO</td> <td align="left" valign="top">200</td>
<td align="center" valign="top"> <input type="hidden"
name="leverandor" value="Orica"> <input type="hidden"
name="valgt_lager" value="Sviland"> <input type="hidden"
name="un_nr" value="0082"> <input type="hidden" name="varenavn"
value="Exan E"> <input type="hidden" name="varenr[]"
value="LEXE25NO"> <input type="hidden" name="adr_vekt_kg[]"
value="200"> <input type="checkbox" name="varenr_inn_pa_lager[]"
value="LEXE25NO"> </td></tr><tr> <td align="left"
valign="top">0081</td> <td align="left" valign="top">Dynamit -
papirpatron - 22x180</td> <td align="left"
valign="top">EDY22X180K</td> <td align="left" valign="top">100</td>
<td align="center" valign="top"> <input type="hidden"
name="leverandor" value=""> <input type="hidden" name="valgt_lager"
value="Sviland"> <input type="hidden" name="un_nr" value="0081">
<input type="hidden" name="varenavn" value="Dynamit - papirpatron -
22x180"> <input type="hidden" name="varenr[]"
value="EDY22X180K"> <input type="hidden" name="adr_vekt_kg[]"
value="100"> <input type="checkbox" name="varenr_inn_pa_lager[]"
value="EDY22X180K"> </td></tr>
Then I have this in PHP source to handle it...
$antall_varenr = count($varenr_inn_pa_lager);
$i = 0;
if($i < $antall_varenr){
foreach($varenr_inn_pa_lager as $vnr){
echo "$vnr<br />";
}
}
++$i;
This source code get the serialnumber ($varenr_inn_pa_lager).
The problem I struggling with is that it is two different products.
The product with serialnumber "LEXE25NO" is named Exan and the other
product with serialnumber "EDY22X180K" is Dynamite.
I need a way to extract products and put them into their own table.
The database have one table for Exan and another table for Dynamite,
and I recive products for both at the same time. I do not know where
to start for put product in their own table knowing by their own
serialnumber.
I think this is a list problem but need some help to understand this stuff.
Thank you very much. I am very thankful for all your help.
Karl