IT. Expert System.

PHP

Get result of next query when executing multiple SQL statements


cubrid_next_result

(PECL CUBRID >= 8.4.0)

cubrid_next_resultGet result of next query when executing multiple SQL statements

Description

bool cubrid_next_result ( resource $result )

The cubrid_next_result() function is used to get results of next query if multiple SQL statements are executed and CUBRID_EXEC_QUERY_ALL flag is set upon cubrid_execute().

Parameters

result

result comes from a call to cubrid_execute()

Return Values

TRUE, when process is successful.

FALSE, when process is unsuccessful.

Examples

Example #1 cubrid_next_result() example

<?php
$conn 
cubrid_connect("127.0.0.1"33000"demodb");

$sql_stmt "SELECT * FROM code; SELECT * FROM history WHERE host_year=2004 AND event_code=20281";
$res cubrid_execute($conn$sql_stmtCUBRID_EXEC_QUERY_ALL);

get_result_info($res);
cubrid_next_result($res);
get_result_info($res);

function 
get_result_info($req)
{
    
printf("\n------------ get_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($req1);

    
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");

    
$size count($column_name_list);
    for(
$i 0$i $size$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:

 ------------ get_result_info -------------------- Row count:      6 Column count:     2 Column Names     Column Types     Column Len  ------------------------------------------------------------------------------ s_name       char(1)      1    f_name       varchar(6)      6     Last Column Name:    f_name Last Column Table:    code Last Column Type:    varchar(6) Last Column Len:    6 Second Column Flags:    ------------ get_result_info -------------------- Row count:      4 Column count:     5 Column Names     Column Types     Column Len  ------------------------------------------------------------------------------ event_code      integer      11    athlete      varchar(40)     40    host_year      integer      11    score       varchar(10)     10    unit       varchar(5)      5     Last Column Name:    unit Last Column Table:    history Last Column Type:    varchar(5) Last Column Len:    5 Second Column Flags:   not_null primary_key unique_key 

See Also



Content

Android Reference

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary

License.
All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.
Copyright 2016 © ELTASK.COM. All rights reserved.
Site is optimized for mobile devices.
Downloads: 581 / 158670809. Delta: 0.04495 с