How to save table values into array?

Question

I have table in wordpress admin panel:

<tr>
    <td><input style="width:80%" type="text" name="ism" value="" /></td>
    <td><input style="width:80%" type="text" name="par" value="" /></td>
    <td><input style="width:80%" type="text" name="mar" value="" /></td>
    <td><input style="width:80%" type="text" name="akc" value="-" /></td>
    <td><a style="cursor:pointer;" onclick="nqsaddtr(this)">Add</a></td>
</tr>

It looks like:

enter image description here

Table can have unlimited number of rows.

I want to save all values in array and save results in database.

I have a code (it's not working):

  $per = array();
   foreach($_POST['ism'] as $prod) {
  $ism = $_POST['ism'][$i];
  $par = $_POST['par'][$i];
  $mar = $_POST['mar'][$i];
  $akc = $_POST['akc'][$i];
  $per = array('post_id'=>$post_id,'ismatavimai'=>$ism,'parametras'=>$par,'marke'=>$mar,'akcijos'=>$akc);
  }

 /* update */
 if (!empty($prev)) $wpdb->update($wpdb->produktas,$upd,array('post_id'=>$post_id));
 else { $upd['post_id'] = $post_id; $wpdb->insert($wpdb->produktas,$per); }

It saves empty first row (without any values, just post id).

  $per = array();
  $ism = $_POST['ism'];
  $par = $_POST['par'];
  $mar = $_POST['mar'];
  $akc = $_POST['akc'];
  $per = array('post_id'=>$post_id,'ismatavimai'=>$ism,'parametras'=>$par,'marke'=>$mar,'akcijos'=>$akc);

This one is working, but of course it saves results just of first row.

How I can make everything work?

Sudhir Bastakoti · Accepted Answer · 2011-12-28 12:48:29Z

2

Do:


$yourArr = array();
$i = 0;
foreach($_POST['ism'] as $prod) {
  $ism = $_POST['ism'][$i];
  $par = $_POST['par'][$i];
  $mar = $_POST['mar'][$i];
  $akc = $_POST['akc'][$i];
$per[$i]["post_id"] = $post_id;
      $per[$i]['ismatavimai'] =$ism;
      $per[$i]['parametras']=$par;
      $per[$i]['marke']=$mar;
      $per[$i]['akcijos']=$akc;
      $i++;
  }

answered Dec 28, 2011 at 12:48

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Manoj · Accepted Answer · 2011-12-28 12:49:10Z

0

you need to generate dynamic names for your input box, like

<tr>
    <td><input style="width:80%" type="text" name="ism1" value="" /></td>
</tr>
<tr>
    <td><input style="width:80%" type="text" name="ism2" value="" /></td>
</tr>
<tr>
    <td><input style="width:80%" type="text" name="ism3" value="" /></td>
</tr>

then you can extract it like

$ism1 = $_POST['ism1'];
$ism2 = $_POST['ism2'];

basically you need to add your code in loop

answered Dec 28, 2011 at 12:49

Manoj

4975 gold badges8 silver badges19 bronze badges

Comments

Steve Buzonas · Accepted Answer · 2011-12-28 13:27:31Z

0

Your form elements are not generating an array for the post variable.

Try:

<td><input style="width:80%" type="text" name="ism[]" value="" /></td>
<td><input style="width:80%" type="text" name="par[]" value="" /></td>
<td><input style="width:80%" type="text" name="mar[]" value="" /></td>
<td><input style="width:80%" type="text" name="akc[]" value="-" /></td>
<td><a style="cursor:pointer;" onclick="nqsaddtr(this)">Add</a></td>

answered Dec 28, 2011 at 13:27

Steve Buzonas

5,7501 gold badge35 silver badges56 bronze badges

Collectives™ on Stack Overflow

How to save table values into array?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related