/PHP-8.3/ext/pdo_oci/tests/ |
H A D | bug46274.phpt | 28 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl… 36 $stmt->bindparam(':id', $id); 37 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 38 $stmt->execute(); 46 $stmt->bindparam(':id', $id); 47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 48 $stmt->execute();
|
H A D | bug46274_2.phpt | 28 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl… 36 $stmt->bindparam(':id', $id); 37 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 38 $stmt->execute(); 46 $stmt->bindparam(':id', $id); 47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 48 $stmt->execute();
|
/PHP-8.3/ext/pdo_mysql/tests/ |
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());
|
H A D | pdo_mysql_types_zerofill.phpt | 25 $stmt->bindValue(1, $offset); 26 $stmt->bindValue(2, $value); 28 if (!$stmt->execute()) { 39 $stmt = $db->query('SELECT id, label FROM test'); 40 $row = $stmt->fetch(PDO::FETCH_ASSOC); 41 $stmt->closeCursor(); 80 $row_string = $stmt->fetch(PDO::FETCH_ASSOC); 81 $stmt->closeCursor(); 95 $stmt = $db->prepare('SELECT @@sql_mode AS _mode'); 96 $stmt->execute(); [all …]
|
H A D | pdo_mysql_fetch_both.phpt | 19 $stmt = $db->query('SELECT 1'); 20 $num = $stmt->fetch(PDO::FETCH_NUM); 22 $stmt = $db->query('SELECT 1'); 23 $assoc = $stmt->fetch(PDO::FETCH_ASSOC); 25 $stmt = $db->query('SELECT 1'); 26 $both = $stmt->fetch(PDO::FETCH_BOTH);
|
H A D | bug41125.phpt | 20 $stmt = $db->prepare($sql); 21 $stmt->execute(); 23 print implode(' - ', $stmt->errorinfo()) ."\n"; 35 $stmt = $db->prepare($query); 36 $stmt->execute(array(1)); 45 $stmt = $db->prepare($sql); 48 $stmt->bindParam(':id', $id); 49 $stmt->execute(); 76 $stmt = $db->prepare($query); 77 $stmt->bindParam(':id', $id); [all …]
|
H A D | pdo_mysql_stmt_bindparam_types.phpt | 26 if ((!$stmt = @$db->prepare($sql)) || (!@$stmt->execute())) 31 if (!$stmt->bindParam(1, $value)) { 33 var_export($stmt->errorInfo(), true)); 36 if (!$stmt->execute()) { 38 var_export($stmt->errorInfo(), true)); 44 if (!$stmt->bindColumn(1, $id)) { 49 if (!$stmt->bindColumn(2, $label)) { 55 if (!$stmt->fetch(PDO::FETCH_BOUND)) { 60 $stmt->closeCursor(); 69 $stmt->execute(); [all …]
|
H A D | pdo_mysql_stmt_getcolumnmeta.phpt | 12 $row = $stmt->fetch(PDO::FETCH_ASSOC); 33 $stmt->execute(); 37 $stmt->getColumnMeta(-1); 50 $stmt->execute(); 67 if (!($stmt = @$db->prepare($sql)) || (!@$stmt->execute())) { 79 $stmt->execute(); 85 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 138 $stmt->execute(); 230 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) { 251 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) { [all …]
|
H A D | pdo_mysql_stmt_nextrowset.phpt | 31 $stmt = $db->query('SELECT id FROM test'); 38 $tmp = $stmt->fetch(PDO::FETCH_ASSOC); 40 while ($stmt->fetch()) ; 47 var_dump($stmt->nextRowSet()); 55 $stmt = $db->query('CALL p()'); 58 } while ($stmt->nextRowSet()); 59 var_dump($stmt->nextRowSet()); 62 unset($stmt); 63 $stmt = $db->query('CALL p()'); 64 var_dump($stmt->nextRowSet()); [all …]
|
/PHP-8.3/ext/oci8/tests/ |
H A D | bug37220.phpt | 32 $stmt = oci_parse ($c, $query); 34 oci_bind_by_name($stmt, ':data', $clob, -1, OCI_B_CLOB); 36 $success = oci_execute($stmt, OCI_COMMIT_ON_SUCCESS); 37 oci_free_statement($stmt); 43 $stmt = oci_parse ($c, $query); 45 oci_execute($stmt); 47 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
|
H A D | bug71600.phpt | 33 $stmt = oci_parse($c, $sql); 36 oci_execute($stmt,OCI_DEFAULT); 39 oci_fetch_all($stmt, $result); 40 oci_free_statement($stmt); 54 $stmt = oci_parse($c, $sql); 57 oci_execute($stmt,OCI_DEFAULT); 60 oci_fetch_all($stmt, $result, 0, -1, OCI_FETCHSTATEMENT_BY_ROW); 61 oci_free_statement($stmt);
|
/PHP-8.3/ext/pdo/tests/ |
H A D | bug_65946.phpt | 38 $stmt = $db->prepare($sql); 39 $stmt->bindValue('limit', 1, PDO::PARAM_INT); 40 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo()); 41 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo()); 42 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
/PHP-8.3/ext/pdo_pgsql/tests/ |
H A D | bug43925.phpt | 33 $stmt = $dbh->prepare(' 43 $stmt->bindValue('left', 1, PDO::PARAM_INT); 44 $stmt->bindValue('rootId', 3, PDO::PARAM_INT); 45 $stmt->bindValue('x', 5, PDO::PARAM_INT); 46 $stmt->bindValue('y', 50, PDO::PARAM_INT); 48 $stmt->execute(); 50 foreach ($stmt->fetchAll() as $row) {
|
H A D | bug71885.phpt | 24 $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\''); 25 $stmt->execute(); 30 $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\''); 31 $stmt->execute(); 33 var_dump($stmt->fetch());
|
H A D | is_in_transaction.phpt | 26 $stmt = $db->prepare("INSERT INTO test_is_in_transaction (a, b) values (?, ?)"); 27 $stmt->bindValue(1, 1); 28 $stmt->bindValue(2, "test insert"); 29 $stmt->execute(); 39 $stmt = $db->prepare("INSERT INTO test_is_in_transaction (a, b) values (?, ?)"); 40 $stmt->bindValue(1, "error"); 41 $stmt->bindValue(2, "test insert"); 42 $stmt->execute();
|
/PHP-8.3/ext/mysqli/tests/ |
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()) { 42 $stmt->close();
|
H A D | 019.phpt | 29 …if (!$stmt = mysqli_prepare($link, "INSERT INTO insert_read(col1,col10, col11, col6) VALUES (?,?,?… 32 mysqli_stmt_bind_param($stmt, "issd", $c1, $c2, $c3, $c4); 39 mysqli_stmt_execute($stmt); 40 mysqli_stmt_close($stmt); 42 …if (!$stmt = mysqli_prepare($link, "SELECT col1, col2, col3, col4, col5, col6, col7, col8, col9, c… 45 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8, $c9, $c10, $c11); 46 mysqli_stmt_execute($stmt); 48 mysqli_stmt_fetch($stmt); 54 mysqli_stmt_close($stmt);
|
H A D | mysqli_report.phpt | 55 $stmt = mysqli_stmt_init($link); 110 mysqli_stmt_close($stmt); 121 mysqli_stmt_execute($stmt); 122 mysqli_stmt_close($stmt); 144 mysqli_stmt_close($stmt); 154 mysqli_stmt_execute($stmt); 155 mysqli_stmt_close($stmt); 273 printf("[026] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 276 printf("[027] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 278 mysqli_stmt_close($stmt); [all …]
|
H A D | bug34785.phpt | 31 $stmt = new my_stmt($link, "SELECT 'foo' FROM DUAL"); 33 $stmt->execute(); 34 $stmt->bind_result($var); 35 $stmt->fetch(); 37 $stmt->close();
|
H A D | mysqli_stmt_attr_get.phpt | 19 $stmt = mysqli_stmt_init($link); 20 mysqli_stmt_prepare($stmt, 'SELECT * FROM test'); 23 mysqli_stmt_attr_get($stmt, -100); 30 if (false === ($tmp = mysqli_stmt_attr_get($stmt, $attr))) { 36 $stmt->close(); 40 mysqli_stmt_attr_get($stmt, $attr);
|
H A D | mysqli_next_result_error.phpt | 34 $stmt = $mysqli->prepare("CALL p()"); 35 $stmt->execute(); 39 $stmt->bind_result($num); 40 while ($stmt->fetch()) { 43 } while ($stmt->more_results() && $stmt->next_result());
|
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 | bug_mysql_49406.phpt | 31 if (!$stmt = $link->prepare($query)) 34 if (!$stmt->execute() || !$stmt->store_result()) 35 printf("[006] [%d] %s\n", $stmt->errno, $stmt->error); 65 $meta_res = $stmt->result_metadata(); 82 if (!$stmt->bind_result($row_stmt) || !$stmt->fetch()) 83 printf("[007] [%d] %s\n", $stmt->errno, $stmt->error); 91 $stmt->close();
|
/PHP-8.3/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();
|
/PHP-8.3/ext/pdo_dblib/tests/ |
H A D | pdo_dblib_param_str_natl.phpt | 13 $stmt = $db->prepare('SELECT :value'); 14 $stmt->bindValue(':value', 'foo', PDO::PARAM_STR | PDO::PARAM_STR_NATL); 15 $stmt->execute(); 17 var_dump($stmt->debugDumpParams());
|