Configure Codeigniter 3.1 and SQLite3 in Windows

Introduction Here in this tutorial I will show you how to configure Codeigniter 3.1 and SQLite3 in Windows environment. You can choose any database from a number of supported databases in Codeigniter framework but here I am going to use SQLite, which is in-memory database and also fit for quick PoC projects. SQLite a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications. SQLite…

Continue

CRUD Example using SQL Scripts in PHP and SQLite3

Introduction Here we will see how to create CRUD example using SQL scripts in PHP and SQLite3. We can easily execute SQL statement in PHP to perform CRUD operations but when you have lots of SQL statements to create tables then you will find easier to execute SQL scripts rather than executing individual SQL statements one by one in PHP programming. You may also need to insert initial data for testing your application and in such case you would want to execute SQL script to insert data rather than executing…

Continue

Configure PHP 7 and SQlite3 in Windows

Introduction In this tutorial I am going to show you how to configure PHP 7 and SQLite3 in Windows environment. By default SQLite3 extension comes with PHP 5.3.0 or higher version of PHP. So you don’t need to download it. SQLite3 is not enabled by default in Windows environment. So you must enable it before you use it. Why do you need SQLite? SQLite, can also be used as an in-memory database, a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the…

Continue