Lines Matching refs:query
17 $mysqli->query('DROP TABLE IF EXISTS test');
18 $mysqli->query('CREATE TABLE test (first int) ENGINE = InnoDB');
19 $mysqli->query('INSERT INTO test VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9)');
22 $mysqli->query("SET innodb_lock_wait_timeout = 1");
23 $mysqli->query("START TRANSACTION");
24 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
25 echo "Running query on $name\n";
26 $stmt = $mysqli->prepare($query);
36 $mysqli->query("SET innodb_lock_wait_timeout = 1");
37 $mysqli->query("START TRANSACTION");
38 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
39 echo "Running query on $name\n";
40 $stmt = $mysqli->prepare($query);
50 $mysqli->query("SET innodb_lock_wait_timeout = 1");
51 $mysqli->query("START TRANSACTION");
52 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
53 echo "Running query on $name\n";
55 $res = $mysqli->query($query);
62 $mysqli->query("SET innodb_lock_wait_timeout = 1");
63 $mysqli->query("START TRANSACTION");
64 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
65 echo "Running query on $name\n";
66 $stmt = $mysqli->prepare($query);
77 $mysqli->query("SET innodb_lock_wait_timeout = 1");
78 $mysqli->query("START TRANSACTION");
79 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
80 echo "Running query on $name\n";
81 $res = $mysqli->query($query, MYSQLI_USE_RESULT);
109 // try it again with unprepared query
120 // try it again with unprepared query
147 Running query on first connection
149 Running query on second connection
152 Running query on first connection
154 Running query on second connection
157 Running query on first connection
159 Running query on second connection
162 Running query on first connection
164 Running query on second connection
167 Running query on first connection
169 Running query on second connection
