Lines Matching refs:mysqli_query
10 mysqli_query($link, 'DROP USER pcontest');
11 mysqli_query($link, 'DROP USER pcontest@localhost');
13 if (!mysqli_query($link, 'CREATE USER pcontest@"%" IDENTIFIED BY "pcontest"') ||
14 !mysqli_query($link, 'CREATE USER pcontest@localhost IDENTIFIED BY "pcontest"')) {
21 if (!mysqli_query($link, sprintf("GRANT SELECT ON TABLE %s.test TO pcontest@'%%'", $db)) ||
22 !mysqli_query($link, sprintf("GRANT SELECT ON TABLE %s.test TO pcontest@'localhost'", $db))) {
24 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
25 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@localhost');
26 mysqli_query($link, 'DROP USER pcontest@localhost');
27 mysqli_query($link, 'DROP USER pcontest');
33 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
34 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@localhost');
35 mysqli_query($link, 'DROP USER pcontest@localhost');
36 mysqli_query($link, 'DROP USER pcontest');
52 if (!mysqli_query($link, 'DROP USER pcontest') ||
53 !mysqli_query($link, 'DROP USER pcontest@localhost') ||
54 !mysqli_query($link, 'CREATE USER pcontest@"%" IDENTIFIED BY "pcontest"') ||
55 !mysqli_query($link, 'CREATE USER pcontest@localhost IDENTIFIED BY "pcontest"') ||
56 !mysqli_query($link, sprintf("GRANT SELECT ON TABLE %s.test TO pcontest@'%%'", $db)) ||
57 !mysqli_query($link, sprintf("GRANT SELECT ON TABLE %s.test TO pcontest@'localhost'", $db))) {
84 if (!$res = mysqli_query($plink, 'SELECT id, label FROM test WHERE id = 1'))
95 if (!mysqli_query($link, 'SET PASSWORD FOR pcontest = PASSWORD("newpass")') ||
96 !mysqli_query($link, 'FLUSH PRIVILEGES'))
100 if (!mysqli_query($link, 'SET PASSWORD FOR pcontest@localhost = PASSWORD("newpass")') ||
101 !mysqli_query($link, 'FLUSH PRIVILEGES'))
106 if (!mysqli_query($link, sprintf('KILL %d', $pthread_id)))
111 if (!$res = mysqli_query($link, "SHOW FULL PROCESSLIST"))
155 if (!$res = mysqli_query($plink, 'SELECT id, label FROM test WHERE id = 1'))
183 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
184 mysqli_query($link, 'DROP USER pcontest');
194 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
197 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
198 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@localhost');
199 mysqli_query($link, 'DROP USER pcontest@localhost');
200 mysqli_query($link, 'DROP USER pcontest');