SQLite tutorial in PHP

SQLite is a SQL database manager that can be used locally or on a website and in particular is PHP compatible.
Any software can use it to store data, not in text files, and therefore make requests to access the data.
In contrast, SQLite does not allow multiple concurrent users to write to the database and is therefore not suitable for an important website .

SQLite queries are the same as in MySQL, only the PHP functions used to execute them differ.

SQLite can be used by browsers for HTML 5 to store database content locally and use it offline.

Resume Summary

1. Install SQLite and create a database.
   Installing SQLite. Create a database and verify the installation.
2. Create and use SQLite table.
   New Table. Delete Table. Add Record. Read the entry.
3. Find and change ticket.
   Fill the table. Dump the table. Record access. Find Ticket ID. Change the content of the message.

Loading

Full SQLite 2 source code in ZIP archive and SQLite 3 source code.

Note that this tutorial is available in English on .com, so the commands and script messages are in English. Only the content is translated into French.

Resources

• SQ Lite official website.
• phpLiteAdmin. SQLite visual interface running on the server.
• Other tools in SQLite documentation.