Home  >  Article  >  Backend Development  >  Step-by-step tutorial: How to extend SQLite with php for database management

Step-by-step tutorial: How to extend SQLite with php for database management

WBOY
WBOYOriginal
2023-07-29 10:29:101501browse

Step-by-step tutorial: How to use PHP to extend SQLite for database management

Introduction:
SQLite is an open source database engine that supports most SQL standards and provides a lightweight , Server-less database solutions. In PHP, we can use SQLite through extensions to achieve database management. This tutorial will walk you through how to use PHP to extend SQLite for database management.

Step 1: Install the SQLite extension
First, we need to make sure that the SQLite extension is installed in PHP. You can make sure the extension is enabled by uncommenting the following code in the php.ini file:

extension=sqlite3

Save the file and restart the web server for the changes to take effect.

Step 2: Create database
Using SQLite, we can connect and operate the database by using the SQLitePDO class. First, we need to create a database file. You can use the following code to create a database file named "mydatabase.db":

<?php
$db = new PDO("sqlite:mydatabase.db");
?>

This will create a database file named "mydatabase.db" in the current directory Database file. If the file already exists, the existing file is opened.

Step 3: Create table and insert data
Next, let us create a table named "users" and insert some sample data. You can use the following code to create a table and insert data:

<?php
// 创建users表格
$sql = "CREATE TABLE users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT,
    email TEXT
    )";
$db->exec($sql);

// 插入数据
$sql = "INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')";
$db->exec($sql);
$sql = "INSERT INTO users (name, email) VALUES ('Jane Smith', 'jane@example.com')";
$db->exec($sql);
$sql = "INSERT INTO users (name, email) VALUES ('Bob Johnson', 'bob@example.com')";
$db->exec($sql);
?>

Step Four: Query the Data
Now, we can execute a query to retrieve the data stored in the database. The following code will retrieve all user data from the "users" table and output it:

<?php
// 查询数据
$sql = "SELECT * FROM users";
$result = $db->query($sql);

// 输出数据
while ($row = $result->fetch()) {
    echo "ID: " . $row['id'] . "<br>" .
         "Name: " . $row['name'] . "<br>" .
         "Email: " . $row['email'] . "<br><br>";
}
?>

Step 5: Update data
If you need to update data, you can use the following code to update the data of a specific row:

<?php
// 更新数据
$id = 1;
$newName = "Updated Name";
$newEmail = "updated@example.com";

$sql = "UPDATE users SET name='$newName', email='$newEmail' WHERE id=$id";
$db->exec($sql);
?>

Step 6: Delete data
If you need to delete data, you can use the following code to delete the data of a specific row:

<?php
// 删除数据
$id = 2;

$sql = "DELETE FROM users WHERE id=$id";
$db->exec($sql);
?>

Summary:
Through this tutorial, we learned how to pass PHP extends SQLite for database management. We learned how to create a database, create tables, insert data, query data, update data and delete data. SQLite is a powerful yet simple database solution suitable for small projects and rapid development. Hope this tutorial is helpful!

The above is the detailed content of Step-by-step tutorial: How to extend SQLite with php for database management. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn