/PHP-7.4/ext/mysqli/tests/ |
H A D | mysqli_stmt_fetch_bit.phpt | 33 if (!$stmt = mysqli_stmt_init($link)) 41 if (!mysqli_stmt_prepare($stmt, $sql) || 42 !mysqli_stmt_execute($stmt)) 43 … printf("[004 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 47 if (!mysqli_stmt_prepare($stmt, $sql) || 48 !mysqli_stmt_execute($stmt) || 49 !mysqli_stmt_bind_result($stmt, $id, $_label0, $label)) 50 … printf("[005 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 52 if (!mysqli_stmt_fetch($stmt)) 53 … printf("[006 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | bug35103.phpt | 26 $stmt = $mysql->prepare("SELECT a FROM test_bint ORDER BY a"); 27 $stmt->bind_result($v); 28 $stmt->execute(); 32 $stmt->fetch(); 35 $stmt->close(); 39 $stmt = $mysql->prepare("SELECT a FROM test_buint ORDER BY a"); 40 $stmt->bind_result($v2); 41 $stmt->execute(); 45 $stmt->fetch(); 48 $stmt->close();
|
H A D | mysqli_stmt_bind_result_format.phpt | 67 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 74 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 81 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 91 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 98 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 116 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 138 mysqli_stmt_close($stmt); 284 mysqli_stmt_close($stmt); 297 if (!$stmt->execute()) { 323 $stmt->free_result(); [all …]
|
H A D | 023.phpt | 27 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?,?,?,?,?,?)"); 28 mysqli_stmt_bind_param($stmt, "iiiiiii", $c1,$c2,$c3,$c4,$c5,$c6,$c7); 37 mysqli_stmt_execute($stmt); 38 mysqli_stmt_close($stmt); 40 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 41 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7); 42 mysqli_stmt_execute($stmt); 43 mysqli_stmt_fetch($stmt); 49 mysqli_stmt_close($stmt);
|
H A D | 024.phpt | 27 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?,?,?,?,?,?)"); 28 mysqli_stmt_bind_param($stmt, "iiiiiii", $c1,$c2,$c3,$c4,$c5,$c6,$c7); 38 mysqli_stmt_execute($stmt); 39 mysqli_stmt_close($stmt); 41 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 42 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7); 43 mysqli_stmt_execute($stmt); 44 mysqli_stmt_fetch($stmt); 50 mysqli_stmt_close($stmt);
|
H A D | mysqli_stmt_bind_limits.phpt | 38 …$stmt_bind_param = 'return mysqli_stmt_bind_param($stmt, "' . $stmt_types . '", ' . $stmt_params .… 48 if (!$stmt = $link->prepare($insert)) { 52 if ($stmt->param_count != $num_params * $rows) { 56 printf("... statement with %d parameters prepared\n", $stmt->param_count); 60 printf("[%03d + 03] [%d] %s\n", $offset, $stmt->errno, $stmt->error); 69 if (!call_user_func_array(array($stmt, 'bind_param'), $param_ref)) { 70 printf("[%03d + 03] [%d] %s\n", $offset, $stmt->errno, $stmt->error); 74 if ($stmt->param_count != $num_params * $rows) { 79 if (!$stmt->execute()) { 80 printf("[%03d + 04] [%d] %s\n", $offset, $stmt->errno, $stmt->error); [all …]
|
H A D | mysqli_stmt_bind_param_type_juggling.phpt | 27 if (!$stmt = mysqli_stmt_init($link)) { 32 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(col1, col2) VALUES (?, ?)")) { 33 … printf("[%03d + 4] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 37 if (!mysqli_stmt_bind_param($stmt, $bind_type1 . $bind_type2, $bind_value1, $bind_value1)) { 38 … printf("[%03d + 5] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 42 if (!mysqli_stmt_execute($stmt)) { 43 … printf("[%03d + 6] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 48 … printf("[%03d + 7] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 51 if (!mysqli_stmt_execute($stmt)) { 52 … printf("[%03d + 8] [%d] %s\n", $offset, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
/PHP-7.4/ext/pdo_oci/tests/ |
H A D | pdo_oci_attr_action.phpt | 18 $stmt = $dbh->query($query); 19 $row = $stmt->fetch(); 25 $stmt = $dbh->query($query); 26 $row = $stmt->fetch(); 32 $stmt = $dbh->query($query); 33 $row = $stmt->fetch(); 39 $stmt = $dbh->query($query); 40 $row = $stmt->fetch();
|
H A D | pdo_oci_attr_client_info.phpt | 18 $stmt = $dbh->query($query); 19 $row = $stmt->fetch(); 25 $stmt = $dbh->query($query); 26 $row = $stmt->fetch(); 32 $stmt = $dbh->query($query); 33 $row = $stmt->fetch(); 39 $stmt = $dbh->query($query); 40 $row = $stmt->fetch();
|
H A D | pdo_oci_attr_client_identifier.phpt | 18 $stmt = $dbh->query($query); 19 $row = $stmt->fetch(); 25 $stmt = $dbh->query($query); 26 $row = $stmt->fetch(); 32 $stmt = $dbh->query($query); 33 $row = $stmt->fetch(); 39 $stmt = $dbh->query($query); 40 $row = $stmt->fetch();
|
/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_emulated.phpt | 20 $stmt = @$db->prepare($query); 22 $stmt = $db->prepare($query); 48 $ret = @$stmt->execute($input_params); 50 $ret = $stmt->execute($input_params); 57 $tmp = $stmt->errorInfo(); 83 return $stmt; 96 $stmt = prepex(4, $db, 'SELECT 1 as "one"'); 97 var_dump($stmt->fetch(PDO::FETCH_ASSOC)); 293 $stmt = prepex(79, $db, $sql, array(-1)); 300 $stmt = prepex(81, $db, $sql, array(1)); [all …]
|
H A D | bug_pecl_12925.phpt | 21 $stmt = $db->prepare("UPDATE test SET id = 'b'"); 22 $stmt->execute(); 23 $stmt = $db->prepare("UPDATE test SET id = 'c'"); 24 $stmt->execute(); 25 $stmt = $db->prepare('SELECT id FROM test'); 26 $stmt->execute(); 27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 28 $stmt->closeCursor();
|
H A D | pdo_mysql_stmt_columncount.phpt | 25 $stmt = $db->prepare("SELECT id, label, '?' as foo FROM test"); 26 $stmt->execute(); 27 var_dump($stmt->columnCount()); 29 $stmt = $db->query('SELECT * FROM test'); 30 var_dump($stmt->columnCount()); 43 $stmt = $db->prepare("SELECT id, label, '?' as foo, 'TODO - Stored Procedure' as bar FROM test"); 44 $stmt->execute(); 45 var_dump($stmt->columnCount()); 47 $stmt = $db->query('SELECT * FROM test'); 48 var_dump($stmt->columnCount());
|
H A D | pdo_mysql_prepare_native_placeholder_everywhere.phpt | 23 $stmt = $db->prepare('SELECT ?, id, label FROM test WHERE ? = ? ORDER BY id ASC'); 24 $stmt->execute(array('id', 'label', 'label')); 25 if ('00000' !== $stmt->errorCode()) 27 var_export($stmt->errorCode(), true), 28 var_export($stmt->errorInfo(), true)); 29 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 38 $stmt->execute(array('id', 'label', 'label')); 39 if ('00000' !== $stmt->errorCode()) 41 var_export($stmt->errorCode(), true), 42 var_export($stmt->errorInfo(), true)); [all …]
|
/PHP-7.4/ext/pdo_sqlite/tests/ |
H A D | bug_63916.phpt | 14 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)'); 15 $stmt->bindValue(':id', 1, PDO::PARAM_INT); 16 $stmt->bindValue(':num', $num, PDO::PARAM_INT); 17 $stmt->execute(); 19 $stmt = $conn->query('SELECT num FROM users'); 20 $result = $stmt->fetchAll(PDO::FETCH_COLUMN);
|
H A D | bug_63916-2.phpt | 14 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)'); 15 $stmt->bindValue(':id', 1, PDO::PARAM_INT); 16 $stmt->bindValue(':num', $num, PDO::PARAM_INT); 17 $stmt->execute(); 19 $stmt = $conn->query('SELECT num FROM users'); 20 $result = $stmt->fetchAll(PDO::FETCH_COLUMN);
|
/PHP-7.4/ext/pdo/tests/ |
H A D | pdo_038.phpt | 16 function fetchColumn($stmt, $index) { 17 $stmt->execute(); 18 return $stmt->fetchColumn($index); 33 $stmt = $conn->prepare($query); 35 var_dump(fetchColumn($stmt, -1)); 36 var_dump(fetchColumn($stmt, 0)); 37 var_dump(fetchColumn($stmt, 1));
|
H A D | pdo_012.phpt | 23 $stmt = $db->query($SELECT, PDO::FETCH_NUM); 24 var_dump($stmt->fetchAll()); 34 unset($stmt); 36 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test'); 37 var_dump($stmt->fetchAll()); 39 unset($stmt); 41 $stmt = $db->query($SELECT, PDO::FETCH_NUM); 42 $stmt->setFetchMode(PDO::FETCH_CLASS, 'Test', array('Changed')); 43 var_dump($stmt->fetchAll());
|
H A D | debug_emulated_prepares.phpt | 23 $stmt = $db->query('SELECT 1'); 26 var_dump($stmt->debugDumpParams()); 28 $stmt = $db->prepare('SELECT :bool, :int, :string, :null'); 29 $stmt->bindValue(':bool', true, PDO::PARAM_BOOL); 30 $stmt->bindValue(':int', 123, PDO::PARAM_INT); 31 $stmt->bindValue(':string', 'foo', PDO::PARAM_STR); 32 $stmt->bindValue(':null', null, PDO::PARAM_NULL); 33 $stmt->execute(); 36 var_dump($stmt->debugDumpParams());
|
/PHP-7.4/ext/oci8/tests/ |
H A D | define1.phpt | 22 $stmt = oci_parse($c, "select string from define1_tab"); 27 var_dump(oci_define_by_name($stmt, "STRING", $string, 20)); 28 var_dump(oci_define_by_name($stmt, "STRING", $string, 20)); 29 var_dump(oci_define_by_name($stmt, "", $string, 20)); 30 var_dump(oci_define_by_name($stmt, "")); 32 oci_execute($stmt); 34 while (oci_fetch($stmt)) {
|
/PHP-7.4/ext/pdo/ |
H A D | pdo_sql_parser.re | 155 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "mixed named and positional parameters"); 160 if (stmt->supports_placeholders == query_type && !stmt->named_rewrite_template) { 180 params = stmt->bound_params; 226 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "parameter was not defined"); 229 if (stmt->dbh->methods->quoter) { 247 … if (!stmt->dbh->methods->quoter(stmt->dbh, ZSTR_VAL(buf), ZSTR_LEN(buf), &plc->quoted, &plc->qlen, 251 strncpy(stmt->error_code, stmt->dbh->error_code, 6); 261 pdo_raise_impl_error(stmt->dbh, stmt, "HY105", "Expected a stream resource"); 299 !stmt->dbh->methods->quoter(stmt->dbh, ZSTR_VAL(buf), 304 strncpy(stmt->error_code, stmt->dbh->error_code, 6); [all …]
|
/PHP-7.4/ext/pdo_pgsql/tests/ |
H A D | bug46274.phpt | 24 $stmt = $db->prepare("INSERT INTO test_one_blob (blob1) VALUES (:foo)"); 31 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 32 $stmt->execute(); 35 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 36 $stmt->execute(); 43 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 44 $stmt->execute(); 47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 48 $stmt->execute();
|
H A D | debug_emulated_prepares.phpt | 16 $stmt = $db->prepare('SELECT :bool, :int, :string, :null'); 17 $stmt->bindValue(':bool', true, PDO::PARAM_BOOL); 18 $stmt->bindValue(':int', 123, PDO::PARAM_INT); 19 $stmt->bindValue(':string', 'foo', PDO::PARAM_STR); 20 $stmt->bindValue(':null', null, PDO::PARAM_NULL); 21 $stmt->execute(); 23 var_dump($stmt->debugDumpParams());
|
/PHP-7.4/ext/sqlite3/tests/ |
H A D | bug63921-64bit.phpt | 14 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)'); 15 $stmt->bindValue(':id', 1, SQLITE3_INTEGER); 16 $stmt->bindValue(':num', $num, SQLITE3_INTEGER); 17 $stmt->execute(); 19 $stmt = $conn->query('SELECT num FROM users'); 20 $result = $stmt->fetchArray();
|
H A D | sqlite3stmt_getsql.phpt | 12 $stmt = $db->prepare('SELECT :a, :b, ?;'); 14 $stmt->bindValue(':a', 42); 15 $stmt->bindValue(':b', 'php'); 16 $stmt->bindValue(3, 43); 19 var_dump($stmt->getSQL(false)); 22 var_dump($res = $stmt->execute());
|