PDOStatement::columnCount

Microsoft Drivers for PHP for SQL Server

Collapse image Expand Image Copy image CopyHover image

Returns the number of columns in a result set.

Syntax

int PDOStatement::columnCount ();

Return Value

Returns the number of columns in a result set. Returns zero if the result set is empty.

Remarks

Support for PDO was added in version 2.0 of the Microsoft Drivers for PHP for SQL Server.

Example

  Copy imageCopy Code
<?php
$database = "AdventureWorks";
$server = "(local)";
$conn = new PDO( "sqlsrv:server=$server ; Database = $database", "", "");

$query = "select * from Person.ContactType";
$stmt = $conn->prepare( $query );
print $stmt->columnCount();   // 0

echo "\n";
$stmt->execute();
print $stmt->columnCount();

echo "\n";
$stmt = $conn->query("select * from HumanResources.Department");
print $stmt->columnCount();
?>

See Also

Reference

Other Resources

PDO