SQLite is a full featured file based database where security ( if required ) can be added to the file based on the environment.
There is no userid and password to connect to SQLite database. SQLite is not like our other database (Example : Oracle or MySQL ) which runs on a client – server concept.
No need to install or setup to use SQLite. The initial procedure of setup, configuration and run of database server is not required in case of SQLite.
The database with table created in Python can be copied and used in PHP environment. We will learn more about using SQLite database in PHP environment using PDO and SQLite3 library.
One of the several drivers available with PHP PDO is pdo_sqlite. These scripts are developed using pdo_sqlite support. Check your PHP installation for pdo_sqlite support here.
|support||Check SQLite support using phpinfo() |
|Connection||Connection to DB and creating table |
|Display||Display multiple rows using Parameter query |
|Display||Display single row using Parameter query |
|Update||Update and get number of records updated |
|insert||Add records to table and display the record ID |
|delete||delete records and get number of affected by query|
|drop||delete table if exists|
Download sample script for SQLite with instructions on how to use.
PDO FunctionsPHP Code generator for PDO & mysqli
|LIKE||String Pattern matching using wildcards |
|LIMIT||Strting position and number of records to return |
|DISTINCT||Unique data from the Column |
|MAX||Highest value of the column and record details |
|MIN||Lowest value of the column and record details |
This article is written by plus2net.com team.