Automaticly convert php to pdf

I made a .PHP page that automatic generates a invoice from database, Now my question is is it possible to load automatic all the users out the database and create a invoice for them with the .PHP page I made.

I use know SELECT * FROM orders Where name=$name;

But I want to run the page again and again in maybe a while loop till all the users have a invoice and I want to save a copy of the php page for every users as .PDF

So my question is, How to generate a invoice for every user and save it as pdf?

Best,

Sven