22.10.2.12. Aliases and deprecated Mysqli Functions

Copyright 1997-2010 the PHP Documentation Group.

22.10.2.12.1. mysqli_bind_param

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_bind_param

    Alias for mysqli_stmt_bind_param

Description

This function is an alias of mysqli_stmt_bind_param.

Notes

Note

mysqli_bind_param is deprecated and will be removed.

See Also

mysqli_stmt_bind_param

22.10.2.12.2. mysqli_bind_result

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_bind_result

    Alias for mysqli_stmt_bind_result

Description

This function is an alias of mysqli_stmt_bind_result.

Notes

Note

mysqli_bind_result is deprecated and will be removed.

See Also

mysqli_stmt_bind_result

22.10.2.12.3. mysqli_client_encoding

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_client_encoding

    Alias of mysqli_character_set_name

Description

This function is an alias of mysqli_character_set_name.

See Also

mysqli_real_escape_string

22.10.2.12.4. mysqli_connect

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_connect

    Alias of mysqli::__construct

Description

This function is an alias of: mysqli::__construct

22.10.2.12.5. mysqli_disable_reads_from_master, mysqli->disable_reads_from_master

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_disable_reads_from_master

    mysqli->disable_reads_from_master

    Disable reads from master

Description

Object oriented style

void mysqli::disable_reads_from_master();

Procedural style

bool mysqli_disable_reads_from_master(mysqli link);
Warning

This function is currently not documented; only its argument list is available.

Warning

This function has been DEPRECATED and REMOVED as of PHP 5.3.0.

22.10.2.12.6. mysqli_disable_rpl_parse

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_disable_rpl_parse

    Disable RPL parse

Description

bool mysqli_disable_rpl_parse(mysqli link);
Warning

This function is currently not documented; only its argument list is available.

Warning

This function has been DEPRECATED and REMOVED as of PHP 5.3.0.

22.10.2.12.7. mysqli_enable_reads_from_master

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_enable_reads_from_master

    Enable reads from master

Description

bool mysqli_enable_reads_from_master(mysqli link);
Warning

This function is currently not documented; only its argument list is available.

Warning

This function has been DEPRECATED and REMOVED as of PHP 5.3.0.

22.10.2.12.8. mysqli_enable_rpl_parse

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_enable_rpl_parse

    Enable RPL parse

Description

bool mysqli_enable_rpl_parse(mysqli link);
Warning

This function is currently not documented; only its argument list is available.

Warning

This function has been DEPRECATED and REMOVED as of PHP 5.3.0.

22.10.2.12.9. mysqli_escape_string

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_escape_string

    Alias of mysqli_real_escape_string

Description

This function is an alias of: mysqli_real_escape_string.

22.10.2.12.10. mysqli_execute

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_execute

    Alias for mysqli_stmt_execute

Description

This function is an alias of mysqli_stmt_execute.

Notes

Note

mysqli_execute is deprecated and will be removed.

See Also

mysqli_stmt_execute

22.10.2.12.11. mysqli_fetch

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_fetch

    Alias for mysqli_stmt_fetch

Description

This function is an alias of mysqli_stmt_fetch.

Notes

Note

mysqli_fetch is deprecated and will be removed.

See Also

mysqli_stmt_fetch

22.10.2.12.12. mysqli_get_cache_stats

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_get_cache_stats

    Returns client Zval cache statistics

Description

array mysqli_get_cache_stats();
Warning

This function is currently not documented; only its argument list is available.

Returns client Zval cache statistics. Available only with mysqlnd.

Parameters

Return Values

Returns an array with client Zval cache stats if success, FALSE otherwise.

Examples

Example 22.152. A mysqli_get_cache_stats example

<?php
$link = mysqli_connect();
print_r(mysqli_get_cache_stats());
?>

    

The above example will output something similar to:



Array
(
    [bytes_sent] => 43
    [bytes_received] => 80
    [packets_sent] => 1
    [packets_received] => 2
    [protocol_overhead_in] => 8
    [protocol_overhead_out] => 4
    [bytes_received_ok_packet] => 11
    [bytes_received_eof_packet] => 0
    [bytes_received_rset_header_packet] => 0
    [bytes_received_rset_field_meta_packet] => 0
    [bytes_received_rset_row_packet] => 0
    [bytes_received_prepare_response_packet] => 0
    [bytes_received_change_user_packet] => 0
    [packets_sent_command] => 0
    [packets_received_ok] => 1
    [packets_received_eof] => 0
    [packets_received_rset_header] => 0
    [packets_received_rset_field_meta] => 0
    [packets_received_rset_row] => 0
    [packets_received_prepare_response] => 0
    [packets_received_change_user] => 0
    [result_set_queries] => 0
    [non_result_set_queries] => 0
    [no_index_used] => 0
    [bad_index_used] => 0
    [slow_queries] => 0
    [buffered_sets] => 0
    [unbuffered_sets] => 0
    [ps_buffered_sets] => 0
    [ps_unbuffered_sets] => 0
    [flushed_normal_sets] => 0
    [flushed_ps_sets] => 0
    [ps_prepared_never_executed] => 0
    [ps_prepared_once_executed] => 0
    [rows_fetched_from_server_normal] => 0
    [rows_fetched_from_server_ps] => 0
    [rows_buffered_from_client_normal] => 0
    [rows_buffered_from_client_ps] => 0
    [rows_fetched_from_client_normal_buffered] => 0
    [rows_fetched_from_client_normal_unbuffered] => 0
    [rows_fetched_from_client_ps_buffered] => 0
    [rows_fetched_from_client_ps_unbuffered] => 0
    [rows_fetched_from_client_ps_cursor] => 0
    [rows_skipped_normal] => 0
    [rows_skipped_ps] => 0
    [copy_on_write_saved] => 0
    [copy_on_write_performed] => 0
    [command_buffer_too_small] => 0
    [connect_success] => 1
    [connect_failure] => 0
    [connection_reused] => 0
    [reconnect] => 0
    [pconnect_success] => 0
    [active_connections] => 1
    [active_persistent_connections] => 0
    [explicit_close] => 0
    [implicit_close] => 0
    [disconnect_close] => 0
    [in_middle_of_command_close] => 0
    [explicit_free_result] => 0
    [implicit_free_result] => 0
    [explicit_stmt_close] => 0
    [implicit_stmt_close] => 0
    [mem_emalloc_count] => 0
    [mem_emalloc_ammount] => 0
    [mem_ecalloc_count] => 0
    [mem_ecalloc_ammount] => 0
    [mem_erealloc_count] => 0
    [mem_erealloc_ammount] => 0
    [mem_efree_count] => 0
    [mem_malloc_count] => 0
    [mem_malloc_ammount] => 0
    [mem_calloc_count] => 0
    [mem_calloc_ammount] => 0
    [mem_realloc_count] => 0
    [mem_realloc_ammount] => 0
    [mem_free_count] => 0
    [proto_text_fetched_null] => 0
    [proto_text_fetched_bit] => 0
    [proto_text_fetched_tinyint] => 0
    [proto_text_fetched_short] => 0
    [proto_text_fetched_int24] => 0
    [proto_text_fetched_int] => 0
    [proto_text_fetched_bigint] => 0
    [proto_text_fetched_decimal] => 0
    [proto_text_fetched_float] => 0
    [proto_text_fetched_double] => 0
    [proto_text_fetched_date] => 0
    [proto_text_fetched_year] => 0
    [proto_text_fetched_time] => 0
    [proto_text_fetched_datetime] => 0
    [proto_text_fetched_timestamp] => 0
    [proto_text_fetched_string] => 0
    [proto_text_fetched_blob] => 0
    [proto_text_fetched_enum] => 0
    [proto_text_fetched_set] => 0
    [proto_text_fetched_geometry] => 0
    [proto_text_fetched_other] => 0
    [proto_binary_fetched_null] => 0
    [proto_binary_fetched_bit] => 0
    [proto_binary_fetched_tinyint] => 0
    [proto_binary_fetched_short] => 0
    [proto_binary_fetched_int24] => 0
    [proto_binary_fetched_int] => 0
    [proto_binary_fetched_bigint] => 0
    [proto_binary_fetched_decimal] => 0
    [proto_binary_fetched_float] => 0
    [proto_binary_fetched_double] => 0
    [proto_binary_fetched_date] => 0
    [proto_binary_fetched_year] => 0
    [proto_binary_fetched_time] => 0
    [proto_binary_fetched_datetime] => 0
    [proto_binary_fetched_timestamp] => 0
    [proto_binary_fetched_string] => 0
    [proto_binary_fetched_blob] => 0
    [proto_binary_fetched_enum] => 0
    [proto_binary_fetched_set] => 0
    [proto_binary_fetched_geometry] => 0
    [proto_binary_fetched_other] => 0
)


          

See Also

Stats description

22.10.2.12.13. mysqli_get_metadata

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_get_metadata

    Alias for mysqli_stmt_result_metadata

Description

This function is an alias of mysqli_stmt_result_metadata.

Notes

Note

mysqli_get_metadata is deprecated and will be removed.

See Also

mysqli_stmt_result_metadata

22.10.2.12.14. mysqli_master_query

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_master_query

    Enforce execution of a query on the master in a master/slave setup

Description

bool mysqli_master_query(mysqli link,
                         string query);
Warning

This function is currently not documented; only its argument list is available.

Warning

This function has been DEPRECATED and REMOVED as of PHP 5.3.0.

22.10.2.12.15. mysqli_param_count

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_param_count

    Alias for mysqli_stmt_param_count

Description

This function is an alias of mysqli_stmt_param_count.

Notes

Note

mysqli_param_count is deprecated and will be removed.

See Also

mysqli_stmt_param_count

22.10.2.12.16. mysqli_report

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_report

    Enables or disables internal report functions

Description

bool mysqli_report(int flags);

mysqli_report is a powerful function to improve your queries and code during development and testing phase. Depending on the flags it reports errors from mysqli function calls or queries which don't use an index (or use a bad index).

Parameters

flags

Table 22.18. Supported flags

NameDescription
MYSQLI_REPORT_OFFTurns reporting off
MYSQLI_REPORT_ERRORReport errors from mysqli function calls
MYSQLI_REPORT_STRICTThrow mysqli_sql_exception for errors instead of warnings
MYSQLI_REPORT_INDEXReport if no index or bad index was used in a query
MYSQLI_REPORT_ALLSet all options (report all)

Return Values

Returns TRUE on success or FALSE on failure.

Changelog

VersionDescription
5.2.15 & 5.3.4Changing the reporting mode is now be per-request, rather than per-process.

Examples

Example 22.153. Object oriented style

<?php
/* activate reporting */
mysqli_report(MYSQLI_REPORT_ALL);

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

/* this query should report an error */
$result = $mysqli->query("SELECT Name FROM Nonexistingtable WHERE population > 50000");

/* this query should report a bad index */
$result = $mysqli->query("SELECT Name FROM City WHERE population > 50000");
$result->close();

$mysqli->close();
?>

    

See Also

MySQLi_Driver::$report_mode
mysqli_debug
mysqli_dump_debug_info

22.10.2.12.17. mysqli_rpl_parse_enabled

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_rpl_parse_enabled

    Check if RPL parse is enabled

Description

int mysqli_rpl_parse_enabled(mysqli link);
Warning

This function is currently not documented; only its argument list is available.

Warning

This function has been DEPRECATED and REMOVED as of PHP 5.3.0.

22.10.2.12.18. mysqli_rpl_probe

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_rpl_probe

    RPL probe

Description

bool mysqli_rpl_probe(mysqli link);
Warning

This function is currently not documented; only its argument list is available.

Warning

This function has been DEPRECATED and REMOVED as of PHP 5.3.0.

22.10.2.12.19. mysqli_rpl_query_type, mysqli->rpl_query_type

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_rpl_query_type

    mysqli->rpl_query_type

    Returns RPL query type

Description

Object oriented style

 mysqli {
  int rpl_query_type(string query);
}

Procedural style

int mysqli_rpl_query_type(mysqli link,
                          string query);

Returns MYSQLI_RPL_MASTER , MYSQLI_RPL_SLAVE or MYSQLI_RPL_ADMIN depending on a query type. INSERT, UPDATE and similar are master queries, SELECT is slave, and FLUSH, REPAIR and similar are admin.

Warning

This function is currently not documented; only its argument list is available.

Warning

This function has been DEPRECATED and REMOVED as of PHP 5.3.0.

22.10.2.12.20. mysqli_send_long_data

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_send_long_data

    Alias for mysqli_stmt_send_long_data

Description

This function is an alias of mysqli_stmt_send_long_data.

Notes

Note

mysqli_send_long_data is deprecated and will be removed.

See Also

mysqli_stmt_send_long_data

22.10.2.12.21. mysqli_send_query, mysqli->send_query

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_send_query

    mysqli->send_query

    Send the query and return

Description

Object oriented style

 mysqli {
  bool send_query(string query);
}

Procedural style

bool mysqli_send_query(mysqli link,
                       string query);
Warning

This function is currently not documented; only its argument list is available.

Warning

This function has been DEPRECATED and REMOVED as of PHP 5.3.0.

22.10.2.12.22. mysqli_set_opt

Copyright 1997-2010 the PHP Documentation Group.

Description

This function is an alias of mysqli_options.

22.10.2.12.23. mysqli_slave_query

Copyright 1997-2010 the PHP Documentation Group.

  • mysqli_slave_query

    Force execution of a query on a slave in a master/slave setup

Description

bool mysqli_slave_query(mysqli link,
                        string query);
Warning

This function is currently not documented; only its argument list is available.

Warning

This function has been DEPRECATED and REMOVED as of PHP 5.3.0.

Copyright © 2010-2024 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout