how can i create and pass value in multidimensional array in php?

Question

I need to save some data's in php. I am trying this code

$click_free = [];
$ano = 0;
while($res_qry = mysql_fetch_array($sel_qry)){
    $arr_cnt = sizeof($click_free);
    if($arr_cnt != 0){
        $m = 0;
        for($k=0;$k<$arr_cnt;$k++)
        {

            if($click_free[$k][0] == $res_qry['Free_id'])
            {
                $click_free[$k][0] = ($click_free[$k][0]+$res_qry['Qty']);
                $m=1;
            }
        }if($m==0){
            $click_free[$arr_cnt] = [1,];
        }
    }else{
        $click_free[0] = [$res_qry['Free_id'],$res_qry['Qty']];
    }
}

But this code has many error. Please help me solve this

@user7538258 could you please give an example of your input and output array(which you want) ? — iit2011081, Feb 10 '17 at 07:17
if there is only date come from database then you cannot fetch `Free_id` and `Qty` — B. Desai, Feb 10 '17 at 07:25
may you show the error or the issue you are encount? or the difference between the output and your expected? — LF00, Feb 10 '17 at 07:26
$sel_qry = mysql_query("SELECT * FROM tmp_free WHERE Bill_No='sm-001/16-17' ORDER BY Free_id,PF ASC,Qty DESC") or die(mysql_error()); this is my query AND i need a output like [free_id = 1, Qty = 2] — Madhan, Feb 10 '17 at 07:30
just after "while($res_qry = mysql_fetch_array($sel_qry)){", put echo "
"; print_r($res_qry); echo "
";die(); and give us the return if you want edit your question — Fahmi B., Feb 10 '17 at 07:33
Possible duplicate of [Creating an empty 2D array in PHP?](http://stackoverflow.com/questions/6613307/creating-an-empty-2d-array-in-php) — osanger, Feb 10 '17 at 08:02

Fahmi B. · Answer 1 · 2017-02-10T10:44:25.200

1

while($res_qry = mysql_fetch_array($sel_qry)){
     $id_existed = false;

    if(!empty($click_free))
        foreach($click_free as $key=>$ligne)
             if( $ligne[0] == $res_qry['Free_id']){
                  $qty = $ligne[1] + $res_qry['Qty'];
                  $click_free[$key] = [ $ligne[0] ,  $qty ];
                  $id_existed =true;
             }


    if(!$id_existed){
        $click_free[] = [ $res_qry['Free_id'] , $res_qry['Qty'] ];
    }
}

edited Feb 10 '17 at 10:44

answered Feb 10 '17 at 08:01

Fahmi B.

758
2
10
23

Parse error: parse error in F:\xampp\htdocs\clients\php\erp\pos\chainstore\garments\businesslayer\freeprduct.php on line 68 on line 68 we declare array this same error occurs previously – Madhan Feb 10 '17 at 09:49
@Madhan, you can give us the line 68 – Fahmi B. Feb 10 '17 at 09:55
$click_free = array(); – Madhan Feb 10 '17 at 10:08
@Madhan : try now – Fahmi B. Feb 10 '17 at 10:17
$click_free = []; sorry the error came for this only i just trying that – Madhan Feb 10 '17 at 10:20
if i use array() means it shows error on $click_free[$key] = [ $ligne[0] , $ligne[1] + $res_qry['Qty'] ]; – Madhan Feb 10 '17 at 10:21
let's replace the [] in the array by () - so try again – Fahmi B. Feb 10 '17 at 10:24
$emptyArray = array(array()); i am use this to declare 2D array but it shows same error ( $click_free[$key] = [ $ligne[0] , $ligne[1] + $res_qry['Qty'] ];) – Madhan Feb 10 '17 at 10:33
Parse error: parse error in F:\xampp\htdocs\clients\php\erp\pos\chainstore\garments\businesslayer\freeprduct.php on line 76 AND the line was $click_free[$key] = [ $ligne[0] , $ligne[1] + $res_qry['Qty'] ]; – Madhan Feb 10 '17 at 10:42
@Madhan: try this $qty =$ligne[1] + $res_qry['Qty']; $click_free[$key] = [ $ligne[0] , $qty ]; – Fahmi B. Feb 10 '17 at 10:43
"; print_r($mnk); echo ""; ?> – Madhan Feb 10 '17 at 11:53

score 0 · Accepted Answer · answered Feb 11 '17 at 06:09

Finally we got a solution

    while($res_qry = mysql_fetch_array($sel_qry)){
    $arr_cnt = sizeof($click_free);
    if($arr_cnt != 0){
        $m = 0;

        foreach ($click_free as $k => $v) {
          if ($v['Free_id']==$res_qry['Free_id']) {
            S_qty=$v['Qty']+$res_qry['Qty'];
            $click_free[$k]['Qty']=$S_qty;
            $m=1;
          }
        }

        if($m==0){
            $click_free[] = array("Free_id" => $res_qry['Free_id'],"Qty"=>$res_qry['Qty']);
        }
    }else{
            $click_free[] = array("Free_id" => $res_qry['Free_id'],"Qty"=>$res_qry['Qty']);
        }
}

Thanks to bfahmi, Kris Roofe, B. Desai , user3542450, dr_debug

how can i create and pass value in multidimensional array in php?

2 Answers2