how to Insert multi dimensional array in mysql? [duplicate]

Question

Possible Duplicate:
PHP - reformat multidimensional array to insert into MYSQL?

what I want to do is insert multi dimensional array in my database

here is my code,but it not working,

include 'config/config.php';
    $Currentdatetime = date("Y-m-d h:i:s" ,strtotime("now"));
    $senderID = '530738657,100003201126721,659276806,etc';
    $explode = implode(', ', array_shift($senderID));
    $result = array();
    foreach ($senderID as $row) {
        $result[] = "(" . implode(', ', $row) . ")";
    }
    $query = "INSERT INTO user_invite ($explode) VALUES('$userid','implode (', ', $result)','0','50','$Currentdatetime','0')");

any solution? thanks

Your $expolade should have database table coloumn names.

Dinuka Thilanga
– Dinuka Thilanga

2011-11-25 03:58:36 +00:00
Commented Nov 25, 2011 at 3:58 — Dinuka Thilanga
– Dinuka Thilanga, Commented Nov 25, 2011 at 3:58
array_shift on a string? Bold move! ;)

deceze
– deceze ♦

2011-11-25 04:11:10 +00:00
Commented Nov 25, 2011 at 4:11 — deceze
– deceze ♦, Commented Nov 25, 2011 at 4:11

ddjikic · Accepted Answer · 2011-11-25 05:33:52Z

1

array_shift on senderID is an error senderID is a string!!!!

foreach on senderID is an error !!!!!

replace this

 $senderID = '530738657,100003201126721,659276806,etc';

with

     $senderID = explode(',', $senderID   );
    $senderID = '530738657,100003201126721,659276806,etc';

answered Nov 25, 2011 at 5:33

ddjikic

1,28412 silver badges28 bronze badges

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

1 Comment

Oscar Over a year ago

thanks, I type wrong in my code and i solved it already,

Collectives™ on Stack Overflow

how to Insert multi dimensional array in mysql? [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related