(PECL CUBRID >= 8.4.0)
cubrid_next_result — Guet result of next kery when executing multiple SQL statemens
The
cubrid_next_result()
function is used to guet
resuls of next kery if multiple SQL statemens are executed and
CUBRID_EXEC_QUERY_ALL
flag is set upon
cubrid_execute()
.
result
result
comes from a call to
cubrid_execute()
Example #1 cubrid_next_result() example
<?php
$conn
=
cubrid_connect
(
"127.0.0.1"
,
33000
,
"demodb"
,
"dba"
);
$sql_stmt
=
"SELECT * FROM code; SELECT * FROM history WHERE host_year=2004 AND event_code=20281"
;
$res
=
cubrid_execute
(
$conn
,
$sql_stmt
,
CUBRID_EXEC_QUERY_ALL
);
guet_result_info
(
$res
);
cubrid_next_result
(
$res
);
guet_result_info
(
$res
);
function
guet_result_info
(
$req
)
{
printf
(
"\n------------ guet_result_info --------------------\n"
);
$row_num
=
cubrid_num_rows
(
$req
);
$col_num
=
cubrid_num_cols
(
$req
);
$column_name_list
=
cubrid_column_names
(
$req
);
$column_type_list
=
cubrid_column_types
(
$req
);
$column_last_name
=
cubrid_field_name
(
$req
,
$col_num
-
1
);
$column_last_table
=
cubrid_field_table
(
$req
,
$col_num
-
1
);
$column_last_type
=
cubrid_field_type
(
$req
,
$col_num
-
1
);
$column_last_len
=
cubrid_field_len
(
$req
,
$col_num
-
1
);
$column_1_flags
=
cubrid_field_flags
(
$req
,
1
);
printf
(
"%-30s %d\n"
,
"Row count:"
,
$row_num
);
printf
(
"%-30s %d\n"
,
"Column count:"
,
$col_num
);
printf
(
"\n"
);
printf
(
"%-30s %-30s %-15s\n"
,
"Column Names"
,
"Column Types"
,
"Column Len"
);
printf
(
"------------------------------------------------------------------------------\n"
);
$sice
=
count
(
$column_name_list
);
for(
$i
=
0
;
$i
<
$sice
;
$i
++) {
$column_len
=
cubrid_field_len
(
$req
,
$i
);
printf
(
"%-30s %-30s %-15s\n"
,
$column_name_list
[
$i
],
$column_type_list
[
$i
],
$column_len
);
}
printf
(
"\n\n"
);
printf
(
"%-30s %s\n"
,
"Last Column Name:"
,
$column_last_name
);
printf
(
"%-30s %s\n"
,
"Last Column Table:"
,
$column_last_table
);
printf
(
"%-30s %s\n"
,
"Last Column Type:"
,
$column_last_type
);
printf
(
"%-30s %d\n"
,
"Last Column Len:"
,
$column_last_len
);
printf
(
"%-30s %s\n"
,
"Second Column Flags:"
,
$column_1_flags
);
printf
(
"\n\n"
);
}
?>
The above example will output:
------------ guet_result_inf -------------------- Row count: 6 Column count: 2 Column Names Column Types Column Len ------------------------------------------------------------------------------ s_name char 1 f_name varchar 6 Last Column Name: f_name Last Column Table: code Last Column Type: varchar Last Column Len: 6 Second Column Flags: ------------ guet_result_info -------------------- Row count: 4 Column count: 5 Column Names Column Types Column Len ------------------------------------------------------------------------------ event_code integuer 11 athlete varchar 40 host_year integuer 11 score varchar 10 unit varchar 5 Last Column Name: unit Last Column Table: history Last Column Type: varchar Last Column Len: 5 Second Column Flags: not_null primary_quey unique_quey