Installation on Linux The common Unix distributions include binary versions of PHP that can be installed. Although these binary versions are typically built with support for the MySQL extensions, the extension libraries themselves may need to be installed using an additional package. Check the package manager that comes with your chosen distribution for availability. For example, on Ubuntu the php5-mysql package installs the ext/mysql, ext/mysqli, and pdo_mysql PHP extensions. On CentOS, the php-mysql package also installs these three PHP extensions. Alternatively, you can compile this extension yourself.
Building PHP from source allows you to specify the MySQL extensions you want to use, as well as your choice of client library for each extension. The MySQL Native Driver is the recommended client library option, as it results in improved performance and gives access to features not available when using the MySQL Client Library. Refer to for a brief overview of the advantages of MySQL Native Driver. The /path/to/mysql_config represents the location of the mysql_config program that comes with MySQL Server.
[resolved] MySQLi extension for PHP - missing! I went into the php.ini and removed the comment in front of 'extension=php_mysql.dll' and 'extension=php_mysqli.dll'. I just installed Apache 2.2.17, PHP 5.2.14, and MySQL 5.1.51 on Windows XP. Extension=php_mysql.dll and uncomment it to enable the extension.
Mysqli compile time support matrix PHP Version Default Configure Options: Configure Options: libmysqlclient Changelog 5.4.x and above mysqlnd --with-mysqli --with-mysqli=/path/to/mysql_config mysqlnd is the default 5.3.x libmysqlclient --with-mysqli=mysqlnd --with-mysqli=/path/to/mysql_config mysqlnd is supported 5.0.x, 5.1.x, 5.2.x libmysqlclient Not Available --with-mysqli=/path/to/mysql_config mysqlnd is not supported Note that it is possible to freely mix MySQL extensions and client libraries. For example, it is possible to enable the MySQL extension to use the MySQL Client Library (libmysqlclient), while configuring the mysqli extension to use the MySQL Native Driver.
However, all permutations of extension and client library are possible. PHP 5.0, 5.1, 5.2 On these old unsupported PHP versions (PHP 5.2 reached EOL on '6 Jan 2011'), additional configuration procedures are required to enable mysqli and specify the client library you want it to use. The mysqli extension is not enabled by default, so the php_mysqli.dll DLL must be enabled inside of php.ini. In order to do this you need to find the php.ini file (typically located in c: php), and make sure you remove the comment (semi-colon) from the start of the line extension=php_mysqli.dll, in the section marked [PHP_MYSQLI]. Also, if you want to use the MySQL Client Library with mysqli, you need to make sure PHP can access the client library file. The MySQL Client Library is included as a file named libmysql.dll in the Windows PHP distribution.
This file needs to be available in the Windows system's PATH environment variable, so that it can be successfully loaded. See the FAQ titled ' for information on how to do this.
Copying libmysql.dll to the Windows system directory (typically c: Windows system) also works, as the system directory is by default in the system's PATH. However, this practice is strongly discouraged.
As with enabling any PHP extension (such as php_mysqli.dll), the PHP directive should be set to the directory where the PHP extensions are located. See also the. An example extension_dir value for PHP 5 is c: php ext. Note: If when starting the web server an error similar to the following occurs: 'Unable to load dynamic library './php_mysqli.dll', this is because php_mysqli.dll and/or libmysql.dll cannot be found by the system. >On Windows, PHP is most commonly installed using the binary installer. Once PHP has been installed, some >configuration is required to enable mysqli and specify the client library you want it to use. Basically, if you want to add extensions you can double-click again on the installer file.
The installer will find the already installed PHP and will ask if you want to change the installation. When you go through the prompts it will take you back to the list of extensions and you can pick which extensions you want to add. For the mysqli extension the installer also edited php.ini so that the extension was enabled: [PHP_MYSQLI] extension=php_mysqli.dll the installer added those lines to the end of the file.
Which version do I choose? IIS If you are using PHP as FastCGI with IIS you should use the Non-Thread Safe (NTS) versions of PHP.
Apache Please use the Apache builds provided. They provide VC11, VC14 and VC15 builds of Apache for x86 and x64. We use their binaries to build the Apache SAPIs.
If you are using PHP as module with Apache builds from apache.org (not recommended) you need to use the older VC6 versions of PHP compiled with the legacy Visual Studio 6 compiler. Do NOT use VC11+ versions of PHP with the apache.org binaries. With Apache you have to use the Thread Safe (TS) versions of PHP.
VC11, VC14 & VC15 More recent versions of PHP are built with VC11, VC14 or VC15 (Visual Studio 2012, 2015 or 2017 compiler respectively) and include improvements in performance and stability. - The VC11 builds require to have the Visual C++ Redistributable for Visual Studio 2012 installed - The VC14 builds require to have the Visual C++ Redistributable for Visual Studio 2015 installed - The VC15 builds require to have the Visual C++ Redistributable for Visual Studio 2017 or installed TS and NTS TS refers to multithread capable builds. NTS refers to single thread only builds. Use case for TS binaries involves interaction with a multithreaded SAPI and PHP loaded as a module into a web server.
For NTS binaries the widespread use case is interaction with a web server through the FastCGI protocol, utilizing no multithreading (but also for example CLI). Is an optimization feature available in Microsoft's Visual C++ compiler that allows you to optimize an output file based on profiling data collected during test runs of the application or module.
Links: • • • (old) amd64 (x86_64) Builds The x64 builds of PHP 5 for Windows are experimental, and do not provide 64-bit integer or large file support. PHP 7 provides full 64-bit support. The x64 builds of PHP 7 support native 64-bit integers, LFS, 64-bit memory_limit and much more. Long and mulibyte path PHP 7.1+ supports long and UTF-8 paths. See the for details. The announces the availability of the OpenSSL 1.0.1g which fixes CVE-2014-0160. In this regard the latest PHP release 5.5.11 was rebuilt with the OpenSSL 1.0.1g.
Windows Server 2012 R2 Ключ При Установке. All PHP users are strongly encouraged to upgrade to PHP 5.5. Caesar Frazier Another Life Raft. 11. If you already have downloaded this version before 10-Apr-2014, please redownload. The existing private keys should be regenerated as soon as possible. Alternatively, the updated OpenSSL dependency DLLs can be downloaded separately as replacement for the older PHP versions. Though be aware that this issue affects only OpenSSL 1.0.x and the DLL packages are only applicable to PHP 5.5 and upper. • • PHP 5.4 and lower is not affected by this issue.
The PHP development team is proud to announce the immediate availability of PHP 5.5.0. This release includes a large number of new features and bug fixes. The key features of PHP 5.5.0 include: • Added and coroutines. • Added the keyword. • Added scalar class name resolution via.
• Added the extension for opcode caching. • The GD library has been upgraded to version 2.1 adding new functions and improving existing functionality. • A lot more improvements and fixes. Changes that affect compatibility: • have been removed. • Windows XP and 2003 support dropped. • Case insensitivity is no longer locale specific.
All case insensitive matching for function, class and constant names is now performed in a locale independent manner according to ASCII rules. For users upgrading from PHP 5.4, detailing the changes between 5.4 and 5.5.0. For a full list of changes in PHP 5.5.0, see the. The PHP development team is proud to announce the immediate availability of PHP.
This release is a major leap forward in the 5.x series, which includes a large number of new features and bug fixes. The PHP development team would like to announce the immediate availability of PHP 5.3.6. This release focuses on improving the stability of the PHP 5.3.x branch with over 60 bug fixes, some of which are security related. Security Enhancements and Fixes in PHP 5.3.6: • Enforce security in the fastcgi protocol parsing with fpm SAPI. • Fixed bug #54247 (format-string vulnerability on Phar). (CVE-2011-1153) • Fixed bug #54193 (Integer overflow in shmop_read()).
(CVE-2011-1092) • Fixed bug #54055 (buffer overrun with high values for precision ini setting). • Fixed bug #54002 (crash on crafted tag in exif). (CVE-2011-0708) • Fixed bug #53885 (ZipArchive segfault with FL_UNCHANGED on empty archive). (CVE-2011-0421) Key enhancements in PHP 5.3.6 include: • Upgraded bundled Sqlite3 to version 3.7.4. • Upgraded bundled PCRE to version 8.11. • Added ability to connect to HTTPS sites through proxy with basic authentication using stream_context/http/header/Proxy-Authorization.
• Added options to debug backtrace functions. • Changed default value of ini directive serialize_precision from 100 to 17.
• Fixed Bug #53971 (isset() and empty() produce apparently spurious runtime error). • Fixed Bug #53958 (Closures can't 'use' shared variables by value and by reference). • Fixed bug #53577 (Regression introduced in 5.3.4 in open_basedir with a trailing forward slash). • Over 60 other bug fixes. Windows users: please mind that we do no longer provide builds created with Visual Studio C++ 6. It is impossible to maintain a high quality and safe build of PHP for Windows using this unmaintained compiler. For Apache SAPIs (php5_apache2_2.dll), be sure that you use a Visual Studio C++ 9 version of Apache.
We recommend the Apache builds as provided. For any other SAPI (CLI, FastCGI via mod_fcgi, FastCGI with IIS or other FastCGI capable server), everything works as before. Third party extension providers must rebuild their extensions to make them compatible and loadable with the Visual Studio C++9 builds that we now provide. All PHP users should note that the PHP 5.2 series is NOT supported anymore. All users are strongly encouraged to upgrade to PHP 5.3.6.
For a full list of changes in PHP 5.3.6, see the. For source and binaries downloads please visit our. The PHP development team is proud to announce the immediate release of PHP 5.3.2. This is a maintenance release in the 5.3 series, which includes a large number of bug fixes. Security Enhancements and Fixes in PHP 5.3.2: • Improved LCG entropy. (Rasmus, Samy Kamkar) • Fixed safe_mode validation inside tempnam() when the directory path does not end with a /).
(Martin Jansen) • Fixed a possible open_basedir/safe_mode bypass in the session extension identified by Grzegorz Stachowiak. (Ilia) Key Bug Fixes in PHP 5.3.2 include: • Added support for SHA-256 and SHA-512 to php's crypt. • Added protection for $_SESSION from interrupt corruption and improved 'session.save_path' check.
• Fixed bug #51059 (crypt crashes when invalid salt are given). • Fixed bug #50940 Custom content-length set incorrectly in Apache sapis.
• Fixed bug #50847 (strip_tags() removes all tags greater then 1023 bytes long). • Fixed bug #50723 (Bug in garbage collector causes crash). • Fixed bug #50661 (DOMDocument::loadXML does not allow UTF-16). • Fixed bug #50632 (filter_input() does not return default value if the variable does not exist).
• Fixed bug #50540 (Crash while running ldap_next_reference test cases). • Fixed bug #49851 (http wrapper breaks on 1024 char long headers).
• Over 60 other bug fixes. The SNMP extension is now available in VC9 versions. The cURL and MPIR libraries have been updated.
For users upgrading from PHP 5.2 there is a migration guide available, detailing the changes between those releases and PHP 5.3. Further information and downloads: For a full list of changes in PHP 5.3.2, see the. For source downloads please visit our, Windows binaries can be found on. The PHP development team would like to announce the immediate availability of PHP 5.2.13. This release focuses on improving the stability of the PHP 5.2.x branch with over 40 bug fixes, some of which are security related. All users of PHP 5.2 are encouraged to upgrade to this release. Security Enhancements and Fixes in PHP 5.2.13: • Fixed safe_mode validation inside tempnam() when the directory path does not end with a /).
(Martin Jansen) • Fixed a possible open_basedir/safe_mode bypass in session extension identified by Grzegorz Stachowiak. (Ilia) • Improved LCG entropy. (Rasmus, Samy Kamkar) Further details about the PHP 5.2.13 release can be found in the, and the full list of changes are available in the. The libcURL library has been updated to 7.20.0, which fixes important bugs fixes as well as a security flaw, see the advisory and the full changelog. The PHP development team would like to announce the immediate availability of PHP 5.3.1. This release focuses on improving the stability of the PHP 5.3.x branch with over 100 bug fixes, some of which are security related. All users of PHP are encouraged to upgrade to this release.
Security Enhancements and Fixes in PHP 5.3.1: • Added 'max_file_uploads' INI directive, which can be set to limit the number of file uploads per-request to 20 by default, to prevent possible DOS via temporary file exhaustion. • Added missing sanity checks around exif processing. • Fixed a safe_mode bypass in tempnam(). • Fixed a open_basedir bypass in posix_mkfifo(). • Fixed failing safe_mode_include_dir. Further details about the PHP 5.3.1 release can be found in the, and the full list of changes are available in the. The OpenSSL library has been updated to 0.9.8l, which fixes important bugs fixes (see the OpenSSL for details.
The PHP development team would like to announce the immediate availability of PHP 5.2.11. This release focuses on improving the stability of the PHP 5.2.x branch with over 75 bug fixes, some of which are security related. All users of PHP 5.2 are encouraged to upgrade to this release. Security Enhancements and Fixes in PHP 5.2.11: • Fixed certificate validation inside php_openssl_apply_verification_policy.
(Ryan Sleevi, Ilia) • Fixed sanity check for the color index in imagecolortransparent(). (Pierre) • Added missing sanity checks around exif processing. (Ilia) • Fixed bug (popen crashes when an invalid mode is passed).
(Pierre) Key enhancements in PHP 5.2.11 include: • Fixed regression in cURL extension that prevented flush of data to output defined as a file handle. • A number of fixes for the FILTER_VALIDATE_EMAIL validation rule • Fixed bug #49361 (wordwrap() wraps incorrectly on end of line boundaries). • Fixed bug #48696 (ldap_read() segfaults with invalid parameters) • Fixed bug #48645 (mb_convert_encoding() doesn't understand hexadecimal html-entities). • Fixed bug #48619 (imap_search ALL segfaults). • Fixed bug #48400 (imap crashes when closing stream opened with OP_PROTOTYPE flag).
• Fixed bug #47351 (Memory leak in DateTime). • Over 60 other bug fixes. On windows, the cURL library has been updated to its latest version (7.19.6) to fix the flaws described. Further details about the PHP 5.2.11 release can be found in the, and the full list of changes are available in the. The PHP development team is proud to announce the immediate release of PHP. This release is a major improvement in the 5.X series, which includes a large number of new features and bug fixes. Some of the key new features include:,,, optional for cyclic references, new extensions (like, and ), over 140 bug fixes and much more.
For users upgrading from PHP 5.2 there is a available here, detailing the changes between those releases and. Further details about the release can be found in the, and the full list of changes are available in the. The PHP development team would like to announce the immediate availability of PHP 5.2.10. This release focuses on improving the stability of the PHP 5.2.x branch with over 100 bug fixes, one of which is security related. All users of PHP are encouraged to upgrade to this release. Security Enhancements and Fixes in PHP 5.2.10: • Fixed bug #48378 (exif_read_data() segfaults on certain corrupted.jpeg files).
(Pierre) Further details about the PHP 5.2.10 release can be found in the, and the full list of changes are available in the. The PHP Development Team would like to announce the availability of a new Windows build for PHP - PHP 5.2.9-2 This release focuses on fixing security flaws in the included OpenSSL library (CVE-2009-0590, CVE-2009-0591 and CVE-2009-0789).
The security advisory is available. The OpenSSL library has been updated to 0.9.8k, which includes fixes for these flaws. Note: Only the Windows binaries are affected. There are no changes to the PHP sources, therefore no source releases are necessary. Binaries are available in our.