Php 5X uses the built-in sqlite3 link database, PDO link sqlite (low-cost development) (1), sqlite3pdo

Php 5X uses the built-in sqlite3 link database, PDO link sqlite (low-cost development) (1), sqlite3pdo

A program engineer occasionally encounters code deployment. There are no databases such as mysql on the server, or the database price must be calculated outside the space, you can consider using sqlite when your project is small or you cannot afford to buy a database space.

Sqlite is a small database, but SQL statements and functions are inferior to those of other databases.

Start:

The general development environment configuration is as follows:
1. Download SQLite3.dll
Open the download Channel link (http://www.sqlite.org/download.html)-> "Precompiled Binaries For Windows"-> download “sqlitedll-3_6_22.zip (249.72 KiB )". This is a dynamic link library file in sqlite windows.

2. Copy the decompressed sqlite3.dll file to the xampp \ php \ ext directory.

3. Open the php. ini file and find
Extension = php_pdo.dll
Extension = php_pdo_sqlite.dll
Remove the semicolon and add the following line:
Extension = sqlite3.dll
Where is the php. ini file? Write a phpinfo () by yourself and run it to find out where "Configuration File" is. There must be a php. ini file, which is called php. ini without something like-dist.

4. You can download SQLiteManagerForPHP for database management. It is a php-based web-based management tool, similar to phpmyadmin of mysql. Decompress the package directly to the htdocs folder of xamppx. If you do not like the web version, you can also use the SQLite visual management tool SQLite Expert (it seems that the domestic direct url can not open, want to open other moves) Official Website: http://www.sqliteexpert.com/