Create pdf from an html php etc file and dynamic data

Hi there, just an idea that came to my mind because someone asked me if possible. The ability to create a pdf directly from the database and not through page preview. I mean to create an .html , .php etc file add dynamic data and then export this as a pdf ready for download. Something like the email, where we use a template, add our dynamic data and we send this to receipients.

Thank you