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

Source: Internet
Author: User

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/




Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.