/PHP-5.5/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_load_data.phpt | 11 $stmt = $db->query('SELECT USER() as _user'); 12 $row = $stmt->fetch(PDO::FETCH_ASSOC); 63 $stmt = $db->query("SHOW VARIABLES LIKE 'secure_file_priv'"); 80 if (!$stmt->execute()) { 81 printf("[004] [%d] %s\n", $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 85 $stmt = $db->query("SELECT 1 as 'one'"); 86 if ($stmt->errorCode() != '0000') { 87 printf("[005] [%d] %s\n", $stmt->errorCode(), var_export($stmt->errorInfo(), true)); 89 $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); 91 printf("[006] [%d] %s\n", $stmt->errorCode(), var_export($stmt->errorInfo(), true)); [all …]
|
H A D | bug41125.phpt | 19 $stmt = $db->prepare($sql); 20 $stmt->execute(); 22 print implode(' - ', $stmt->errorinfo()) ."\n"; 34 $stmt = $db->prepare($query); 35 $stmt->execute(array(1)); 44 $stmt = $db->prepare($sql); 47 $stmt->bindParam(':id', $id); 48 $stmt->execute(); 75 $stmt = $db->prepare($query); 76 $stmt->bindParam(':id', $id); [all …]
|
H A D | pdo_mysql_prepare_emulated_placeholder_everywhere.phpt | 27 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?'); 28 $stmt->execute(array('test')); 29 if ('00000' !== $stmt->errorCode()) { 31 var_export($stmt->errorCode(), true), 32 var_export($stmt->errorInfo(), true)); 34 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 43 $stmt->execute(array('test')); 44 if ('00000' !== $stmt->errorCode()) 46 var_export($stmt->errorCode(), true), 47 var_export($stmt->errorInfo(), true)); [all …]
|
H A D | pdo_mysql_errorcode.phpt | 38 $stmt = $db->query('SELECT id, label FROM test'); 39 $stmt2 = &$stmt; 41 check_error(4, $stmt); 44 @$stmt->execute(); 46 check_error(5, $stmt, '42S02'); 50 @$stmt = $db->query('SELECT id, label FROM unknown'); 54 $stmt = $db->query('SELECT id, label FROM test'); 56 check_error(9, $stmt); 62 check_error(12, $stmt); 70 check_error(16, $stmt);
|
H A D | bug_45120.phpt | 18 $stmt = $db->prepare("SELECT 1 AS 'one'"); 19 if (true !== $stmt->execute()) 20 printf("[001] Execute has failed: %s\n", var_export($stmt->errorInfo(), true)); 22 $res = $stmt->fetch(PDO::FETCH_ASSOC); 26 if (true !== $stmt->execute()) 27 printf("[003] Execute has failed: %s\n", var_export($stmt->errorInfo(), true)); 29 $res = $stmt->fetch(PDO::FETCH_ASSOC);
|
H A D | pdo_mysql_stmt_errorinfo.phpt | 23 var_dump($stmt->errorInfo()); 24 $stmt->execute(); 25 var_dump($stmt->errorInfo()); 28 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1'); 30 var_dump($stmt->execute()); 31 var_dump($stmt->errorInfo()); 46 var_dump($stmt); 49 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1'); 50 var_dump($stmt->errorInfo()); 52 $stmt->execute(); [all …]
|
/PHP-5.5/ext/mysqli/tests/ |
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 …]
|
H A D | 067.phpt | 23 if (!is_object($stmt = $mysql->prepare($query))) { 28 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY); 29 return $stmt; 47 $stmt[$i] = open_cursor($mysql, "SELECT a FROM cursor$i"); 48 $stmt[$i]->execute(); 49 $stmt[$i]->bind_result($a[$i]); 54 while ($stmt[0]->fetch()) { 55 $stmt[1]->fetch(); 56 $stmt[2]->fetch(); 61 $stmt[$i]->close();
|
H A D | mysqli_explain_metadata.phpt | 66 $stmt = mysqli_stmt_init($link); 68 if ($stmt->prepare('EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2') && $stmt->execute()) { 69 if (!mysqli_stmt_store_result($stmt)) 70 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 72 if (!$res_meta = mysqli_stmt_result_metadata($stmt)) 73 printf("[009] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 104 $stmt->execute()) { 105 if (!$res_stmt = mysqli_stmt_get_result($stmt)) { 107 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 113 if ((mysqli_stmt_num_rows($stmt)) !== 0) { [all …]
|
H A D | 020.phpt | 39 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_result VALUES (?,?,?,?,?,?,?)"); 40 mysqli_stmt_bind_param($stmt, "sssssss", $d1, $d2, $d3, $d4, $d5, $d6, $d7); 50 mysqli_stmt_execute($stmt); 51 mysqli_stmt_close($stmt); 53 $stmt = mysqli_prepare($link, "SELECT c1, c2, c3, c4, c5, c6, c7 FROM test_bind_result"); 55 mysqli_stmt_bind_result($stmt,$c1, $c2, $c3, $c4, $c5, $c6, $c7); 57 mysqli_stmt_execute($stmt); 58 mysqli_stmt_fetch($stmt); 64 mysqli_stmt_close($stmt);
|
H A D | 025.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); 45 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 46 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7); 47 mysqli_stmt_execute($stmt); 48 mysqli_stmt_fetch($stmt); 54 mysqli_stmt_close($stmt);
|
H A D | 016.phpt | 18 if (!$stmt = mysqli_prepare($link, "SELECT @dummy")) 21 mysqli_stmt_bind_result($stmt, $dummy); 22 mysqli_stmt_execute($stmt); 23 mysqli_stmt_fetch($stmt); 27 mysqli_stmt_close($stmt);
|
H A D | mysqli_stmt_get_result_types.phpt | 38 printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 44 printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 45 mysqli_stmt_close($stmt); 52 mysqli_stmt_close($stmt); 56 mysqli_stmt_close($stmt); 62 mysqli_stmt_close($stmt); 68 mysqli_stmt_close($stmt); 76 mysqli_stmt_close($stmt); 100 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num); 102 mysqli_stmt_close($stmt); [all …]
|
H A D | bug35759.phpt | 35 $stmt = $mysql->prepare("SELECT * FROM test"); 36 if ($stmt) { 38 $stmt->execute(); 39 $stmt->store_result(); 43 call_user_func_array(array($stmt, "bind_result"), $params); 44 $stmt->fetch(); 46 $stmt->close();
|
H A D | mysqli_stmt_bind_result_zerofill.phpt | 29 if (!($stmt = mysqli_prepare($link, 'SELECT zero FROM test LIMIT 1'))) { 36 if (!mysqli_stmt_bind_result($stmt, $result)) { 38 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 42 if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_fetch($stmt)) { 44 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 48 $res = mysqli_stmt_result_metadata($stmt); 50 mysqli_stmt_free_result($stmt);
|
/PHP-5.5/ext/pdo/ |
H A D | pdo_sql_parser.re | 139 if (stmt->supports_placeholders == query_type && !stmt->named_rewrite_template) { 154 params = stmt->bound_params; 158 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "no parameters were bound" TSRMLS_CC); 198 pdo_raise_impl_error(stmt->dbh, stmt, "HY093", "parameter was not defined" TSRMLS_CC); 211 if (!stmt->dbh->methods->quoter(stmt->dbh, buf, len, &plc->quoted, &plc->qlen, 215 strncpy(stmt->error_code, stmt->dbh->error_code, 6); 253 if (!stmt->dbh->methods->quoter(stmt->dbh, Z_STRVAL(tmp_param), 258 strncpy(stmt->error_code, stmt->dbh->error_code, 6); 308 const char *tmpl = stmt->named_rewrite_template ? stmt->named_rewrite_template : ":pdo%d"; 453 if(stmt->dbh->methods->quoter(stmt->dbh, Z_STRVAL_P(param->parameter), [all …]
|
H A D | php_pdo_driver.h | 321 typedef int (*pdo_stmt_dtor_func)(pdo_stmt_t *stmt TSRMLS_DC); 324 typedef int (*pdo_stmt_execute_func)(pdo_stmt_t *stmt TSRMLS_DC); 329 typedef int (*pdo_stmt_fetch_func)(pdo_stmt_t *stmt, 334 typedef int (*pdo_stmt_describe_col_func)(pdo_stmt_t *stmt, int colno TSRMLS_DC); 397 typedef int (*pdo_stmt_next_rowset_func)(pdo_stmt_t *stmt TSRMLS_DC); 403 typedef int (*pdo_stmt_cursor_closer_func)(pdo_stmt_t *stmt TSRMLS_DC); 538 pdo_stmt_t *stmt; /* for convenience in dtor */ member 652 PDO_API int pdo_parse_params(pdo_stmt_t *stmt, char *inquery, int inquery_len, 655 PDO_API void pdo_raise_impl_error(pdo_dbh_t *dbh, pdo_stmt_t *stmt, 661 PDO_API void php_pdo_stmt_addref(pdo_stmt_t *stmt TSRMLS_DC); [all …]
|
/PHP-5.5/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-5.5/ext/sqlite3/tests/ |
H A D | bug63921-32bit.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 | 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();
|
/PHP-5.5/ext/pdo/tests/ |
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 | pdo_032.phpt | 24 $stmt = $db->prepare('SELECT * from test'); 25 $stmt->execute(); 26 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 27 $stmt->closeCursor(); 31 $stmt = $db->prepare('SELECT * from test'); 32 $stmt->execute(); 33 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 34 $stmt->closeCursor();
|
H A D | bug_39656.phpt | 24 $stmt = $db->prepare("SELECT * FROM test WHERE id = ?"); 25 $stmt->bindValue(1, 1, PDO::PARAM_INT ); 26 $stmt->execute(); 27 $row = $stmt->fetch(); 30 $stmt->execute(); 31 $stmt->closeCursor(); 32 $row = $stmt->fetch(); // this line will crash CLI
|
H A D | pdo_028.phpt | 18 $stmt = $db->prepare('INSERT INTO test values (1, ?, ?, ?)'); 23 $stmt->bindValue($i+1, $v); 25 $stmt->execute(); 27 $stmt = $db->prepare('SELECT * from test'); 28 $stmt->execute(); 30 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
/PHP-5.5/ext/pdo_pgsql/tests/ |
H A D | bug46274_2.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();
|