PHP version: 5.5.38

Simple example of PHP/SQLite code

by Philip Kearns

Minimal code which creates a SQLite database, collects data and displays it. Follow this link to find the code and a detailed explanation.

3.1
176588 (176588): (176588)

Each time this script runs it deletes all but the 5 most recent entries, this is to stop this sample database growing indefinitely.

Here are the contents of the database (if any):
1. ) ORDER BY 1-- AUCC
2. ORDER BY 1-- Hfxo
3. ') ORDER BY 1-- WxIJ
4. ' ORDER BY 1-- jAIX
5. ORDER BY 1-- LobB