/php-src/ext/mysqli/tests/ |
H A D | bug45289.phpt | 21 if (!($stmt = $link->prepare('SELECT id, label FROM test WHERE id=? LIMIT 1'))) 24 if (!$stmt->bind_param('i', $id) || !$stmt->execute()) 25 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
|
H A D | bug48909.phpt | 21 if (!$stmt = $link->prepare("INSERT INTO test(id, label) VALUES (?, ?)")) 24 if (!$stmt->bind_param("bb",$bvar, $bvar)) 25 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error); 27 if (!$stmt->execute()) { 28 if ($stmt->errno != 1366) { 33 printf("[005] [%d] %s\n", $stmt->errno, $stmt->error); 37 $stmt->close();
|
H A D | bug55653.phpt | 19 if (!($stmt = $link->stmt_init())) 22 if (!($stmt->prepare("SELECT ?")) || 23 !($stmt->bind_param("s", $in_and_out)) || 24 !($stmt->execute()) || 25 !($stmt->bind_result($in_and_out))) 26 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error); 28 if (!$stmt->fetch()) 29 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
|
H A D | bug62046.phpt | 16 if (FALSE === ($stmt = $link->prepare('SELECT 42'))) { 19 if (FALSE === $stmt->execute()) { 20 printf("[003] Execute failed, [%d] %s\n", $stmt->errorno, $stmt->error); 22 if (FALSE === $stmt->store_result()) { 23 printf("[004] store_result failed, [%d] %s\n", $stmt->errorno, $stmt->error); 26 if (FALSE === $stmt->bind_result($one)) { 27 printf("[005] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error); 29 if (FALSE === $stmt->reset()) { 30 printf("[006] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error); 32 while ($stmt->fetch()) { [all …]
|
H A D | bug66043.phpt | 31 $stmt = $db->stmt_init(); 32 if (!$stmt->prepare("SELECT str FROM test")) { 37 $stmt->execute(); 38 $stmt->bind_result($testArg);
|
H A D | bug66124.phpt | 34 $stmt = $link->prepare($table_insert); 35 if (!$stmt) { 41 $stmt->bind_param('i', $id); 43 if ($stmt->execute()){ 44 echo "insert id:{$id}=>{$stmt->insert_id}\n"; 62 $stmt->close(); 68 $stmt = $link->prepare($table_insert); 69 $stmt->bind_param('s', $id); 73 if ($stmt->execute()){
|
H A D | bug67839.phpt | 36 if (!($stmt = mysqli_prepare($link, "SELECT id, fp4, fp8 FROM test"))) { 45 if (!mysqli_stmt_bind_result($stmt, $id, $fp4, $fp8)) { 50 if (!mysqli_stmt_execute($stmt)) { 56 if (!(mysqli_stmt_fetch($stmt))) {
|
H A D | bug69899.phpt | 2 Bug #69899: Segfault on stmt close after free_result with mysqlnd. 23 $stmt = $mysqli->prepare('SELECT 1'); 27 $stmt->free_result(), 28 $stmt->close()
|
H A D | bug70949.phpt | 20 if ($stmt = $mysql->prepare($sql)) 22 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY); 24 if ($stmt->bind_result($name)) { 26 if ($stmt->execute()) 28 while ($stmt->fetch()) 35 $stmt->free_result(); 36 $stmt->close();
|
H A D | bug72489.phpt | 32 if (!$stmt = $link->prepare("SELECT id, code FROM bug72489")) { 36 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY); 37 if (!$stmt->bind_result($subRow['id'], $subRow['code']) || !$stmt->execute()) { 41 while ($stmt->fetch()) {
|
H A D | bug76386.phpt | 39 $stmt = $link->prepare('SELECT * FROM ts_test;'); // must be statement 40 if ($stmt) { 41 $stmt->execute(); 44 $stmt->fetch(); 46 $stmt->free_result(); 67 $stmt = $link->prepare('SELECT * FROM t_test;'); 68 if ($stmt) { 69 $stmt->execute(); 71 $stmt->bind_result($tid, $t, $t2, $t4, $t6); 72 while ($stmt->fetch()) { [all …]
|
H A D | bug77935.phpt | 27 $stmt = $db->prepare("CALL testSp()"); 28 $stmt->execute(); 29 $result = $stmt->get_result();
|
H A D | bug79375.phpt | 27 $stmt = $mysqli->prepare($query); 28 $stmt->execute(); 30 $stmt->store_result(); 31 echo "Got {$stmt->num_rows} for $name\n"; 41 $stmt = $mysqli->prepare($query); 42 $stmt->execute(); 44 $res = $stmt->get_result(); 67 $stmt = $mysqli->prepare($query); 68 $stmt->execute(); 70 $stmt->fetch(); // should throw an error [all …]
|
H A D | bug_mysql_49406.phpt | 31 if (!$stmt = $link->prepare($query)) 34 if (!$stmt->execute() || !$stmt->store_result()) 35 printf("[006] [%d] %s\n", $stmt->errno, $stmt->error); 65 $meta_res = $stmt->result_metadata(); 82 if (!$stmt->bind_result($row_stmt) || !$stmt->fetch()) 83 printf("[007] [%d] %s\n", $stmt->errno, $stmt->error); 91 $stmt->close();
|
H A D | gh11550.phpt | 27 $stmt = $link->prepare('select * from test_gh11550'); 28 var_dump('mysqli-1:', $stmt->execute(), $stmt->get_result()->fetch_all()); 35 var_dump('mysqli-2:', $stmt->execute(), $stmt->get_result()->fetch_all());
|
H A D | gh12107.phpt | 24 $stmt = $mysqli->prepare("call `gh12107`()"); 25 $stmt->execute(); 26 $stmt->bind_result($output); 27 var_dump($stmt->fetch()); 33 $stmt->execute(); 34 $stmt->bind_result($output); 35 var_dump($stmt->fetch());
|
H A D | gh8058.phpt | 17 $stmt = $mysqli->prepare("select 1,2,3"); 18 $stmt->bind_result($a,$a,$a); 19 $stmt->prepare(""); 21 unset($stmt); // trigger dtor 24 $stmt = $mysqli->prepare("select 1,2,3"); 25 $stmt->bind_result($a,$a,$a); 26 $stmt->prepare(""); 27 $stmt->prepare("select 1"); 28 unset($stmt); // trigger dtor 31 $stmt = $mysqli->prepare("select 1,2,3"); [all …]
|
H A D | mysqli_change_user_prepared_statements.phpt | 16 if (!$stmt = mysqli_prepare($link, "SELECT 'prepared statements should be released'")) 22 if ($stmt->execute() && $stmt->bind_result($wrong) && $stmt->fetch()) { 25 if ($stmt->errno == 0)
|
H A D | mysqli_class_mysqli_stmt_interface.phpt | 100 assert(mysqli_stmt_errno($stmt) === $stmt->errno); 101 printf("stmt->errno = '%s'\n", $stmt->errno); 103 assert(mysqli_stmt_error($stmt) === $stmt->error); 104 printf("stmt->error = '%s'\n", $stmt->error); 107 var_dump("stmt->error = ", $stmt->error_list); 113 printf("stmt->id = '%s'\n", $stmt->id); 116 printf("stmt->insert_id = '%s'\n", $stmt->insert_id); 119 printf("stmt->num_rows = '%s'\n", $stmt->num_rows); 125 printf("stmt->sqlstate = '%s'\n", $stmt->sqlstate); 128 printf("stmt->unknown = '%s'\n", @$stmt->unknown); [all …]
|
H A D | mysqli_execute_query.phpt | 43 // stmt error - duplicate key
|
H A D | mysqli_explain_metadata.phpt | 62 $stmt = mysqli_stmt_init($link); 64 … if ($stmt->prepare('EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2') && $stmt->execute()) { 65 if (!mysqli_stmt_store_result($stmt)) 66 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 68 if (!$res_meta = mysqli_stmt_result_metadata($stmt)) 69 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 99 $stmt->execute()) { 100 if (!$res_stmt = mysqli_stmt_get_result($stmt)) { 102 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 108 if ((mysqli_stmt_num_rows($stmt)) !== 0) { [all …]
|
H A D | mysqli_fetch_array_large.phpt | 58 if (!$stmt = mysqli_prepare($link, "SELECT id, label FROM test")) { 64 if (!mysqli_stmt_execute($stmt)) { 65 …= %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysq… 70 if (!mysqli_stmt_bind_result($stmt, $id, $label)) { 71 …= %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysq… 75 while (mysqli_stmt_fetch($stmt)) { 78 … $offset, $random_char, $label, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 83 mysqli_stmt_free_result($stmt); 84 mysqli_stmt_close($stmt);
|
H A D | mysqli_get_client_stats.phpt | 321 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 329 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 358 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 363 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 367 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 399 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 404 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 408 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 447 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 452 ++$test_counter, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | mysqli_get_client_stats_ps.phpt | 22 if (!$stmt = mysqli_stmt_init($link)) 27 !mysqli_stmt_execute($stmt) || 28 !mysqli_stmt_store_result($stmt) || 30 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 33 while (mysqli_stmt_fetch($stmt)) 36 mysqli_stmt_free_result($stmt); 58 !mysqli_stmt_execute($stmt) || 60 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 63 while (mysqli_stmt_fetch($stmt)) 78 mysqli_stmt_free_result($stmt); [all …]
|
/php-src/ext/mysqli/tests/closing_connection_tests/ |
H A D | non_freed_statement.phpt | 16 $stmt = mysqli_prepare($link, "SELECT CURRENT_USER()"); 17 mysqli_stmt_execute($stmt);
|