cubrid_num_cols

(PECL CUBRID >= 8.3.0)

cubrid_num_cols — Return the number of columns in the result set

説明

function cubrid_num_cols(resource $result): int

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.

パラメータ

result: Result.

戻り値

Number of columns, when process is successful.

false, if SQL statement is not SELECT.

例

例1 cubrid_num_cols() example

<?php
$conn = cubrid_connect("localhost", 33000, "demodb", "dba");

$req = cubrid_execute($conn, "SELECT * FROM code");

$row_num = cubrid_num_rows($req);
$col_num = cubrid_num_cols($req);

printf("Row Num: %d\nColumn Num: %d\n", $row_num, $col_num);

cubrid_disconnect($conn);
?>

上の例の出力は以下となります。

Row Num: 6
Column Num: 2

参考

cubrid_execute() - Execute a prepared SQL statement
cubrid_num_rows() - Get the number of rows in the result set

関連キーワード:

cubrid cols number columns rows Return statement conn used query execute next resource executed Number process successful example connect localhost demodb code printf nColumn disconnect