When writing code that talks to database files and database servers, it can be frustrating when things are not working to not be able to see inside the database. Therefore, database clients exist to allow you to interact with database servers without having to use code.
A lightweight (single file!) solution when using PHP and SQLite is phpLiteAdmin, which is free to use (although you may consider donating if you use it a lot). It is included in the phpLiteAdmin folder with this recipe's PHP scripts. It can be run using the Composer script shortcut command—composer dbadmin—and will run locally at localhost:8001. Once running, just click on the link for the player table to see the data for each player's score in the database file:
Figure 8.5 – Using phpLiteAdmin in a web browser