无涯教程-PHP - mysqli options函数

39 阅读1分钟

mysqli options - 语法

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

它用于设置连接选项和更改连接设置

Sr.No 参数 & Description
1

link

它指定要使用的MySQL连接

2

options

它指定选项集

3

value

它指定选项的值

mysqli options - 返回值

成功时返回TRUE,失败时返回FALSE。

mysqli options - 示例

<?php
   $connection_mysql=mysqli_init();

if (!connectionmysql</span><spanclass="pun">)</span><spanclass="pln"></span><spanclass="kwd">die</span><spanclass="pun">(</span><spanclass="str">"mysqliinitfailed"</span><spanclass="pun">);</span><spanclass="pln"></span><spanclass="pun"></span><spanclass="pln">mysqlioptions</span><spanclass="pun">(</span><spanclass="pln">connection_mysql</span><span class="pun">){</span><span class="pln"> </span><span class="kwd">die</span><span class="pun">(</span><span class="str">"mysqli_init failed"</span><span class="pun">);</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> mysqli_options</span><span class="pun">(</span><span class="pln">connection_mysql,MYSQLI_READ_DEFAULT_FILE,"configure.cnf");

if (!mysqli_real_connect(connectionmysql</span><spanclass="pun">,</span><spanclass="str">"localhost"</span><spanclass="pun">,</span><spanclass="str">"user"</span><spanclass="pun">,</span><spanclass="str">"paswword"</span><spanclass="pun">,</span><spanclass="str">"db"</span><spanclass="pun">))</span><spanclass="pln"></span><spanclass="kwd">die</span><spanclass="pun">(</span><spanclass="str">"ConnectError:"</span><spanclass="pln"></span><spanclass="pun">.</span><spanclass="pln">mysqliconnecterror</span><spanclass="pun">());</span><spanclass="pln"></span><spanclass="pun"></span><spanclass="pln">mysqliclose</span><spanclass="pun">(</span><spanclass="pln">connection_mysql</span><span class="pun">,</span><span class="str">"localhost"</span><span class="pun">,</span><span class="str">"user"</span><span class="pun">,</span><span class="str">"paswword"</span><span class="pun">,</span><span class="str">"db"</span><span class="pun">)){</span><span class="pln"> </span><span class="kwd">die</span><span class="pun">(</span><span class="str">"Connect Error: "</span><span class="pln"> </span><span class="pun">.</span><span class="pln"> mysqli_connect_error</span><span class="pun">());</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> mysqli_close</span><span class="pun">(</span><span class="pln">connection_mysql); ?>

参考链接

www.learnfk.com/php/php-fun…