Annotation of embedaddon/php/ext/mysqli/tests/mysqli_stmt_fetch_geom.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: mysqli_stmt_fetch - geometry / spatial types
3: --SKIPIF--
4: <?php
5: require_once('skipif.inc');
6: require_once('skipifemb.inc');
7: require_once('skipifconnectfailure.inc');
8:
9: if (!defined("MYSQLI_TYPE_GEOMETRY"))
10: die("skip MYSQLI_TYPE_GEOMETRY not defined");
11: ?>
12: --FILE--
13: <?php
14: require('connect.inc');
15: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
16: printf("[001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
17:
18: function func_mysqli_stmt_fetch_geom($link, $engine, $sql_type, $bind_value, $offset) {
19:
20: if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) {
21: printf("[%04d] [%d] %s\n", $offset, mysqli_errno($link), mysqli_error($link));
22: return false;
23: }
24:
25: if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT, label %s, PRIMARY KEY(id)) ENGINE = %s", $sql_type, $engine))) {
26: // don't bail - column type might not be supported by the server, ignore this
27: return false;
28: }
29:
30: for ($id = 1; $id < 4; $id++) {
31: $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, %s)", $id, $bind_value);
32: if (!mysqli_query($link, $sql)) {
33: printf("[%04d] [%d] %s\n", $offset + 2 + $id, mysqli_errno($link), mysqli_error($link));
34: }
35: }
36:
37: if (!$stmt = mysqli_stmt_init($link)) {
38: printf("[%04d] [%d] %s\n", $offset + 6, mysqli_errno($link), mysqli_error($link));
39: return false;
40: }
41:
42: if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) {
43: printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
44: mysqli_stmt_close($stmt);
45: return false;
46: }
47:
48: if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_store_result($stmt)) {
49: printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
50: mysqli_stmt_close($stmt);
51: return false;
52: }
53:
54: if (!mysqli_stmt_bind_result($stmt, $id, $bind_res)) {
55: printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
56: mysqli_stmt_close($stmt);
57: return false;
58: }
59:
60: $result = mysqli_stmt_result_metadata($stmt);
61: $fields = mysqli_fetch_fields($result);
62: if ($fields[1]->type != MYSQLI_TYPE_GEOMETRY) {
63: printf("[%04d] [%d] %s wrong type %d\n", $offset + 10, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $fields[1]->type);
64: }
65:
66: $num = 0;
67: $rows = array();
68: while (true === @mysqli_stmt_fetch($stmt)) {
69: $rows[] = array('id' => $id, 'label' => $bind_res);
70: $num++;
71: }
72:
73: if ($num != 3) {
74: printf("[%04d] [%d] %s, expecting 3 results, got only %d results\n",
75: $offset + 17, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
76: return false;
77: }
78: mysqli_stmt_close($stmt);
79:
80: foreach ($rows as $row) {
81: if (!$stmt = mysqli_stmt_init($link)) {
82: printf("[%04d] [%d] %s\n", $offset + 10, mysqli_errno($link), mysqli_error($link));
83: return false;
84: }
85:
86: if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) {
87: printf("[%04d] [%d] %s\n", $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
88: return false;
89: }
90:
91: $new_id = $row['id'] + 10;
92: if (!mysqli_stmt_bind_param($stmt, "is", $new_id, $row['label'])) {
93: printf("[%04d] [%d] %s\n", $offset + 12, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
94: return false;
95: }
96:
97: if (!mysqli_stmt_execute($stmt)) {
98: printf("[%04d] [%d] %s\n", $offset + 13, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
99: return false;
100: }
101: mysqli_stmt_close($stmt);
102:
103: if (!$res_normal = mysqli_query($link, sprintf("SELECT id, label FROM test WHERE id = %d",
104: $new_id))) {
105: printf("[%04d] [%d] %s\n", $offset + 14, mysqli_errno($link), mysqli_error($link));
106: return false;
107: }
108:
109: if (!$row_normal = mysqli_fetch_assoc($res_normal)) {
110: printf("[%04d] [%d] %s\n", $offset + 15, mysqli_errno($link), mysqli_error($link));
111: return false;
112: }
113:
114: if ($row_normal['label'] != $row['label']) {
115: printf("[%04d] PS and non-PS return different data.\n", $offset + 16);
116: return false;
117: }
118: mysqli_free_result($res_normal);
119: }
120:
121: return true;
122: }
123:
124: func_mysqli_stmt_fetch_geom($link, $engine, "GEOMETRY", "GeomFromText('POINT(2 2)')", 20);
125: func_mysqli_stmt_fetch_geom($link, $engine, "POINT", "GeomFromText('POINT(1 1)')", 40);
126: func_mysqli_stmt_fetch_geom($link, $engine, "LINESTRING", "GeomFromText('LINESTRING(0 0,1 1,2 2)')", 60);
127: func_mysqli_stmt_fetch_geom($link, $engine, "POLYGON", "GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0),(5 5,7 5,7 7,5 7, 5 5))')", 80);
128: func_mysqli_stmt_fetch_geom($link, $engine, "MULTIPOINT", "GeomFromText('MULTIPOINT(1 1, 2 2)')", 100);
129: func_mysqli_stmt_fetch_geom($link, $engine, "MULTILINESTRING", "GeomFromText('MULTILINESTRING((0 0,1 1,2 2),(0 0,1 1,3 3))')", 120);
130: func_mysqli_stmt_fetch_geom($link, $engine, "MULTIPOLYGON", "GeomFromText('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(5 5,7 5,7 7,5 7, 5 5)),((0 0,10 0,10 10,0 10,0 0),(5 5,7 5,7 7,5 7, 5 5)))')", 140);
131: func_mysqli_stmt_fetch_geom($link, $engine, "GEOMETRYCOLLECTION", "GeomFromText('GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(0 0,1 1,2 2,3 3,4 4))')", 160);
132:
133: mysqli_close($link);
134: print "done!";
135: ?>
136: --CLEAN--
137: <?php
138: require_once("clean_table.inc");
139: ?>
140: --EXPECTF--
141: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>