DOMPDF Calculation

Question

PHP Page I have not understand what I have to do on this to show the net value.

It doesn't show me any value. What should I do please help me.PDF File

Here is the table code. I can't see the shipping charge net value in table footer.

  <table width="100%">
                  <tr>
                    <td colspan="8" class="estilo4"><CENTER><strong> <h1>Payment</h1></strong></CENTER></td>
                  </tr>
                  <tr bgcolor="black" border="1" solid  #5D6975 cellspacing="0" cellpadding="0">
                    <th class="estilo1">'.$TRACK.'</th>
                    <th class="estilo1">'.$zones.'</th>
                    <th class="estilo1">'.$FECHA.'</th>
                    <th class="estilo1">'.$Mer.'</th>
                    <th class="estilo1">'.$DESTINA.'</th>
                    <th class="estilo1">'.$NUMBERPHONE.'</th>
                    <th class="estilo1">'.$ESTADO.'</th>
                    <th class="estilo1">'.$deliveryboy.'</th>
                  </tr>
                  </thead>
                <tbody>
                ';

                $sql=mysql_query("SELECT * FROM courier_online WHERE payment = 'OK' AND email='$qname' AND date   BETWEEN '$desde' AND '$hasta'");
                while($express=mysql_fetch_array($sql)){
                $initial = 0; // Empezar a contar desde 0
                $initial = $initial + $row['shipping_subtotal'];
                $codigoHTML.='  
                    <tr>
                        <td class="estilo3">'.$express['cons_no'].'</td>
                        <td class="estilo3">'.$express['shipping_subtotal'].'</td>
                        <td class="estilo3">'.$express['date'].'</td>
                        <td class="estilo3">'.$express['user'].'</td>
                        <td class="estilo3">'.$express['rev_name'].'</td>
                        <td class="estilo3">'.$express['r_phone'].'</td>
                        <td class="estilo3">'.$express['status'].'</td> 
                        <td class="estilo3"></td>                           
                    </tr>   
                </tbody>
<tfoot>
                                                    <tr>
                                                        <td colspan="2" style="text-align: right;" rowspan="1">
                                                            <b><?php echo $initial; ?></b>
                                                        </td>
                                                    </tr>
                                                </tfoot>                
                    ';

                }
        $codigoHTML.='

              </table>

Please edit your question to include your code. And not a picture of your code. — David Makogon, Sep 24 '17 at 20:00
@rtfm - it *is* random: the OP didn't embed any code, so nobody has context unless they click through to view a screencap of the code (which is not how questions should be set up, and why the question has been downvoted). And you've provided no context to the code you posted and why it's relevant. — David Makogon, Sep 24 '17 at 20:31
wow clicking a link is so hard. OP has highlighted the variable and asked what it would be, which is exactly what i provided. — , Sep 24 '17 at 20:35

BrianS · Answer 1 · 2017-09-25T16:46:42.813

0

I see two issues with your code:

1) You're echoing the value of $initial rather than concatenating it to the value of your $codigoHTML variable. Because of this it is not included in the HTML document (as contained in the variable).

2) Your generated HTML is not valid. You should move the closing TBODY tag and the entire TFOOT block outside the closing brace for the while loop.

edited Sep 25 '17 at 16:46

answered Sep 25 '17 at 14:53

BrianS

13,284
15
62
125

Would please change the code? I requested you. I don't understand. I need subtotal value. – Zenith Jhony Dec 07 '17 at 12:29

DOMPDF Calculation

1 Answers1