Build Mysql query with forearch loop php

Question

Values are inside a multidimenssional array like:

Array ( 
    [0] => Array (
        [fname] => CollectiveAccess
        [lname] => Administrator
        [username] => administrator
        )
    [1] => Array (
        [fname] => Jorge
        [lname] => Ghelman 
        [username] => jorgeghe 
        )
    [2] => Array (
        [fname] => Sebastian
        [lname] => Scarano
        [username] => sscarano
        )
)

This is the loop I use to build the query:

foreach ($user_names as $value) {
    foreach ($value as  $value2) {
        echo $value2 . " "; //prints all values
        $query = "INSERT INTO users (username, fname, lname)
                  VALUES ('$value2', );";
    }
}

print_r($query) shows that only the last value from $value2 is passed to the query.

INSERT INTO users (username, fname, lname) VALUES ('test1', );

I'm sure it's a rookie mistake but can't figure it out. Thanks

Surely you're using parametrized queries so this won't be a problem. — JJJ
– JJJ, Commented Aug 17, 2013 at 18:53

bansi · Accepted Answer · 2013-08-17 18:59:33Z

1

try this

foreach ($user_names as $value) {
    $query = "INSERT INTO users (username, fname, lname)
              VALUES ('{$value['username']}', '{$value['fname']}', '{$value['lname']}');";
    echo $query;
}

answered Aug 17, 2013 at 18:59

bansi

57.3k6 gold badges44 silver badges52 bronze badges

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

1 Comment

sms Over a year ago

It worked like a charm! Thanks!. I have some php book but none of them contains situations like this one, it's frustrating. Thanks again.

Collectives™ on Stack Overflow

Build Mysql query with forearch loop php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related