how to enable sqlite3 for php

Question

I am trying to install sqlite3 for PHP in Ubuntu   I install apt-get php5-sqlite3 and edited php ini to include sqlite3 extension   When I run phpinfo    I get  SQLITE3 SQLite3 support  enabled   sqlite3 library version  3 4 2     as shown above  sqlite3 is enabled  However  I get  Class SQLite3 not found  when I use   new SQLite3  database

User · Answer

sudo apt-get install php5-cli php5-dev make  sudo apt-get install libsqlite3-0 libsqlite3-dev  sudo apt-get install php5-sqlite3  sudo apt-get remove php5-sqlite3  cd    wget http   pecl php net get sqlite3-0 6 tgz  tar -zxf sqlite3-0 6 tgz  cd sqlite3-0 6   sudo phpize  sudo   configure   That worked for me

User · Answer

For PHP7  use   sudo apt-get install php7 0-sqlite3   and restart Apache  sudo apache2ctl restart

User · Answer

try this   sudo apt-get --purge remove php5  sudo apt-get install php5 php5-sqlite php5-mysql sudo apt-get install php-pear php-apc php5-curl sudo apt-get autoremove sudo apt-get install php5-sqlite sudo apt-get install libapache2-mod-fastcgi php5-fpm php5

User · Answer

The Debian Ubuntu way for php-7 2  php-7 3  amp  php-7 4  e g  the  234  part   sudo apt install php7  234 -sqlite sudo phpenmod sqlite3   Be sure to note that on Windows Subsystem for Linux version 1  WSL1  the  file- locking system for SQlite is broken

User · Answer

In Centos 6 7  in my case the library file  usr lib64 php modules sqlite3 so was missing   yum install php-pdo   vim  etc php d sqlite3 ini   Enable sqlite3 extension module extension sqlite3 so  sudo service httpd restart

User · Answer

This will drown here  but I fixed my problems with this   As far as I have found out  there is a faulty file in  usr local lib called libsqlite3 so 0 which points to libsqlite3 so 0 8 6  It s been installed through the php7 3-  packages as far as I can tell   I renamed the file in case it was needed for something  With the command   cd  usr local lib sudo mv libsqlite3 so 0   libsqlite3 so 0 back  But you can also just delete it  rm libsqlite3 so 0  The thread that lead me to the answer  link  This solved my problems  and I hope they solve yours as well

User · Answer

Edit  This answer is outdated  but can t be removed because it s accepted  Please see the solution from Stacey Richards for the correct answer    sudo apt-get install php5-cli php5-dev make  sudo apt-get install libsqlite3-0 libsqlite3-dev  sudo apt-get install php5-sqlite3  sudo apt-get remove php5-sqlite3  cd    wget http   pecl php net get sqlite3-0 6 tgz  tar -zxf sqlite3-0 6 tgz  cd sqlite3-0 6   sudo phpize  sudo   configure  sudo make  sudo make install  sudo apache2ctl restart   Ripped from the ubuntu form

User · Answer

For Debian distributions  Nothing worked for until I added the debian main repositories on the apt sources  I don t know how were they removed   sudo vi  etc apt sources list  and added  deb  http   deb debian org debian  stretch main deb-src  http   deb debian org debian  stretch main   after that sudo apt-get update  you can upgrade too  and finally sudo apt-get install php-sqlite3

User · Answer

For Ubuntu 18 04 and PHP 7 2   sudo apt install php-sqlite3

User · Answer

The SQLite3 PDO driver is named SQLite  not SQLite3  so you can do   new SQLite  database      For a SQLite2 database   new SQLite2  database

User · Answer

The accepted answer is not complete without the remainder of instructions  paraphrased below  from the forum thread linked to   cd  etc php5 conf d  cat  gt  sqlite3 ini   configuration for php SQLite3 module extension sqlite3 so  D  sudo  etc init d apache2 restart

User · Answer

Try   apt-get install php5-sqlite   That worked for me

User · Answer

Only use   sudo apt-get install php5-sqlite   and later  sudo service apache2 restart

User · Answer

one thing I want to add   before you try to  install   apt-get install php5-sqlite   or   apt-get install php5-sqlite3    search the given package is available or not  -      apt-cache search  php5    After that you get  -  php5-rrd - rrd module for PHP 5  php5-sasl - Cyrus SASL extension for PHP 5  php5-snmp - SNMP module for php5    php5-sqlite - SQLite module for php5    php5-svn - PHP Bindings for the Subversion Revision control system  php5-sybase - Sybase   MS SQL Server module for php5   Here you get an idea about whether your version support or not    in my system I get php5-sqlite - SQLite module for php5 so I prefer to install     apt-get install php5-sqlite

User · Answer

Depends on the version of PHP  For php7 0 the following commands work  sudo apt-get install php7 0-sqlite3 then restart the Apache server  sudo service apache2 restart

[php] how to enable sqlite3 for php?

Examples related to php

Examples related to sqlite