Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Instead of displaying your table directly to the browser page, simply store the text in a variable and echo it...then you can send the var to the TCPDF library.</p> <pre><code>$dyn_table = '&lt;table border="1" cellpadding="3" cellspacing="1"&gt;&lt;tr&gt;&lt;td align="center"&gt;/td&gt;&lt;th align="center"&gt;First Name&lt;/th&gt;&lt;th align="center"&gt;Last Name&lt;/th&gt;&lt;th align="center"&gt;Caste&lt;/th&gt;&lt;th align="center"&gt;Residence address&lt;/th&gt;&lt;th align="center"&gt;Education&lt;/th&gt;&lt;/tr&gt;'; $i = 1; while ($row = mysql_fetch_array($res)) { $member_no = $row['member_no']; $total_member = "SELECT COUNT(*) AS total_member FROM family_member_details WHERE member_no =" . $member_no; $total_res = $n-&gt;querySend($total_member); $row_total = mysql_fetch_array($total_res); $dyn_table .= '&lt;tr&gt;&lt;td align="center" rowspan="' . $row_total['total_member'] + 1 . '"&gt;' . $i . '&lt;/td&gt;&lt;td align="center"&gt;' . $row['fname'] . '&lt;/td&gt;&lt;td align="center"&gt;' . $row['lname'] . '&lt;/td&gt;&lt;td align="center"&gt;' . $row['caste'] . '&lt;/td&gt;&lt;td align="center"&gt;' . $row['residence_addr'] . '&lt;/td&gt;&lt;td align="center"&gt;' . $row['education'] . '&lt;/td&gt;&lt;/tr&gt;'; $family_sql = "SELECT * from family_member_details WHERE member_no = $member_no"; $family_res = $n-&gt;querySend($family_sql); while ($row1 = mysql_fetch_array($family_res)) { $dyn_table .= '&lt;tr&gt;&lt;td align="center"&gt;' . $row1['name'] . '&lt;/td&gt;&lt;td align="center"&gt;' . $row1['name'] . '&lt;/td&gt;&lt;td align="center"&gt;' . $row1['name'] . '&lt;/td&gt;&lt;td align="center"&gt;' . $row1['name'] . '&lt;/td&gt;&lt;td align="center"&gt;' . $row1['name'] . '&lt;/td&gt;&lt;/tr&gt;'; } $i++; } $dyn_table .= '&lt;/table&gt;'; echo $dyn_table; </code></pre> <h3>EDIT</h3> <p>In order to post this html to your TCPDF library, I would use AJAX to prevent another page request/load. I prefer to use <a href="http://www.jquery.com" rel="nofollow noreferrer">JQuery</a> as it simplifies this process immensely. Here is one way you could do it:</p> <pre><code>&lt;input type="button" name="TCPDF" id="submitToTCPDF" /&gt; &lt;script type="text/javascript"&gt; var url = 'php/script/to/handle/post'; var data = {'table_html': '&lt;? echo $dyn_table; ?&gt;'}; $('#TCPDF').click(function(){ $.ajax({ type: "POST", url: url, data: data, success: function($result){ // Do whatever after html is submitted } }); }); &lt;/script&gt; </code></pre> <p>You can read more about <a href="http://api.jquery.com/jQuery.post/" rel="nofollow noreferrer">Jquery's AJAX post method</a> in <a href="https://stackoverflow.com/questions/5046930/jquery-send-string-as-post-parameters"><strong>this StackOverflow question</strong></a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to print table from php file to TCPDF in following scenario?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USPastor Bones
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COsuppose after echo $dyn_table; there is <input type="button" name="tcpdf"/> then how to send that var to tcpdf library onclick of a button?
      singulars
      1. PO
      1. USAnand Jaju
    2. COI updated my answer to help show how to go about performing an AJAX request as further shown in the link at the bottom of the answer.
      singulars
      1. PO
      1. USPastor Bones
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload