O'Reilly logo

Introducing SQLite for Mobile Developers by Jesse Feiler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 6

image

Using SQLite with PHP

The basics of SQLite and, indeed, of SQL itself, are simple. It’s a repetitive routine of creating tables with a column for each data element in the table. You then add rows to each table with a value for each column. You can retrieve data from a single table with a basic SELECT statement. Join two tables by using a WHERE clause to match a value in one table with a corresponding value in another table (or in the same table in the case of a self-join).

The complexity of SQL and all of its implementations including SQLite comes from combinations of these basic building blocks. In addition, the fact that we are often ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required