PHP: mysqli_options - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

mysqli_param_count mysqli_num_rows

Last updated: Fri, 26 Jan 2007

view this page in

# mysqli_options

(PHP 5)

mysqli_options

(no version information, might be only in CVS)

mysqli->options -- Set options

## Description

Procedural style:

bool mysqli_options ( mysqli link, int option, mixed value )

Object oriented style (method)

class mysqli {
bool options ( int option, mixed value )
}

mysqli_options() can be used to set extra connect options and affect behavior for a connection.

This function may be called multiple times to set several options.

mysqli_options() should be called after mysqli_init() and before mysqli_real_connect().

The parameter `option` is the option that you want to set, the `value` is the value for the option. The parameter `option` can be one of the following values:

Таблица 1. Valid options

Name | Description
--- | ---
`MYSQLI_OPT_CONNECT_TIMEOUT` | connection timeout in seconds
`MYSQLI_OPT_LOCAL_INFILE` | enable/disable use of `LOAD LOCAL INFILE`
`MYSQLI_INIT_COMMAND` | command to execute after when connecting to MySQL server
`MYSQLI_READ_DEFAULT_FILE` | Read options from named option file instead of `my.cnf`
`MYSQLI_READ_DEFAULT_GROUP` | Read options from the named group from `my.cnf` or the file specified with `MYSQL_READ_DEFAULT_FILE`.

## Возвращаемые значения

Возвращает `TRUE` в случае успешного завершения или `FALSE` в случае возникновения ошибки.

## Смотрите также

mysqli_init() и mysqli_real_connect().

## Примеры

See mysqli_real_connect().

add a note User Contributed Notes
mysqli_options
fluppy
07-Mar-2007 02:46
`Here es little example to create a SSL Connection
<?php
$db = mysqlii_init();
/*
When you want so use a separate cnf
$test = $db->options(MYSQLI_EAD_DEFAULT_FILE,'myother.cnf');
*/
$db->ssl_set('server-key.pem','server-cert.pem',
'cacert.pem',NULL,NULL);
$db->real_connct('localhost','root','','mydb');
//Here some query
$db->close();
?>`
add a note
mysqli_param_count mysqli_num_rows

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST