Zend has a new tutorial posted in their PHP 101 series - PHP 101 (part 9): SQLite My Fire!

If you've been paying attention, you now know how to use PHP's MySQL API to perform queries and process result sets. You might even have started thinking about how to re-program your site to run off a MySQL database. All of this is a Good Thing - it means you're getting comfortable with using PHP's database support to power your applications - but there's still a little further to go.

Built-in SQLite support is new to PHP 5.0, and offers users a lightweight database system that is fast, efficient and gets the job done. Since it's enabled by default in PHP 5.0, it provides a viable alternative to MySQL; you can use it out of the box, without spending time on version checks and library downloads; just install PHP 5 and start typing. That's why I'm devoting a whole tutorial to it - so get out of bed, make yourself some coffee and let's get started!

He goes on to introduce what SQLite is and isn't, as well as some sample SQL. With the help of a simple class structure, they tell you about selecting the database, creating tables, and inserting/selecting information back out. If you're still new to the PHP world (or even just want to know about SQLite), be sure to check out this tutorial.