/PHP-5.5/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_emulated_anonymous.phpt | 25 $stmt->execute(array('first row')); 26 if ('00000' !== $stmt->errorCode()) 28 var_export($stmt->errorCode(), true), 29 var_export($stmt->errorInfo(), true)); 32 $stmt->execute(); 33 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 44 $stmt->execute(array('first row')); 45 if ('00000' !== $stmt->errorCode()) 47 var_export($stmt->errorCode(), true), 48 var_export($stmt->errorInfo(), true)); [all …]
|
H A D | pdo_mysql_stmt_bindcolumn.phpt | 22 $stmt->execute(); 25 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT)) 27 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 31 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 34 while ($stmt->fetch(PDO::FETCH_BOUND)) { 43 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 62 $stmt->execute(); 65 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT)) 67 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 71 $stmt->errorCode(), var_export($stmt->errorInfo(), true)); [all …]
|
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 | bug_44707.phpt | 13 $row = $stmt->fetch(PDO::FETCH_ASSOC); 39 $stmt->bindParam(1, $id); 42 $stmt->bindParam(2, $mybool, PDO::PARAM_BOOL); 45 $stmt->execute(); 48 $stmt = $db->query('SELECT * FROM test'); 49 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 52 $stmt->bindParam(1, $id); 54 $stmt->bindParam(2, $mybool, PDO::PARAM_INT); 55 $stmt->execute(); 57 $stmt = $db->query('SELECT * FROM test'); [all …]
|
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_prepare_native_named_placeholder.phpt | 31 $stmt->execute(array(':placeholder' => 'row1')); 32 if ('00000' !== $stmt->errorCode()) 34 var_export($stmt->errorCode(), true), 35 var_export($stmt->errorInfo(), true)); 39 $stmt->execute(); 40 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 52 if ('00000' !== $stmt->errorCode()) 54 var_export($stmt->errorCode(), true), 55 var_export($stmt->errorInfo(), true)); 59 $stmt->execute(); [all …]
|
/PHP-5.5/ext/pdo_pgsql/tests/ |
H A D | large_objects.phpt | 26 $stmt->bindValue(1, 1); 31 $stmt->bindParam(2, $stm, PDO::PARAM_LOB); 32 $stmt->execute(); 36 $stmt = $db->prepare("SELECT * from test"); 38 $stmt->execute(); 40 while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) { 47 $stmt = $db->prepare("SELECT * from test"); 48 $stmt->execute(); 51 while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) { 58 $stmt = $db->prepare("SELECT * from test"); [all …]
|
/PHP-5.5/ext/pdo/tests/ |
H A D | bug_44173.phpt | 22 $stmt = $db->query(); 23 var_dump($stmt); 28 var_dump($stmt); 32 $stmt = $db->query("SELECT * FROM test", 'abc'); 33 var_dump($stmt); 38 var_dump($stmt); 42 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_INTO); 43 var_dump($stmt); 48 var_dump($stmt); 52 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS); [all …]
|
H A D | pdo_026.phpt | 49 $stmt->setFetchMode(PDO::FETCH_ASSOC); 50 $stmt->execute(); 51 return $stmt; 60 $stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)"); 61 var_dump(get_class($stmt)); 63 $stmt->execute($row); 66 unset($stmt); 68 $stmt = $db->query('SELECT * FROM test'); 69 var_dump(get_class($stmt)); 70 var_dump(get_class($stmt->dbh)); [all …]
|
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 …]
|
/PHP-5.5/ext/mysqli/tests/ |
H A D | mysqli_stmt_bind_result.phpt | 28 printf("[002a] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 33 mysqli_stmt_close($stmt); 44 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 56 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 62 mysqli_stmt_close($stmt); 90 mysqli_stmt_close($stmt); 101 mysqli_stmt_close($stmt); 107 mysqli_stmt_close($stmt); 144 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num); 149 mysqli_stmt_close($stmt); [all …]
|
H A D | mysqli_stmt_get_warnings.phpt | 40 if (!$stmt = mysqli_stmt_init($link)) 43 if (NULL !== ($tmp = mysqli_stmt_get_warnings($stmt))) 46 if (!mysqli_stmt_prepare($stmt, "DROP TABLE IF EXISTS test") || !mysqli_stmt_execute($stmt)) 47 printf("[005] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 49 if (false !== ($tmp = mysqli_stmt_get_warnings($stmt))) 52 …if (!mysqli_stmt_prepare($stmt, "CREATE TABLE test(id SMALLINT, label CHAR(1))") || !mysqli_stmt_e… 53 printf("[007] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 55 if (false !== ($tmp = mysqli_stmt_get_warnings($stmt))) 59 !mysqli_stmt_execute($stmt)) 60 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
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_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 | 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 | 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 | 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 | 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 …]
|
/PHP-5.5/ext/pdo/ |
H A D | php_pdo_int.h | 42 void pdo_dbstmt_free_storage(pdo_stmt_t *stmt TSRMLS_DC); 45 int pdo_stmt_describe_columns(pdo_stmt_t *stmt TSRMLS_DC); 46 int pdo_stmt_setup_fetch_mode(INTERNAL_FUNCTION_PARAMETERS, pdo_stmt_t *stmt, int skip_first_arg); 51 void pdo_row_free_storage(pdo_stmt_t *stmt TSRMLS_DC); 58 extern void pdo_handle_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt TSRMLS_DC); 67 #define PDO_STMT_CLEAR_ERR() strcpy(stmt->error_code, PDO_ERR_NONE) 69 #define PDO_HANDLE_STMT_ERR() if (strcmp(stmt->error_code, PDO_ERR_NONE)) { pdo_handle_error(stmt->…
|
/PHP-5.5/ext/oci8/tests/ |
H A D | bug43497.phpt | 24 $row = oci_fetch($stmt); 25 return oci_result($stmt, 1); 39 $row = oci_fetch($stmt); 40 $val = oci_result($stmt, 1); 41 oci_free_statement($stmt); 54 if (oci_execute($stmt)) { 69 if (oci_execute($stmt)) { 83 if (oci_execute($stmt)) { 95 oci_execute($stmt); 101 oci_execute($stmt); [all …]
|
H A D | define4.phpt | 22 $stmt = oci_parse($c, "select value, string from define4_tab"); 26 var_dump(oci_define_by_name($stmt, "STRING", $string)); 28 oci_execute($stmt); 32 while (oci_fetch($stmt)) { 33 var_dump(oci_result($stmt, 'VALUE')); 35 var_dump(oci_result($stmt, 'STRING')); 37 var_dump(oci_result($stmt, 'VALUE')); 38 var_dump(oci_result($stmt, 'STRING')); 42 var_dump(oci_free_statement($stmt)); 44 var_dump(oci_result($stmt, 'STRING'));
|
H A D | bug36096.phpt | 11 $stmt = oci_parse($c, $sql); 13 if(oci_execute($stmt, OCI_COMMIT_ON_SUCCESS)){ 14 var_dump(oci_fetch($stmt)); 15 var_dump(oci_result($stmt, 1)); 16 var_dump(oci_field_name($stmt, 1)); 17 var_dump(oci_field_type($stmt, 1));
|
/PHP-5.5/ext/mysqlnd/ |
H A D | mysqlnd_driver.c | 200 MYSQLND_STMT_DATA * stmt = NULL; in MYSQLND_METHOD() local 211 DBG_INF_FMT("stmt=%p", stmt); in MYSQLND_METHOD() 212 if (!stmt) { in MYSQLND_METHOD() 215 stmt->persistent = conn->persistent; in MYSQLND_METHOD() 216 stmt->error_info = &(stmt->error_info_impl); in MYSQLND_METHOD() 217 stmt->upsert_status = &(stmt->upsert_status_impl); in MYSQLND_METHOD() 218 stmt->state = MYSQLND_STMT_INITTED; in MYSQLND_METHOD() 219 stmt->execute_cmd_buffer.length = 4096; in MYSQLND_METHOD() 220 stmt->execute_cmd_buffer.buffer = mnd_pemalloc(stmt->execute_cmd_buffer.length, stmt->persistent); in MYSQLND_METHOD() 221 if (!stmt->execute_cmd_buffer.buffer) { in MYSQLND_METHOD() [all …]
|
/PHP-5.5/ext/pdo_oci/tests/ |
H A D | bug57702.phpt | 19 $stmt = $db->prepare($query); 20 $stmt->execute(); 23 $stmt = $db->prepare($query); 24 $stmt->execute(); 30 $stmt->bindParam(':id', $id); 35 $stmt->execute(); 53 $stmt->execute(); 54 $row = $stmt->fetch(PDO::FETCH_ASSOC); 76 $rs = $stmt->execute(); 128 $stmt = $db->prepare($query); [all …]
|