php: Use different arrays in foreach loop

Question

I have 3 input that can be added dynamically. So the name of input is array, like:

<input type="text" name="qty1[]">
<input type="text" name="qty2[]">
<input type="text" name="qty3[]">

(Each of these input texts can be generated by javascript)

In my php file, I get them and want to insert to database (my controller in codeigniter):

$address = $this->input->post("qty1");
$LocX =    $this->input->post("qty2");
$LocY =    $this->input->post("qty3");

In my db part, where I want to use foreach and add to database:

Edit

foreach ($address as $key) {
  // I want to add $LocX and $LocY to the table
  // LocX and LocY are column names.
  $query = $this->db->query("INSERT INTO address (Comp_ID, Value, LocX, LocY)
                             VALUES(?, ?)", array($Comp_ID, $key ,? ,?));
}

I want to add all of them into foreach as parameter. As I searched it's not possible. What shoud I do? Thanks.

Edit2

The result of arrays, for example for $LocX :

Array
(
  [0] => test1
  [1] => test2
  [2] => test3
)

@VladimirSerykh $address , $LocX and $locY, all of these variables are arrays. I should use them in foreach in order to insert into database. — Vahid Najafi
– Vahid Najafi, Commented Aug 15, 2015 at 10:10
What do you want to be the expected output of your array? Before inserting in your database? — aldrin27
– aldrin27, Commented Aug 15, 2015 at 10:13
array_merge() is not preferable in this case, as it will overwrite the keys — Viral
– Viral, Commented Aug 15, 2015 at 10:14

Tom V. · Accepted Answer · 2015-08-15 10:17:22Z

1

You can use the index in the foreach to get to the other elements. But you need to carefully check if the index value exists in the other arrays (isset check)

For example:

foreach ($address as $key => $value) {
  if(isset($LocX[$key], $LocY[$key]) {
      $a_LocX = $LocX[$key]; // This will be the locx of the address
      $a_LocY = $LocY[$key]; // This will be the locy of the address

      // Change your query to fit the table and fill in the locx and y.
      $query = $this->db->query("INSERT INTO address (Comp_ID, Value)
                             VALUES(?, ?)", array($Comp_ID, $key));
}

answered Aug 15, 2015 at 10:17

Tom V.

3232 silver badges10 bronze badges

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

Comments

Hanky Panky · Accepted Answer · 2015-08-15 10:22:28Z

1

You can also use a for loop for this.

$address = $this->input->post("qty1");
$LocX =    $this->input->post("qty2");
$LocY =    $this->input->post("qty3");

$n=count($address);
for($i=0;$i<$n;$i++){
       $a=$address[$i];
       $x=$locX[$i];
       $y=$locY[$i];
       //insert here
}

answered Aug 15, 2015 at 10:22

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

Comments

Viral · Accepted Answer · 2015-08-15 10:36:35Z

1

I will suggest you to use Codeigniter syntax, and this will make your insert work,

foreach($address as $k => $v)
{
    $insert = array(
                'Comp_ID' => $Comp_ID,
                'Value' => $v,
            ); // insert array

    if(in_array($LocX[$k], $LocX)) // existance check
        $insert = array_merge($insert, array('LocX' => $LocX[$k]));

    if(in_array($LocY[$k], $LocY)) // existance check
        $insert = array_merge($insert, array('LocY' => $LocY[$k]));

    $this->db->insert('address', $insert); // No need to write full query
}

edited Aug 15, 2015 at 10:36

answered Aug 15, 2015 at 10:28

Viral

3,7531 gold badge20 silver badges34 bronze badges

Collectives™ on Stack Overflow

php: Use different arrays in foreach loop

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