mysqli_stmt_affected_rows.phpt - OpenGrok cross reference for /PHP-8.3/ext/mysqli/tests/mysqli_stmt_affected

Lines Matching refs:stmt
17     $stmt = mysqli_stmt_init($link);
19     if (!mysqli_stmt_prepare($stmt, 'DROP TABLE IF EXISTS test') ||
20         !mysqli_stmt_execute($stmt)) {
21 …03] Failed to drop old test table: [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
24 …if (!mysqli_stmt_prepare($stmt, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE …
25         !mysqli_stmt_execute($stmt)) {
26 …[004] Failed to create test table: [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
29     if (0 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
32     mysqli_stmt_close($stmt);
33     $stmt = mysqli_stmt_init($link);
35     if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (1, 'a')") ||
36         !mysqli_stmt_execute($stmt))
37         printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
39     mysqli_stmt_close($stmt);
40     $stmt = mysqli_stmt_init($link);
42     if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (100, 'z')") ||
43         !mysqli_stmt_execute($stmt))
44         printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
46     if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
49     mysqli_stmt_close($stmt);
50     $stmt = mysqli_stmt_init($link);
52     if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (100, 'z')") ||
53         !mysqli_stmt_execute($stmt))
55 … message varies with the MySQL Server version, check the error code)\n", mysqli_stmt_errno($stmt));
58     if (-1 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
61     mysqli_stmt_close($stmt);
62     $stmt = mysqli_stmt_init($link);
64 …if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDA…
65         !mysqli_stmt_execute($stmt))
66         printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
68     if (2 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
71     mysqli_stmt_close($stmt);
72     $stmt = mysqli_stmt_init($link);
74     if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')") ||
75         !mysqli_stmt_execute($stmt))
76         printf("[013] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
78     if (2 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
81     mysqli_stmt_close($stmt);
82     $stmt = mysqli_stmt_init($link);
84     if (!mysqli_stmt_prepare($stmt, "INSERT IGNORE INTO test(id, label) VALUES (1, 'a')") ||
85         !mysqli_stmt_execute($stmt))
86         printf("[015] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
88     if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
97     mysqli_stmt_close($stmt);
98     $stmt = mysqli_stmt_init($link);
100 …  if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) SELECT id + 10, label FROM test") ||
101         !mysqli_stmt_execute($stmt))
102         printf("[018] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
104     if ($num !== ($tmp = mysqli_stmt_affected_rows($stmt)))
107     mysqli_stmt_close($stmt);
108     $stmt = mysqli_stmt_init($link);
110     if (!mysqli_stmt_prepare($stmt, "REPLACE INTO test(id, label) values (4, 'd')") ||
111         !mysqli_stmt_execute($stmt))
112         printf("[020] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
114     if (2 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
117     mysqli_stmt_close($stmt);
118     $stmt = mysqli_stmt_init($link);
120     if (!mysqli_stmt_prepare($stmt, "REPLACE INTO test(id, label) values (5, 'e')") ||
121         !mysqli_stmt_execute($stmt))
122         printf("[022] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
124     if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
127     mysqli_stmt_close($stmt);
128     $stmt = mysqli_stmt_init($link);
130     if (!mysqli_stmt_prepare($stmt, "UPDATE test SET label = 'a' WHERE id = 2") ||
131         !mysqli_stmt_execute($stmt))
132         printf("[024] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
134     if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
137     if (!mysqli_stmt_prepare($stmt, "UPDATE test SET label = 'a' WHERE id = 2") ||
138         !mysqli_stmt_execute($stmt))
139         printf("[026] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
141     if (0 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
144     mysqli_stmt_close($stmt);
145     $stmt = mysqli_stmt_init($link);
147     if (!mysqli_stmt_prepare($stmt, "UPDATE test SET label = 'a' WHERE id = 100") ||
148         !mysqli_stmt_execute($stmt))
149         printf("[028] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
151     if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
154     if (!mysqli_stmt_prepare($stmt, 'SELECT label FROM test WHERE id = 100') ||
155         !mysqli_stmt_execute($stmt))
156         printf("[030] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
160     if (-1 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
163     if (0 !== ($tmp = mysqli_stmt_num_rows($stmt)))
166     if (!mysqli_stmt_store_result($stmt))
167         printf("[033] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
169     if (1 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
172     if (1 !== ($tmp = mysqli_stmt_num_rows($stmt)))
175     mysqli_stmt_free_result($stmt);
176     mysqli_stmt_close($stmt);
177     $stmt = mysqli_stmt_init($link);
179     if (!mysqli_stmt_prepare($stmt, 'SELECT label FROM test WHERE 1 = 2') ||
180         !mysqli_stmt_execute($stmt))
181         printf("[036] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
184     if (-1 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
187     if (true !== ($tmp = mysqli_stmt_store_result($stmt)))
190     if (0 !== ($tmp = mysqli_stmt_num_rows($stmt)))
193     if (0 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
198     if (mysqli_stmt_prepare($stmt, 'SELECT unknown_column FROM this_table_does_not_exist') ||
199         mysqli_stmt_execute($stmt))
202     if (-1 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
205     if (true !== ($tmp = mysqli_stmt_store_result($stmt)))
208     if (0 !== ($tmp = mysqli_stmt_num_rows($stmt)))
211     if (-1 !== ($tmp = mysqli_stmt_affected_rows($stmt)))
214     mysqli_stmt_close($stmt);
215     $stmt = mysqli_stmt_init($link);
217     if (!mysqli_stmt_prepare($stmt, "DROP TABLE IF EXISTS test") ||
218         !mysqli_stmt_execute($stmt))
219         printf("[046] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
221     mysqli_stmt_close($stmt);
224         mysqli_stmt_affected_rows($stmt);