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))) {
88 if (!$res = mysqli_query($plink, 'SELECT id, label FROM test WHERE id = 1'))
99 if ((!mysqli_query($link, 'SET PASSWORD FOR pcontest = "newpass"') &&
100 !mysqli_query($link, 'SET PASSWORD FOR pcontest = PASSWORD("newpass")'))||
101 !mysqli_query($link, 'FLUSH PRIVILEGES'))
105 if ((!mysqli_query($link, 'SET PASSWORD FOR pcontest@localhost = "newpass"') &&
106 !mysqli_query($link, 'SET PASSWORD FOR pcontest@localhost = PASSWORD("newpass")')) ||
107 !mysqli_query($link, 'FLUSH PRIVILEGES'))
112 if (!mysqli_query($link, sprintf('KILL %d', $pthread_id)))
117 if (!$res = mysqli_query($link, "SHOW FULL PROCESSLIST"))
161 if (!$res = mysqli_query($plink, 'SELECT id, label FROM test WHERE id = 1'))
189 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
190 mysqli_query($link, 'DROP USER pcontest');
200 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
203 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest');
204 mysqli_query($link, 'REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@localhost');
205 mysqli_query($link, 'DROP USER pcontest@localhost');
206 mysqli_query($link, 'DROP USER pcontest');