diff options
| -rw-r--r-- | ext/mysqli/tests/058.phpt | 55 |
1 files changed, 55 insertions, 0 deletions
diff --git a/ext/mysqli/tests/058.phpt b/ext/mysqli/tests/058.phpt new file mode 100644 index 0000000000..11b9475905 --- /dev/null +++ b/ext/mysqli/tests/058.phpt @@ -0,0 +1,55 @@ +--TEST-- +multiple binds +--FILE-- +<?php + include "connect.inc"; + + /*** test mysqli_connect 127.0.0.1 ***/ + $link = mysqli_connect("localhost", $user, $passwd); + + mysqli_select_db($link, "test"); + + mysqli_query($link,"DROP TABLE IF EXISTS mbind"); + mysqli_query($link,"CREATE TABLE mbind (a int, b varchar(10))"); + + $stmt = mysqli_prepare($link, "INSERT INTO mbind VALUES (?,?)"); + + mysqli_bind_param($stmt, array(MYSQLI_BIND_INT, MYSQLI_BIND_STRING), $a, $b); + + $a = 1; + $b = "foo"; + + mysqli_execute($stmt); + + mysqli_bind_param($stmt, array(MYSQLI_BIND_INT, MYSQLI_BIND_STRING), $c, $d); + + $c = 2; + $d = "bar"; + + mysqli_execute($stmt); + mysqli_stmt_close($stmt); + + $stmt = mysqli_prepare($link, "SELECT * FROM mbind"); + mysqli_execute($stmt); + + mysqli_bind_result($stmt, $e, $f); + mysqli_fetch($stmt); + + mysqli_bind_result($stmt, $g, $h); + mysqli_fetch($stmt); + + var_dump((array($e,$f,$g,$h))); + + mysqli_close($link); +?> +--EXPECT-- +array(4) { + [0]=> + int(1) + [1]=> + string(3) "foo" + [2]=> + int(2) + [3]=> + string(3) "bar" +} |