📄 sqlite.installation.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <title>Installation</title> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head> <body><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="sqlite.setup.html">Installing/Configuring</a></div> <div class="next" style="text-align: right; float: right;"><a href="sqlite.configuration.html">Runtime Configuration</a></div> <div class="up"><a href="sqlite.setup.html">Installing/Configuring</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div><hr /><div id="sqlite.installation" class="section"> <h2 class="title">Installation</h2> <p class="para"> Read the INSTALL file, which comes with the package. Or just use the PEAR installer with <strong class="command">pecl install sqlite</strong>. SQLite itself is already included, You do not need to install any additional software. </p> <p class="para"> Windows users will enable <var class="filename">php_sqlite.dll</var> inside of <var class="filename">php.ini</var> in order to use these functions. The <acronym title="Dynamic Link Library">DLL</acronym> for this <acronym title="PHP Extension and Application Repository">PECL</acronym> extensionmay be downloaded from either the <a href="http://www.php.net/downloads.php" class="link external">» PHP Downloads</a> page or from <a href="http://pecl4win.php.net/" class="link external">» http://pecl4win.php.net/</a> </p> <p class="para"> In PHP 5, the SQLite extension and the engine itself are bundled and compiled by default. However, since PHP 5.1.0 you need to manually activate the extension in <var class="filename">php.ini</var> (because it is now bundled as shared). Moreover, since PHP 5.1.0 SQLite depends on <a href="intro.pdo.html" class="link">PDO</a> it must be enabled too, by adding the following lines to <var class="filename">php.ini</var> (in order): <div class="informalexample"> <div class="example-contents"><div class="cdata"><pre>extension=php_pdo.dllextension=php_sqlite.dll</pre></div> </div> </div> On Linux or Unix operating systems, if you build PDO as a shared extension, you must build SQLite as a shared extension using the <strong class="command">--with-sqlite=shared</strong> configure option. </p> <p class="para"> SQLite 3 is supported through <a href="ref.pdo-sqlite.html" class="link">PDO SQLite</a>. </p> <blockquote><p><b class="note">Note</b>: <b>Windows installation for unprivileged accounts</b><br /> On Windows operating systems, unprivileged accounts don't have the <var class="varname">TMP</var> environment variable set by default. This will make sqlite create temporary files in the windows directory, which is not desirable. So, you should set the <var class="varname">TMP</var> environment variable for the web server or the user account the web server is running under. If Apache is your web server, you can accomplish this via a <strong class="command">SetEnv</strong> directive in your <var class="filename">httpd.conf</var> file. For example: <div class="informalexample"> <div class="example-contents"><div class="cdata"><pre>SetEnv TMP c:/temp</pre></div> </div> </div> If you are unable to establish this setting at the server level, you can implement the setting in your script: <div class="informalexample"> <div class="example-contents"><div class="phpcode"><code><span style="color: #000000">putenv('TMP=C:/temp');</span></code></div> </div> </div> The setting must refer to a directory that the web server has permission to create files in and subsequently write to and delete the files it created. Otherwise, you may receive the following error message: <span class="computeroutput"> malformed database schema - unable to open a temporary database file for storing temporary tables </span> <br /> </p></blockquote> </div><hr /><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="sqlite.setup.html">Installing/Configuring</a></div> <div class="next" style="text-align: right; float: right;"><a href="sqlite.configuration.html">Runtime Configuration</a></div> <div class="up"><a href="sqlite.setup.html">Installing/Configuring</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div></body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -