PHP tool for generating pdf/excel reports?

Question

PHP

You need a free tool for creating reports / tables with further download in pdf / excel formats, based on sql queries and / or a wysiwyg tool (the idea is like in Crystal Reports). You need something like DbFace, ClicData Personal, only free. And so that you can embed it on the site with php.
I would be grateful for any advice.

Answer 1

There is no such thing. Only phpexcel and handles. For pdf it is similar to mpdf.
Handles = you yourself in the code get data from the database, create a phpexcel object, fill in the data by coordinates in the loop, set the cell format, etc.

Answer 2

You write in PHP a generalized output of data from a query into an HTML table.
If xls is needed, you add an HTML header with encoding, give this file with a header that says that this is an xls file, any office can easily accept it.
If you need pdf, you feed the same mPDF table. Ten lines of code.
Here is ace.
The main difficulty is to produce correct table column headers.
But no third-party library will do this for you anyway - how does it know what kind of data you have?

Answer 3

Sounds like a task)))
Well, okay ...
You have a two-part question:
1. how to make a visual constructor for something - Google is bursting with ready-made pieces of code.
there’s even nothing to chew here, because you, like most beginners, brought one line plus a sea of ​​\u200b\u200bwater, no one will think for you.
write clearly and according to the runts, maybe someone will chew it, but for now there is nothing to chew.
2. to form a pdf file from a certain heap of information formed by the user
, there is also an excellent tFPDF lib, though by default it has troubles with Cyrillic, but there is also a (ready-made) solution.
if you can’t do it, then write, I’ll look for a ready-made code, I’ve already tested it on 3 projects