/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_stmt_blobs.phpt | 32 $stmt->bindValue(1, 1); 33 $stmt->bindValue(2, $value); 34 if (!$stmt->execute()) { 36 $offset, $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 40 $stmt = $db->query('SELECT id, label FROM test'); 42 $stmt->bindColumn(1, $id, PDO::PARAM_INT); 43 $stmt->bindColumn(2, $label, PDO::PARAM_LOB); 45 if (!$stmt->fetch(PDO::FETCH_BOUND)) { 47 $offset, $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 63 $stmt = $db->query('SELECT id, label FROM test'); [all …]
|
H A D | bug44327.phpt | 15 $stmt = $db->prepare("SELECT 1 AS \"one\""); 16 $stmt->execute(); 17 $row = $stmt->fetch(PDO::FETCH_LAZY); 28 $stmt = $db->prepare("SELECT id FROM test"); 29 $stmt->execute(); 30 $row = $stmt->fetch(PDO::FETCH_LAZY); 37 $stmt = $db->prepare('foo'); 38 @$stmt->execute(); 39 $row = $stmt->fetch();
|
H A D | pdo_mysql_attr_multi_statements.phpt | 26 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (2)', $table, $table)); 27 $stmt->closeCursor(); 30 $stmt = $db->query(sprintf('SELECT id FROM %s', $table)); 31 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 33 $stmt = $db->query('SELECT 1 AS value;'); 34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 39 var_dump($stmt); 43 $stmt = $db->query(sprintf('SELECT id FROM %s', $table)); 44 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 46 $stmt = $db->query('SELECT 1 AS value;'); [all …]
|
H A D | pdo_mysql_connect_attr.phpt | 12 $stmt = $pdo->query("select count(*) from information_schema.tables where table_schema='performance… 13 if (!$stmt || !$stmt->fetchColumn()) { 17 $stmt = $pdo->query("show variables like 'performance_schema'"); 18 if (!$stmt || $stmt->fetchColumn(1) !== 'ON') { 35 …$stmt = $pdo->query("select * from performance_schema.session_connect_attrs where ATTR_NAME='_serv… 37 $row = $stmt->fetch(PDO::FETCH_ASSOC); 46 $stmt = $pdo->query("select * from performance_schema.session_connect_attrs where ATTR_NAME='_clien… 48 $row = $stmt->fetch(PDO::FETCH_ASSOC);
|
H A D | pdo_mysql_attr_fetch_table_names.phpt | 16 $stmt = $db->query('SELECT label FROM test LIMIT 1'); 17 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 18 $stmt->closeCursor(); 21 $stmt = $db->query('SELECT label FROM test LIMIT 1'); 22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 23 $stmt->closeCursor();
|
H A D | pdo_mysql_prepare_match_against.phpt | 20 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)'); 21 $stmt->execute(array(':placeholder' => 'row')); 22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 24 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)'); 25 $stmt->execute(array('placeholder' => 'row')); 26 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 28 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (?)'); 29 $stmt->execute(array('row')); 30 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
/PHP-7.4/ext/mysqli/tests/ |
H A D | mysqli_stmt_execute_stored_proc_out.phpt | 33 if (!$stmt = mysqli_prepare($link, 'CALL p(?, ?)')) 38 if (!mysqli_stmt_bind_param($stmt, 'ss', $ver_in, $ver_out)) 39 …intf("[006] Cannot bind parameter, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 41 if (!mysqli_stmt_execute($stmt)) 42 …printf("[007] Cannot execute CALL, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 47 if (!mysqli_stmt_bind_result($stmt, $ver_out) || !mysqli_stmt_fetch($stmt)) 48 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 53 if (!mysqli_stmt_close($stmt)) 54 …ntf("[012] Cannot close statement, [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
|
H A D | mysqli_stmt_bind_result.phpt | 24 $stmt = mysqli_stmt_init($link); 26 printf("[002a] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 31 mysqli_stmt_close($stmt); 32 $stmt = mysqli_stmt_init($link); 42 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 54 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 60 mysqli_stmt_close($stmt); 99 mysqli_stmt_close($stmt); 142 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num); 305 printf("[3001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | bug48909.phpt | 20 if (!$stmt = $link->prepare("INSERT INTO test(id, label) VALUES (?, ?)")) 23 if (!$stmt->bind_param("bb",$bvar, $bvar)) 24 printf("[004] [%d] %s\n", $stmt->errno, $stmt->error); 26 if (!$stmt->execute()) { 27 if ($stmt->errno != 1366) { 32 printf("[005] [%d] %s\n", $stmt->errno, $stmt->error); 36 $stmt->close();
|
H A D | 021.phpt | 20 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?)"); 21 mysqli_stmt_bind_param($stmt, "ss", $q1, $q2); 24 mysqli_stmt_execute($stmt); 25 mysqli_stmt_close($stmt); 27 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 28 mysqli_stmt_bind_result($stmt, $c1, $c2); 29 mysqli_stmt_execute($stmt); 30 mysqli_stmt_fetch($stmt); 36 mysqli_stmt_close($stmt);
|
H A D | 022.phpt | 21 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?)"); 22 mysqli_stmt_bind_param($stmt, "ss", $a1, $a2); 27 mysqli_stmt_execute($stmt); 28 mysqli_stmt_close($stmt); 30 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 31 mysqli_stmt_bind_result($stmt, $c1, $c2); 32 mysqli_stmt_execute($stmt); 33 mysqli_stmt_fetch($stmt); 40 mysqli_stmt_close($stmt);
|
H A D | mysqli_stmt_errno.phpt | 24 if (!$stmt = mysqli_stmt_init($link)) 28 if (0 !== ($tmp = mysqli_stmt_errno($stmt))) 31 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id")) 35 if (0 === ($tmp = mysqli_stmt_errno($stmt))) 38 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id")) 39 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 42 if (0 != ($tmp = mysqli_stmt_errno($stmt))) 47 if (true === ($tmp = mysqli_stmt_execute($stmt))) 51 if (0 === ($tmp = mysqli_stmt_errno($stmt))) 54 mysqli_stmt_close($stmt); [all …]
|
H A D | mysqli_stmt_error.phpt | 24 if (!$stmt = mysqli_stmt_init($link)) 28 if ('' !== ($tmp = mysqli_stmt_error($stmt))) 31 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id")) 35 if ('' === ($tmp = mysqli_stmt_error($stmt))) 38 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id")) 39 printf("[007] [%d] %s\n", mysqli_stmt_error($stmt), mysqli_stmt_error($stmt)); 42 if ('' !== ($tmp = mysqli_stmt_error($stmt))) 47 if (true === ($tmp = mysqli_stmt_execute($stmt))) 51 if ('' === ($tmp = mysqli_stmt_error($stmt))) 54 mysqli_stmt_close($stmt); [all …]
|
H A D | 059.phpt | 22 $stmt = mysqli_prepare($link, "INSERT INTO mbind VALUES (?||?)"); 24 mysqli_stmt_bind_param($stmt, "ss", $a, $b); 29 mysqli_stmt_execute($stmt); 31 mysqli_stmt_close($stmt); 33 $stmt = mysqli_prepare($link, "SELECT * FROM mbind"); 34 mysqli_stmt_execute($stmt); 36 mysqli_stmt_bind_result($stmt, $e); 37 mysqli_stmt_fetch($stmt);
|
H A D | 064.phpt | 14 $stmt = new mysqli_stmt($mysql, "SELECT NULL FROM DUAL"); 15 $stmt->execute(); 16 $stmt->bind_result($foo); 17 $stmt->fetch(); 18 $stmt->close();
|
H A D | mysqli_stmt_get_result_geom.phpt | 40 if (!$stmt = mysqli_stmt_init($link)) { 46 … printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 47 mysqli_stmt_close($stmt); 51 if (!mysqli_stmt_execute($stmt)) { 52 … printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 53 mysqli_stmt_close($stmt); 57 … printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 58 mysqli_stmt_close($stmt); 115 $offset + 18, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num); 117 mysqli_stmt_close($stmt); [all …]
|
H A D | 063.phpt | 14 $stmt = new mysqli_stmt($mysql, "SELECT 'foo' FROM DUAL"); 15 $stmt->execute(); 16 $stmt->bind_result($foo); 17 $stmt->fetch(); 18 $stmt->close(); 24 $stmt = new mysqli_stmt($mysql, "SELECT invalid FROM DUAL");
|
/PHP-7.4/ext/oci8/tests/ |
H A D | bug43497.phpt | 21 $row = oci_fetch($stmt); 22 return oci_result($stmt, 1); 36 $row = oci_fetch($stmt); 37 $val = oci_result($stmt, 1); 38 oci_free_statement($stmt); 51 if (oci_execute($stmt)) { 66 if (oci_execute($stmt)) { 80 if (oci_execute($stmt)) { 92 oci_execute($stmt); 98 oci_execute($stmt); [all …]
|
H A D | bug72524.phpt | 26 $stmt = oci_parse($c, $sql); 30 oci_bind_by_name($stmt, ':clob_col', $clob); 31 oci_bind_by_name($stmt, ':varchar2_col', $varchar2); 33 var_dump(oci_execute($stmt)); 39 oci_bind_by_name($stmt, ':clob_col', $clob); 40 oci_bind_by_name($stmt, ':varchar2_col', $varchar2); 42 var_dump(oci_execute($stmt)); 47 oci_bind_by_name($stmt, ':clob_col', $clob, 0); 50 var_dump(oci_execute($stmt)); 58 var_dump(oci_execute($stmt)); [all …]
|
H A D | statement_cache.phpt | 17 $stmt = oci_parse($pc, "select 1+3 from dual"); 18 oci_execute($stmt); 19 var_dump(oci_fetch_array($stmt)); 21 $stmt = oci_parse($pc, "select 1+3 from dual"); 22 oci_execute($stmt); 23 var_dump(oci_fetch_array($stmt));
|
/PHP-7.4/ext/pdo/tests/ |
H A D | pdo_029.phpt | 55 $stmt->setFetchMode(PDO::FETCH_ASSOC); 56 $stmt->execute(); 57 return $stmt; 66 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)"); 67 var_dump(get_class($stmt)); 69 $stmt->execute($row); 72 unset($stmt); 76 $stmt = $db->query('SELECT * FROM test'); 77 var_dump(get_class($stmt)); 78 var_dump(get_class($stmt->dbh)); [all …]
|
H A D | bug_73234.phpt | 20 $stmt = $db->prepare('INSERT INTO test VALUES(:value)'); 22 $stmt->bindValue(':value', 0, PDO::PARAM_NULL); 23 $stmt->execute(); 25 $stmt->bindValue(':value', null, PDO::PARAM_NULL); 26 $stmt->execute(); 28 $stmt = $db->query('SELECT * FROM test'); 29 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
/PHP-7.4/ext/pdo_dblib/tests/ |
H A D | bug_69757.phpt | 18 $stmt = $db->query($sql); 19 $resultset1 = $stmt->fetchAll(PDO::FETCH_ASSOC); 20 if (true !== $stmt->nextRowset()) { 23 $resultset2 = $stmt->fetchAll(PDO::FETCH_ASSOC); 24 if (false !== $stmt->nextRowset()) { 27 $stmt->closeCursor();
|
/PHP-7.4/ext/pdo_sqlite/tests/ |
H A D | bug78192.phpt | 13 $stmt = $connection->prepare('INSERT INTO user (id, name) VALUES(:id, :name)'); 14 $stmt->execute([ 19 $stmt = $connection->prepare('SELECT * FROM user WHERE id = :id'); 20 $stmt->execute(['id' => 10]); 21 var_dump($stmt->fetchAll(\PDO::FETCH_ASSOC)); 24 $stmt->execute(['id' => 10]); 25 var_dump($stmt->fetchAll(\PDO::FETCH_ASSOC));
|
/PHP-7.4/ext/pdo_oci/ |
H A D | oci_statement.c | 71 if (S->stmt) { in oci_stmt_dtor() 78 S->stmt = NULL; in oci_stmt_dtor() 123 stmt->driver_data = NULL; in oci_stmt_dtor() 139 if (stmt->executed) { in oci_stmt_execute() 149 if (stmt->dbh->auto_commit && !stmt->dbh->in_txn) { in oci_stmt_execute() 159 if (!stmt->executed) { in oci_stmt_execute() 630 pdo_stmt_t *stmt; member 682 pdo_stmt_t *stmt = self->stmt; in oci_blob_close() local 737 self->stmt = stmt; in oci_create_lob_stream() 747 obj = &stmt->std; in oci_create_lob_stream() [all …]
|