Lines Matching refs:query
19 $mysqli->query('DROP TABLE IF EXISTS test');
20 $mysqli->query('CREATE TABLE test (first int) ENGINE = InnoDB');
21 $mysqli->query('INSERT INTO test VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9)');
24 $mysqli->query("SET innodb_lock_wait_timeout = 1");
25 $mysqli->query("START TRANSACTION");
26 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
27 echo "Running query on $name\n";
28 $stmt = $mysqli->prepare($query);
38 $mysqli->query("SET innodb_lock_wait_timeout = 1");
39 $mysqli->query("START TRANSACTION");
40 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
41 echo "Running query on $name\n";
42 $stmt = $mysqli->prepare($query);
52 $mysqli->query("SET innodb_lock_wait_timeout = 1");
53 $mysqli->query("START TRANSACTION");
54 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
55 echo "Running query on $name\n";
57 $res = $mysqli->query($query);
64 $mysqli->query("SET innodb_lock_wait_timeout = 1");
65 $mysqli->query("START TRANSACTION");
66 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
67 echo "Running query on $name\n";
68 $stmt = $mysqli->prepare($query);
79 $mysqli->query("SET innodb_lock_wait_timeout = 1");
80 $mysqli->query("START TRANSACTION");
81 $query = "SELECT first FROM test WHERE first = 1 FOR UPDATE";
82 echo "Running query on $name\n";
83 $res = $mysqli->query($query, MYSQLI_USE_RESULT);
111 // try it again with unprepared query
122 // try it again with unprepared query
149 Running query on first connection
151 Running query on second connection
154 Running query on first connection
156 Running query on second connection
159 Running query on first connection
161 Running query on second connection
164 Running query on first connection
166 Running query on second connection
169 Running query on first connection
171 Running query on second connection
