how insert foreach function in html?

Question

I'm a newbie who's been looking for a solution regarding inserting a PHP foreach output in HTML,

there is my query code:

$qr = $this->db->query("select journalDetail.COA_CODE, COA_TITLE, COA_TYPE from t_journal_detail journalDetail left join r_coa coaTitle on journalDetail.coa_code=coaTitle.coa_code where journalDetail.JOURNAL_ID = '".$journalId."'");
$coaTitle = $qr->result_array();

    foreach ($coaTitle as $coa) {
        echo '<td width=55><span style=font-size:10pt; line-height:19px; text-align:left>'.$coaTitle[0]['COA_CODE'].'</span></td><br>';
    }

and there is my html code:

$detailJournal = '<!DOCTYPE html>
                        <html>
                            <table> 
                                <tr>            
                            <table border = 0 cellspacing = 0 cellpadding = 0 align = center>
                                <tr>
                                    <td width=55><span style=font-size:10pt; line-height:19px; text-align:left>'.$coaTitle[0]['COA_CODE'].'</span></td>
                                    <td width=170><span style=font-size:10pt; line-height:19px; text-align:center>'.$coaTitle[0]['COA_TITLE'].'</span></td>
                                    <td width=55><span style=font-size:10pt; line-height:19px; text-align:center>IDR</span></td>
                                    <td width=81><span style=font-size:10pt; line-height:19px; text-align:right>'.$journalDetail[0]['ORIG'].'</span></td>
                                    <td width=89><span style=font-size:10pt; line-height:19px; text-align:right>0</span></td>
                                    <td width=89><span style=font-size:10pt; line-height:19px; text-align:right>'.$journalDetail[0]['SUM'].'</span></td>
                                </tr><br><br>        
                            </table>
                        </html>';

    return $detailJournal;

}

the question is how insert foreach in html?

give the full html code. You already insert an output inside foreach loop. — Nur Zico
– Nur Zico, Commented Nov 12, 2018 at 7:00
The easiest way would be by not putting the HTML in a PHP variable but to end the PHP block (?>), write your html (with any PHP you need, like usual), and then start the PHP block again. Otherwise, you need to concatenate your variable. — M. Eriksson
– M. Eriksson, Commented Nov 12, 2018 at 7:00
i try insert php block ( ?> ) but it's not working, i try insert function in model it's not working too — Krisanda Triputro
– Krisanda Triputro, Commented Nov 12, 2018 at 7:08
What have you tried? What are you looking for - what is not working with the given code? — Nico Haase
– Nico Haase, Commented Nov 12, 2018 at 7:21

Nigel Ren · Accepted Answer · 2018-11-12 07:19:54Z

In your foreach, rather than echoing the value, build it up into a string (adding each part with .=) which you can then insert into your larger HTML...

$qr = $this->db->query("select journalDetail.COA_CODE, COA_TITLE, COA_TYPE from t_journal_detail journalDetail left join r_coa coaTitle on journalDetail.coa_code=coaTitle.coa_code where journalDetail.JOURNAL_ID = '".$journalId."'");
$coaTitle = $qr->result_array();
$htmlTable = "";
foreach ($coaTitle as $coa) {
    $htmlTable .= '<tr>';
    $htmlTable .= '<td width=55><span style=font-size:10pt; line-height:19px; text-align:left>'.$coa['COA_CODE'].'</span></td><br>';

    //  Continue adding fields using `$coa['FIELD NAME']` and $htmlTable .= ...

    $htmlTable .= '</tr>';
}

$detailJournal = '<!DOCTYPE html>
                        <html>
                            <table> 
                                <tr>            
                            <table border = 0 cellspacing = 0 cellpadding = 0 align = center>'
                              .$htmlTable.'<br><br>        
                            </table>
                        </html>';

    return $detailJournal;

}

You just need to use the line

$htmlTable .= '<td width=55><span style=font-size:10pt; line-height:19px; text-align:left>'.$coa['COA_CODE'].'</span></td><br>';

as a template to add in the other columns.

user10116577 · Accepted Answer · 2018-11-12 07:04:49Z

0

try this:

$qr = $this->db->query("select journalDetail.COA_CODE, COA_TITLE, COA_TYPE from t_journal_detail journalDetail left join r_coa coaTitle on journalDetail.coa_code=coaTitle.coa_code where journalDetail.JOURNAL_ID = '".$journalId."'");
$coaTitle = $qr->result_array();

    foreach ($coaTitle as $coa) {
        echo '<td width=55><span style=font-size:10pt; line-height:19px; text-align:left>'.$coa[0]['COA_CODE'].'</span></td><br>';
    }

in foreach($coaTitle as $coa) you must use $coa instead $coaTitle

answered Nov 12, 2018 at 7:04

user10116577

262 bronze badges

Comments

Poonam Navapara · Accepted Answer · 2018-11-12 07:31:16Z

0

if you want to add php code in html file then, you can add directly by adding php tag, and save file with .php extension

$detailJournal = '<!DOCTYPE html>
<html>
    <table> 
        <tr>            
            <table border = 0 cellspacing = 0 cellpadding = 0 align = center>
                <?php
                foreach ($coaTitle as $coa) {
                ?>
                    <tr>
                        <td width=55><span style=font-size:10pt; line-height:19px; text-align:left>'.$coa['COA_CODE'].'</span></td>
                        <td width=170><span style=font-size:10pt; line-height:19px; text-align:center>'.$coa[0]['COA_TITLE'].'</span></td>
                        <td width=55><span style=font-size:10pt; line-height:19px; text-align:center>IDR</span></td>
                        <td width=81><span style=font-size:10pt; line-height:19px; text-align:right>'.$journalDetail[0]['ORIG'].'</span></td>
                        <td width=89><span style=font-size:10pt; line-height:19px; text-align:right>0</span></td>
                        <td width=89><span style=font-size:10pt; line-height:19px; text-align:right>'.$journalDetail[0]['SUM'].'</span></td>
                    </tr>
                <?php
                }
                ?>  
            </table>
        </tr>
    </table>
</html>

edited Nov 12, 2018 at 7:31

answered Nov 12, 2018 at 7:06

Poonam Navapara

1861 silver badge9 bronze badges

1 Comment

Nico Haase Over a year ago

Please add some explanation to your code. Additionally, are you sure that it does anything good? Why is there an opening <?php within the output?

Collectives™ on Stack Overflow

how insert foreach function in html?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related