/PHP-5.5/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_bit.phpt | 26 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)'); 27 $stmt->bindValue(1, $offset); 28 $stmt->bindValue(2, $value); 29 if (!$stmt->execute()) { 30 printf("[%03d + 1] INSERT failed, %s\n", $offset, var_export($stmt->errorInfo(), true)); 33 $stmt = $db->query('SELECT id, label FROM test'); 34 $row = $stmt->fetch(PDO::FETCH_ASSOC);
|
H A D | pdo_mysql_prepare_native_column.phpt | 20 $stmt = $db->prepare("SELECT :param FROM test ORDER BY id ASC LIMIT 1"); 21 $stmt->execute(array(':param' => 'id')); 22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 25 $stmt->execute(array(':placeholder' => 'test')); 27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
H A D | bug46292.phpt | 45 $stmt = $pdoDb->prepare("SELECT * FROM testz"); 47 var_dump($stmt->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_CLASSTYPE | PDO::FETCH_GROUP)); 48 $stmt->execute(); 50 var_dump($stmt->fetch()); 51 var_dump($stmt->fetch()); 52 var_dump($stmt->fetchAll());
|
H A D | pdo_mysql_stmt_fetch_serialize.phpt | 90 $stmt = $db->prepare('INSERT INTO test(id, myobj) VALUES (?, ?)'); 91 $stmt->bindValue(1, $id); 92 $stmt->bindValue(2, $myobj); 93 $stmt->execute(); 99 $stmt = $db->prepare('SELECT myobj FROM test'); 101 $stmt->execute(); 102 var_dump($stmt->fetch()); 105 $stmt = $db->prepare('SELECT myobj FROM test'); 106 $stmt->setFetchMode(PDO::FETCH_CLASS, 'myclass', array('PDO shall call __construct()')); 107 $stmt->execute(); [all …]
|
H A D | pdo_mysql_begintransaction.phpt | 39 $row = $stmt->fetch(PDO::FETCH_ASSOC); 57 var_dump($stmt->fetch(PDO::FETCH_ASSOC)); 67 $new_row1 = $stmt->fetch(PDO::FETCH_ASSOC); 76 $new_row2 = $stmt->fetch(PDO::FETCH_ASSOC); 98 $new_row2 = $stmt->fetch(PDO::FETCH_ASSOC); 106 if (!($stmt = $db->query('SELECT @@autocommit as auto_commit'))) 109 $tmp = $stmt->fetch(PDO::FETCH_ASSOC); 112 $tmp['auto_commit'], $stmt->errorCode(), $stmt->errorInfo()); 120 $tmp = $stmt->fetch(PDO::FETCH_ASSOC); 123 $tmp['auto_commit'], $stmt->errorCode(), trim(implode(' ', $stmt->errorInfo()))); [all …]
|
H A D | pdo_mysql_stmt_multiquery.phpt | 15 …$stmt = $db->query('SELECT label FROM test ORDER BY id ASC LIMIT 1; SELECT label FROM test ORDER B… 16 var_dump($stmt->errorInfo()); 17 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 18 var_dump($stmt->errorInfo()); 24 …$stmt = $db->query('SELECT label FROM test ORDER BY id ASC LIMIT 1; SELECT label FROM test ORDER B… 26 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 27 } while ($stmt->nextRowset());
|
H A D | pdo_mysql_stmt_errorcode.phpt | 23 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC'); 24 $stmt->execute(); 25 var_dump($stmt->errorCode()); 39 $stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC'); 40 $stmt->execute(); 41 var_dump($stmt->errorCode());
|
H A D | pdo_mysql_stmt_fetch_serialize_simple.phpt | 50 $stmt = $db->prepare('SELECT myobj FROM test'); 51 $stmt->execute(); 52 $rows = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass', array('Called by PDO')); 55 $stmt->execute(); 56 $rows = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass'); 60 $stmt = $db->prepare('SELECT myobj FROM test'); 61 $stmt->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_SERIALIZE, 'myclass', array('Called by PDO')); 62 $stmt->execute(); 63 var_dump($stmt->fetch());
|
/PHP-5.5/ext/mysqli/tests/ |
H A D | 046.phpt | 22 $stmt = mysqli_prepare($link, "DELETE FROM test_affected WHERE foo=?"); 23 mysqli_stmt_bind_param($stmt, "i", $c1); 27 mysqli_stmt_execute($stmt); 28 $x = mysqli_stmt_affected_rows($stmt); 30 mysqli_stmt_close($stmt);
|
H A D | bug45289.phpt | 20 if (!($stmt = $link->prepare('SELECT id, label FROM test WHERE id=? LIMIT 1'))) 23 if (!$stmt->bind_param('i', $id) || !$stmt->execute()) 24 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error);
|
H A D | mysqli_stmt_get_result_metadata_fetch_field.phpt | 23 if (!($stmt = mysqli_stmt_init($link)) || 24 …!mysqli_stmt_prepare($stmt, "SELECT id, label, id + 1 as _id, concat(label, '_') ___label FROM te… 25 !mysqli_stmt_execute($stmt)) 26 printf("[001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 28 if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) { 30 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 33 if (!is_object($res_meta = mysqli_stmt_result_metadata($stmt)) || 36 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 60 mysqli_stmt_close($stmt);
|
H A D | mysqli_stmt_attr_get.phpt | 41 $stmt = mysqli_stmt_init($link); 42 mysqli_stmt_prepare($stmt, 'SELECT * FROM test'); 43 if (false !== ($tmp = @mysqli_stmt_attr_get($stmt, $invalid_attr))) 47 if (false === ($tmp = mysqli_stmt_attr_get($stmt, $attr))) { 53 $stmt->close(); 56 if (!is_null($tmp = @mysqli_stmt_attr_get($stmt, $attr))) {
|
H A D | mysqli_stmt_prepare.phpt | 30 if (!$stmt = mysqli_stmt_init($link)) 33 if (NULL !== ($tmp = @mysqli_stmt_prepare($stmt))) 36 if (false !== ($tmp = mysqli_stmt_prepare($stmt, ''))) 39 if (true !== ($tmp = mysqli_stmt_prepare($stmt, 'SELECT id FROM test'))) 42 mysqli_stmt_close($stmt); 44 if (NULL !== ($tmp = mysqli_stmt_prepare($stmt, "SELECT id FROM test")))
|
H A D | mysqli_fetch_array_large.phpt | 54 if (!$stmt = mysqli_prepare($link, "SELECT id, label FROM test")) { 60 if (!mysqli_stmt_execute($stmt)) { 61 …= %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysq… 66 if (!mysqli_stmt_bind_result($stmt, $id, $label)) { 67 …= %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysq… 71 while (mysqli_stmt_fetch($stmt)) { 74 $offset, $random_char, $label, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 79 mysqli_stmt_free_result($stmt); 80 mysqli_stmt_close($stmt);
|
H A D | 013.phpt | 31 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_result"); 34 $b_res= mysqli_stmt_bind_result($stmt, $c[0], $c[1], $c[2], $c[3], $c[4], $c[5], $c[6], $c[7]); 35 mysqli_stmt_execute($stmt); 36 mysqli_stmt_fetch($stmt); 37 mysqli_stmt_fetch($stmt); 38 mysqli_stmt_close($stmt);
|
/PHP-5.5/ext/sqlite3/tests/ |
H A D | sqlite3_33_reset.phpt | 16 $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id'); 17 $stmt->bindValue(':id', 1, SQLITE3_INTEGER); 18 $stmt->reset("dummy"); 19 $stmt->reset();
|
/PHP-5.5/ext/oci8/tests/ |
H A D | define_old.phpt | 22 $stmt = ociparse($c, "select string from define_old_tab"); 27 ocidefinebyname($stmt, "STRING", $string, 20); 29 ociexecute($stmt); 31 while (ocifetch($stmt)) {
|
H A D | define.phpt | 22 $stmt = oci_parse($c, "select string from define_tab"); 27 oci_define_by_name($stmt, "STRING", $string, 20); 29 oci_execute($stmt); 31 while (oci_fetch($stmt)) {
|
H A D | bug37581.phpt | 33 $stmt = oci_parse($c,'begin ARRAYBINDPKG1.array_bind(:in_arr, :out_str); end;'); 36 oci_bind_array_by_name($stmt,':in_arr',$strings,5,1,SQLT_AFC); 37 oci_bind_by_name($stmt,':out_str',$result,10); 39 oci_execute($stmt); 42 oci_execute($stmt);
|
H A D | select_null.phpt | 12 $stmt = oci_parse($pc, "select NULL from dual"); 13 oci_execute($stmt); 14 var_dump(oci_fetch_array($stmt, OCI_RETURN_NULLS));
|
/PHP-5.5/ext/pdo/tests/ |
H A D | pdo_006.phpt | 22 $stmt = $db->prepare('SELECT val, id from test'); 24 $stmt->execute(); 25 var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_GROUP)); 27 $stmt->execute(); 28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_GROUP));
|
H A D | pdo_007.phpt | 22 $stmt = $db->prepare('SELECT id, val from test'); 24 $stmt->execute(); 25 var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_UNIQUE)); 27 $stmt->execute(); 28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_UNIQUE));
|
H A D | bug_38253.phpt | 21 $stmt = $pdo->prepare ("SELECT * FROM test"); 22 $stmt->execute(); 23 var_dump($stmt->fetchAll()); 37 $stmt = $pdo->prepare ("SELECT * FROM test2"); 38 $stmt->execute(); 39 var_dump($stmt->fetchAll());
|
/PHP-5.5/ext/mysqli/ |
H A D | mysqli_priv.h | 67 extern void php_clear_stmt_bind(MY_STMT *stmt TSRMLS_DC); 144 #define MYSQLI_REPORT_STMT_ERROR(stmt) \ argument 145 if ((MyG(report_mode) & MYSQLI_REPORT_ERROR) && mysql_stmt_errno(stmt)) { \ 146 …php_mysqli_report_error(mysql_stmt_sqlstate(stmt), mysql_stmt_errno(stmt), mysql_stmt_error(stmt) …
|
/PHP-5.5/ext/pdo_odbc/ |
H A D | php_pdo_odbc_int.h | 148 PDO_ODBC_HSTMT stmt; member 170 void pdo_odbc_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, PDO_ODBC_HSTMT statement, char *what, const c… 172 #define pdo_odbc_stmt_error(what) pdo_odbc_error(stmt->dbh, stmt, SQL_NULL_HSTMT, what, __FILE__, _… 173 #define pdo_odbc_doer_error(what) pdo_odbc_error(dbh, NULL, stmt, what, __FILE__, __LINE__ TSRMLS_C…
|