pdo_mysql.c

Go to the documentation of this file.

/*
  +----------------------------------------------------------------------+
  | Copyright (c) The PHP Group                                          |
  +----------------------------------------------------------------------+
  | This source file is subject to version 3.01 of the PHP license,      |
  | that is bundled with this package in the file LICENSE, and is        |
  | available through the world-wide-web at the following url:           |
  | https://www.php.net/license/3_01.txt                                 |
  | If you did not receive a copy of the PHP license and are unable to   |
  | obtain it through the world-wide-web, please send a note to          |
  | license@php.net so we can mail you a copy immediately.               |
  +----------------------------------------------------------------------+
  | Author: George Schlossnagle <george@omniti.com>                      |
  |         Johannes Schlueter <johannes@mysql.com>                      |
  +----------------------------------------------------------------------+
*/
 
#ifdef HAVE_CONFIG_H
#include <config.h>
#endif
 
#include "php.h"
#include "php_ini.h"
#include "ext/standard/info.h"
#include "ext/pdo/php_pdo.h"
#include "ext/pdo/php_pdo_driver.h"
#include "php_pdo_mysql.h"
#include "php_pdo_mysql_int.h"
#include "pdo_mysql_arginfo.h"
 
static zend_class_entry *pdo_mysql_ce;
 
#ifdef COMPILE_DL_PDO_MYSQL
#ifdef ZTS
ZEND_TSRMLS_CACHE_DEFINE()
#endif
ZEND_GET_MODULE(pdo_mysql)
#endif
 
ZEND_DECLARE_MODULE_GLOBALS(pdo_mysql)
 
/*
 The default socket location is sometimes defined by configure.
 With libmysql `mysql_config --socket` will fill PDO_MYSQL_UNIX_ADDR
 and the user can use --with-mysql-sock=SOCKET which will fill
 PHP_MYSQL_UNIX_SOCK_ADDR. If both aren't set we're using mysqlnd and use
 /tmp/mysql.sock as default on *nix and NULL for Windows (default
 named pipe name is set in mysqlnd).
*/
#ifndef PDO_MYSQL_UNIX_ADDR
# ifdef PHP_MYSQL_UNIX_SOCK_ADDR
#  define PDO_MYSQL_UNIX_ADDR PHP_MYSQL_UNIX_SOCK_ADDR
# else
#  ifndef PHP_WIN32
#   define PDO_MYSQL_UNIX_ADDR "/tmp/mysql.sock"
#  else
#   define PDO_MYSQL_UNIX_ADDR NULL
#  endif
# endif
#endif
 
#ifdef PDO_USE_MYSQLND
#include "ext/mysqlnd/mysqlnd_reverse_api.h"
static MYSQLND * pdo_mysql_convert_zv_to_mysqlnd(zval * zv)
{
    if (Z_TYPE_P(zv) == IS_OBJECT && instanceof_function(Z_OBJCE_P(zv), php_pdo_get_dbh_ce())) {
        pdo_dbh_t * dbh = Z_PDO_DBH_P(zv);
 
        ZEND_ASSERT(dbh);
 
        if (dbh->driver != &pdo_mysql_driver) {
            php_error_docref(NULL, E_WARNING, "Provided PDO instance is not using MySQL but %s", dbh->driver->driver_name);
            return NULL;
        }
 
        return ((pdo_mysql_db_handle *)dbh->driver_data)->server;
    }
    return NULL;
}
 
static const MYSQLND_REVERSE_API pdo_mysql_reverse_api = {
    &pdo_mysql_module_entry,
    pdo_mysql_convert_zv_to_mysqlnd
};
#endif
 
/* Returns the number of SQL warnings during the execution of the last statement */
PHP_METHOD(Pdo_Mysql, getWarningCount)
{
    pdo_dbh_t *dbh;
    pdo_mysql_db_handle *H;
 
    ZEND_PARSE_PARAMETERS_NONE();
 
    dbh = Z_PDO_DBH_P(ZEND_THIS);
    PDO_CONSTRUCT_CHECK;
 
    H = (pdo_mysql_db_handle *)dbh->driver_data;
    RETURN_LONG(mysql_warning_count(H->server));
}
 
/* {{{ PHP_INI_BEGIN */
PHP_INI_BEGIN()
#ifndef PHP_WIN32
    STD_PHP_INI_ENTRY("pdo_mysql.default_socket", PDO_MYSQL_UNIX_ADDR, PHP_INI_SYSTEM, OnUpdateStringUnempty, default_socket, zend_pdo_mysql_globals, pdo_mysql_globals)
#endif
#if PDO_DBG_ENABLED
    STD_PHP_INI_ENTRY("pdo_mysql.debug",   NULL, PHP_INI_SYSTEM, OnUpdateString, debug, zend_pdo_mysql_globals, pdo_mysql_globals)
#endif
PHP_INI_END()
/* }}} */
 
/* true global environment */
 
/* {{{ PHP_MINIT_FUNCTION */
static PHP_MINIT_FUNCTION(pdo_mysql)
{
    REGISTER_INI_ENTRIES();
 
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_USE_BUFFERED_QUERY", (zend_long)PDO_MYSQL_ATTR_USE_BUFFERED_QUERY);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_LOCAL_INFILE", (zend_long)PDO_MYSQL_ATTR_LOCAL_INFILE);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_INIT_COMMAND", (zend_long)PDO_MYSQL_ATTR_INIT_COMMAND);
#ifndef PDO_USE_MYSQLND
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_MAX_BUFFER_SIZE", (zend_long)PDO_MYSQL_ATTR_MAX_BUFFER_SIZE);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_READ_DEFAULT_FILE", (zend_long)PDO_MYSQL_ATTR_READ_DEFAULT_FILE);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_READ_DEFAULT_GROUP", (zend_long)PDO_MYSQL_ATTR_READ_DEFAULT_GROUP);
#endif
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_COMPRESS", (zend_long)PDO_MYSQL_ATTR_COMPRESS);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_DIRECT_QUERY", (zend_long)PDO_MYSQL_ATTR_DIRECT_QUERY);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_FOUND_ROWS", (zend_long)PDO_MYSQL_ATTR_FOUND_ROWS);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_IGNORE_SPACE", (zend_long)PDO_MYSQL_ATTR_IGNORE_SPACE);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_KEY", (zend_long)PDO_MYSQL_ATTR_SSL_KEY);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_CERT", (zend_long)PDO_MYSQL_ATTR_SSL_CERT);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_CA", (zend_long)PDO_MYSQL_ATTR_SSL_CA);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_CAPATH", (zend_long)PDO_MYSQL_ATTR_SSL_CAPATH);
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_CIPHER", (zend_long)PDO_MYSQL_ATTR_SSL_CIPHER);
#if MYSQL_VERSION_ID > 50605 || defined(PDO_USE_MYSQLND)
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SERVER_PUBLIC_KEY", (zend_long)PDO_MYSQL_ATTR_SERVER_PUBLIC_KEY);
#endif
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_MULTI_STATEMENTS", (zend_long)PDO_MYSQL_ATTR_MULTI_STATEMENTS);
#ifdef PDO_USE_MYSQLND
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_VERIFY_SERVER_CERT", (zend_long)PDO_MYSQL_ATTR_SSL_VERIFY_SERVER_CERT);
#endif
#if MYSQL_VERSION_ID >= 80021 || defined(PDO_USE_MYSQLND)
    REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_LOCAL_INFILE_DIRECTORY", (zend_long)PDO_MYSQL_ATTR_LOCAL_INFILE_DIRECTORY);
#endif
 
#ifdef PDO_USE_MYSQLND
    mysqlnd_reverse_api_register_api(&pdo_mysql_reverse_api);
#endif
 
    pdo_mysql_ce = register_class_Pdo_Mysql(pdo_dbh_ce);
    pdo_mysql_ce->create_object = pdo_dbh_new;
 
    if (php_pdo_register_driver(&pdo_mysql_driver) == FAILURE) {
        return FAILURE;
    }
 
    return php_pdo_register_driver_specific_ce(&pdo_mysql_driver, pdo_mysql_ce);
}
/* }}} */
 
/* {{{ PHP_MSHUTDOWN_FUNCTION */
static PHP_MSHUTDOWN_FUNCTION(pdo_mysql)
{
    php_pdo_unregister_driver(&pdo_mysql_driver);
#ifdef PDO_USE_MYSQLND
    UNREGISTER_INI_ENTRIES();
#endif
 
    return SUCCESS;
}
/* }}} */
 
/* {{{ PHP_MINFO_FUNCTION */
static PHP_MINFO_FUNCTION(pdo_mysql)
{
    php_info_print_table_start();
 
    php_info_print_table_row(2, "PDO Driver for MySQL", "enabled");
    php_info_print_table_row(2, "Client API version", mysql_get_client_info());
 
    php_info_print_table_end();
 
#ifndef PHP_WIN32
    DISPLAY_INI_ENTRIES();
#endif
}
/* }}} */
 
 
#if defined(PDO_USE_MYSQLND) && PDO_DBG_ENABLED
/* {{{ PHP_RINIT_FUNCTION */
static PHP_RINIT_FUNCTION(pdo_mysql)
{
    if (PDO_MYSQL_G(debug)) {
        MYSQLND_DEBUG *dbg = mysqlnd_debug_init(mysqlnd_debug_std_no_trace_funcs);
        if (!dbg) {
            return FAILURE;
        }
        dbg->m->set_mode(dbg, PDO_MYSQL_G(debug));
        PDO_MYSQL_G(dbg) = dbg;
    }
 
    return SUCCESS;
}
/* }}} */
 
/* {{{ PHP_RSHUTDOWN_FUNCTION */
static PHP_RSHUTDOWN_FUNCTION(pdo_mysql)
{
    MYSQLND_DEBUG *dbg = PDO_MYSQL_G(dbg);
    PDO_DBG_ENTER("RSHUTDOWN");
    if (dbg) {
        dbg->m->close(dbg);
        dbg->m->free_handle(dbg);
        PDO_MYSQL_G(dbg) = NULL;
    }
 
    return SUCCESS;
}
/* }}} */
#endif
 
/* {{{ PHP_GINIT_FUNCTION */
static PHP_GINIT_FUNCTION(pdo_mysql)
{
#if defined(COMPILE_DL_PDO_MYSQL) && defined(ZTS)
ZEND_TSRMLS_CACHE_UPDATE();
#endif
#ifndef PHP_WIN32
    pdo_mysql_globals->default_socket = NULL;
#endif
#if PDO_DBG_ENABLED
    pdo_mysql_globals->debug = NULL;    /* The actual string */
    pdo_mysql_globals->dbg = NULL;  /* The DBG object*/
#endif
}
/* }}} */
 
/* {{{ pdo_mysql_deps[] */
static const zend_module_dep pdo_mysql_deps[] = {
    ZEND_MOD_REQUIRED("pdo")
#ifdef PDO_USE_MYSQLND
    ZEND_MOD_REQUIRED("mysqlnd")
#endif
    ZEND_MOD_END
};
/* }}} */
 
/* {{{ pdo_mysql_module_entry */
zend_module_entry pdo_mysql_module_entry = {
    STANDARD_MODULE_HEADER_EX, NULL,
    pdo_mysql_deps,
    "pdo_mysql",
    NULL,
    PHP_MINIT(pdo_mysql),
    PHP_MSHUTDOWN(pdo_mysql),
#if defined(PDO_USE_MYSQLND) && PDO_DBG_ENABLED
    PHP_RINIT(pdo_mysql),
    PHP_RSHUTDOWN(pdo_mysql),
#else
    NULL,
    NULL,
#endif
    PHP_MINFO(pdo_mysql),
    PHP_PDO_MYSQL_VERSION,
    PHP_MODULE_GLOBALS(pdo_mysql),
    PHP_GINIT(pdo_mysql),
    NULL,
    NULL,
    STANDARD_MODULE_PROPERTIES_EX
};
/* }}} */