Lines Matching refs:mysqli_query
9 mysqli_query($link, 'DROP USER pcontest');
10 mysqli_query($link, 'DROP USER pcontest@localhost');
12 if (!mysqli_query($link, 'CREATE USER pcontest@"%" IDENTIFIED BY "pcontest"') ||
13 !mysqli_query($link, 'CREATE USER pcontest@localhost IDENTIFIED BY "pcontest"')) {
20 if (!mysqli_query($link, sprintf("GRANT SELECT ON TABLE %s.test TO pcontest@'%%'", $db)) ||
21 … !mysqli_query($link, sprintf("GRANT SELECT ON TABLE %s.test TO pcontest@'localhost'", $db))) {
23 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
24 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@localhost');
25 mysqli_query($link, 'DROP USER pcontest@localhost');
26 mysqli_query($link, 'DROP USER pcontest');
32 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
33 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@localhost');
34 mysqli_query($link, 'DROP USER pcontest@localhost');
35 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))) {
87 if (!$res = mysqli_query($plink, 'SELECT id, label FROM test WHERE id = 1'))
98 if ((!mysqli_query($link, 'SET PASSWORD FOR pcontest = "newpass"') &&
99 !mysqli_query($link, 'SET PASSWORD FOR pcontest = PASSWORD("newpass")'))||
100 !mysqli_query($link, 'FLUSH PRIVILEGES'))
104 if ((!mysqli_query($link, 'SET PASSWORD FOR pcontest@localhost = "newpass"') &&
105 !mysqli_query($link, 'SET PASSWORD FOR pcontest@localhost = PASSWORD("newpass")')) ||
106 !mysqli_query($link, 'FLUSH PRIVILEGES'))
111 if (!mysqli_query($link, sprintf('KILL %d', $pthread_id)))
116 if (!$res = mysqli_query($link, "SHOW FULL PROCESSLIST"))
160 if (!$res = mysqli_query($plink, 'SELECT id, label FROM test WHERE id = 1'))
188 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
189 mysqli_query($link, 'DROP USER pcontest');
199 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
202 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
203 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@localhost');
204 mysqli_query($link, 'DROP USER pcontest@localhost');
205 mysqli_query($link, 'DROP USER pcontest');