Home
last modified time | relevance | path

Searched refs:stmt (Results 326 – 350 of 467) sorted by relevance

1...<<111213141516171819

/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_attr_max_buffer_size.phpt38 $stmt = $db->prepare('SELECT id, val FROM test');
39 $stmt->execute();
42 $stmt->bindColumn(1, $id);
43 $stmt->bindColumn(2, $val);
44 while ($row = $stmt->fetch(PDO::FETCH_BOUND)) {
H A Dbug81037.phpt20 $stmt = $pdo->prepare($sql);
22 $stmt->execute();
26 $data = $stmt->fetchAll(PDO::FETCH_ASSOC);
H A Dbug_33689.phpt24 $stmt = $db->prepare('SELECT * from test');
25 print_r($stmt->getColumnMeta(0));
26 $stmt->execute();
27 $tmp = $stmt->getColumnMeta(0);
H A Dpdo_mysql_stmt_closecursor.phpt79 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2');
81 if (!$stmt->bindParam(1, $in))
83 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
85 $stmt->execute();
88 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
90 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
92 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
94 $stmt->errorCode(), var_export($stmt->errorInfo(), true));
96 while ($stmt->fetch(PDO::FETCH_BOUND))
102 $stmt->closeCursor();
[all …]
H A Dbug54929.phpt20 $stmt = $pdodb->prepare($query);
22 if (!$stmt->execute(array("foo"))) {
23 var_dump($stmt->errorInfo());
25 var_dump($stmt->fetch(PDO::FETCH_ASSOC));
/PHP-7.4/ext/oci8/tests/
H A Dbug32325.phpt29 $stmt = oci_parse($c, $sql);
31 oci_bind_by_name($stmt, ":list", $collection, -1, OCI_B_NTY);
32 oci_execute($stmt);
H A Dbug27303_3.phpt17 $stmt = oci_parse($c, $statement);
18 @oci_execute($stmt);
24 $stmt = "insert into mytab (mydata, seqcol) values ('Some data', myseq.nextval) returning seqcol in…
26 $stid = OCIParse($c, $stmt);
46 $stmt = oci_parse($c, $statement);
47 oci_execute($stmt);
/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_stmt_bind_param_many_columns.phpt65 $stmt = $link->prepare("INSERT INTO test VALUES(".str_repeat("?, ", $cols-1) . "?)");
66 var_dump($stmt->id);
68 $eval_str="\$stmt->bind_param(\"".str_repeat("s",$cols)."\", ";
76 if (!$stmt->execute()) {
78 printf("Failed to execute: [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
83 mysqli_stmt_close($stmt);
H A Dmysqli_stmt_result_metadata.phpt24 if (!$stmt = mysqli_stmt_init($link))
27 if (false !== ($tmp = mysqli_stmt_result_metadata($stmt)))
30 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test"))
31 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
33 if (!is_object(($res = mysqli_stmt_result_metadata($stmt))))
83 mysqli_stmt_close($stmt);
85 if (false !== ($tmp = mysqli_stmt_result_metadata($stmt)))
H A D042.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);
H A D002.phpt34 …$stmt = mysqli_prepare($link, "SELECT col1, col2, col3, col4, col5, col6, col7, col8, col9, col10,…
35 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8, $c9, $c10, $c11);
36 mysqli_stmt_execute($stmt);
38 mysqli_stmt_fetch($stmt);
44 mysqli_stmt_close($stmt);
H A D050.phpt17 $stmt = mysqli_prepare($link, "SELECT CURRENT_USER()");
18 mysqli_stmt_execute($stmt);
H A Dmysqli_insert_id_variation.phpt70 $stmt = $link->prepare("SELECT 1");
76 if (0 != $stmt->insert_id || 0 != mysqli_stmt_insert_id($stmt)) {
77 … printf("[008b] mysqli_stmt doesn't initialise insert_id: %s", var_export($stmt->insert_id, true));
81 unset($stmt);
83 printf("[009] stmt free changes insert_id: %s", var_export($link->insert_id, true));
/PHP-7.4/ext/sqlite3/tests/
H A Dbug47159.phpt10 $stmt = $db->prepare("SELECT 1");
12 var_dump($stmt->close());
H A Dsqlite3_36_create_collation.phpt14 $stmt = $db->prepare('INSERT INTO t VALUES (?)');
16 $stmt->bindParam(1, $s);
17 $stmt->execute();
H A Dsqlite3stmt_paramCount_basic.phpt28 $stmt = $db->prepare($query);
31 var_dump($stmt->paramCount());
33 $result = $stmt->execute();
37 $stmt = null;
/PHP-7.4/ext/pdo/tests/
H A Dpdo_002.phpt22 $stmt = $db->prepare('SELECT * from test');
23 $stmt->execute();
25 var_dump($stmt->fetchAll(PDO::FETCH_NUM));
H A Dpdo_001.phpt22 $stmt = $db->prepare('SELECT * from test');
23 $stmt->execute();
25 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dpdo_008.phpt22 $stmt = $db->prepare('SELECT val, id from test');
24 $stmt->execute();
25 var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_UNIQUE));
H A Dpdo_009.phpt27 $stmt = $db->prepare('SELECT classtypes.name, test.id AS id, test.val AS val FROM test LEFT JOIN cl…
53 $stmt->execute();
54 var_dump($stmt->fetchAll(PDO::FETCH_NUM));
56 $stmt->execute();
57 var_dump($stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_CLASSTYPE, 'Test3'));
H A Dbug_77849_2.phpt9 $stmt = new PDOStatement();
11 clone $stmt;
/PHP-7.4/ext/pdo_dblib/tests/
H A Dtypes.phpt40 $stmt = $db->query($sql);
41 $row = $stmt->fetch(PDO::FETCH_ASSOC);
53 $stmt = $db->query($sql);
54 $row = $stmt->fetch(PDO::FETCH_ASSOC);
/PHP-7.4/ext/pdo_oci/tests/
H A Dbug54379.phpt24 $stmt = $db->prepare("SELECT * FROM test");
25 $stmt->execute();
26 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dpecl_bug_6364.phpt21 $stmt = $dbh->prepare("call bug_6364_sp('p1','p2','p3',?,?)");
26 $stmt->bindParam(1, $out_param1,PDO::PARAM_STR, 1024);
27 $stmt->bindParam(2, $out_param2,PDO::PARAM_STR, 1024);
29 $stmt->execute() or die ("Execution error: " . var_dump($dbh->errorInfo()));
/PHP-7.4/ext/pdo_mysql/
H A Dphp_pdo_mysql_int.h136 MYSQLND_STMT *stmt; member
138 MYSQL_STMT *stmt; member
155 extern int _pdo_mysql_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, const char *file, int line);
157 #define pdo_mysql_error_stmt(s) _pdo_mysql_error(stmt->dbh, stmt, __FILE__, __LINE__)

Completed in 29 milliseconds

1...<<111213141516171819