/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | bug_45120.phpt | 18 $stmt = $db->prepare("SELECT 1 AS 'one'"); 19 if (true !== $stmt->execute()) 20 printf("[001] Execute has failed: %s\n", var_export($stmt->errorInfo(), true)); 22 $res = $stmt->fetch(PDO::FETCH_ASSOC); 26 if (true !== $stmt->execute()) 27 printf("[003] Execute has failed: %s\n", var_export($stmt->errorInfo(), true)); 29 $res = $stmt->fetch(PDO::FETCH_ASSOC);
|
H A D | bug_39858.phpt | 42 $stmt = $db->prepare("CALL p()"); 43 $stmt->execute(); 45 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 46 } while ($stmt->nextRowset()); 48 $stmt = $db->prepare("CALL p()"); 49 $stmt->execute(); 51 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 52 } while ($stmt->nextRowset()); 53 $stmt->closeCursor();
|
H A D | pdo_mysql_attr_oracle_nulls.phpt | 28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 32 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 35 $stmt = $db->query('SELECT VERSION() as _version'); 36 $row = $stmt->fetch(PDO::FETCH_ASSOC); 48 $stmt = $db->prepare('CALL p()'); 49 $stmt->execute(); 61 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC); 66 } while ($stmt->nextRowset()); 68 $stmt->execute(); 70 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC); [all …]
|
H A D | pdo_mysql_stmt_getcolumnmeta.phpt | 11 $row = $stmt->fetch(PDO::FETCH_ASSOC); 32 $stmt->execute(); 57 $stmt->execute(); 74 if (!($stmt = @$db->prepare($sql)) || (!@$stmt->execute())) { 86 $stmt->execute(); 87 $meta = $stmt->getColumnMeta(1); 92 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 145 $stmt->execute(); 238 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) { 259 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) { [all …]
|
H A D | bug_41997.phpt | 30 $stmt = $db->query("CALL p()"); 32 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 33 } while ($stmt->nextRowset()); 34 var_dump($stmt->errorInfo()); 36 $stmt = $db->query('SELECT 2 AS "two"'); 37 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 38 var_dump($stmt->errorInfo());
|
/PHP-7.4/ext/mysqli/tests/ |
H A D | bug35759.phpt | 35 $stmt = $mysql->prepare("SELECT * FROM test"); 36 if ($stmt) { 38 $stmt->execute(); 39 $stmt->store_result(); 43 call_user_func_array(array($stmt, "bind_result"), $params); 44 $stmt->fetch(); 46 $stmt->close();
|
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 | 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 | mysqli_stmt_get_result_types.phpt | 36 … printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 42 … printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 43 mysqli_stmt_close($stmt); 54 mysqli_stmt_close($stmt); 59 … printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 60 mysqli_stmt_close($stmt); 65 … printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 66 mysqli_stmt_close($stmt); 73 … printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 98 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num); [all …]
|
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 | 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_change_user_prepared_statements.phpt | 16 if (!$stmt = mysqli_prepare($link, "SELECT 'prepared statements should be released'")) 22 if ($stmt->execute() && $stmt->bind_result($wrong) && $stmt->fetch()) { 25 if ($stmt->errno == 0)
|
/PHP-7.4/ext/pdo_firebird/tests/ |
H A D | bug_64037.phpt | 22 $stmt = $dbh->prepare($query); 23 $stmt->execute(); 24 $rows = $stmt->fetchAll(); 30 $stmt = $dbh->prepare('DELETE FROM price'); 31 $stmt->execute(); 37 unset($stmt);
|
/PHP-7.4/ext/mysqlnd/ |
H A D | mysqlnd_driver.c | 193 MYSQLND_STMT_DATA * stmt = NULL; in MYSQLND_METHOD() local 203 DBG_INF_FMT("stmt=%p", stmt); in MYSQLND_METHOD() 204 if (!stmt) { in MYSQLND_METHOD() 211 stmt->error_info = &stmt->error_info_impl; in MYSQLND_METHOD() 214 stmt->upsert_status = &(stmt->upsert_status_impl); in MYSQLND_METHOD() 215 stmt->state = MYSQLND_STMT_INITTED; in MYSQLND_METHOD() 216 stmt->execute_cmd_buffer.length = 4096; in MYSQLND_METHOD() 217 stmt->execute_cmd_buffer.buffer = mnd_emalloc(stmt->execute_cmd_buffer.length); in MYSQLND_METHOD() 218 if (!stmt->execute_cmd_buffer.buffer) { in MYSQLND_METHOD() 222 stmt->prefetch_rows = MYSQLND_DEFAULT_PREFETCH_ROWS; in MYSQLND_METHOD() [all …]
|
/PHP-7.4/ext/sqlite3/tests/ |
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-7.4/ext/oci8/tests/ |
H A D | error_bind.phpt | 22 $stmt = oci_parse($c, "insert into bind_test values (:name)"); 23 oci_bind_by_name($stmt, ":name", $name, 10, SQLT_CHR); 24 var_dump(oci_execute($stmt)); 28 var_dump(oci_execute($stmt)); 31 oci_bind_by_name($stmt, ":name", $c); 32 var_dump(oci_execute($stmt)); 37 $stmt = oci_parse($c, "update bind_test set name='xyz' returning rowid into :r_id"); 38 oci_bind_by_name($stmt, ":r_id", $c); 39 var_dump(oci_execute($stmt));
|
H A D | bug37220.phpt | 29 $stmt = oci_parse ($c, $query); 31 oci_bind_by_name($stmt, ':data', $clob, -1, OCI_B_CLOB); 33 $success = oci_execute($stmt, OCI_COMMIT_ON_SUCCESS); 34 oci_free_statement($stmt); 40 $stmt = oci_parse ($c, $query); 42 oci_execute($stmt); 44 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
|
/PHP-7.4/ext/pdo/tests/ |
H A D | pdo_025.phpt | 30 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)"); 32 $stmt->execute($row); 39 $stmt = $db->prepare('SELECT * FROM test'); 40 $stmt->setFetchMode(PDO::FETCH_INTO, new Test); 41 $stmt->execute(); 43 foreach($stmt as $obj) { 54 $stmt->setFetchMode(PDO::FETCH_INTO, new Fail); 55 $stmt->execute(); 57 foreach($stmt as $obj) {
|
H A D | pdo_013.phpt | 23 $stmt = $db->prepare($SELECT); 25 $stmt->execute(); 26 $stmt->setFetchMode(PDO::FETCH_NUM); 27 foreach ($stmt as $data) 40 unset($stmt); 47 unset($stmt); 49 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test', array('WOW')); 51 foreach($stmt as $data)
|
H A D | bug_65946.phpt | 37 $stmt = $db->prepare($sql); 38 $stmt->bindValue('limit', 1, PDO::PARAM_INT); 39 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo()); 40 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo()); 41 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
/PHP-7.4/ext/pdo_oci/tests/ |
H A D | pdo_oci_attr_module.phpt | 20 $stmt = $dbh->query($query); 21 $row = $stmt->fetch(); 27 $stmt = $dbh->query($query); 28 $row = $stmt->fetch(); 34 $stmt = $dbh->query($query); 35 $row = $stmt->fetch();
|
H A D | bug46274.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-7.4/ext/pdo_pgsql/tests/ |
H A D | is_in_transaction.phpt | 24 $stmt = $db->prepare("INSERT INTO test (a, b) values (?, ?)"); 25 $stmt->bindValue(1, 1); 26 $stmt->bindValue(2, "test insert"); 27 $stmt->execute(); 37 $stmt = $db->prepare("INSERT INTO test (a, b) values (?, ?)"); 38 $stmt->bindValue(1, "error"); 39 $stmt->bindValue(2, "test insert"); 40 $stmt->execute();
|
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-7.4/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_tostring_exception.phpt | 17 $stmt = $db->prepare('INSERT INTO t VALUES(:i, :v)'); 19 $stmt->bindValue('i', $param1); 21 $stmt->bindParam('v', $param2); 26 $stmt->execute(); 32 $stmt->execute();
|