/PHP-5.5/ext/pdo_pgsql/tests/ |
H A D | bug43925.phpt | 31 $stmt = $dbh->prepare(' 41 $stmt->bindValue('left', 1, PDO::PARAM_INT); 42 $stmt->bindValue('rootId', 3, PDO::PARAM_INT); 43 $stmt->bindValue('x', 5, PDO::PARAM_INT); 44 $stmt->bindValue('y', 50, PDO::PARAM_INT); 46 $stmt->execute(); 48 foreach ($stmt->fetchAll() as $row) {
|
/PHP-5.5/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_types_zerofill.phpt | 24 $stmt->bindValue(1, $offset); 25 $stmt->bindValue(2, $value); 27 if (!$stmt->execute()) { 38 $stmt = $db->query('SELECT id, label FROM test'); 39 $row = $stmt->fetch(PDO::FETCH_ASSOC); 40 $stmt->closeCursor(); 78 $stmt = $db->query('SELECT id, label FROM test'); 79 $row_string = $stmt->fetch(PDO::FETCH_ASSOC); 80 $stmt->closeCursor(); 95 $stmt->execute(); [all …]
|
H A D | pdo_mysql_errorinfo.phpt | 48 $stmt = $db->query('SELECT id, label FROM test'); 49 $stmt2 = &$stmt; 51 check_error($offset + 4, $stmt); 54 @$stmt->execute(); 56 check_error($offset + 6, $stmt, '42S02'); 59 @$stmt = $db->query('SELECT id, label FROM unknown'); 63 $stmt = $db->query('SELECT id, label FROM test'); 65 check_error($offset + 10, $stmt); 72 check_error($offset + 13, $stmt); 80 check_error($offset + 17, $stmt);
|
H A D | pdo_mysql_stmt_fetch_non_select.phpt | 27 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 39 if (!is_object($stmt = $db->query('SHOW ENGINES'))) 44 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 61 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) 85 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 119 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 151 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) 164 $stmt->execute(); 172 $stmt->execute(); 173 $stmt->execute(); [all …]
|
H A D | pdo_mysql_prepare_native_mixed_style.phpt | 20 $stmt = $db->query('DELETE FROM test'); 21 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, ?), (2, ?)'); 22 $stmt->execute(array('a', 'b')); 23 …$stmt = $db->prepare("SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label… 24 $stmt->execute(array(1, 1)); 25 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
H A D | pdo_mysql_fetch_both.phpt | 18 $stmt = $db->query('SELECT 1'); 19 $num = $stmt->fetch(PDO::FETCH_NUM); 21 $stmt = $db->query('SELECT 1'); 22 $assoc = $stmt->fetch(PDO::FETCH_ASSOC); 24 $stmt = $db->query('SELECT 1'); 25 $both = $stmt->fetch(PDO::FETCH_BOTH);
|
/PHP-5.5/ext/mysqli/tests/ |
H A D | bug34785.phpt | 30 $stmt = new my_stmt($link, "SELECT 'foo' FROM DUAL"); 32 $stmt->execute(); 33 $stmt->bind_result($var); 34 $stmt->fetch(); 36 $stmt->close();
|
H A D | bug44897.phpt | 33 if (!$stmt = $link->prepare('CALL p(?, ?)')) 36 if (!$stmt->bind_param('is', $new_id, $new_label) || !$stmt->execute()) 37 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error); 40 if (!$stmt->bind_result($out_new_label) || !$stmt->fetch()) 41 printf("[005] [%d] %s\n", $stmt->errno, $stmt->error); 47 $stmt->close();
|
H A D | mysqli_stmt_get_result_bit.phpt | 54 if (!$stmt = mysqli_stmt_init($link)) 84 if (!mysqli_stmt_prepare($stmt, $sql) || 85 !mysqli_stmt_execute($stmt)) 86 printf("[004 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 89 if (!mysqli_stmt_prepare($stmt, $sql) || 90 !mysqli_stmt_execute($stmt)) 91 printf("[005 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 93 if (!$res = mysqli_stmt_get_result($stmt)) 94 printf("[006 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 121 mysqli_stmt_close($stmt);
|
H A D | 018.phpt | 18 if (!$stmt = mysqli_prepare($link, "SELECT @@autocommit")) 21 mysqli_stmt_bind_result($stmt, $c0); 22 mysqli_stmt_execute($stmt); 24 mysqli_stmt_fetch($stmt);
|
H A D | mysqli_stmt_attr_get_prefetch.phpt | 14 $stmt = mysqli_stmt_init($link); 15 mysqli_stmt_prepare($stmt, 'SELECT * FROM test'); 16 if (1 !== ($tmp = mysqli_stmt_attr_get($stmt, MYSQLI_STMT_ATTR_PREFETCH_ROWS))) { 20 $stmt->close();
|
H A D | mysqli_report.phpt | 76 $stmt = mysqli_stmt_init($link); 84 mysqli_stmt_close($stmt); 95 mysqli_stmt_execute($stmt); 96 mysqli_stmt_close($stmt); 118 mysqli_stmt_close($stmt); 128 mysqli_stmt_execute($stmt); 129 mysqli_stmt_close($stmt); 247 printf("[026] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 250 printf("[027] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 252 mysqli_stmt_close($stmt); [all …]
|
H A D | mysqli_stmt_get_result_seek.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)); 42 $i, mysqli_stmt_errno($stmt), $stmt->error); 90 mysqli_stmt_close($stmt);
|
H A D | 009.phpt | 41 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 42 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8); 43 mysqli_stmt_execute($stmt); 44 $rc = mysqli_stmt_fetch($stmt); 57 mysqli_stmt_close($stmt); 68 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch_uint"); 69 mysqli_stmt_bind_result($stmt, $c1, $c2); 70 mysqli_stmt_execute($stmt); 71 $rc = mysqli_stmt_fetch($stmt); 75 mysqli_stmt_close($stmt);
|
H A D | 005.phpt | 25 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 26 mysqli_stmt_bind_result($stmt, $c1, $c2); 27 mysqli_stmt_execute($stmt); 28 mysqli_stmt_fetch($stmt); 36 mysqli_stmt_fetch($stmt); 38 mysqli_stmt_close($stmt);
|
H A D | bug45019.phpt | 27 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C… 31 if (!$stmt->bind_result($column1) || !$stmt->execute()) 32 printf("[003] [%d] %s\n", $stmt->errno, $stmt->error); 35 while ($stmt->fetch()) { 48 $stmt->close();
|
/PHP-5.5/ext/pdo_dblib/tests/ |
H A D | bug_45876.phpt | 12 $stmt = $db->prepare("select ic1.* from information_schema.columns ic1"); 13 $stmt->execute(); 14 var_dump($stmt->getColumnMeta(0)); 15 $stmt = null;
|
H A D | bug_50755.phpt | 13 $stmt = $db->prepare("select * 18 $x = $stmt->execute(); 20 while (($r = $stmt->fetch())) { 23 $stmt = null;
|
/PHP-5.5/ext/sqlite3/tests/ |
H A D | sqlite3_35_stmt_readonly.phpt | 24 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC"); 25 var_dump($stmt->readOnly()); 28 $stmt = $db->prepare("UPDATE test SET id = 'c' WHERE id = ?"); 29 var_dump($stmt->readOnly()); 32 $stmt = $db->prepare("DELETE FROM test"); 33 var_dump($stmt->readOnly());
|
/PHP-5.5/ext/pdo_oci/tests/ |
H A D | bug46274_2.phpt | 27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl… 35 $stmt->bindparam(':id', $id); 36 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 37 $stmt->execute(); 45 $stmt->bindparam(':id', $id); 46 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 47 $stmt->execute();
|
/PHP-5.5/ext/pdo/tests/ |
H A D | pdo_030.phpt | 64 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)"); 65 var_dump(get_class($stmt)); 67 $stmt->execute($row); 70 unset($stmt); 77 $stmt = $db->query('SELECT * FROM test'); 78 var_dump(get_class($stmt)); 79 var_dump(get_class($stmt->dbh)); 83 foreach($stmt as $obj) {
|
H A D | pdo_023.phpt | 53 $stmt = parent::prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx'))); 54 $stmt->execute(); 55 return $stmt; 68 $stmt = $db->query('SELECT val, id FROM test'); 69 var_dump($stmt); 70 var_dump($stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE)); 72 $stmt = NULL;
|
/PHP-5.5/ext/pdo_oci/ |
H A D | oci_driver.c | 43 if (stmt) { in pdo_oci_fetch_error_func() 69 if (stmt) { in _oci_error() 70 S = (pdo_oci_stmt*)stmt->driver_data; in _oci_error() 72 pdo_err = &stmt->error_code; in _oci_error() 176 if (stmt) { in _oci_error() 316 stmt->driver_data = S; in oci_handle_preparer() 317 stmt->methods = &oci_stmt_methods; in oci_handle_preparer() 330 OCIStmt *stmt; in oci_handle_doer() local 340 OCIHandleFree(stmt, OCI_HTYPE_STMT); in oci_handle_doer() 348 OCIHandleFree(stmt, OCI_HTYPE_STMT); in oci_handle_doer() [all …]
|
/PHP-5.5/ext/pdo_sqlite/ |
H A D | php_pdo_sqlite_int.h | 66 sqlite3_stmt *stmt; member 73 extern int _pdo_sqlite_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, const char *file, int line TSRMLS_DC… 75 #define pdo_sqlite_error_stmt(s) _pdo_sqlite_error(stmt->dbh, stmt, __FILE__, __LINE__ TSRMLS_CC)
|
/PHP-5.5/ext/mysqli/ |
H A D | mysqli_prop.c | 354 ZVAL_LONG(*retval, mysqli_stmt_get_id(p->stmt)); in MYSQLI_MAP_PROPERTY_FUNC_LONG() 374 rc = mysql_stmt_affected_rows(p->stmt); in stmt_affected_rows_read() 396 MY_STMT * stmt; in stmt_error_list_read() local 403 if (stmt && stmt->stmt) { in stmt_error_list_read() 405 if (stmt->stmt->data && stmt->stmt->data->error_info->error_list) { in stmt_error_list_read() 408 …for (message = (MYSQLND_ERROR_LIST_ELEMENT *) zend_llist_get_first_ex(stmt->stmt->data->error_info… in stmt_error_list_read() 410 …message = (MYSQLND_ERROR_LIST_ELEMENT *) zend_llist_get_next_ex(stmt->stmt->data->error_info->erro… in stmt_error_list_read() 422 if (mysql_stmt_errno(stmt->stmt)) { in stmt_error_list_read() 426 add_assoc_long_ex(single_error, "errno", sizeof("errno"), mysql_stmt_errno(stmt->stmt)); in stmt_error_list_read() 427 …add_assoc_string_ex(single_error, "sqlstate", sizeof("sqlstate"), mysql_stmt_sqlstate(stmt->stmt),… in stmt_error_list_read() [all …]
|