处理数组后值并转储到数据库

Question

I have an dynamic POST array like this.

    Array
    (
        [56-1] => 9
        [56-2] => 7
        [56-3] => 2
        [56-4] => 3
        [66-1] => 1
        [66-2] => 5
        ..................... so on...........
    }

Now what i want to do is - Store the below array values in the table like this

        Book ID     Author ID       Rating
        56          1               9
        56          2               7
        56          3               2   
        56          4               3
        66          1               1
        66          2               5

Thanks, Kimz

Answer 1

Please review this code

<?php

foreach($yourarray as $key=>$value){
    $skeys=explode('-',$key);
    $bookid=$skeys[0];
    $authorid=$keys[1];
    $ratings=$value;

    $insert="insert into table_name (`Book_ID`,`Author_ID`,`Rating`) values ('$bookid','$authorid','$ratings')";
    mysql_query($insert);
}

?>