Documentation Home
MySQL PHP API
Download this Manual
PDF (US Ltr) - 2.4Mb
PDF (A4) - 2.4Mb
HTML Download (TGZ) - 250.9Kb
HTML Download (Zip) - 258.4Kb


MySQL PHP API  /  ...  /  RowResult::getColumnCount

5.25.4 RowResult::getColumnCount

Copyright 1997-2019 the PHP Documentation Group.

  • RowResult::getColumnCount

    Get column count

Description

public integer mysql_xdevapi\RowResult::getColumnCount();

Retrieve the column count for columns present in the result set.

Parameters

This function has no parameters.

Return Values

The number of columns, or FALSE if the result set is empty.

Examples

Example 5.94 mysql_xdevapi\RowResult::getColumnCount example

<?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");

$session->sql("DROP DATABASE addressbook")->execute();
$session->sql("CREATE DATABASE foo")->execute();
$session->sql("CREATE TABLE foo.test_table(x int)")->execute();
$session->sql("INSERT INTO addressbook.names values ('John', 42), ('Sam', 33)")->execute();

$sql = $session->sql("SELECT * from addressbook.names")->execute();

echo $sql->getColumnCount();

The above example will output something similar to:


2