/PHP-5.5/ext/mysqli/tests/ |
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 | 41 !mysqli_stmt_fetch($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)) 81 !mysqli_stmt_fetch($stmt)) 82 printf("[018] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 87 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 94 !mysqli_stmt_fetch($stmt)) 95 printf("[021] [%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_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_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)); 74 printf("[015 - %d] [%d] %s\n", $i, mysqli_stmt_errno($stmt), mysqli_stmt_error($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 | 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); 58 if (!$res = $stmt->get_result()) 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_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_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)) 79 mysqli_stmt_close($stmt); 85 if (!mysqli_stmt_bind_param($stmt, 's', $testvar) || !mysqli_stmt_execute($stmt)) [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 (NULL !== ($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 …]
|
H A D | bug55653.phpt | 18 if (!($stmt = $link->stmt_init())) 21 if (!($stmt->prepare("SELECT ?")) || 22 !($stmt->bind_param("s", $in_and_out)) || 23 !($stmt->execute()) || 24 !($stmt->bind_result($in_and_out))) 25 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error); 27 if (!$stmt->fetch()) 28 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
|
H A D | mysqli_stmt_bind_param_check_param_no_change.phpt | 27 $stmt->bind_result($one); 28 $stmt->execute(); 29 $stmt->fetch(); 30 $stmt->free_result(); 44 $stmt->execute(); 47 $stmt->bind_result($one, $two); 48 $stmt->fetch(); 49 $stmt->free_result(); 59 $stmt->execute(); 60 $stmt->fetch(); [all …]
|
H A D | mysqli_stmt_num_rows.phpt | 24 if (!$stmt = mysqli_stmt_init($link)) 30 printf("[%03d] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 34 if (!mysqli_stmt_execute($stmt)) { 35 printf("[%03d] [%d] %s\n", $offset + 1, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 40 printf("[%03d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 49 mysqli_stmt_free_result($stmt); 74 printf("[051] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 76 if (mysqli_stmt_execute($stmt)) { 83 } while (mysqli_stmt_fetch($stmt)); 99 printf("[055] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | 058.phpt | 22 mysqli_stmt_bind_param($stmt, "is", $a, $b); 27 mysqli_stmt_execute($stmt); 29 mysqli_stmt_bind_param($stmt, "is", $c, $d); 34 mysqli_stmt_execute($stmt); 35 mysqli_stmt_close($stmt); 37 $stmt = mysqli_prepare($link, "SELECT * FROM mbind"); 38 mysqli_stmt_execute($stmt); 40 mysqli_stmt_bind_result($stmt, $e, $f); 41 mysqli_stmt_fetch($stmt); 43 mysqli_stmt_bind_result($stmt, $g, $h); [all …]
|
/PHP-5.5/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 | 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 …]
|
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 …]
|
/PHP-5.5/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));
|
H A D | pdo_mysql_prepare_native_dup_named_placeholder.phpt | 29 if ('00000' !== $stmt->errorCode()) 31 var_export($stmt->errorCode(), true), 32 var_export($stmt->errorInfo(), true)); 36 $stmt->execute(); 48 if ('00000' !== $stmt->errorCode()) 50 var_export($stmt->errorCode(), true), 55 $stmt->execute(); 67 $stmt = $db->prepare($sql); 69 if ('00000' !== $stmt->errorCode()) 81 $stmt = $db->prepare($sql); [all …]
|
/PHP-5.5/ext/pdo/ |
H A D | pdo.php | 11 $stmt = $x->prepare("INSERT INTO test (NAME, VALUE) VALUES (:name, :value)"); variable 13 $stmt->bindParam(":name", $the_name, PDO_PARAM_STR, 32); 14 $stmt->bindParam(":value", $the_value, PDO_PARAM_STR, 32); 20 if (!$stmt->execute()) { 25 $stmt = null; variable 47 $stmt = $x->prepare("select NAME, VALUE from test where value like ?"); variable 49 $stmt->execute(array($the_name)) or die("failed to execute!"); 50 $stmt->bindColumn('VALUE', $value); 52 while ($row = $stmt->fetch()) {
|
/PHP-5.5/ext/pdo_firebird/tests/ |
H A D | rowCount.phpt | 22 $stmt = $dbh->prepare($query); 23 $stmt->execute(array('A')); 24 $rows = $stmt->fetch(); 25 $rows = $stmt->fetch(); 26 var_dump($stmt->fetch()); 27 var_dump($stmt->rowCount()); 30 $stmt->execute(array('A')); 31 var_dump($stmt->rowCount()); 35 $stmt->execute(); 36 var_dump($stmt->rowCount()); [all …]
|
/PHP-5.5/ext/pdo_odbc/ |
H A D | odbc_stmt.c | 146 if (stmt->executed) { in odbc_stmt_dtor() 147 SQLCloseCursor(S->stmt); in odbc_stmt_dtor() 150 S->stmt = SQL_NULL_HANDLE; in odbc_stmt_dtor() 153 free_cols(stmt, S TSRMLS_CC); in odbc_stmt_dtor() 169 if (stmt->executed) { in odbc_stmt_execute() 170 SQLCloseCursor(S->stmt); in odbc_stmt_execute() 173 rc = SQLExecute(S->stmt); in odbc_stmt_execute() 203 SQLCloseCursor(S->stmt); in odbc_stmt_execute() 219 SQLCloseCursor(S->stmt); in odbc_stmt_execute() 259 stmt->row_count = row_count; in odbc_stmt_execute() [all …]
|