Membuat database sqlite di php

To enable CURL and SQLITE3 on Windows with PHP 7.4 edit httpd.conf and php.ini as below:

httpd.conf:

# load php.ini from chosen directory
PHPIniDir "${SRVROOT}/php"
# load PHP 7.4 on Windows
LoadModule php7_module "${SRVROOT}/php/php7apache2_4.dll"
# load CURL on Windows
LoadFile "${SRVROOT}/php/libssh2.dll"
# load SQLITE3 on Windows
LoadFile "${SRVROOT}/php/libsqlite3.dll"

php.ini:

extension=curl
extension=pdo_sqlite
extension=sqlite3

Now CURL and SQLITE3 are enabled and working fine on Windows on PHP 7.4.

$encryption_key and all encryption features will be enabled only if the SQLite encryption module is installed. It's a proprietary, costly module. So if it's not present, supplying an encryption key will have absolutely no effect.

If you plan to have concurrent access to a SQLITE3 database, it is advised to change the default SQLite3::busyTimeout value (set to zero by default). Otherwise, you may get a "database locked" error while writing to the database.

With the timeout set to a non zero value, a write attempt to a locked database will wait for the lock to be released (within the timeout) before sending an error.

Note that the default value was set to 60 seconds on SQLITE2.

Ringkasan. dalam tutorial ini, kami akan menunjukkan cara membuat koneksi ke database SQLite dari PHP menggunakan PDO

PHP menyertakan ekstensi SQLite secara default sehingga Anda tidak perlu melakukan konfigurasi apa pun untuk membuatnya berfungsi dengan SQLite

Setup struktur proyek PHP dengan Composer

Pertama, buat folder proyek bernama  

composer update

composer update

composer update

Selanjutnya, buat file

composer update

{
    "autoload": {
        "psr-4": {
            "App\\": "app/"
        }
    }
}
Code language: JavaScript (javascript)

Jika Anda tidak terbiasa dengan Komposer, Anda dapat memeriksanya di sini. Di PHP, kami menggunakan komposer sebagai alat untuk manajemen ketergantungan. Komposer memungkinkan Anda mendeklarasikan perpustakaan di proyek kami dan mengelola pembaruan secara otomatis

Di file komposer, Anda memetakan ruang nama

composer update

composer update

Kemudian, buat nama subfolder lain

composer update

Setelah itu, buka alat perintah, arahkan ke

composer update

composer update

Pesan berikut akan ditampilkan

>composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Generating autoload files



Code language: Shell Session (shell)

Selain itu, Composer membuat folder baru bernama

composer update

Terakhir, buat file bernama

composer update

<?php
require 'vendor/autoload.php';
Code language: PHP (php)

Mulai sekarang, jika Anda ingin menggunakan classé apa pun di folder

composer update

Membuat koneksi database ke database SQLite

Pertama, buat file baru

>composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Generating autoload files
Code language: Shell Session (shell)

composer update

>composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Generating autoload files
Code language: Shell Session (shell)

<?php

namespace App;

class Config {
   /**
    * path to the sqlite file
    */
    const PATH_TO_SQLITE_FILE = 'db/phpsqlite.db';

}
Code language: PHP (php)

Konstanta

>composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Generating autoload files
Code language: Shell Session (shell)

composer update

Kedua, buat file

>composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Generating autoload files
Code language: Shell Session (shell)

>composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Generating autoload files
Code language: Shell Session (shell)

<?php
namespace App;

/**
 * SQLite connnection
 */
class SQLiteConnection {
    /**
     * PDO instance
     * @var type 
     */
    private $pdo;

    /**
     * return in instance of the PDO object that connects to the SQLite database
     * @return \PDO
     */
    public function connect() {
        if ($this->pdo == null) {
            $this->pdo = new \PDO("sqlite:" . Config::PATH_TO_SQLITE_FILE);
        }
        return $this->pdo;
    }
}
Code language: PHP (php)

Untuk membuat koneksi database ke database SQLite, Anda perlu membuat instance baru dari kelas

>composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Generating autoload files
Code language: Shell Session (shell)

>composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Generating autoload files
Code language: Shell Session (shell)

Misalkan file database SQLite ada di folder

composer update

sqlite:db/phpsqlite.db
Code language: PHP (php)

Karena Anda menyimpan jalur ke file database sqlite di kelas

>composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Generating autoload files
Code language: Shell Session (shell)

Perhatikan bahwa ketika PHP terhubung ke database SQLite yang tidak ada, PHP akan membuat file database SQLite baru

<?php
require 'vendor/autoload.php';
Code language: PHP (php)

>composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Generating autoload files



Code language: Shell Session (shell)

<?php
require 'vendor/autoload.php';
Code language: PHP (php)

Setelah semua kelas berada di tempatnya, Anda menggunakan perintah berikut untuk membuat file muat otomatis

composer dump-autoload -o

Untuk membuat koneksi ke database SQLite, Anda menggunakan kode berikut di file

composer update

<?php

require 'vendor/autoload.php';

use App\SQLiteConnection;

$pdo = (new SQLiteConnection())->connect();
if ($pdo != null)
    echo 'Connected to the SQLite database successfully!';
else
    echo 'Whoops, could not connect to the SQLite database!';
Code language: SQL (Structured Query Language) (sql)

Jika Anda memeriksa folder

composer update

<?php
require 'vendor/autoload.php';
Code language: PHP (php)

Saat Anda membuat instance baru dari PDO, PDOException akan selalu muncul jika koneksi gagal

Untuk menangani pengecualian, Anda dapat menggunakan blok ________13______8 sebagai berikut

try {
   $this->pdo = new \PDO("sqlite:" . Config::PATH_TO_SQLITE_FILE);
} catch (\PDOException $e) {
   // handle the exception here
}
Code language: PHP (php)

Dalam tutorial ini, Anda telah mempelajari cara menyiapkan struktur proyek PHP dan membuat koneksi database ke database SQLite

Bagaimana cara menggunakan database SQLite di PHP?

Bagaimana cara membuat basis data SQLite?

Bisakah PHP bekerja dengan SQLite?

Bagaimana cara membuka database SQLite di PHP?