News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

ZetCode.com:
SQLite PHP tutorial
October 17, 2011 @ 12:12:48

If you're in the process of prototyping a site or just need a lightweight storage tool for your application, you might look into SQLite. Fortunately, PHP has direct support for it and this great tutorial from ZetCode.com will introduce you to some of the basic concepts you'll need to get working (it's a bit older, but still very useful).

This is a PHP programming tutorial for the SQLite database. It covers the basics of SQLite programming with PHP language. There are two ways to code PHP scripts with SQLite library. We can use procedural functions or OOP objects and methods. In this tutorial, we use the classical procedural style. You might also want to check the PHP tutorial or SQLite tutorial on ZetCode.

They go through the basic installation (on a linux platform, but easily adapted to others) including changes to your php.ini and the creation and use of a first sample database. You'll find the interface very similar to some of its other RDBMS cousins with a few exceptions. They show you the CRUD basics - creating records, reading the contents of a table, updating data already there and deleting records. There's also a simple form tutorial that takes a name and gender and does the inserts.

0 comments voice your opinion now!
sqlite tutorial crud form example


blog comments powered by Disqus

Similar Posts

Pádraic Brady's Blog: Complex Views with the Zend Framework - Part 3: Composite View Pattern

Kevin van Zonneveld: It's Almost 2014 and We Are Still Committing Broken Code

Richard Thomas' Blog: Pjq becomes jQPie - jQuery PHP interface extension

Pádraic Brady's Blog:Doing that thing called PEAR - Packaging Source Code for PEAR Distribution

AnyExample.com: Downloading files from Amazon S3


Community Events





Don't see your event here?
Let us know!


interview series code community application framework api laravel bugfix wordpress project language configure threedevsandamaybe list developer introduction release library podcast

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework