/PHP-5.5/ext/mysqli/tests/ |
H A D | 059.phpt | 22 $stmt = mysqli_prepare($link, "INSERT INTO mbind VALUES (?||?)"); 24 mysqli_stmt_bind_param($stmt, "ss", $a, $b); 29 mysqli_stmt_execute($stmt); 31 mysqli_stmt_close($stmt); 33 $stmt = mysqli_prepare($link, "SELECT * FROM mbind"); 34 mysqli_stmt_execute($stmt); 36 mysqli_stmt_bind_result($stmt, $e); 37 mysqli_stmt_fetch($stmt);
|
H A D | mysqli_stmt_fetch_bit.phpt | 33 if (!$stmt = mysqli_stmt_init($link)) 41 if (!mysqli_stmt_prepare($stmt, $sql) || 42 !mysqli_stmt_execute($stmt)) 43 printf("[004 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 47 if (!mysqli_stmt_prepare($stmt, $sql) || 48 !mysqli_stmt_execute($stmt) || 49 !mysqli_stmt_bind_result($stmt, $id, $_label0, $label)) 50 printf("[005 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 52 if (!mysqli_stmt_fetch($stmt)) 53 printf("[006 - %d] [%d] %s\n", $bits, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); [all …]
|
H A D | 064.phpt | 14 $stmt = new mysqli_stmt($mysql, "SELECT NULL FROM DUAL"); 15 $stmt->execute(); 16 $stmt->bind_result($foo); 17 $stmt->fetch(); 18 $stmt->close();
|
H A D | mysqli_stmt_bind_result_format.phpt | 67 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 74 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 81 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 91 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 98 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 116 mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 136 mysqli_stmt_close($stmt); 294 if (!$stmt->execute()) { 312 while ($stmt->fetch()) { 319 $stmt->free_result(); [all …]
|
H A D | bug35103.phpt | 26 $stmt = $mysql->prepare("SELECT a FROM test_bint ORDER BY a"); 27 $stmt->bind_result($v); 28 $stmt->execute(); 32 $stmt->fetch(); 35 $stmt->close(); 39 $stmt = $mysql->prepare("SELECT a FROM test_buint ORDER BY a"); 40 $stmt->bind_result($v2); 41 $stmt->execute(); 45 $stmt->fetch(); 48 $stmt->close();
|
H A D | 063.phpt | 14 $stmt = new mysqli_stmt($mysql, "SELECT 'foo' FROM DUAL"); 15 $stmt->execute(); 16 $stmt->bind_result($foo); 17 $stmt->fetch(); 18 $stmt->close();
|
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); 133 mysqli_stmt_close($stmt); 312 printf("[2000] [%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)); 365 if (!$stmt->execute()) [all …]
|
H A D | 023.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); 37 mysqli_stmt_execute($stmt); 38 mysqli_stmt_close($stmt); 40 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 41 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7); 42 mysqli_stmt_execute($stmt); 43 mysqli_stmt_fetch($stmt); 49 mysqli_stmt_close($stmt);
|
H A D | 024.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); 41 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 42 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7); 43 mysqli_stmt_execute($stmt); 44 mysqli_stmt_fetch($stmt); 50 mysqli_stmt_close($stmt);
|
H A D | mysqli_stmt_bind_limits.phpt | 38 …$stmt_bind_param = 'return mysqli_stmt_bind_param($stmt, "' . $stmt_types . '", ' . $stmt_params .… 48 if (!$stmt = $link->prepare($insert)) { 52 if ($stmt->param_count != $num_params * $rows) { 56 printf("... statement with %d parameters prepared\n", $stmt->param_count); 60 printf("[%03d + 03] [%d] %s\n", $offset, $stmt->errno, $stmt->error); 69 if (!call_user_func_array(array($stmt, 'bind_param'), $param_ref)) { 70 printf("[%03d + 03] [%d] %s\n", $offset, $stmt->errno, $stmt->error); 74 if ($stmt->param_count != $num_params * $rows) { 79 if (!$stmt->execute()) { 80 printf("[%03d + 04] [%d] %s\n", $offset, $stmt->errno, $stmt->error); [all …]
|
/PHP-5.5/ext/oci8/tests/ |
H A D | bug43497_92.phpt | 28 $row = oci_fetch($stmt); 29 return oci_result($stmt, 1); 43 $row = oci_fetch($stmt); 44 $val = oci_result($stmt, 1); 45 oci_free_statement($stmt); 58 if (oci_execute($stmt)) { 73 if (oci_execute($stmt)) { 87 if (oci_execute($stmt)) { 99 oci_execute($stmt); 105 oci_execute($stmt); [all …]
|
H A D | statement_cache.phpt | 17 $stmt = oci_parse($pc, "select 1+3 from dual"); 18 oci_execute($stmt); 19 var_dump(oci_fetch_array($stmt)); 21 $stmt = oci_parse($pc, "select 1+3 from dual"); 22 oci_execute($stmt); 23 var_dump(oci_fetch_array($stmt));
|
/PHP-5.5/ext/pdo/tests/ |
H A D | bug65946.phpt | 19 $stmt = $db->prepare('SELECT * FROM test LIMIT :limit'); 20 $stmt->bindValue('limit', 1, PDO::PARAM_INT); 21 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo()); 22 if(!($res = $stmt->execute())) var_dump($stmt->errorInfo()); 23 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
/PHP-5.5/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_match_against.phpt | 20 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)'); 21 $stmt->execute(array(':placeholder' => 'row')); 22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 24 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)'); 25 $stmt->execute(array('placeholder' => 'row')); 26 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 28 $stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (?)'); 29 $stmt->execute(array('row')); 30 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
|
H A D | bug44327.phpt | 15 $stmt = $db->prepare("SELECT 1 AS \"one\""); 16 $stmt->execute(); 17 $row = $stmt->fetch(PDO::FETCH_LAZY); 28 $stmt = $db->prepare("SELECT id FROM test"); 29 $stmt->execute(); 30 $row = $stmt->fetch(PDO::FETCH_LAZY); 37 $stmt = $db->prepare('foo'); 38 @$stmt->execute(); 39 $row = $stmt->fetch();
|
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 | pdo_mysql_prepare_emulated.phpt | 20 $stmt = @$db->prepare($query); 22 $stmt = $db->prepare($query); 48 $ret = @$stmt->execute($input_params); 50 $ret = $stmt->execute($input_params); 57 $tmp = $stmt->errorInfo(); 83 return $stmt; 96 $stmt = prepex(4, $db, 'SELECT 1 as "one"'); 97 var_dump($stmt->fetch(PDO::FETCH_ASSOC)); 293 $stmt = prepex(79, $db, $sql, array(-1)); 300 $stmt = prepex(81, $db, $sql, array(1)); [all …]
|
H A D | pdo_mysql_attr_fetch_table_names.phpt | 16 $stmt = $db->query('SELECT label FROM test LIMIT 1'); 17 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 18 $stmt->closeCursor(); 21 $stmt = $db->query('SELECT label FROM test LIMIT 1'); 22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 23 $stmt->closeCursor();
|
H A D | bug_pecl_12925.phpt | 21 $stmt = $db->prepare("UPDATE test SET id = 'b'"); 22 $stmt->execute(); 23 $stmt = $db->prepare("UPDATE test SET id = 'c'"); 24 $stmt->execute(); 25 $stmt = $db->prepare('SELECT id FROM test'); 26 $stmt->execute(); 27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 28 $stmt->closeCursor();
|
H A D | pdo_mysql_stmt_columncount.phpt | 25 $stmt = $db->prepare("SELECT id, label, '?' as foo FROM test"); 26 $stmt->execute(); 27 var_dump($stmt->columnCount()); 29 $stmt = $db->query('SELECT * FROM test'); 30 var_dump($stmt->columnCount()); 43 $stmt = $db->prepare("SELECT id, label, '?' as foo, 'TODO - Stored Procedure' as bar FROM test"); 44 $stmt->execute(); 45 var_dump($stmt->columnCount()); 47 $stmt = $db->query('SELECT * FROM test'); 48 var_dump($stmt->columnCount());
|
H A D | pdo_mysql_prepare_native_placeholder_everywhere.phpt | 23 $stmt = $db->prepare('SELECT ?, id, label FROM test WHERE ? = ? ORDER BY id ASC'); 24 $stmt->execute(array('id', 'label', 'label')); 25 if ('00000' !== $stmt->errorCode()) 27 var_export($stmt->errorCode(), true), 28 var_export($stmt->errorInfo(), true)); 29 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); 38 $stmt->execute(array('id', 'label', 'label')); 39 if ('00000' !== $stmt->errorCode()) 41 var_export($stmt->errorCode(), true), 42 var_export($stmt->errorInfo(), true)); [all …]
|
/PHP-5.5/ext/mysqlnd/ |
H A D | mysqlnd_ps_codec.c | 532 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_store_params() local 553 SET_OOM_ERROR(*stmt->error_info); in mysqlnd_stmt_execute_store_params() 585 PASS != mysqlnd_stmt_copy_it(&copies, stmt->param_bind[i].zv, stmt->param_count, i TSRMLS_CC)) in mysqlnd_stmt_execute_store_params() 587 SET_OOM_ERROR(*stmt->error_info); in mysqlnd_stmt_execute_store_params() 628 if (stmt->send_types_to_server) { in mysqlnd_stmt_execute_store_params() 636 SET_OOM_ERROR(*stmt->error_info); in mysqlnd_stmt_execute_store_params() 706 switch (stmt->param_bind[i].type) { in mysqlnd_stmt_execute_store_params() 774 SET_OOM_ERROR(*stmt->error_info); in mysqlnd_stmt_execute_store_params() 798 switch (stmt->param_bind[i].type) { in mysqlnd_stmt_execute_store_params() 866 MYSQLND_STMT_DATA * stmt = s->data; in mysqlnd_stmt_execute_generate_request() local [all …]
|
/PHP-5.5/ext/pdo_sqlite/tests/ |
H A D | bug_63916.phpt | 14 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)'); 15 $stmt->bindValue(':id', 1, PDO::PARAM_INT); 16 $stmt->bindValue(':num', $num, PDO::PARAM_INT); 17 $stmt->execute(); 19 $stmt = $conn->query('SELECT num FROM users'); 20 $result = $stmt->fetchAll(PDO::FETCH_COLUMN);
|
H A D | bug_63916-2.phpt | 14 $stmt = $conn->prepare('insert into users (id, num) values (:id, :num)'); 15 $stmt->bindValue(':id', 1, PDO::PARAM_INT); 16 $stmt->bindValue(':num', $num, PDO::PARAM_INT); 17 $stmt->execute(); 19 $stmt = $conn->query('SELECT num FROM users'); 20 $result = $stmt->fetchAll(PDO::FETCH_COLUMN);
|
/PHP-5.5/ext/pdo_pgsql/tests/ |
H A D | bug46274.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();
|