/php-src/ext/pdo/tests/ |
H A D | pdo_007.phpt | 23 $stmt = $db->prepare('SELECT id, val from test007'); 25 $stmt->execute(); 26 var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_UNIQUE)); 28 $stmt->execute(); 29 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_UNIQUE));
|
H A D | pdo_031.phpt | 27 $stmt = $db->prepare("INSERT INTO test031 VALUES(?, ?, ?)"); 29 $stmt->execute($row); 32 unset($stmt); 36 $stmt = $db->query('SELECT * FROM test031'); 38 foreach(new RecursiveTreeIterator(new RecursiveArrayIterator($stmt->fetchAll(PDO::FETCH_ASSOC)), Re…
|
H A D | bug_72368.phpt | 24 $stmt = $db->prepare($sql); 25 var_dump($stmt->execute($params)); 33 $stmt = $db->prepare($sql); 34 var_dump($stmt->execute($params));
|
/php-src/ext/pdo_odbc/tests/ |
H A D | bug80783.phpt | 19 $stmt = $db->prepare("SELECT name FROM bug80783"); 20 $stmt->bindColumn(1, $data, PDO::PARAM_LOB); 21 $stmt->execute(); 22 $stmt->fetch(PDO::FETCH_BOUND);
|
/php-src/ext/sqlite3/tests/ |
H A D | bug76665.phpt | 9 $stmt = $db->prepare("INSERT INTO foo VALUES (:bar)"); 10 $stmt->bindValue(':bar', 17, SQLITE3_FLOAT); 11 $stmt->execute();
|
H A D | bug71049.phpt | 12 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC"); 14 $stmt->bindParam(1, $foo, SQLITE3_BLOB); 15 $results = $stmt->execute();
|
/php-src/ext/pdo_dblib/tests/ |
H A D | bug_71667.phpt | 16 $stmt = $db->prepare("SELECT 1, 2 AS named, 3"); 17 $stmt->execute(); 18 var_dump($stmt->fetchAll());
|
H A D | bug_68957.phpt | 17 $stmt = $db->query($query); 18 $stmt->nextRowset(); // Added line 19 $rows = $stmt->fetchAll();
|
H A D | stringify_uniqueidentifier.phpt | 34 $stmt = $db->query($sql); 35 $row = $stmt->fetch(PDO::FETCH_ASSOC); 44 $stmt = $db->query($sql); 45 $row = $stmt->fetch(PDO::FETCH_ASSOC); 58 $stmt = $db->query($sql); 59 $row = $stmt->fetch(PDO::FETCH_ASSOC);
|
/php-src/ext/pdo_sqlite/tests/ |
H A D | bug79664.phpt | 10 $stmt = $pdo->query('select 1 where 0'); 11 if ($stmt->columnCount()) { 12 var_dump($stmt->getColumnMeta(0));
|
/php-src/ext/sqlite3/ |
H A D | sqlite3.c | 556 zval stmt; in PHP_METHOD() local 591 zval_ptr_dtor(&stmt); in PHP_METHOD() 677 sqlite3_stmt *stmt; in PHP_METHOD() local 707 return_code = sqlite3_step(stmt); in PHP_METHOD() 740 sqlite3_finalize(stmt); in PHP_METHOD() 1645 hash = stmt->bound_params; in register_bound_parameter_to_sqlite() 1650 stmt->bound_params = hash; in register_bound_parameter_to_sqlite() 1665 param->param_number = sqlite3_bind_parameter_index(stmt->stmt, ZSTR_VAL(param->name)); in register_bound_parameter_to_sqlite() 1778 sqlite3_reset(stmt_obj->stmt); in PHP_METHOD() 1793 sqlite3_reset(stmt_obj->stmt); in PHP_METHOD() [all …]
|
/php-src/ext/mysqli/tests/ |
H A D | bug35517.phpt | 17 $stmt = $mysql->prepare("SELECT id FROM temp"); 18 $stmt->execute(); 19 $stmt->bind_result($id); 20 while ($stmt->fetch()) { 32 $stmt->close();
|
H A D | bug69899.phpt | 2 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 D | mysqli_stmt_result_metadata.phpt | 13 if (!$stmt = mysqli_stmt_init($link)) 17 mysqli_stmt_result_metadata($stmt); 22 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) 23 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 25 if (!is_object(($res = mysqli_stmt_result_metadata($stmt)))) 75 mysqli_stmt_close($stmt); 78 mysqli_stmt_result_metadata($stmt);
|
H A D | mysqli_fetch_array_large.phpt | 58 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 D | bug32405.phpt | 23 if ($stmt = $link->prepare("SELECT SQL_NO_CACHE user_id, login FROM test_users")) { 24 $stmt->execute(); 25 $stmt->bind_result($col1, $col2); 26 while ($stmt->fetch()) { 29 $stmt->close();
|
/php-src/ext/mysqli/tests/bind_fetch/ |
H A D | varied_data_types.phpt | 33 $stmt = mysqli_prepare($link, "SELECT col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, … 34 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8, $c9, $c10, $c11, $c12); 35 mysqli_stmt_execute($stmt); 37 mysqli_stmt_fetch($stmt); 43 mysqli_stmt_close($stmt);
|
/php-src/ext/pdo_odbc/ |
H A D | php_pdo_odbc_int.h | 140 PDO_ODBC_HSTMT stmt; member 163 void pdo_odbc_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, PDO_ODBC_HSTMT statement, char *what, const c… 165 #define pdo_odbc_stmt_error(what) pdo_odbc_error(stmt->dbh, stmt, SQL_NULL_HSTMT, what, __FILE__, _… 166 #define pdo_odbc_doer_error(what) pdo_odbc_error(dbh, NULL, stmt, what, __FILE__, __LINE__)
|
/php-src/ext/pdo_mysql/tests/ |
H A D | bug53551.phpt | 25 $stmt = $db->prepare($sql); 32 $stmt->execute($values); 33 var_dump($stmt->errorInfo()); 36 $stmt->execute($values); 37 var_dump($stmt->errorInfo());
|
H A D | pdo_mysql_begintransaction.phpt | 41 $row = $stmt->fetch(PDO::FETCH_ASSOC); 59 var_dump($stmt->fetch(PDO::FETCH_ASSOC)); 69 $new_row1 = $stmt->fetch(PDO::FETCH_ASSOC); 78 $new_row2 = $stmt->fetch(PDO::FETCH_ASSOC); 100 $new_row2 = $stmt->fetch(PDO::FETCH_ASSOC); 108 if (!($stmt = $db->query('SELECT @@autocommit as auto_commit'))) 111 $tmp = $stmt->fetch(PDO::FETCH_ASSOC); 114 $tmp['auto_commit'], $stmt->errorCode(), $stmt->errorInfo()); 122 $tmp = $stmt->fetch(PDO::FETCH_ASSOC); 125 $tmp['auto_commit'], $stmt->errorCode(), trim(implode(' ', $stmt->errorInfo()))); [all …]
|
H A D | bug_39483.phpt | 16 $stmt = $db->prepare('SELECT UPPER(\'\0:D\0\'),?'); 17 $stmt->execute([1]); 18 var_dump($stmt->fetchAll(PDO::FETCH_NUM));
|
H A D | bug_44454.phpt | 21 $stmt = $db->query('SELECT a, b FROM test_44454'); 22 printf("... SELECT has returned %d row...\n", $stmt->rowCount()); 23 while ($row = $stmt->fetch()) { 28 printf("... STMT - %s\n", var_export($stmt->errorCode(), true)); 41 $stmt = $db->query('SELECT a, b FROM test_44454'); 42 printf("... SELECT has returned %d row...\n", $stmt->rowCount()); 43 foreach ($stmt as $row) { 48 printf("... STMT - %s\n", var_export($stmt->errorCode(), true));
|
H A D | pdo_mysql_stmt_errorcode.phpt | 23 …$stmt = $db->prepare('SELECT id FROM pdo_mysql_stmt_errorcode_ihopeitdoesnotexist ORDER BY id ASC'… 24 $stmt->execute(); 25 var_dump($stmt->errorCode()); 39 …$stmt = $db->prepare('SELECT id FROM pdo_mysql_stmt_errorcode_ihopeitdoesnotexist ORDER BY id ASC'… 40 $stmt->execute(); 41 var_dump($stmt->errorCode());
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | bug70313.phpt | 20 $stmt = $db->prepare(");"); 22 $stmt->execute([1]); 29 $stmt = $db->prepare(");"); 31 $stmt->execute([1]);
|
/php-src/ext/pdo/ |
H A D | pdo_dbh.c | 83 if (stmt) { in pdo_raise_impl_error() 141 if (stmt) { in pdo_handle_error() 550 pdo_stmt_t *stmt; in PHP_METHOD() local 619 stmt->dbh = dbh; in PHP_METHOD() 1152 pdo_stmt_t *stmt; in PHP_METHOD() local 1182 stmt->active_query_string = zend_string_copy(stmt->query_string); in PHP_METHOD() 1184 stmt->dbh = dbh; in PHP_METHOD() 1195 if (stmt->methods->executer(stmt)) { in PHP_METHOD() 1197 if (!stmt->executed) { in PHP_METHOD() 1201 stmt->executed = 1; in PHP_METHOD() [all …]
|