Annotation of embedaddon/php/ext/mysqli/tests/058.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: multiple binds
3: --SKIPIF--
4: <?php
5: require_once('skipif.inc');
6: require_once('skipifconnectfailure.inc');
7: ?>
8: --FILE--
9: <?php
10: require_once("connect.inc");
11:
12: /*** test mysqli_connect 127.0.0.1 ***/
13: $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
14:
15: mysqli_select_db($link, $db);
16:
17: mysqli_query($link,"DROP TABLE IF EXISTS mbind");
18: mysqli_query($link,"CREATE TABLE mbind (a int, b varchar(10))");
19:
20: $stmt = mysqli_prepare($link, "INSERT INTO mbind VALUES (?,?)");
21:
22: mysqli_stmt_bind_param($stmt, "is", $a, $b);
23:
24: $a = 1;
25: $b = "foo";
26:
27: mysqli_stmt_execute($stmt);
28:
29: mysqli_stmt_bind_param($stmt, "is", $c, $d);
30:
31: $c = 2;
32: $d = "bar";
33:
34: mysqli_stmt_execute($stmt);
35: mysqli_stmt_close($stmt);
36:
37: $stmt = mysqli_prepare($link, "SELECT * FROM mbind");
38: mysqli_stmt_execute($stmt);
39:
40: mysqli_stmt_bind_result($stmt, $e, $f);
41: mysqli_stmt_fetch($stmt);
42:
43: mysqli_stmt_bind_result($stmt, $g, $h);
44: mysqli_stmt_fetch($stmt);
45:
46: var_dump((array($e,$f,$g,$h)));
47:
48: mysqli_close($link);
49: print "done!";
50: ?>
51: --CLEAN--
52: <?php
53: require_once("connect.inc");
54: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
55: printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
56:
57: if (!mysqli_query($link, "DROP TABLE IF EXISTS mbind"))
58: printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
59:
60: mysqli_close($link);
61: ?>
62: --EXPECTF--
63: array(4) {
64: [0]=>
65: int(1)
66: [1]=>
67: %unicode|string%(3) "foo"
68: [2]=>
69: int(2)
70: [3]=>
71: %unicode|string%(3) "bar"
72: }
73: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>