Table within a table with 3 columns repeating in each row

Question

0.00/5 (No votes)

See more:

Hello,

I want a Table within a Table with 3 columns in each row, to print 3 copies of each row from database table.
Example

I tried this code but it gives me error.Allowed memory size of 536870912 bytes exhausted

Thanks in advance.

What I have tried:

HTML

<table class="table table-sm">
        <table>
          <?php foreach($results as $row){ ?>
          <tr>
              <td>
                  <tr><th colspan="2"><?php echo $row->institutionname; ?></th></tr>
                    <tr><td colspan="2"><?php echo $row->sessionname.' '.$row->classname; ?></td></tr>
                    <tr><td><?php echo $row->admissionno.' '. $row->studentname; ?></td></tr>
                    <tr><td>Fee Type</td><td><?php echo $row->feetype; ?></td></tr>
                    <tr><td>Fee Month</td><td><?php echo $row->formonth; ?></td></tr>
                    <?php 
                    $tb = floatval($row->balance) - floatval($row->payableamount);
                    ?>
                    <tr><td>Remaining Dues</td><td><?php echo $tb; ?></td></tr>
                    <tr><td>Current Payable</td><td><?php echo $row->payableamount; ?></td></tr>
                    <tr><td>Total Payable</td><td><?php echo $row->balance; ?></td></tr>
                    <tr><td>Paid</td><td><?php echo ($row->paid==1)?'Yes':'No'; ?></td></tr>
              </td>
              <td>
                  <tr><th colspan="2"><?php echo $row->institutionname; ?></th></tr>
                    <tr><td colspan="2"><?php echo $row->sessionname.' '.$row->classname; ?></td></tr>
                    <tr><td><?php echo $row->admissionno.' '. $row->studentname; ?></td></tr>
                    <tr><td>Fee Type</td><td><?php echo $row->feetype; ?></td></tr>
                    <tr><td>Fee Month</td><td><?php echo $row->formonth; ?></td></tr>
                    <?php 
                    $tb = floatval($row->balance) - floatval($row->payableamount);
                    ?>
                    <tr><td>Remaining Dues</td><td><?php echo $tb; ?></td></tr>
                    <tr><td>Current Payable</td><td><?php echo $row->payableamount; ?></td></tr>
                    <tr><td>Total Payable</td><td><?php echo $row->balance; ?></td></tr>
                    <tr><td>Paid</td><td><?php echo ($row->paid==1)?'Yes':'No'; ?></td></tr>
              </td>
              <td>
                  <tr><th colspan="2"><?php echo $row->institutionname; ?></th></tr>
                    <tr><td colspan="2"><?php echo $row->sessionname.' '.$row->classname; ?></td></tr>
                    <tr><td><?php echo $row->admissionno.' '. $row->studentname; ?></td></tr>
                    <tr><td>Fee Type</td><td><?php echo $row->feetype; ?></td></tr>
                    <tr><td>Fee Month</td><td><?php echo $row->formonth; ?></td></tr>
                    <?php 
                    $tb = floatval($row->balance) - floatval($row->payableamount);
                    ?>
                    <tr><td>Remaining Dues</td><td><?php echo $tb; ?></td></tr>
                    <tr><td>Current Payable</td><td><?php echo $row->payableamount; ?></td></tr>
                    <tr><td>Total Payable</td><td><?php echo $row->balance; ?></td></tr>
                    <tr><td>Paid</td><td><?php echo ($row->paid==1)?'Yes':'No'; ?></td></tr>
              </td>
           </tr> 
            <?php } ?>
        </table>
    </table>

Posted 19-Jan-21 4:25am

nyt1972

Updated 19-Jan-21 5:31am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Accepted Answer · 2021-01-19T05:31:00

Solution 1

Understand the reason for this error & fix it. Check these
Fixing PHP Fatal Error: Allowed Memory Size Exhausted[^]
Fixing PHP Fatal error: Allowed memory size of (X) bytes exhausted.[^]

You must optimize your code, SQL query, web page & etc., which's the proper way.

EDIT

I found one issue in your HTML.

You put tr tag inside td tag. It's not a valid child element. It won't work. You need to use Nested Table. Check below page for example.
How to an Html Table inside another Table[^]

Posted 19-Jan-21 5:31am

thatraja

Updated 19-Jan-21 5:56am

v2

Comments

nyt1972 19-Jan-21 11:38am

thanks for the reply but I think I am getting this error bcoz of wrong use of table rows and columns, but I dont have idea that how to fix.

thatraja 19-Jan-21 11:52am

First try to generate output with minimal nodes(Say 3-4 nodes). Ensure it generates output. Then add other nodes one by one. That way you can spot the issue.
Don't use SELECT *; Use SELECT Column Names in SQL query.

thatraja 19-Jan-21 11:57am

Check my updated answer. That's the problem. I missed it first

nyt1972 19-Jan-21 12:09pm

thanks

nyt1972 19-Jan-21 12:05pm

tried that but still getting the error.

thatraja 19-Jan-21 12:08pm

As I said in my updated answer, your HTML is wrong. Modify it.

inside won't work. You need to put inside those Just try with minimum nodes first. Then integrate everything after you get output