PHP: cubrid_num_cols - Manual (original) (raw)

(PECL CUBRID >= 8.3.0)

cubrid_num_cols — Return the number of columns in the result set

Description

The cubrid_num_cols() function is used to get the number of columns from the query result. It can only be used when the query executed is a SELECT statement.

Parameters

result

Result.

Return Values

Number of columns, when process is successful.

[false](reserved.constants.php#constant.false), if SQL statement is not SELECT.

Examples

Example #1 cubrid_num_cols() example

<?php <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>c</mi><mi>o</mi><mi>n</mi><mi>n</mi><mo>=</mo><mi>c</mi><mi>u</mi><mi>b</mi><mi>r</mi><mi>i</mi><msub><mi>d</mi><mi>c</mi></msub><mi>o</mi><mi>n</mi><mi>n</mi><mi>e</mi><mi>c</mi><mi>t</mi><mo stretchy="false">(</mo><mi mathvariant="normal">"</mi><mi>l</mi><mi>o</mi><mi>c</mi><mi>a</mi><mi>l</mi><mi>h</mi><mi>o</mi><mi>s</mi><mi>t</mi><mi mathvariant="normal">"</mi><mo separator="true">,</mo><mn>33000</mn><mo separator="true">,</mo><mi mathvariant="normal">"</mi><mi>d</mi><mi>e</mi><mi>m</mi><mi>o</mi><mi>d</mi><mi>b</mi><mi mathvariant="normal">"</mi><mo separator="true">,</mo><mi mathvariant="normal">"</mi><mi>d</mi><mi>b</mi><mi>a</mi><mi mathvariant="normal">"</mi><mo stretchy="false">)</mo><mo separator="true">;</mo></mrow><annotation encoding="application/x-tex">conn = cubrid_connect("localhost", 33000, "demodb", "dba");</annotation></semantics></math>conn=cubridconnect("localhost",33000,"demodb","dba");req = cubrid_execute($conn, "SELECT * FROM code");$row_num = cubrid_num_rows($req); <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>c</mi><mi>o</mi><msub><mi>l</mi><mi>n</mi></msub><mi>u</mi><mi>m</mi><mo>=</mo><mi>c</mi><mi>u</mi><mi>b</mi><mi>r</mi><mi>i</mi><msub><mi>d</mi><mi>n</mi></msub><mi>u</mi><msub><mi>m</mi><mi>c</mi></msub><mi>o</mi><mi>l</mi><mi>s</mi><mo stretchy="false">(</mo></mrow><annotation encoding="application/x-tex">col_num = cubrid_num_cols(</annotation></semantics></math>colnum=cubridnumcols(req);printf("Row Num: %d\nColumn Num: %d\n", <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>o</mi><msub><mi>w</mi><mi>n</mi></msub><mi>u</mi><mi>m</mi><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">row_num, </annotation></semantics></math>rownum,col_num);cubrid_disconnect($conn); ?>

The above example will output:

PHP: cubrid_num_cols - Manual (original) (raw)

Description

Parameters

Return Values

Examples

See Also