/PHP-5.5/ext/mysqli/tests/ |
H A D | bug66124.phpt | 34 $stmt = $link->prepare($table_insert); 35 if (!$stmt) { 41 $stmt->bind_param('i', $id); 43 if ($stmt->execute()){ 44 echo "insert id:{$id}=>{$stmt->insert_id}\n"; 62 $stmt->close(); 68 $stmt = $link->prepare($table_insert); 69 $stmt->bind_param('s', $id); 73 if ($stmt->execute()){
|
H A D | bug33263.phpt | 23 $stmt = $mysql->prepare("SELECT DATABASE()"); 24 $stmt->execute(); 25 $stmt->bind_result($database); 26 $stmt->fetch(); 27 $stmt->close();
|
H A D | 017.phpt | 16 if (!$stmt = mysqli_prepare($link, "SELECT md5('bar'), database(), 'foo'")) 19 mysqli_stmt_bind_result($stmt, $c0, $c1, $c2); 20 mysqli_stmt_execute($stmt); 22 mysqli_stmt_fetch($stmt); 23 mysqli_stmt_close($stmt);
|
H A D | 019.phpt | 28 …if (!$stmt = mysqli_prepare($link, "INSERT INTO insert_read(col1,col10, col11, col6) VALUES (?,?,?… 31 mysqli_stmt_bind_param($stmt, "issd", $c1, $c2, $c3, $c4); 38 mysqli_stmt_execute($stmt); 39 mysqli_stmt_close($stmt); 41 …if (!$stmt = mysqli_prepare($link, "SELECT col1, col2, col3, col4, col5, col6, col7, col8, col9, c… 44 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8, $c9, $c10, $c11); 45 mysqli_stmt_execute($stmt); 47 mysqli_stmt_fetch($stmt); 53 mysqli_stmt_close($stmt);
|
H A D | bug66043.phpt | 17 $stmt = $db->stmt_init(); 18 $stmt->prepare("SELECT User FROM user WHERE password=\"\""); 19 $stmt->execute(); 20 $stmt->bind_result($testArg);
|
H A D | mysqli_change_user_prepared_statements.phpt | 16 if (!$stmt = mysqli_prepare($link, "SELECT 'prepared statements should be released'")) 22 if ($stmt->execute() && $stmt->bind_result($wrong) && $stmt->fetch()) { 25 if ($stmt->errno == 0)
|
H A D | mysqli_stmt_get_result_metadata.phpt | 20 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 22 if (!mysqli_stmt_execute($stmt)) 23 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 27 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 33 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 41 mysqli_stmt_close($stmt); 46 !mysqli_stmt_execute($stmt)) 47 printf("[006] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 51 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 57 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | bug_mysql_49406.phpt | 30 if (!$stmt = $link->prepare($query)) 33 if (!$stmt->execute() || !$stmt->store_result()) 34 printf("[006] [%d] %s\n", $stmt->errno, $stmt->error); 64 $meta_res = $stmt->result_metadata(); 81 if (!$stmt->bind_result($row_stmt) || !$stmt->fetch()) 82 printf("[007] [%d] %s\n", $stmt->errno, $stmt->error); 90 $stmt->close();
|
/PHP-5.5/ext/pdo/tests/ |
H A D | pdo_025.phpt | 30 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)"); 32 $stmt->execute($row); 39 $stmt = $db->prepare('SELECT * FROM test'); 40 $stmt->setFetchMode(PDO::FETCH_INTO, new Test); 41 $stmt->execute(); 43 foreach($stmt as $obj) { 54 $stmt->setFetchMode(PDO::FETCH_INTO, new Fail); 55 $stmt->execute(); 57 foreach($stmt as $obj) {
|
H A D | pdo_013.phpt | 23 $stmt = $db->prepare($SELECT); 25 $stmt->execute(); 26 $stmt->setFetchMode(PDO::FETCH_NUM); 27 foreach ($stmt as $data) 40 unset($stmt); 47 unset($stmt); 49 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test', array('WOW')); 51 foreach($stmt as $data)
|
H A D | pdo_019.phpt | 26 $stmt = $db->prepare('SELECT idx, txt FROM test ORDER by idx'); 28 $stmt->execute(); 29 $cont = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE); 34 $stmt->bindColumn('idx', $idx); 35 $stmt->bindColumn('txt', $txt); 36 $stmt->execute(); 38 while($stmt->fetch(PDO::FETCH_BOUND)) {
|
/PHP-5.5/ext/oci8/tests/ |
H A D | error_bind.phpt | 22 $stmt = oci_parse($c, "insert into bind_test values (:name)"); 23 oci_bind_by_name($stmt, ":name", $name, 10, SQLT_CHR); 24 var_dump(oci_execute($stmt)); 28 var_dump(oci_execute($stmt)); 31 oci_bind_by_name($stmt, ":name", $c); 32 var_dump(oci_execute($stmt)); 37 $stmt = oci_parse($c, "update bind_test set name='xyz' returning rowid into :r_id"); 38 oci_bind_by_name($stmt, ":r_id", $c); 39 var_dump(oci_execute($stmt));
|
H A D | bug42841.phpt | 50 $stmt = oci_parse($c, $sql); 52 oci_bind_by_name($stmt, ":cursor", $cursor, -1, OCI_B_CURSOR); 54 oci_execute($stmt, OCI_DEFAULT); 61 oci_free_statement($stmt); 68 $stmt = oci_parse($c, $sql); 70 oci_bind_by_name($stmt, ":cursor", $cursor, -1, OCI_B_CURSOR); 72 oci_execute($stmt, OCI_DEFAULT); 79 oci_free_statement($stmt); 96 oci_bind_by_name($stmt, ':cur', $cur, -1, OCI_B_CURSOR); 97 oci_execute($stmt, OCI_DEFAULT); [all …]
|
H A D | bug37220.phpt | 29 $stmt = oci_parse ($c, $query); 31 oci_bind_by_name($stmt, ':data', $clob, -1, OCI_B_CLOB); 33 $success = oci_execute($stmt, OCI_COMMIT_ON_SUCCESS); 34 oci_free_statement($stmt); 40 $stmt = oci_parse ($c, $query); 42 oci_execute($stmt); 44 while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
|
/PHP-5.5/ext/pdo_odbc/ |
H A D | odbc_driver.c | 41 if (stmt) { in pdo_odbc_fetch_error_func() 42 S = (pdo_odbc_stmt*)stmt->driver_data; in pdo_odbc_fetch_error_func() 70 if (stmt) { in pdo_odbc_error() 71 S = (pdo_odbc_stmt*)stmt->driver_data; in pdo_odbc_error() 74 pdo_err = &stmt->error_code; in pdo_odbc_error() 78 statement = S->stmt; in pdo_odbc_error() 202 stmt->driver_data = S; in odbc_handle_preparer() 203 stmt->methods = &odbc_stmt_methods; in odbc_handle_preparer() 228 PDO_ODBC_HSTMT stmt; in odbc_handle_doer() local 251 rc = SQLRowCount(stmt, &row_count); in odbc_handle_doer() [all …]
|
/PHP-5.5/ext/sqlite3/tests/ |
H A D | sqlite3_28_clear_bindings.phpt | 19 $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC"); 22 var_dump($stmt->bindParam(1, $foo, SQLITE3_TEXT)); 24 $results = $stmt->execute(); 28 $stmt->reset(); 29 $stmt->clear(); 30 var_dump($stmt->bindValue(1, 'b', SQLITE3_TEXT)); 31 $results = $stmt->execute();
|
/PHP-5.5/ext/pdo_oci/tests/ |
H A D | bug46274.phpt | 27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl… 35 $stmt->bindparam(':id', $id); 36 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 37 $stmt->execute(); 45 $stmt->bindparam(':id', $id); 46 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB); 47 $stmt->execute();
|
/PHP-5.5/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 | bug_39858.phpt | 42 $stmt = $db->prepare("CALL p()"); 43 $stmt->execute(); 45 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 46 } while ($stmt->nextRowset()); 48 $stmt = $db->prepare("CALL p()"); 49 $stmt->execute(); 51 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 52 } while ($stmt->nextRowset()); 53 $stmt->closeCursor();
|
H A D | pdo_mysql_stmt_bindparam_types.phpt | 25 if ((!$stmt = @$db->prepare($sql)) || (!@$stmt->execute())) 30 if (!$stmt->bindParam(1, $value)) { 32 var_export($stmt->errorInfo(), true)); 35 if (!$stmt->execute()) { 37 var_export($stmt->errorInfo(), true)); 43 if (!$stmt->bindColumn(1, $id)) { 48 if (!$stmt->bindColumn(2, $label)) { 54 if (!$stmt->fetch(PDO::FETCH_BOUND)) { 59 $stmt->closeCursor(); 68 $stmt->execute(); [all …]
|
H A D | pdo_mysql_attr_oracle_nulls.phpt | 28 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 32 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 35 $stmt = $db->query('SELECT VERSION() as _version'); 36 $row = $stmt->fetch(PDO::FETCH_ASSOC); 48 $stmt = $db->prepare('CALL p()'); 49 $stmt->execute(); 61 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC); 66 } while ($stmt->nextRowset()); 68 $stmt->execute(); 70 $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC); [all …]
|
H A D | pdo_mysql_stmt_getcolumnmeta.phpt | 11 $row = $stmt->fetch(PDO::FETCH_ASSOC); 32 $stmt->execute(); 57 $stmt->execute(); 74 if (!($stmt = @$db->prepare($sql)) || (!@$stmt->execute())) { 86 $stmt->execute(); 87 $meta = $stmt->getColumnMeta(1); 92 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 145 $stmt->execute(); 238 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) { 259 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) { [all …]
|
H A D | pdo_mysql_pconnect.phpt | 23 $tmp = $stmt->fetch(PDO::FETCH_ASSOC); 27 $stmt = $db1->query('SELECT CONNECTION_ID() as _con1'); 28 $tmp = $stmt->fetch(PDO::FETCH_ASSOC); 31 $stmt = $db2->query('SELECT CONNECTION_ID() as _con2'); 32 $tmp = $stmt->fetch(PDO::FETCH_ASSOC); 40 $stmt = $db1->query('SELECT CONNECTION_ID() as _con1'); 41 $tmp = $stmt->fetch(PDO::FETCH_ASSOC); 63 $stmt = $db1->query('SELECT CONNECTION_ID() as _con1'); 64 $tmp = $stmt->fetch(PDO::FETCH_ASSOC); 68 $stmt = $db2->query('SELECT CONNECTION_ID() as _con2'); [all …]
|
/PHP-5.5/ext/pdo_firebird/tests/ |
H A D | bug_64037.phpt | 23 $stmt = $dbh->prepare($query); 24 $stmt->execute(); 25 $rows = $stmt->fetchAll(); 31 $stmt = $dbh->prepare('DELETE FROM price'); 32 $stmt->execute(); 38 unset($stmt);
|
/PHP-5.5/ext/pdo_pgsql/tests/ |
H A D | is_in_transaction.phpt | 24 $stmt = $db->prepare("INSERT INTO test (a, b) values (?, ?)"); 25 $stmt->bindValue(1, 1); 26 $stmt->bindValue(2, "test insert"); 27 $stmt->execute(); 37 $stmt = $db->prepare("INSERT INTO test (a, b) values (?, ?)"); 38 $stmt->bindValue(1, "error"); 39 $stmt->bindValue(2, "test insert"); 40 $stmt->execute();
|