Home
last modified time | relevance | path

Searched refs:stmt (Results 101 – 125 of 392) sorted by relevance

12345678910>>...16

/PHP-5.5/ext/mysqli/tests/
H A D059.phpt22 $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 Dmysqli_stmt_fetch_bit.phpt33 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 D064.phpt14 $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 Dmysqli_stmt_bind_result_format.phpt67 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));
136 mysqli_stmt_close($stmt);
294 if (!$stmt->execute()) {
312 while ($stmt->fetch()) {
319 $stmt->free_result();
[all …]
H A Dbug35103.phpt26 $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 D063.phpt14 $stmt = new mysqli_stmt($mysql, "SELECT 'foo' FROM DUAL");
15 $stmt->execute();
16 $stmt->bind_result($foo);
17 $stmt->fetch();
18 $stmt->close();
H A Dmysqli_stmt_bind_param.phpt38 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
90 printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
92 mysqli_stmt_close($stmt);
133 mysqli_stmt_close($stmt);
312 printf("[2000] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
337 $stmt->errno, $stmt->error);
340 if (!$stmt->execute())
341 printf("[2006] [%d] %s\n", $stmt->errno, $stmt->error);
362 $values['id'], mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
365 if (!$stmt->execute())
[all …]
H A D023.phpt27 $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 D024.phpt27 $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 Dmysqli_stmt_bind_limits.phpt38 …$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 …]
/PHP-5.5/ext/oci8/tests/
H A Dbug43497_92.phpt28 $row = oci_fetch($stmt);
29 return oci_result($stmt, 1);
43 $row = oci_fetch($stmt);
44 $val = oci_result($stmt, 1);
45 oci_free_statement($stmt);
58 if (oci_execute($stmt)) {
73 if (oci_execute($stmt)) {
87 if (oci_execute($stmt)) {
99 oci_execute($stmt);
105 oci_execute($stmt);
[all …]
H A Dstatement_cache.phpt17 $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-5.5/ext/pdo/tests/
H A Dbug65946.phpt19 $stmt = $db->prepare('SELECT * FROM test LIMIT :limit');
20 $stmt->bindValue('limit', 1, PDO::PARAM_INT);
21 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo());
22 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo());
23 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
/PHP-5.5/ext/pdo_mysql/tests/
H A Dpdo_mysql_prepare_match_against.phpt20 $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));
H A Dbug44327.phpt15 $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 Dpdo_mysql_prepare_native.phpt20 $stmt = @$db->prepare($query);
22 $stmt = $db->prepare($query);
44 if (!is_object($stmt))
52 $ret = @$stmt->execute($input_params);
54 $ret = $stmt->execute($input_params);
60 $tmp = $stmt->errorInfo();
94 return $stmt;
115 $row = $stmt->fetch(PDO::FETCH_ASSOC);
168 if (is_object($stmt)) {
237 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC);
[all …]
H A Dpdo_mysql_prepare_emulated.phpt20 $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 Dpdo_mysql_attr_fetch_table_names.phpt16 $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 Dbug_pecl_12925.phpt21 $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 Dpdo_mysql_stmt_columncount.phpt25 $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 Dpdo_mysql_prepare_native_placeholder_everywhere.phpt23 $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-5.5/ext/mysqlnd/
H A Dmysqlnd_ps_codec.c532 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_store_params() local
553 SET_OOM_ERROR(*stmt->error_info); in mysqlnd_stmt_execute_store_params()
585 PASS != mysqlnd_stmt_copy_it(&copies, stmt->param_bind[i].zv, stmt->param_count, i TSRMLS_CC)) in mysqlnd_stmt_execute_store_params()
587 SET_OOM_ERROR(*stmt->error_info); in mysqlnd_stmt_execute_store_params()
628 if (stmt->send_types_to_server) { in mysqlnd_stmt_execute_store_params()
636 SET_OOM_ERROR(*stmt->error_info); in mysqlnd_stmt_execute_store_params()
706 switch (stmt->param_bind[i].type) { in mysqlnd_stmt_execute_store_params()
774 SET_OOM_ERROR(*stmt->error_info); in mysqlnd_stmt_execute_store_params()
798 switch (stmt->param_bind[i].type) { in mysqlnd_stmt_execute_store_params()
866 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_generate_request() local
[all …]
/PHP-5.5/ext/pdo_sqlite/tests/
H A Dbug_63916.phpt14 $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 Dbug_63916-2.phpt14 $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-5.5/ext/pdo_pgsql/tests/
H A Dbug46274.phpt24 $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();

Completed in 42 milliseconds

12345678910>>...16