CodeIgniter Forums
How can insert values array as batch in database mysql? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: How can insert values array as batch in database mysql? (/showthread.php?tid=46064)



How can insert values array as batch in database mysql? - El Forum - 10-17-2011

[eluser]SaSa[/eluser]
For example i have following values and want insert batch they in database, How is it?(can done it with foreach)

My values:
Code:
<input name="u_id[]" value="76">

<input name="un[0][0]" value="1">
<input type="text" name="ue[]" value="11">
<input type="text" name="up[]" value="111">



<input name="u_id[]" value="77">

<input name="un[]" value="2">
<input type="text" name="ue[]" value="22">
<input type="text" name="up[]" value="222">

<input name="un[1][2]" value="3">
<input type="text" name="ue[]" value="33">
<input type="text" name="up[]" value="333">

insert batch in database as:

http://i.imgur.com/H6EDa.png