PHP Array comes out backwards

Question

This is my current output from a preg_match_all

Array
(
[0] => Array
    (
        [0] => 2 Sentence text here
    )

)

Array
(
[0] => Array
    (
        [0] => 3 Sentence text here.
        [1] => 4 Sentence text here.
        [2] => 5 Sentence text here.
    )

)

I'm trying to insert each output as a new row in a table but it's thinking that each [0] [1] [2] is a new column. How do I insert the array into mysql?

$query = "INSERT INTO table (col1) VALUES ";
foreach ($matches as $item) {
$query .= "('".$item[0]."'),";
}
$query = rtrim($query,",");
$result = mysql_query($query);

The above obviously only inserts the first row in of the array

can you show what your `$query` content looks like before you pass it to mysql_query? — Mike 'Pomax' Kamermans, Jun 20 '13 at 19:06
So many things wrong with this, I don't even know where to begin. — crush, Jun 20 '13 at 19:10
_Insert obligatory "please use [`mysqli`](http://php.net/manual/en/book.mysqli.php) instead of mysql" comment here_ — jterry, Jun 20 '13 at 19:14
I don't understand how the question relates to the title. :confused: — Herbert, Jun 20 '13 at 19:31

score 1 · Answer 1 · edited May 25 '19 at 14:22

1

Well, you have an array in other array, so...

$query = "INSERT INTO table (col1) VALUES ";

if(!empty($matches))
{
    foreach ($matches as $item) {
        foreach ($item[0] as $items) {
            $query .= "('".$items."'),";
        }
    }
}

if(!empty($matches))
{
    foreach ($matches[0] as $item) {
        $query .= "('".$item."'),";
    }
}

Depends on how you are getting your array matches.

$query = rtrim($query,",");
$result = mysql_query($query);

That way you'll get this query:

INSERT INTO table (col1) VALUES ('2 Sentence text here'), ('3 Sentence text here'), ('4 Sentence text here'), ('5 Sentence text here')

Which is a valid way to insert several values in one column with a single INSERT statement.

Note: Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO, or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

edited May 25 '19 at 14:22

Zoe

27,060
21
118
148

answered Jun 20 '13 at 19:20

Luigi Siri

2,068
2
19
27

Note that if his $matches array is empty, this will crash. – Dany Caissy Jun 20 '13 at 19:22
@ChadPriddle, What output this gives you: `mysql_query($query) or die(mysql_error())` and/or this: `echo $query;` – Luigi Siri Jun 20 '13 at 19:37
INSERT INTO table (col1) VALUES – Chad Priddle Jun 20 '13 at 19:46
@ChadPriddle, the arrays at the top of your question. Are they in an array? Or those arrays represents different matches? What you get with `print_r($matches)`? – Luigi Siri Jun 20 '13 at 19:49
@LuigiSiri the opt example is what print_r($matches) is outputting – Chad Priddle Jun 20 '13 at 20:01
Does it outputs both arrays or those arrays represents different matches? @ChadPriddle? – Luigi Siri Jun 20 '13 at 20:09

PHP Array comes out backwards

1 Answers1