In the same way as the tmpfile() PHP opens a temporary file that is deleted as soon as the script ends, MySQL allows you to create temporary tables. These temporary tables work in the same way as normal tables - you can give them names, add data, read data back, sort information, and such, but are deleted as soon as your database connection is closed.
Temporary tables are covered in full depth later in this chapter.
Want to learn PHP 7?
Hacking with PHP has been fully updated for PHP 7, and is now available as a downloadable PDF. Get over 1200 pages of hands-on PHP learning today!
If this was helpful, please take a moment to tell others about Hacking with PHP by tweeting about it!