Database - SQLite

Introduction

SQLite is a popular free and open-source database management system. It uses a single file to store the entire database.
It is serverless and does not require a separate server process.
Besides MySQL / MariaDB, PHP can also be used to interact with SQLite databases.
Other than the connection string, the SQL commands are similar to MySQL / MariaDB.

<?php
	// Database file location
	$dbname = "sqlite.db";

	// Create connection
	$conn = new SQLite3($dbname);

	// Check connection
	if (!$conn) {
		die("Connection failed: " . $conn->lastErrorMsg());
	} else {
		echo "Connected successfully";
	}
?>
	

<?php
	// Database file location
	$dbname = "sqlite.db";
	
	// Create connection
	$conn = new SQLite3($dbname);
	
	// Check connection
	if (!$conn) {
		die("Connection failed: " . $conn->lastErrorMsg());
	} else {
		// if connected successfully
		$sql = "SELECT * FROM accounts";

		// execute and display all results
		$result = $conn->query($sql);
		while ($row = $result->fetchArray()) {
			print_r($row);
		}
	}	
?>