mysqli_affected_rows.phpt - OpenGrok cross reference for /PHP-8.0/ext/mysqli/tests/mysqli_affected

Lines Matching refs:link
12     if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
16     if (0 !== ($tmp = mysqli_affected_rows($link)))
18             gettype($tmp), $tmp, mysqli_errno($link), mysqli_error($link));
20     if (!mysqli_query($link, 'DROP TABLE IF EXISTS test'))
21         printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
23 …if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE = ' . $…
24         printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
26     if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a')"))
27         printf("[008] [%d] %s\n",  mysqli_errno($link), mysqli_error($link));
29     if (1 !== ($tmp = mysqli_affected_rows($link)))
33     mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a')");
34     if (-1 !== ($tmp = mysqli_affected_rows($link)))
37 …if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id =…
38         printf("[012] [%d] %s\n",  mysqli_errno($link), mysqli_error($link));
40     if (2 !== ($tmp = mysqli_affected_rows($link)))
43     if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')"))
44         printf("[014] [%d] %s\n",  mysqli_errno($link), mysqli_error($link));
46     if (2 !== ($tmp = mysqli_affected_rows($link)))
49     if (!mysqli_query($link, "INSERT IGNORE INTO test(id, label) VALUES (1, 'a')")) {
50         printf("[016] [%d] %s\n",  mysqli_errno($link), mysqli_error($link));
53     if (1 !== ($tmp = mysqli_affected_rows($link)))
56     if (!mysqli_query($link, "INSERT INTO test(id, label) SELECT id + 10, label FROM test"))
57         printf("[018] [%d] %s\n",  mysqli_errno($link), mysqli_error($link));
59     if (4 !== ($tmp = mysqli_affected_rows($link)))
62     if (!mysqli_query($link, "REPLACE INTO test(id, label) values (4, 'd')"))
63         printf("[020] [%d] %s\n",  mysqli_errno($link), mysqli_error($link));
65     if (2 !== ($tmp = mysqli_affected_rows($link)))
68     if (!mysqli_query($link, "REPLACE INTO test(id, label) values (5, 'e')"))
69         printf("[022] [%d] %s\n",  mysqli_errno($link), mysqli_error($link));
71     if (1 !== ($tmp = mysqli_affected_rows($link)))
74     if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 2"))
75         printf("[024] [%d] %s\n",  mysqli_errno($link), mysqli_error($link));
77     if (1 !== ($tmp = mysqli_affected_rows($link)))
82         if (!($res = mysqli_query($link, sprintf("SHOW CHARACTER SET LIKE '%s'", $charset))))
85         if (true !== ($tmp = mysqli_set_charset($link, $charset)))
88         if (0 !== ($tmp = mysqli_affected_rows($link)))
92     if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 2")) {
93         printf("[028] [%d] %s\n",  mysqli_errno($link), mysqli_error($link));
96     if (0 !== ($tmp = mysqli_affected_rows($link)))
99     if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 100")) {
100         printf("[030] [%d] %s\n",  mysqli_errno($link), mysqli_error($link));
103     if (0 !== ($tmp = mysqli_affected_rows($link)))
106     if (!mysqli_query($link, 'DROP TABLE IF EXISTS test'))
107         printf("[032] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
110     mysqli_close($link);
113         mysqli_affected_rows($link);