What is the best PHP export mysql to csv or excel class?: Export MySQL tables using PHP to Excel Ideally

Recommend this page to a friend!
  All requests RSS feed  >  What is the best PHP export mysql to ...  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

What is the best PHP export mysql to csv or excel class?

Edit

Picture of luis fernando arango by luis fernando arango - 2 months ago (2020-12-18)

Export MySQL tables using PHP to Excel Ideally

This request is clear and relevant.
This request is not clear or is not relevant.

+2

I want to export a table of 300.000 records that is in CSV and compress it using ZIP or gzip in a way that is fast and efficient.

In Spanish:

Exportar tablas de mysql mediante php en excel optimamente

Quiero exportar una tabla de 300.000 registros en csv comprimida en zip o gzip de una manera rapida y eficaz gracias

  • 1 Clarification request

  • 1. Picture of Alexey Dodonov by Alexey Dodonov - 1 month ago (2021-01-22) Reply

    Hi! Try this one github.com/alexdodonov/php-2-excel

    Ask clarification

    1 Recommendation

    Niger: Query MySQL to generate data exports

    This recommendation solves the problem.
    This recommendation does not solve the problem.

    0

    Picture of Manuel Lemos by Manuel Lemos Reputation 20550 - 2 months ago (2020-12-22) Comment

    This package can do what you ask by generating CSV files from MySQL table queries. What you need to do when you use this package is to compress the output CSV files into ZIP or gzip files. There are other packages for that purpose. If you need a recommendation, try sending another package recommendation request.

    • 1 Comment

    • 1. Picture of luis fernando arango by luis fernando arango - 2 months ago (2020-12-23) Reply

      Gracias la clase niger es perfecta para crear el archivo csv.

      me explico un poco mejor como puedo comprimir este archivo.csv a zip o gzip con php sin que me limite los tiempos de carga del navegador y evitar el error 504 mientras comprimo el archivo para su descarga con header.

    Recommend package
    : 
    : 
    For more information send a message to info at phpclasses dot org.