Lines Matching refs:query
18 $mysqli->query('DROP TABLE IF EXISTS test');
19 $mysqli->query('CREATE TABLE test (first int) ENGINE = InnoDB');
20 $mysqli->query('INSERT INTO test VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9)');
23 $mysqli->query("SET innodb_lock_wait_timeout = 1");
24 $mysqli->query("START TRANSACTION");
25 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
26 echo "Running query on $name\n";
27 $stmt = $mysqli->prepare($query);
37 $mysqli->query("SET innodb_lock_wait_timeout = 1");
38 $mysqli->query("START TRANSACTION");
39 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
40 echo "Running query on $name\n";
41 $stmt = $mysqli->prepare($query);
51 $mysqli->query("SET innodb_lock_wait_timeout = 1");
52 $mysqli->query("START TRANSACTION");
53 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
54 echo "Running query on $name\n";
56 $res = $mysqli->query($query);
63 $mysqli->query("SET innodb_lock_wait_timeout = 1");
64 $mysqli->query("START TRANSACTION");
65 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
66 echo "Running query on $name\n";
67 $stmt = $mysqli->prepare($query);
78 $mysqli->query("SET innodb_lock_wait_timeout = 1");
79 $mysqli->query("START TRANSACTION");
80 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
81 echo "Running query on $name\n";
82 $res = $mysqli->query($query, MYSQLI_USE_RESULT);
110 // try it again with unprepared query
121 // try it again with unprepared query
148 Running query on first connection
150 Running query on second connection
153 Running query on first connection
155 Running query on second connection
158 Running query on first connection
160 Running query on second connection
163 Running query on first connection
165 Running query on second connection
168 Running query on first connection
170 Running query on second connection
