System requirements

Installation

  1. Load up the script files to your server
  2. Depending on your server configuration you may need to change the write permissions of the following files/directories:
    • cms/data - directory of the SQLite database files, needs to be writable by the webserver
    • content.sqlite, entries.sqlite and userdata.sqlite - SQLite database files, need to be writable by the webserver
    • cms/cache - cache directory, needs to be writable if you want to use the caching feature
    • cms/media and cms/files - need to be writable if you want to use the file uploader
  3. Ready! You should now be able to access the index page by browsing to the address you uploaded phpSQLiteCMS (e.g. http://example.org/path/to/phpsqlitecms/). To administrate the page, go to http://example.org/path/to/phpsqlitecms/cms/. The default admin userdata is: username: admin, password: admin.

Basic usage

Log in, click on "Create new page" or "Edit", fill out and submit the form. Additional options like the used template are set under "Properties".

Create a new page and select "News page" or "Overview Page" as page type in the properties. To insert a page into the news or overview page, edit or create a new page, switch to "Include" and select the page on which it should be included ("Include in:"). Then specify the teaser headline and the teser - this will be shown on the news or overview page. With "Order nr." you can order the teasers in overview pages. The order in news pages is chronological.

News demo

On simple news pages you can just add news without creating new pages for each item.

Simple news demo

Like into overview pages you can include pages into RSS Feeds and XML Sitemaps. Create a new page with page type RSS Feed or XML Sitemap, then include the pages you like into it (Include » Include in: RSS Feed / XML Sitemap). The title of the RSS Feed will be the page title, the description the description in "Properties".

RSS demo

First you need to create a photo gallery (Administration → Photo galleries → Create new gallery. There you can add photos and set titles and descriptions. After you created a photo gallery you can insert it into a photo page (page type "Photo page" with the gallery name as page type parameter) or insert the gallery with the gallery tag [gallery:NAME_OF_THE_GALLERY]

Photo gallery demo

phpSQLiteCMS uses PHP templates to display the pages (preferable with alternative syntax). The templates are stored in the subdirectory templates. You can specify the template in the page properties when editing or creating a page. The default template is default.tpl.
You can define global content blocks (Administration → Global content blocks) and include them on several pages or in a template. The following template code includes the global content block #1 specified in the page properties:
<?php if($gcb_1 && isset($gcb[$gcb_1])) echo $gcb[$gcb_1]; ?>
This displays the global content block with ID 1 on all pages using the template:
<?php echo $gcb[1]; ?>
Since SQLite is file based data synchronisation is easy: if you edit pages on your local server you can synchronise the data by uploading the file /cms/data/content.sqlite. But don't upload /cms/data/entries.sqlite as this will delete all comments! You can download both files for backup purpose.
You can specify not accepted words, IPs and user agents and you can use Akismet for spam protection (Administration → Spam protection).