• 首页
  • css3教程
  • html5教程
  • jQuery手册
  • php7教程
  • MySQL手册
  • apache手册
  • 位置: php7教程 -> php7外部扩展库

    MySQL数据库(原始)

    MySQL是一个关系型数据库管理系统.

    为了使这些函数能够使用,你必须编译加入 PHP 对 MySQL 的支持。

    Warning
    本扩展自 PHP 5.5.0 起已废弃,并在自 PHP 7.0.0 开始被移除。应使用 MySQLi 或 PDO_MySQL 扩展来替换之

    编译时,只要使用 --with-mysql[=DIR] 配置选项即可,其中可选的[DIR]指向 MySQL 的安装目录。

    虽然本 MySQL 扩展库兼容 MySQL 4.1.0 及其以后版本,但是它不支持这些版本提供的额外功能。要使用这些功能,请使用 MySQLi 扩展库。

    如果要同时安装 mysql 扩展库和 mysqli 扩展库,必须使用同一个客户端库以避免任何冲突。

    在 Linux 系统下安装

    Note:[DIR]is the path to the MySQL client library files (headers and libraries), which can be downloaded from » MySQL.

    ext/mysql compile time support matrix
    PHP 版本默认配置选项: mysqlnd配置选项:libmysql更新日志
    4.x.xlibmysql不适用--without-mysql to disableMySQL enabled by default, MySQL client libraries are bundled
    5.0.x, 5.1.x, 5.2.xlibmysql不适用--with-mysql=[DIR] MySQL is no longer enabled by default, and the MySQL client libraries are no longer bundled
    5.3.xlibmysql--with-mysql=mysqlnd--with-mysql=[DIR]mysqlnd is now available
    5.4.xmysqlnd--with-mysql--with-mysql=[DIR]mysqlnd is now the default

    在 Windows 系统下安装

    PHP 4

    PHP MySQL 扩展已经编译入 PHP。

    PHP 5+

    MySQL 默认未启用,因此必须在php.ini中激活php_mysql.dll动态连接库。此外,PHP 还需要访问 MySQL 客户端连接库。PHP 的 Windows 发行版包括了一个libmysql.dll,为了让 PHP 能和 MySQL 对话,此文件必须放在 Windows 的系统路径PATH中。怎样做见 FAQ 中的“怎样把 PHP 目录加入到 WindowsPATH中”。尽管将libmysql.dll拷贝到 Windows 系统目录中也可以(因为系统目录默认在系统路径PATH中),但不推荐这样做。

    要激活任何 PHP 扩展库(例如php_mysql.dll),PHP 指令 extension_dir 要被设为 PHP 扩展库所在的目录。参见手工 Windows 安装指南。PHP 5 下 extension_dir 取值的一个例子是c:\php\ext

    Note:

    如果启动 web 服务器时出现类似如下的错误:"Unable to load dynamic library './php_mysql.dll'",这是因为系统找不到php_mysql.dll和/或libmysql.dll

    PHP 5.3.0+

    The MySQL Native Driver is enabled by default. Includephp_mysql.dll, butlibmysql.dllis no longer required or used.

    MySQL 安装注意事项

    Warning

    当同时加在本扩展库和 recode 扩展库时 PHP 可能会崩溃。更多信息见 recode 扩展库。

    Note:

    如果需要不同于latin(默认值)的字符集,必须安装外部的(非绑定的)已编译入所需字符集支持的 libmysql。

    I believe that this is happens especially with Windows 7. As far I I've been able to tell XP and Vista come with this line enabled, but windows 7 comments it out and notes that the DNS will handle this.
    In windows systems, the same error "unable to load dynamic library php_mysql.dll" will happen, if there's an old version of the file in the "windows\system32" folder.
    Either remove it or update it.
    I had problems when moving from a version of PHP that used the isapi dll to the fast cgi version. The script to register the script maps compained that there was already a script map in place.
    I went to the IIS control panel, right clicked on websites and removed the php association in the Home Directory | Configuration screen.
    However, the fastcgi script still complained about existing script map. Finally I tracked it down, I had to right click on Default Web Site and clear out the php mappings from there too.
    Then it all worked, except that for some strange reason, the php.ini file that gets picked up is the one from my old PHP directory, not the latest upgrade one. But this can be detected by running phpinfo which shows the loaded php.ini file so I knew which one to amend with the fastcgi options.
    Bit of a hassle to figure it all out but it does work in the end.
    i've experienced a similar (if not the same) problem.
    to enable the mysql_... and mysqli_... funtionality, i opened the php.ini file to uncomment the following lines:
    ;extension=php_mysql.dll
    ;extension=php_mysqli.dll
    ;extension=php_pdo_mysql.dll
    but phpinfo() still stated that no mysql extensions were loaded.
    i tried the fixes and suggestions above with no success.
    so i invoked the windows shell and typed ("Path" environment variable set to the PHP & MySQL directories):
    php.exe -m
    this returned the following error: "PHP Startup: Unable to load dynamic library 'C:\php5\php_mysql.dll' - Module not found."
    this told me that PHP didn't recognize what i thought was the extensions directory. it searched all other places first (sys-dir, workin'-dir, the MySQL "bin" dir because of the "Path" variable set, and even a curious directory "C:\php5" that doesn't even exist on my mashine) but not the expected "ext" directory.
    so the fix was to go to "php.ini" again and uncomment the following line:
    ;extension_dir="ext"
    this fixed it for me.
    so if module loading is done improperly, first of all check the "Path" environment variable and the "php.ini" file - especially the "extension_dir" config value - and check if all values are set to their correct values.
    hope this helps any1.
    ----------------------------------------
    OS: Win7 Ultimate x86
    Apache v2.2.16
    PHP v5.3.3
    MySQL v5.1.50
    Could not install mysql, on windows, had several conflicts or bugs.
    In order to solve it:
    * Used the "libmysql.dll" provided by PHP zip files, not the one that comes with Mysql, the mysql file had to be moved or deleted from its folder. Put it on the "apache/bin" folder, altought some use it in "windows" folder.
    * Originally, moved "*mysql*.dll" files from its extension folder, and returned back.
    * enabled mysql driver extensions in the "php.ini" file, but also enabled some extensions, that seemed not to be required, but, it did, like "php_openssl.dll" or "php_pdo.dll" on an early version of php.
    Added the "PHPIniDir xxx"" to the "httpd.conf" apache config. file, where xxx is the path to the folder where the "php.ini" file is located, and make sure its the same.
    Be warned, that this fixes, may help or not, for your installation, since there are many ways to configure the same thing (to solve a problem).
    I have experienced exactly the same problem as flo_stefi at yahoo dot com below. It appears that instead of loading libmysql.dll that came with the PHP package, the PHP engine was loading libmySQL.dll located in MySQL's bin directory, which was causing Apache to crash.
    I fixed the problem by renaming MySQL's libmySQL.dll into libmySQL_renamed.dll. Now PHP loads the library that came with its package and everything works fine.
    Please note that libmySQL.dll in MySQL bin directory should be renamed in order to use right library (that comes with PHP).

    运行时配置

    这些函数的行为受php.ini中的设置影响。

    MySQL 配置选项
    名字默认可修改范围更新日志
    mysql.allow_local_infile"1"PHP_INI_SYSTEM
    mysql.allow_persistent"1"PHP_INI_SYSTEM
    mysql.max_persistent"-1"PHP_INI_SYSTEM
    mysql.max_links"-1"PHP_INI_SYSTEM
    mysql.trace_mode"0"PHP_INI_ALL自 PHP 4.3.0 起可用
    mysql.default_portNULLPHP_INI_ALL
    mysql.default_socketNULLPHP_INI_ALL自 PHP 4.0.1 起可用
    mysql.default_hostNULLPHP_INI_ALL
    mysql.default_userNULLPHP_INI_ALL
    mysql.default_passwordNULLPHP_INI_ALL
    mysql.connect_timeout"60"PHP_INI_ALL自 PHP 4.3.0 起可用。在 PHP <= 4.3.2 时为 PHP_INI_SYSTEM

    MySQL 扩展概述范例

    这个简单的范例展示了如何连接、执行一个查询,打印结果集后断开 MySQL 数据库的连接。

    Example #1 MySQL 扩展概述范例

    <?php
    // 连接、选择数据库
    $link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
        or die('Could not connect: ' . mysql_error());
    echo 'Connected successfully';
    mysql_select_db('my_database') or die('Could not select database');
    // 执行 SQL 查询
    $query = 'SELECT * FROM my_table';
    $result = mysql_query($query) or die('Query failed: ' . mysql_error());
    // 以 HTML 打印查询结果
    echo "<table>\n";
    while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
        echo "\t<tr>\n";
        foreach ($line as $col_value) {
            echo "\t\t<td>$col_value</td>\n";
        }
        echo "\t</tr>\n";
    }
    echo "</table>\n";
    // 释放结果集
    mysql_free_result($result);
    // 关闭连接
    mysql_close($link);
    ?>