PHP使用foreach获取数组值

Question

PHP how to get array value:

<?php

print_r($_POST['cb']);

Array
(
[0] => Array
    (
        [id] => 1
        [tipe] => read
    )

[1] => Array
    (
        [id] => 1
        [tipe] => update
    )

[2] => Array
    (
        [id] => 2
        [tipe] => update
    )

)
?>

So what I want to get maybe in foreach function like this:

foreach(...)
{
   $qInsert = oci_parse("INSERT INTO TDATA(ID, CHKSTATUS) VALUES('$getID', '$getTipe')");
   oci_execute($qInsert);
}

$getID means the [id], and $getTipe means the [tipe] in array.

Is it possible to do like that?

Answer 1

If your Array has 100s of indices, your query will execute 100 times to insert data. Avoid such operations as much as possible, See the answer below, you can insert data in a single query, the code is not tested, you can adjust to meet your requirements .

$dataArray = $_POST['cb']; 
$queryData = null;

foreach($dataArray as $data){

    $queryData[]="(".$data['id'].", '".$data['tipe']."')";

}

$values = implode(',',$queryData);
$qInsert = oci_parse("INSERT INTO TDATA(ID, CHKSTATUS) VALUES ".$values."");
oci_execute($qInsert);

I hope this might save your database operations overhead