How to insert 2 arrays into mysql database into 2 columns, different rows?

Question

foreach ($_SESSION['exampleOne'] as $item)
{//insert sql

foreach ($_SESSION['exampleTwo'] as $comment)
{//insert sql

How do I merge 2 foreach together? now my database store like this.. :

    comment | item
    ---------------
    Nice!   | Pants
    Great!  | Pants
    Awesome!| Pants
    Nice!   | Skirts
    Great!  | Skirts
    Awesome!| Skirts
    Nice!   | Shirts
    Great!  | Shirts
    Awesome!| Shirts

I want it somehow to be like this in my database when I store it:

comment | item
---------------
Nice!   | Pants
Great!  | Skirts
Awesome!| Shirts

I don't understand. Can you show the values of your $_SESSION arrays? — bozdoz
– bozdoz, Commented Dec 31, 2012 at 9:05
You've basically omitted most of the relevant information: what your arrays contain and what your SQL statements look like. — Álvaro González
– Álvaro González, Commented Dec 31, 2012 at 9:05
$_SESSION['exampleOne'] is having comments and $_SESSION['exampleTwo'] is having item ? — Sahal
– Sahal, Commented Dec 31, 2012 at 9:06
The questions are in your mind only still.. Please express it — Sahal
– Sahal, Commented Dec 31, 2012 at 9:07

Suresh Kamrushi · Accepted Answer · 2012-12-31 09:15:04Z

1

You can do like this--

$merge = array_combine ($_SESSION['exampleOne'],$_SESSION['exampleTwo'])
foreach($merge as $key => $value)
{
    // your insert query
    $query = "insert into tableName set comment='$key', item='$value'";
}

answered Dec 31, 2012 at 9:15

Suresh Kamrushi

16.2k13 gold badges79 silver badges93 bronze badges

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

2 Comments

bozdoz Over a year ago

I still don't know what OP is looking for. This seems correct, except I think the SESSION arrays might need to be boiled down to their unique values with array_unique, according to the example in the question. Still, though, it doesn't make sense to me. :)

d33tah Over a year ago

Beware of the SQL injection!

Collectives™ on Stack Overflow

How to insert 2 arrays into mysql database into 2 columns, different rows?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related