unexpected foreach in codeigniter

Question

hello here is my code which i have written in the codeigniter controller,when i run this code am getting Parse error: syntax error, unexpected 'foreach' (T_FOREACH) ,kindly help me on this

function send_payment_notification()
{
    if($_POST)
    {

     $vendor_id=$_POST['vendor_id'];
     $vendor_name=$_POST['vendor_name'];
     $from_date=$_POST['from_date'];
     $to_date=$_POST['to_date'];

     for($i=0;$i<count($vendor_id);$i++)
     {
        $v_id= $vendor_id[$i];
        $v_name= $vendor_name[$i];
        $f_date=$from_date[$i];
        $t_date=$to_date[$i];

        $query="select * from `order` where (DATE(order.service_date) between '".$f_date."' and '".$t_date."') AND status_code='OCMP' and order.vendor_id=$v_id";
        $data['order_ids']=$this->finance_model->run_manual_query_return_result2($query);


        $query="SELECT v.vendor_email,c.cat_name,c.commission_type,c.commission,sum(c.commission) commissionrupees, SUM( CASE WHEN final_amount_paid !=0 THEN final_amount_paid ELSE total_cost END ) AS total,order.vendor_id,v.vendor_name,sum(distinct v.wallet_balance) as wallet FROM `order` join vendor v on v.vendor_id=order.vendor_id join category c on c.cat_id=v.cat_id where (DATE(order.service_date) between '".$f_date."' and '".$t_date."') AND status_code='OCMP' and order.vendor_id=$v_id";
    $payment_notification=$this->finance_model->run_manual_query_return_row($query);


         $template="

        Hi Service Providers,

        Please find payment details for the week ".$f_date." to ".$t_date." .

        <table>
            <tr> <th>Category </th><th>order ids </th><th>Total Amount </th> <th>Commission charged </th><th>online payment </th><th>Bro4u offers </th><th>Total payable </th> </tr>

    <tr> 
    <td>".$payment_notification->cat_name."</td> 

    <td>"foreach($data['order_ids'] as $o_id)
     { 
     $o_id->order_id

     }"</td> 

    <td>".$payment_notification->total."</td> 

    <td>".$payment_notification->commissionrupees."</td> 

    <td>online</td> 

    <td>offers</td> 

    <td>payable</td>
      </tr>     


        </table>

        <br/>   
        Happy to serve,<br/>
        Team Bro4u<br/>
        ";










        //$this->bro4u->email_alert($payment_notification->vendor_email, "credit of amount", $template);


    echo $template;


     }  

    }




}

missing ; b/w foreach and quotes `"; foreach` – Thamilhan Nov 05 '15 at 05:44 — Thamilhan, Nov 05 '15 at 05:44
no its not working,where i have to write> – khan Nov 05 '15 at 05:46 — khan, Nov 05 '15 at 05:46
Don't forget to mark the answer – Thamilhan Nov 05 '15 at 06:37 — Thamilhan, Nov 05 '15 at 06:37

score 0 · Answer 1 · answered Nov 05 '15 at 05:45

0

Need to close statement:

Change:

<td>"foreach($data['order_ids'] as $o_id)

To:

<td>";foreach($data['order_ids'] as $o_id)

answered Nov 05 '15 at 05:45

Pupil

23,834
6
44
66

score 0 · Answer 2 · answered Nov 05 '15 at 05:52

0

what about this

<td>"; # close ;
    foreach($data['order_ids'] as $o_id)
    { 
        $o_id->order_id ; # use echo or some of your argument as well
    }
"</td> # start "

answered Nov 05 '15 at 05:52

Abdulla Nilam

36,589
17
64
85

Please add some explanation to your answer! – ρss Nov 05 '15 at 15:25

score 0 · Answer 3 · answered Nov 05 '15 at 05:59

You cannot use for each inside a variable. Use like this instead:

$template=" Hi Service Providers, Please find payment details for the week to
<table>
    <tr>
        <th>Category</th>
        <th>order ids</th>
        <th>Total Amount</th>
        <th>Commission charged</th>
        <th>online payment</th>
        <th>Bro4u offers</th>
        <th>Total payable</th>
    </tr>
    <tr>
        <td>a</td>"; 

foreach($d as $o) { 
  $template.= "<td>".$o."</td>"; 
} 

$template.="<td>adsfsaf</td>
            <td>asdfdsf</td>
            <td>online</td>
            <td>offers</td>
            <td>payable</td>
        </tr>
    </table>
    <br/>Happy to serve,
    <br/>Team Bro4u
    <br/>";

Arvind Jaiswal · Answer 4 · 2015-11-05T07:33:39.407

0

You can't use foreach loop inside variable. You can use this type-

 foreach($data['order_ids'] as $o_id)
 { 
    $template.= "<td>".$o_id->order_id."</td>";

 }

edited Nov 05 '15 at 07:33

answered Nov 05 '15 at 06:51

Arvind Jaiswal

442
5
14

unexpected foreach in codeigniter

4 Answers4