/php-src/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_stmt_errorinfo.phpt | 25 var_dump($stmt->errorInfo()); 26 $stmt->execute(); 27 var_dump($stmt->errorInfo()); 30 $stmt = $db->prepare("SELECT label FROM {$table} ORDER BY id ASC LIMIT 1"); 32 var_dump($stmt->execute()); 33 var_dump($stmt->errorInfo()); 48 var_dump($stmt); 51 $stmt = $db->prepare("SELECT label FROM {$table} ORDER BY id ASC LIMIT 1"); 52 var_dump($stmt->errorInfo()); 54 $stmt->execute(); [all …]
|
H A D | pdo_mysql_attr_oracle_nulls.phpt | 35 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 39 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 42 $stmt = $db->query('SELECT VERSION() as _version'); 43 $row = $stmt->fetch(PDO::FETCH_ASSOC); 55 $stmt = $db->prepare("CALL {$procedure}()"); 56 $stmt->execute(); 58 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 59 } while ($stmt->nextRowset()); 61 $stmt->execute(); 63 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); [all …]
|
H A D | pdo_mysql_errorcode.phpt | 37 $stmt = $db->query("SELECT id, label FROM {$table}"); 38 $stmt2 = &$stmt; 40 check_error(4, $stmt); 43 @$stmt->execute(); 45 check_error(5, $stmt, '42S02'); 49 @$stmt = $db->query('SELECT id, label FROM pdo_mysql_errorcode_unknown'); 53 $stmt = $db->query("SELECT id, label FROM {$table}"); 55 check_error(9, $stmt); 61 check_error(12, $stmt); 69 check_error(16, $stmt);
|
H A D | pdo_mysql_attr_fetch_table_names.phpt | 20 $stmt = $db->query("SELECT label FROM {$table} LIMIT 1"); 21 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 22 $stmt->closeCursor(); 26 $stmt = $db->query("SELECT label FROM {$table} LIMIT 1"); 27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 28 $stmt->closeCursor();
|
H A D | pdo_mysql_prepare_emulated_myisam_index.phpt | 21 $stmt = @$db->prepare($query); 23 $stmt = $db->prepare($query); 49 $ret = @$stmt->execute($input_params); 51 $ret = $stmt->execute($input_params); 58 $tmp = $stmt->errorInfo(); 84 return $stmt; 133 $stmt = prepex(14, $db, $sql, array(-1)); 134 if (count(($tmp = $stmt->fetchAll(PDO::FETCH_ASSOC))) != 0) 140 $stmt = prepex(15, $db, $sql, array(1)); 145 $stmt = prepex(16, $db, $sql, array(1, 1)); [all …]
|
H A D | pdo_mysql_prepare_native_anonymous_placeholder.phpt | 18 $stmt = @$db->prepare($query); 20 $stmt = $db->prepare($query); 42 if (!is_object($stmt)) 50 $ret = @$stmt->execute($input_params); 52 $ret = $stmt->execute($input_params); 58 $tmp = $stmt->errorInfo(); 90 return $stmt; 138 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC); 200 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC); 217 $stmt = prepex(30, $db, $sql, array(-1)); [all …]
|
H A D | pdo_mysql_prepare_native.phpt | 18 $stmt = @$db->prepare($query); 20 $stmt = $db->prepare($query); 42 if (!is_object($stmt)) 50 $ret = @$stmt->execute($input_params); 52 $ret = $stmt->execute($input_params); 58 $tmp = $stmt->errorInfo(); 90 return $stmt; 105 $stmt = prepex(4, $db, 'SELECT 1 as "one"'); 113 $row = $stmt->fetch(PDO::FETCH_ASSOC); 121 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); [all …]
|
/php-src/ext/pdo/tests/ |
H A D | bug_39656.phpt | 24 $stmt = $db->prepare("SELECT * FROM test39656 WHERE id = ?"); 25 $stmt->bindValue(1, 1, PDO::PARAM_INT ); 26 $stmt->execute(); 27 $row = $stmt->fetch(); 30 $stmt->execute(); 31 $stmt->closeCursor(); 32 $row = $stmt->fetch(); // this line will crash CLI
|
H A D | pdo_028.phpt | 19 $stmt = $db->prepare('INSERT INTO test028 values (1, ?, ?, ?)'); 24 $stmt->bindValue($i+1, $v); 26 $stmt->execute(); 28 $stmt = $db->prepare('SELECT * from test028'); 29 $stmt->execute(); 31 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
/php-src/ext/mysqli/tests/ |
H A D | mysqli_stmt_bind_result_zerofill.phpt | 29 if (!($stmt = mysqli_prepare($link, 'SELECT zero FROM test LIMIT 1'))) { 36 if (!mysqli_stmt_bind_result($stmt, $result)) { 38 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 42 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_fetch($stmt)) { 44 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 48 $res = mysqli_stmt_result_metadata($stmt); 50 mysqli_stmt_free_result($stmt);
|
H A D | bug33263.phpt | 23 $stmt = $mysql->prepare("SELECT DATABASE()"); 24 $stmt->execute(); 25 $stmt->bind_result($database); 26 $stmt->fetch(); 27 $stmt->close();
|
H A D | bug35759.phpt | 36 $stmt = $mysql->prepare("SELECT * FROM test"); 37 if ($stmt) { 39 $stmt->execute(); 40 $stmt->store_result(); 44 call_user_func_array(array($stmt, "bind_result"), $params); 45 $stmt->fetch(); 47 $stmt->close();
|
H A D | gh12107.phpt | 24 $stmt = $mysqli->prepare("call `gh12107`()"); 25 $stmt->execute(); 26 $stmt->bind_result($output); 27 var_dump($stmt->fetch()); 33 $stmt->execute(); 34 $stmt->bind_result($output); 35 var_dump($stmt->fetch());
|
H A D | mysqli_stmt_get_result_types.phpt | 33 … printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 39 … printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 40 mysqli_stmt_close($stmt); 51 mysqli_stmt_close($stmt); 56 … printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 57 mysqli_stmt_close($stmt); 62 … printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 63 mysqli_stmt_close($stmt); 70 … printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 95 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num); [all …]
|
H A D | bug66124.phpt | 34 $stmt = $link->prepare($table_insert); 35 if (!$stmt) { 41 $stmt->bind_param('i', $id); 43 if ($stmt->execute()){ 44 echo "insert id:{$id}=>{$stmt->insert_id}\n"; 62 $stmt->close(); 68 $stmt = $link->prepare($table_insert); 69 $stmt->bind_param('s', $id); 73 if ($stmt->execute()){
|
H A D | bug76386.phpt | 39 $stmt = $link->prepare('SELECT * FROM ts_test;'); // must be statement 40 if ($stmt) { 41 $stmt->execute(); 44 $stmt->fetch(); 46 $stmt->free_result(); 67 $stmt = $link->prepare('SELECT * FROM t_test;'); 68 if ($stmt) { 69 $stmt->execute(); 71 $stmt->bind_result($tid, $t, $t2, $t4, $t6); 72 while ($stmt->fetch()) { [all …]
|
H A D | mysqli_stmt_get_result_metadata_fetch_field.phpt | 20 if (!($stmt = mysqli_stmt_init($link)) || 21 …!mysqli_stmt_prepare($stmt, "SELECT id, label, id + 1 as _id, concat(label, '_') ___label FROM te… 22 !mysqli_stmt_execute($stmt)) 23 printf("[001] [%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)); 57 mysqli_stmt_close($stmt);
|
/php-src/ext/sqlite3/tests/ |
H A D | sqlite3_28_clear_bindings.phpt | 19 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC"); 22 var_dump($stmt->bindParam(1, $foo, SQLITE3_TEXT)); 24 $results = $stmt->execute(); 28 $stmt->reset(); 29 $stmt->clear(); 30 var_dump($stmt->bindValue(1, 'b', SQLITE3_TEXT)); 31 $results = $stmt->execute();
|
H A D | exception_from_toString.phpt | 17 $stmt = $db->prepare('INSERT INTO t VALUES(:i, :v)'); 18 $stmt->bindValue('i', 1234); 19 $stmt->bindValue('v', new throws); 22 $stmt->execute(); 28 $stmt->execute();
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | bug43925.phpt | 29 $stmt = $dbh->prepare(' 39 $stmt->bindValue('left', 1, PDO::PARAM_INT); 40 $stmt->bindValue('rootId', 3, PDO::PARAM_INT); 41 $stmt->bindValue('x', 5, PDO::PARAM_INT); 42 $stmt->bindValue('y', 50, PDO::PARAM_INT); 44 $stmt->execute(); 46 foreach ($stmt->fetchAll() as $row) {
|
H A D | bug71885_2.phpt | 31 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ?? ?"); 32 $stmt->execute(['b']); 33 var_dump($stmt->fetch()); 35 $stmt = $db->prepare("SELECT {$jsonb}::jsonb ???"); 36 $stmt->execute(['a']); 37 var_dump($stmt->fetch());
|
H A D | bug46274_2.phpt | 26 $stmt = $db->prepare("INSERT INTO test_one_blob_46274_2 (blob1) VALUES (:foo)"); 33 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 34 $stmt->execute(); 37 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 38 $stmt->execute(); 45 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 46 $stmt->execute(); 49 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 50 $stmt->execute();
|
/php-src/ext/mysqlnd/ |
H A D | mysqlnd_driver.c | 193 MYSQLND_STMT_DATA * stmt = NULL; in MYSQLND_METHOD() local 198 stmt = ret->data = mnd_ecalloc(1, sizeof(MYSQLND_STMT_DATA)); in MYSQLND_METHOD() 199 DBG_INF_FMT("stmt=%p", stmt); in MYSQLND_METHOD() 201 mysqlnd_error_info_init(&stmt->error_info_impl, 0); in MYSQLND_METHOD() 202 stmt->error_info = &stmt->error_info_impl; in MYSQLND_METHOD() 204 mysqlnd_upsert_status_init(&stmt->upsert_status_impl); in MYSQLND_METHOD() 205 stmt->upsert_status = &(stmt->upsert_status_impl); in MYSQLND_METHOD() 206 stmt->state = MYSQLND_STMT_INITTED; in MYSQLND_METHOD() 208 stmt->execute_cmd_buffer.buffer = mnd_emalloc(stmt->execute_cmd_buffer.length); in MYSQLND_METHOD() 209 stmt->prefetch_rows = MYSQLND_DEFAULT_PREFETCH_ROWS; in MYSQLND_METHOD() [all …]
|
/php-src/ext/pdo/ |
H A D | php_pdo_driver.h | 317 typedef int (*pdo_stmt_dtor_func)(pdo_stmt_t *stmt); 320 typedef int (*pdo_stmt_execute_func)(pdo_stmt_t *stmt); 325 typedef int (*pdo_stmt_fetch_func)(pdo_stmt_t *stmt, 330 typedef int (*pdo_stmt_describe_col_func)(pdo_stmt_t *stmt, int colno); 338 pdo_stmt_t *stmt, int colno, zval *result, enum pdo_param_type *type); 393 typedef int (*pdo_stmt_next_rowset_func)(pdo_stmt_t *stmt); 399 typedef int (*pdo_stmt_cursor_closer_func)(pdo_stmt_t *stmt); 545 pdo_stmt_t *stmt; /* for convenience in dtor */ member 647 pdo_stmt_t *stmt; member 679 PDO_API void pdo_raise_impl_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, [all …]
|
/php-src/ext/mysqli/tests/bind_fetch/ |
H A D | system_variable.phpt | 18 $stmt = mysqli_prepare($link, "SELECT @@autocommit"); 20 mysqli_stmt_bind_result($stmt, $c0); 21 mysqli_stmt_execute($stmt); 23 mysqli_stmt_fetch($stmt);
|