/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_native.phpt | 20 $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 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 | bug80458.phpt | 24 $stmt->execute(); 25 var_dump($stmt->fetchAll()); 41 $stmt->execute(); 42 var_dump($stmt->fetchAll()); 65 $stmt->execute(); 66 var_dump($stmt->fetchAll()); 82 $stmt->execute(); 83 var_dump($stmt->fetchAll()); 105 $stmt->execute(); 106 var_dump($stmt->fetchAll()); [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 | 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 …]
|
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 …]
|
/PHP-7.4/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(); 143 $stmt = $db->prepare($query); [all …]
|
/PHP-7.4/ext/mysqli/tests/ |
H A D | mysqli_stmt_bind_param.phpt | 38 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); 312 printf("[2000] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 317 printf("[2001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 322 printf("[2002] [%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)); [all …]
|
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 | 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 | 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 | bug70949.phpt | 23 if ($stmt = $mysql->prepare($sql)) 25 $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY); 27 if ($stmt->bind_result($name)) { 29 if ($stmt->execute()) 31 while ($stmt->fetch()) 38 $stmt->free_result(); 39 $stmt->close();
|
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);
|
/PHP-7.4/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 | 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-7.4/ext/mysqlnd/ |
H A D | mysqlnd_ps_codec.c | 620 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_prepare_param_types() 720 if (Z_ISREF(stmt->param_bind[j].zv) && Z_REFVAL(stmt->param_bind[j].zv) == the_var) { in mysqlnd_stmt_execute_calculate_param_values_size() 733 switch (stmt->param_bind[i].type) { in mysqlnd_stmt_execute_calculate_param_values_size() 871 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_store_params() local 884 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params() 908 if (stmt->send_types_to_server) { in mysqlnd_stmt_execute_store_params() 910 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params() 926 SET_OOM_ERROR(stmt->error_info); in mysqlnd_stmt_execute_store_params() 947 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_generate_request() local 955 int4store(p, stmt->stmt_id); in mysqlnd_stmt_execute_generate_request() [all …]
|
/PHP-7.4/ext/pdo/tests/ |
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));
|
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-7.4/ext/oci8/tests/ |
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 …]
|
/PHP-7.4/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();
|