/PHP-7.4/ext/mysqli/tests/ |
H A D | mysqli_stmt_fetch_fields_win32_unicode.phpt | 15 if (!($stmt = mysqli_stmt_init($link)) || 17 !mysqli_stmt_execute($stmt) || 18 !($result = mysqli_stmt_result_metadata($stmt)) || 19 !mysqli_stmt_bind_result($stmt, $id, $bind_res) || 23 while (mysqli_stmt_fetch($stmt)) { 27 mysqli_stmt_close($stmt); 29 if (!($stmt = mysqli_stmt_init($link)) || 31 !mysqli_stmt_execute($stmt) || 32 !($result = mysqli_stmt_result_metadata($stmt)) || 40 while (mysqli_stmt_fetch($stmt)) { [all …]
|
H A D | mysqli_stmt_multires.phpt | 27 printf("[003] [%d] %s\n", $stmt->error, $stmt->errno); 31 printf("[005] [%d] %s\n", $stmt->error, $stmt->errno); 37 printf("[004] [%d] %s\n", $stmt->error, $stmt->errno); 41 if (!$stmt->fetch()) { 42 printf("[006] [%d] %s\n", $stmt->error, $stmt->errno); 47 if ($stmt->fetch()) { 52 if ($stmt->fetch()) { 63 printf("[010] [%d] %s\n", $stmt->error, $stmt->errno); 68 printf("[011] [%d] %s\n", $stmt->error, $stmt->errno); 73 if ($stmt->fetch()) { [all …]
|
H A D | bug62046.phpt | 15 if (FALSE === ($stmt = $link->prepare('SELECT 42'))) { 18 if (FALSE === $stmt->execute()) { 19 printf("[003] Execute failed, [%d] %s\n", $stmt->errorno, $stmt->error); 21 if (FALSE === $stmt->store_result()) { 22 printf("[004] store_result failed, [%d] %s\n", $stmt->errorno, $stmt->error); 25 if (FALSE === $stmt->bind_result($one)) { 26 printf("[005] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error); 28 if (FALSE === $stmt->reset()) { 29 printf("[006] bind_result failed, [%d] %s\n", $stmt->errorno, $stmt->error); 31 while ($stmt->fetch()) { [all …]
|
H A D | mysqli_stmt_execute_stored_proc_next_result.phpt | 36 if (!mysqli_stmt_execute($stmt)) 37 …printf("[007] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 42 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 47 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 49 mysqli_stmt_free_result($stmt); 54 if (!mysqli_stmt_close($stmt)) 82 printf("[018] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 87 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 95 printf("[021] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 100 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | mysqli_stmt_free_result.phpt | 29 if (!$stmt = mysqli_stmt_init($link)) 32 // stmt object status test 37 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 42 if (!mysqli_stmt_execute($stmt)) 43 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 51 mysqli_stmt_close($stmt); 53 if (!$stmt = mysqli_stmt_init($link)) 57 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 59 if (!mysqli_stmt_execute($stmt)) 60 printf("[012] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | mysqli_stmt_bind_param_references.phpt | 60 printf("[001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 68 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 79 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 90 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 101 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 109 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 119 printf("[016] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 130 printf("[019] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 140 printf("[022] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 150 printf("[025] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | mysqli_stmt_get_result_field_count.phpt | 16 if (!$stmt = mysqli_stmt_init($link)) 19 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3")) 20 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 22 if (!mysqli_stmt_execute($stmt)) 23 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 25 if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) { 27 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 30 if (!is_object($res_meta = mysqli_stmt_result_metadata($stmt)) || 33 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 40 mysqli_stmt_close($stmt);
|
H A D | mysqli_stmt_reset.phpt | 38 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 48 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 50 if (!mysqli_stmt_fetch($stmt)) 51 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 54 mysqli_stmt_close($stmt); 65 printf("[013] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 69 printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 77 if (!mysqli_stmt_reset($stmt)) 78 printf("[016] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 81 printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | mysqli_stmt_get_result_non_select.phpt | 21 if (!$stmt = mysqli_stmt_init($link)) 28 !$stmt->execute()) 29 printf("[002] [%d] %s\n", $stmt->errno, $stmt->error); 31 if (!$res = $stmt->get_result()) 32 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error); 55 !$stmt->execute()) 56 printf("[006] [%d] %s\n", $stmt->errno, $stmt->error); 59 printf("[007] [%d] %s\n", $stmt->errno, $stmt->error); 74 !$stmt->execute()) 75 printf("[009] [%d] %s\n", $stmt->errno, $stmt->error); [all …]
|
H A D | mysqli_prepare.phpt | 37 mysqli_stmt_close($stmt); 45 mysqli_stmt_close($stmt); 52 if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt)) 54 mysqli_stmt_close($stmt); 60 if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt)) 62 mysqli_stmt_close($stmt); 71 mysqli_stmt_close($stmt); 77 if (!mysqli_stmt_bind_param($stmt, 'i', $where) || !mysqli_stmt_execute($stmt)) 85 if (!mysqli_stmt_bind_param($stmt, 's', $testvar) || !mysqli_stmt_execute($stmt)) 97 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_bind_result($stmt, $id, $testvar)) [all …]
|
H A D | mysqli_stmt_fetch_geom.phpt | 43 … printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 44 mysqli_stmt_close($stmt); 48 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_store_result($stmt)) { 49 … printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 50 mysqli_stmt_close($stmt); 55 … printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 56 mysqli_stmt_close($stmt); 75 $offset + 17, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num); 78 mysqli_stmt_close($stmt); 87 … printf("[%04d] [%d] %s\n", $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | mysqli_stmt_fetch.phpt | 29 if (!$stmt = mysqli_stmt_init($link)) 32 // stmt object status test 37 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 43 if (!mysqli_stmt_execute($stmt)) 44 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 49 mysqli_stmt_close($stmt); 54 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 56 if (!mysqli_stmt_execute($stmt)) 57 printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 66 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | mysqli_stmt_sqlstate.phpt | 27 if (!$stmt = mysqli_stmt_init($link)) 30 if (false !== ($tmp = mysqli_stmt_sqlstate($stmt))) 33 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test")) 34 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 36 if ('00000' !== ($tmp = mysqli_stmt_sqlstate($stmt))) 38 gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 41 printf("[008] Should fail! [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 43 if ('' === ($tmp = mysqli_stmt_sqlstate($stmt))) 44 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 46 mysqli_stmt_close($stmt); [all …]
|
/PHP-7.4/ext/pdo_dblib/tests/ |
H A D | batch_stmt_transaction.phpt | 14 $stmt = $db->query( 27 var_dump($stmt->rowCount()); 31 var_dump($stmt->rowCount()); 35 var_dump($stmt->rowCount()); 39 var_dump($stmt->rowCount()); 43 var_dump($stmt->rowCount()); 47 var_dump($stmt->rowCount()); 51 var_dump($stmt->fetchAll()); 52 var_dump($stmt->rowCount()); 56 var_dump($stmt->rowCount()); [all …]
|
H A D | batch_stmt_try.phpt | 14 $stmt = $db->query( 30 var_dump($stmt->rowCount()); 31 var_dump($stmt->nextRowset()); 34 var_dump($stmt->rowCount()); 38 var_dump($stmt->rowCount()); 42 var_dump($stmt->rowCount()); 46 var_dump($stmt->rowCount()); 60 var_dump($stmt->fetchAll()); 61 var_dump($stmt->rowCount()); 65 var_dump($stmt->rowCount()); [all …]
|
H A D | batch_stmt_ins_sel_up_del.phpt | 14 $stmt = $db->query( 25 var_dump($stmt->rowCount()); 26 var_dump($stmt->nextRowset()); 29 var_dump($stmt->rowCount()); 30 var_dump($stmt->nextRowset()); 33 var_dump($stmt->rowCount()); 37 var_dump($stmt->rowCount()); 41 var_dump($stmt->rowCount()); 45 var_dump($stmt->rowCount()); 49 var_dump($stmt->rowCount()); [all …]
|
/PHP-7.4/ext/pdo/tests/ |
H A D | bug_71447.phpt | 24 $stmt = $db->prepare(" 30 $stmt->execute(); 34 $stmt = $db->prepare(" 40 $stmt->execute(); 44 $stmt = $db->prepare(" 50 $stmt->execute(); 54 $stmt = $db->prepare(" 60 $stmt->execute(); 64 $stmt = $db->prepare(" 70 $stmt->execute(); [all …]
|
/PHP-7.4/ext/pdo_firebird/tests/ |
H A D | rowCount.phpt | 21 $stmt = $dbh->prepare($query); 22 $stmt->execute(array('A')); 23 $rows = $stmt->fetch(); 24 $rows = $stmt->fetch(); 25 var_dump($stmt->fetch()); 26 var_dump($stmt->rowCount()); 29 $stmt->execute(array('A')); 30 var_dump($stmt->rowCount()); 34 $stmt->execute(); 35 var_dump($stmt->rowCount()); [all …]
|
/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pecl_bug_5802.phpt | 16 $stmt = $db->prepare('insert into test (bar) values(:bar)') or var_dump($db->errorInfo()); 19 $stmt->bindParam(':bar', $bar); 20 $stmt->execute() or var_dump($stmt->errorInfo()); 23 $stmt->bindParam(':bar', $bar); 24 $stmt->execute() or var_dump($stmt->errorInfo()); 27 $stmt->bindParam(':bar', $bar); 28 $stmt->execute() or var_dump($stmt->errorInfo()); 30 $stmt = $db->prepare('select * from test') or var_dump($db->errorInfo()); 32 if($stmt) $stmt->execute(); 33 if($stmt) var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
/PHP-7.4/ext/oci8/tests/ |
H A D | define2.phpt | 26 oci_bind_by_name( $stmt, ":id", $i, -1); 28 oci_execute($stmt, OCI_DEFAULT); 33 var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $fi)); 34 oci_execute($stmt); 36 while (oci_fetch($stmt)) { 44 oci_execute($stmt); 46 while (oci_fetch($stmt)) { 54 oci_execute($stmt); 56 while (oci_fetch($stmt)) { 64 oci_execute($stmt); [all …]
|
H A D | bind_long_raw.phpt | 13 $stmt = oci_parse($c, "create table phptestlngraw( id number(10), fileimage long raw)"); 14 oci_execute($stmt); 16 $stmt = oci_parse ($c, "insert into phptestlngraw (id, fileimage) values (:id, :fileimage)"); 20 oci_bind_by_name( $stmt, ":id", $i, -1); 21 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_LBI); 22 oci_execute($stmt, OCI_DEFAULT); 25 $stmt = oci_parse($c, "SELECT fileimage FROM phptestlngraw"); 26 oci_execute($stmt); 28 $row = oci_fetch_row($stmt); 32 $stmt = oci_parse($c, "drop table phptestlngraw"); [all …]
|
H A D | bind_raw.phpt | 13 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))"); 14 oci_execute($stmt); 16 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)"); 21 oci_bind_by_name( $stmt, ":id", $i, -1); 22 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, SQLT_BIN); 23 oci_execute($stmt, OCI_DEFAULT); 26 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); 27 oci_execute($stmt); 29 $row = oci_fetch_row($stmt); 33 $stmt = oci_parse($c, "drop table phptestrawtable"); [all …]
|
H A D | bind_raw_2.phpt | 13 $stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))"); 14 oci_execute($stmt); 16 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)"); 21 oci_bind_by_name( $stmt, ":id", $i, -1); 22 oci_bind_by_name( $stmt, ":fileimage", $fileimage, -1, OCI_B_BIN); 23 oci_execute($stmt, OCI_DEFAULT); 26 $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); 27 oci_execute($stmt); 29 $row = oci_fetch_row($stmt); 33 $stmt = oci_parse($c, "drop table phptestrawtable"); [all …]
|
H A D | bug71148.phpt | 45 $stmt = oci_parse($c, $sql); 50 oci_execute($stmt); 54 oci_free_statement($stmt); 67 oci_execute($stmt); 72 oci_free_statement($stmt); 85 oci_execute($stmt); 90 oci_free_statement($stmt); 104 oci_execute($stmt); 122 oci_execute($stmt); 128 oci_free_statement($stmt); [all …]
|
H A D | define3.phpt | 23 oci_bind_by_name($stmt,":id",$id); 26 oci_execute($stmt, OCI_DEFAULT); 36 oci_execute($stmt, OCI_DEFAULT); 43 oci_execute($stmt); 45 while (oci_fetch($stmt)) { 53 oci_execute($stmt); 55 while (oci_fetch($stmt)) { 62 oci_execute($stmt); 64 while (oci_fetch($stmt)) { 72 oci_execute($stmt); [all …]
|