Home
last modified time | relevance | path

Searched refs:stmt (Results 51 – 75 of 434) sorted by path

12345678910>>...18

/php-src/ext/mysqli/tests/
H A Dbug45289.phpt21 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 Dbug48909.phpt21 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 Dbug55653.phpt19 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 Dbug62046.phpt16 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 Dbug66043.phpt31 $stmt = $db->stmt_init();
32 if (!$stmt->prepare("SELECT str FROM test")) {
37 $stmt->execute();
38 $stmt->bind_result($testArg);
H A Dbug66124.phpt34 $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 Dbug67839.phpt36 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 Dbug69899.phpt2 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 Dbug70949.phpt20 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 Dbug72489.phpt32 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 Dbug76386.phpt39 $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 Dbug77935.phpt27 $stmt = $db->prepare("CALL testSp()");
28 $stmt->execute();
29 $result = $stmt->get_result();
H A Dbug79375.phpt27 $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 Dbug_mysql_49406.phpt31 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 Dgh11550.phpt27 $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 Dgh12107.phpt24 $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 Dgh8058.phpt17 $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 Dmysqli_change_user_prepared_statements.phpt16 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 Dmysqli_class_mysqli_stmt_interface.phpt100 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 Dmysqli_execute_query.phpt43 // stmt error - duplicate key
H A Dmysqli_explain_metadata.phpt62 $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 Dmysqli_fetch_array_large.phpt58 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 Dmysqli_get_client_stats.phpt321 ++$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 Dmysqli_get_client_stats_ps.phpt22 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 Dnon_freed_statement.phpt16 $stmt = mysqli_prepare($link, "SELECT CURRENT_USER()");
17 mysqli_stmt_execute($stmt);

Completed in 30 milliseconds

12345678910>>...18