Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The easiest thing you could do, if your hosting allows it, is to set the PHP memory_limit higher by creating your custom php.ini and setting <code>memory_limit = 64M</code>. You can check if the setting is working via <code>phpinfo()</code>, just remember to delete the line/file you used to check phpinfo to avoid exposing the PHP settings to everyone.</p> <p>If this is not working, you can try fine-tuning some performance settings.</p> <p>For TCPDF these are listed under <a href="http://www.tcpdf.org/performances.php" rel="nofollow">TCPDF Performance Docs</a> and I suggest you apply all the settings and use the practices that may reduce memory consumption and don't affect your output. For example:</p> <blockquote> <ul> <li>If you are not using the Thai language, edit the config/tcpdf_config.php file and set the K_THAI_TOPCHARS constant to false;</li> <li>If you do not need extended chars, edit the config/tcpdf_config.php file and set the default fonts to core fonts;</li> <li>By default TCPDF enables font subsetting to reduce the size of embedded Unicode TTF fonts, this process, that is very slow and requires a lot of memory, can be turned off using setFontSubsetting(false) method;</li> <li>Use core fonts instead of embedded fonts whenever possible;</li> <li>Avoid using the HTML syntax (writeHTML and writeHTMLCell methods) if not strictly required;</li> <li>Split large HTML blocks in smaller pieces;</li> <li>Avoid using transactions if not strictly required;</li> </ul> </blockquote> <p>You could also export page by page and then merge the generated PDF files locally.</p> <p>Your last option is to either kindly ask your hosting provider to increase PHP memory_limit (at least temporary), or to upgrade to a better hosting plan.</p>
    singulars
    1. This table or related slice is empty.
    1. POhow to php export to pdf one big query?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USAndrei
    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. This table or related slice is empty.
    1. COI tested with hosting php.ini (memory_limit = 64M) but will not let me. currently export to excel, word or html shows no faults with large query, but the problem is only with PDF
      singulars
      1. PO
      1. UScriss_ae
    2. COI´ve solved with this simple solution http://phptopdf.com
      singulars
      1. PO
      1. UScriss_ae
 

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