Lines Matching refs:link
9 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
12 if (mysqli_get_server_version($link) <= 50000) {
13 die(sprintf('skip Needs MySQL 5.0+, found version %d.', mysqli_get_server_version($link)));
21 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
22 printf("[001] [%d] %s.\n", mysqli_errno($link), mysqli_error($link));
24 …if (mysqli_query($link, 'CREATE PROCEDURE p() READS SQL DATA BEGIN SELECT id, label FROM test ORDE…
27 if (mysqli_multi_query($link, 'CALL p()')) {
29 if ($res = mysqli_use_result($link)) {
34 } while (mysqli_more_results($link) && mysqli_next_result($link));
37 printf("[003] Cannot call SP, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
40 if (mysqli_multi_query($link, 'CALL p()')) {
42 if ($res = mysqli_store_result($link)) {
47 } while (mysqli_more_results($link) && mysqli_next_result($link));
50 printf("[004] Cannot call SP, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
53 if (mysqli_multi_query($link, 'CALL p()')) {
55 if ($res = mysqli_store_result($link)) {
62 } while (mysqli_more_results($link) && mysqli_next_result($link));
65 printf("[005] Cannot call SP, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
69 printf("[002] Cannot create SP, [%d] %s.\n", mysqli_errno($link), mysqli_error($link));
72 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
73 printf("[006] [%d] %s.\n", mysqli_errno($link), mysqli_error($link));
75 …if (mysqli_query($link, 'CREATE PROCEDURE p() READS SQL DATA BEGIN SELECT id, label FROM test ORDE…
78 if (mysqli_multi_query($link, 'CALL p()')) {
80 if ($res = mysqli_store_result($link)) {
85 } while (mysqli_more_results($link) && mysqli_next_result($link));
88 printf("[008] Cannot call SP, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
92 printf("[007] Cannot create SP, [%d] %s.\n", mysqli_errno($link), mysqli_error($link));
95 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
96 printf("[009] [%d] %s.\n", mysqli_errno($link), mysqli_error($link));
98 …if (mysqli_real_query($link, 'CREATE PROCEDURE p(OUT ver_param VARCHAR(25)) BEGIN SELECT VERSION()…
100 if (!mysqli_query($link, 'CALL p(@version)'))
101 printf("[011] Cannot call SP, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
103 if (!mysqli_query($link, "SET @version = 'unknown'"))
104 … printf("[012] Cannot reset user variable, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
106 if (!mysqli_query($link, 'CALL p(@version)'))
107 printf("[013] Cannot call SP, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
109 if (!$res = mysqli_query($link, 'SELECT @version as _vers'))
110 … printf("[014] Cannot fetch user variable, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
116 mysqli_errno($link), mysqli_error($link));
120 printf("[010] Cannot create SP, [%d] %s.\n", mysqli_errno($link), mysqli_error($link));
123 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
124 printf("[016] [%d] %s.\n", mysqli_errno($link), mysqli_error($link));
126 …if (mysqli_real_query($link, 'CREATE PROCEDURE p(IN ver_in VARCHAR(25), OUT ver_out VARCHAR(25)) B…
128 if (!mysqli_query($link, "CALL p('myversion', @version)"))
129 printf("[018] Cannot call SP, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
131 if (!mysqli_query($link, "SET @version = 'unknown'"))
132 … printf("[019] Cannot reset user variable, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
134 if (!mysqli_query($link, "CALL p('myversion', @version)"))
135 printf("[020] Cannot call SP, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
137 if (!$res = mysqli_query($link, 'SELECT @version as _vers'))
138 … printf("[021] Cannot fetch user variable, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
144 mysqli_errno($link), mysqli_error($link));
148 printf("[017] Cannot create SP, [%d] %s.\n", mysqli_errno($link), mysqli_error($link));
151 mysqli_close($link);
157 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
160 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
161 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
163 @mysqli_query($link, "DROP PROCEDURE IS EXISTS p");
165 mysqli_close($link);
