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');
51 if (!mysqli_query($link, 'DROP USER pcontest') ||
52 !mysqli_query($link, 'DROP USER pcontest@localhost') ||
53 !mysqli_query($link, 'CREATE USER pcontest@"%" IDENTIFIED BY "pcontest"') ||
54 !mysqli_query($link, 'CREATE USER pcontest@localhost IDENTIFIED BY "pcontest"') ||
55 !mysqli_query($link, sprintf("GRANT SELECT ON TABLE %s.test TO pcontest@'%%'", $db)) ||
56 !mysqli_query($link, sprintf("GRANT SELECT ON TABLE %s.test TO pcontest@'localhost'", $db))) {
75 if (!$res = mysqli_query($plink, 'SELECT id, label FROM test WHERE id = 1'))
86 if (!mysqli_query($link, 'SET PASSWORD FOR pcontest = PASSWORD("newpass")') ||
87 !mysqli_query($link, 'FLUSH PRIVILEGES'))
91 if (!mysqli_query($link, 'SET PASSWORD FOR pcontest@localhost = PASSWORD("newpass")') ||
92 !mysqli_query($link, 'FLUSH PRIVILEGES'))
97 if (!mysqli_query($link, sprintf('KILL %d', $pthread_id)))
102 if (!$res = mysqli_query($link, "SHOW FULL PROCESSLIST"))
134 if (!$res = mysqli_query($plink, 'SELECT id, label FROM test WHERE id = 1'))
160 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
161 mysqli_query($link, 'DROP USER pcontest');
171 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
174 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
175 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@localhost');
176 mysqli_query($link, 'DROP USER pcontest@localhost');
177 mysqli_query($link, 'DROP USER pcontest');