PHP my_mysqli_real_connect函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中my_mysqli_real_connect函数的典型用法代码示例。如果您正苦于以下问题：PHP my_mysqli_real_connect函数的具体用法？PHP my_mysqli_real_connect怎么用？PHP my_mysqli_real_connect使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了my_mysqli_real_connect函数的7个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: test_fetch

function test_fetch($host, $user, $passwd, $db, $port, $socket, $engine, $flags = null)
{
    $link = mysqli_init();
    if (!my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket, $flags)) {
        printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket);
        return false;
    }
    if (!mysqli_query($link, "DROP TABLE IF EXISTS test") || !mysqli_query($link, sprintf("CREATE TABLE test(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, label VARCHAR(255)) ENGINE = %s", $engine))) {
        printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        return false;
    }
    $package_size = 524288;
    $offset = 3;
    $limit = ini_get('memory_limit') > 0 ? parse_memory_limit(ini_get('memory_limit')) : pow(2, 32);
    /* try to respect php.ini but make run time a soft limit */
    $max_runtime = ini_get('max_execution_time') > 0 ? ini_get('max_execution_time') : 30;
    set_time_limit(0);
    do {
        if ($package_size > $limit) {
            printf("stop: memory limit - %s vs. %s\n", $package_size, $limit);
            break;
        }
        $start = microtime(true);
        if (!mysqli_fetch_array_large($offset++, $link, $package_size)) {
            printf("stop: packet size - %d\n", $package_size);
            break;
        }
        $duration = microtime(true) - $start;
        $max_runtime -= $duration;
        if ($max_runtime < $duration * 3) {
            /* likely the next iteration will not be within max_execution_time */
            printf("stop: time limit - %2.2fs\n", $max_runtime);
            break;
        }
        $package_size += $package_size;
    } while (true);
    mysqli_close($link);
    return true;
}

开发者ID:gleamingthecube，项目名称:php，代码行数:39，代码来源:ext_mysqli_tests_mysqli_fetch_array_large.php

示例2: printf

    if (!($res = mysqli_query($link, "SELECT id FROM test"))) {
        printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        continue;
    }
    $row = mysqli_fetch_assoc($res);
    mysqli_free_result($res);
    if ($row['id'] !== $data[1]) {
        printf("[007] Expecting %s - %s/%s got %s/%s\n", $name, $data[1], gettype($data[1]), $row['id'], gettype($row['id']));
    }
    mysqli_close($link);
    $link = mysqli_init();
    if (!mysqli_options($link, MYSQLI_OPT_INT_AND_FLOAT_NATIVE, 0)) {
        printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        continue;
    }
    if (!my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket)) {
        printf("[009] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
        continue;
    }
    if (!($res = mysqli_query($link, "SELECT id FROM test"))) {
        printf("[010] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        continue;
    }
    $row = mysqli_fetch_assoc($res);
    mysqli_free_result($res);
    if (!is_string($row['id']) || $row['id'] != $data[1]) {
        printf("[011] Expecting %s - %s/string got %s/%s\n", $name, $data[1], $row['id'], gettype($row['id']));
    }
    mysqli_close($link);
}
print "done!";

开发者ID:gleamingthecube，项目名称:php，代码行数:31，代码来源:ext_mysqli_tests_mysqli_options_int_and_float_native.php

示例3: printf

<?php

require_once "connect.inc";
$host = 'p:' . $host;
if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) {
    printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket);
}
if (true !== ($tmp = my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket))) {
    printf("[003] Expecting boolean/true got %s/%s\n", gettype($tmp), $tmp);
}
/* it is undefined which pooled connection we get - thread ids may differ */
if (!($res = mysqli_query($link, "SELECT 'ok' AS it_works")) || !($row = mysqli_fetch_assoc($res))) {
    printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
var_dump($row);
mysqli_free_result($res);
mysqli_close($link);
if (!($link = new my_mysqli($host, $user, $passwd, $db, $port, $socket))) {
    printf("[007] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket);
}
if (true !== ($tmp = $link->real_connect($host, $user, $passwd, $db, $port, $socket))) {
    printf("[009] Expecting boolean/true got %s/%s\n", gettype($tmp), $tmp);
}
/* it is undefined which pooled connection we get - thread ids may differ */
if (!($res = $link->query("SELECT 'works also with oo' AS syntax")) || !($row = $res->fetch_assoc())) {
    printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
var_dump($row);
mysqli_free_result($res);
mysqli_close($link);
if (NULL !== ($tmp = $link->connect($host, $user, $passwd, $db, $port, $socket))) {

开发者ID:badlamer，项目名称:hhvm，代码行数:31，代码来源:mysqli_pconn_twice.php

示例4: printf

    printf("[004] Connect should fail, [%d] %s\n", $link->errno, $link->error);
}
/* allow connect */
$link = mysqli_init();
$link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 1);
if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) {
    printf("[005] Cannot connect [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
} else {
    $link->query("SELECT id FROM test WHERE id = 1");
    printf("[006] Connect allowed, query fail, [%d] %s\n", $link->errno, $link->error);
    $link->close();
}
/* allow connect, fix pw */
$link = mysqli_init();
$link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 1);
if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) {
    printf("[007] Cannot connect [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
} else {
    $link->query("SET PASSWORD=PASSWORD('expiretest')");
    printf("[008] Connect allowed, pw set, [%d] %s\n", $link->errno, $link->error);
    if ($res = $link->query("SELECT id FROM test WHERE id = 1")) {
        var_dump($res->fetch_assoc());
    }
    $link->close();
}
/* check login */
if (!($link = my_mysqli_connect($host, 'expiretest', "expiretest", $db, $port, $socket))) {
    printf("[001] Cannot connect [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
} else {
    $link->query("SELECT id FROM test WHERE id = 1");
    if ($res = $link->query("SELECT id FROM test WHERE id = 1")) {

开发者ID:gleamingthecube，项目名称:php，代码行数:31，代码来源:ext_mysqli_tests_mysqli_expire_password.php

示例5: mysqli_report

// Check that none of the above would have caused any error messages if MYSQL_REPORT_ERROR would
// not have been set. If that would be the case, the test would be broken.
mysqli_report(MYSQLI_REPORT_OFF);
mysqli_multi_query($link, "BAR; FOO;");
mysqli_query($link, "FOO");
mysqli_change_user($link, "This might work if you accept anonymous users in your setup", "password", $db);
mysqli_kill($link, -1);
mysqli_real_query($link, "FOO");
mysqli_select_db($link, "Oh lord, let this be an unknown database name");
mysqli_report(MYSQLI_REPORT_OFF);
mysqli_report(MYSQLI_REPORT_STRICT);
try {
    if ($link = my_mysqli_connect($host, $user . 'unknown_really', $passwd . 'non_empty', $db, $port, $socket)) {
        printf("[010] Can connect to the server using host=%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n", $host, $user . 'unknown_really', $db, $port, $socket);
    }
    mysqli_close($link);
} catch (mysqli_sql_exception $e) {
    printf("[011] %s\n", $e->getMessage());
}
try {
    if (!($link = mysqli_init())) {
        printf("[012] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
    }
    if ($link = my_mysqli_real_connect($link, $host, $user . 'unknown_really', $passwd . 'non_empty', $db, $port, $socket)) {
        printf("[013] Can connect to the server using host=%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n", $host, $user . 'unknown_really', $db, $port, $socket);
    }
    mysqli_close($link);
} catch (mysqli_sql_exception $e) {
    printf("[014] %s\n", $e->getMessage());
}
print "done!";

开发者ID:zaky-92，项目名称:php-1，代码行数:31，代码来源:ext_mysqli_tests_mysqli_report_wo_ps.php

示例6: mysqli

<?php

include "connect.inc";
$db1 = new mysqli();
$flags = MYSQLI_CLIENT_SSL;
$link = mysqli_init();
mysqli_ssl_set($link, null, null, null, null, "RC4-MD5");
if (my_mysqli_real_connect($link, 'p:' . $host, $user, $passwd, $db, $port, null, $flags)) {
    $r = $link->query("SHOW STATUS LIKE 'Ssl_cipher'");
    var_dump($r->fetch_row());
}
/* non-persistent connection */
$link2 = mysqli_init();
mysqli_ssl_set($link2, null, null, null, null, "RC4-MD5");
if (my_mysqli_real_connect($link2, $host, $user, $passwd, $db, $port, null, $flags)) {
    $r2 = $link2->query("SHOW STATUS LIKE 'Ssl_cipher'");
    var_dump($r2->fetch_row());
}
echo "done\n";

开发者ID:alphaxxl，项目名称:hhvm，代码行数:19，代码来源:bug55283.php

示例7: mysqli

<?php

include "connect.inc";
$db1 = new mysqli();
// These calls fail
$db1->options(MYSQLI_OPT_CONNECT_TIMEOUT, 3);
my_mysqli_real_connect($db1, $host, $user, $passwd, $db, $port, $socket);
if (mysqli_connect_error()) {
    echo "error 1\n";
} else {
    echo "ok 1\n";
}
$db2 = mysqli_init();
$db2->options(MYSQLI_OPT_CONNECT_TIMEOUT, 3);
my_mysqli_real_connect($db2, $host, $user, $passwd, $db, $port, $socket);
if (mysqli_connect_error()) {
    echo "error 2\n";
} else {
    echo "ok 2\n";
}
echo "done\n";

开发者ID:alphaxxl，项目名称:hhvm，代码行数:21，代码来源:bug50772.php

注：本文中的my_mysqli_real_connect函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP my_number_format函数代码示例发布时间：2022-05-15

PHP my_mysqli_connect函数代码示例发布时间：2022-05-15

CVE-2022-30221

1 bradtraversy/iweather: Ionic 3 mobile we

bradtraversy/iweather: Ionic 3 mobile weather app

阅读：1571|2022-08-30

2 joaomh/curso-de-matlab

joaomh/curso-de-matlab

阅读：1141|2022-08-17

3 断牙刷新位置时间（断牙属性及刷新位置介绍

魔兽世界怀旧服已经开启两个多月了，但作为一个猎人玩家，抓到“断牙”，已经成为了一

阅读：997|2022-11-06

4 rugk/mastodon-simplified-federation: Sim

rugk/mastodon-simplified-federation: Simplifies following and interacting with r

阅读：1069|2022-08-17

5 小程序自适应布局开发，注意点（待搜索资料

设计图中宽为750px的图片，可以直接设置：宽为100%，高为图片高度加上rpx。定位时，使

阅读：536|2022-07-18

6 MATLAB和C语言混合编程-----Matlab7.0编译

(1)mex命令设置(a)运行Matlab，在Matlab的命令窗口(CommandWindow)键入“mex-setup”

阅读：962|2022-07-18

7 CVE-2022-33011

Known v1.3.1+2020120201 was discovered to allow attackers to perform an account

阅读：1693|2022-07-29

8 Tangshitao/Dense-Scene-Matching: Learnin

Tangshitao/Dense-Scene-Matching: Learning Camera Localization via Dense Scene Ma

阅读：751|2022-08-16

9 Respring是什么意思?没有越狱设备如何 Resp

相信不少果粉在对自己的设备进行某些操作时，都会碰到Respring，但这个 Respring 到底

阅读：359|2022-11-06

10 lightningtgc/MProgress.js: Material Prog

lightningtgc/MProgress.js: Material Progress —Google Material Design Progress l

阅读：398|2022-08-17

客服电话

电子邮件

PHP my_mysqli_real_connect函数代码示例

示例1: test_fetch

示例2: printf

示例3: printf

示例4: printf

示例5: mysqli_report

示例6: mysqli

示例7: mysqli

请发表评论

全部评论

上一篇：

下一篇：

bradtraversy/iweather: Ionic 3 mobile we

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

rugk/mastodon-simplified-federation: Sim

小程序自适应布局开发，注意点（待搜索资料

CVE-2022-30221

rapidsai/cuml: cuML - RAPIDS Machine Lea

librespeed/speedtest: Self-hosted Speedt

avehtari/BDA_m_demos: Bayesian Data Anal

四维彩超怎么看性别？四维看男孩女孩诀窍

medfreeman/markdown-it-toc-and-anchor: m

关于我们

产品与服务

解决方案

139-2527-9053