douyiji3919
2017-03-04 11:39
浏览 51
已采纳

PHP使用foreach获取数组值

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?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongyi9023 2017-03-04 12:23
    已采纳

    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

    点赞 评论

相关推荐 更多相似问题