PHP创建多维数组

理查德

我正在用LEFT JOIN查询数据库以获取以下数组:

Array
(
    [invoice_number] => 000010
    [invoice_date] => 1432764000
    [country] => 115
    [fao] => Rick
    [company_name] => Chubbs
    [address_line_1] => kjhk
    [address_line_2] => jh
    [town] => kjh
    [postcode] => kjh
    [filename] => INV-1432820860.pdf
    [id] => 11
    [description] => dfgh
    [rates] => 2
    [quantity] => 3
    [price] => 6
    [created] => 0
    [country_name] => Kazakhstan
)
Array
(
    [invoice_number] => 000010
    [invoice_date] => 1432764000
    [country] => 115
    [fao] => Rick
    [company_name] => Chubbs
    [address_line_1] => kjhk
    [address_line_2] => jh
    [town] => kjh
    [postcode] => kjh
    [filename] => INV-1432820860.pdf
    [id] => 18
    [description] => biscuits
    [rates] => 2
    [quantity] => 3
    [price] => 6
    [created] => 0
    [country_name] => Kazakhstan
)

我想循环浏览并删除重复项,因此如下所示:

Array
    (
        ['inv_details'] => array(
            [invoice_number] => 000010
            [invoice_date] => 1432764000
            [country] => 115
            [fao] => Rick
            [company_name] => Chubbs
            [address_line_1] => kjhk
            [address_line_2] => jh
            [town] => kjh
            [postcode] => kjh
            [filename] => INV-1432820860.pdf
        )
        ['items'] => array(
            [0] => array(
                [description] => dfgh
                [rates] => 2
                [quantity] => 3
                [price] => 6
                [created] => 0
            )
            [1] => array(
                [description] => biscuits
                [rates] => 2
                [quantity] => 3
                [price] => 6
                [created] => 0
            )

        )
    )

我现在有这段代码,但是items数组没有添加两个数组,最后一个项目覆盖了第一个数组,而我最终没有在项目中添加2个数组,只有一个:

$i = 0;

foreach($res->fetchAll(PDO::FETCH_ASSOC) as $row){

    $form = array();

    $form['title'] = $row['invoice_number'];
    $form['inv_details']['invoice_date'] = array('value'=>gmdate('d/m/Y', $row['invoice_date']), 'type'=>'date');
    $form['inv_details']['company_name'] = array('value' => $row['company_name'], 'type' => 'text');
    $form['inv_details']['fao'] = array('value' => $row['fao'], 'type' => 'text');
    $form['inv_details']['address_line_1'] = array('value' => $row['address_line_1'], 'type' => 'text');
    $form['inv_details']['address_line_2'] = array('value' => $row['address_line_2'], 'type' => 'text');
    $form['inv_details']['town'] = array('value' => $row['town'], 'type' => 'text');
    $form['inv_details']['postcode'] = array('value' => $row['postcode'], 'type' => 'text');
    //$form['inv_details']['countries'] = $this->crm_account_address->getCountries();
    $form['country'] = $row['country_name'];
    $form['country_id'] = $row['id'];

    $form['items'][$i]['description'] = $row['description'];
    $form['items'][$i]['rates'] = $row['rates'];
    $form['items'][$i]['quantity'] = $row['quantity'];
    $form['items'][$i]['price'] = $row['price'];

    //counter
    $i++;

}

任何帮助将是巨大的!谢谢

阿曼·拉瓦特(Aman Rawat)

在您的代码中,$form每次迭代发生时都会初始化数组因此,先前的数据将用空白数组重新写入。

因此,将数组初始化保留在循环中,以便它首先像这样初始化

$i = 0;

$form = array();    

foreach($res->fetchAll(PDO::FETCH_ASSOC) as $row){

    $form['title'] = $row['invoice_number'];
    $form['inv_details']['invoice_date'] = array('value'=>gmdate('d/m/Y', $row['invoice_date']), 'type'=>'date');
    $form['inv_details']['company_name'] = array('value' => $row['company_name'], 'type' => 'text');
    $form['inv_details']['fao'] = array('value' => $row['fao'], 'type' => 'text');
    $form['inv_details']['address_line_1'] = array('value' => $row['address_line_1'], 'type' => 'text');
    $form['inv_details']['address_line_2'] = array('value' => $row['address_line_2'], 'type' => 'text');
    $form['inv_details']['town'] = array('value' => $row['town'], 'type' => 'text');
    $form['inv_details']['postcode'] = array('value' => $row['postcode'], 'type' => 'text');
    //$form['inv_details']['countries'] = $this->crm_account_address->getCountries();
    $form['country'] = $row['country_name'];
    $form['country_id'] = $row['id'];

    $form['items'][$i]['description'] = $row['description'];
    $form['items'][$i]['rates'] = $row['rates'];
    $form['items'][$i]['quantity'] = $row['quantity'];
    $form['items'][$i]['price'] = $row['price'];

    //counter
    $i++;

}

这会工作

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章