Code Library: SQLite
store.db file queried in your PHP files; your sqlite connection is made at the beggininng of all pages:
$sDB = new SQLite3("store.db");
Making changes to your SQLite database
Data for your website is stored in two databases: the central vendo MySQL database, which contains customer and order records, which you do not have access to, and your local SQLite database, which contains your product data, which you have full access to. (You can also add tables and fields to your SQLite database). Keep in mind you should not alter existing table structure unless you really know what you are doing.
The above SELECT example shows you how to query your sqlite database to show fields for the
category table. Your database also contains the following tables. Note that table structure is subject to change.
- content (info pages)
- grouping (empty)
- grouping_option (empty)
- product_attribute_label (empty)
- product_attribute_value (empty)
- product_comments (empty)
- product_grouping (empty)
- product_img (empty)
- product_multi (empty)
- product_price_matrix (empty)
- product_price_variation (empty)
- product_price_variation_data (empty)
Running queries using the SQLite Admin function
If you want to update your database manually you can also execute queries using the SQLite Admin function.