将数组对象插入数据库

Question

This is my array which am saving to a var $multi...

{
"multicast_id":6026270875633827713,
"success":2,
"failure":1,
}

This is my current implementation that doesn't work...

$bony = "INSERT INTO log_notifications(sent_at,multicast_id,reg_id,message_id,success,failed) 
        VALUES(NOW(),
        '$multi[multicast_id]',
        '$each',
        '$multi[multicast_id]',
        '$multi[success]',
        '$multi[failure]'
        ";

I cant seem to insert the values in the db...

Answer 1

Try this ;)

$bony = "INSERT INTO log_notifications(sent_at,multicast_id,reg_id,message_id,success,failed) 
    VALUES(NOW(),
    '$multi[multicast_id]',
    '$each',
    '$multi[multicast_id]',
    '$multi[success]',
    '$multi[failure]')";

You forgot to close ) for VALUES(;