Abstract
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).
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Jesse Feiler
About this chapter
Cite this chapter
Feiler, J. (2015). Using SQLite with PHP. In: Introducing SQLite for Mobile Developers. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1766-5_6
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1766-5_6
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1765-8
Online ISBN: 978-1-4842-1766-5
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)