$database->getPrimaryKey() method

Get column(s) or info for given table’s primary key/index

By default it returns a string with the column name compromising the primary key, i.e. col1. If the primary key is multiple columns then it returns a CSV string, like col1,col2,col3.

If you specify boolean true for the verbose option then it returns an simplified array of information about the primary key. If you specify integer 2 then it returns an array of raw MySQL SHOW INDEX information.

Available since version 3.0.182.

Usage

// basic usage
$string = $database->getPrimaryKey(string $table);

// usage with all arguments
$string = $database->getPrimaryKey(string $table, $verbose = false);

Arguments

NameType(s)Description
tablestring
verbose (optional)bool, int

Get array of info rather than column(s) string? (default=false)

Return value

string array


$database methods and properties

API reference based on ProcessWire core version 3.0.236

Latest news

  • ProcessWire Weekly #518
    The 518th issue of ProcessWire Weekly brings in all the latest news from the ProcessWire community. Modules, sites, and more. Read on!
    Weekly.pw / 13 April 2024
  • ProFields Table Field with Actions support
    This week we have some updates for the ProFields table field (FieldtypeTable). These updates are primarily focused on adding new tools for the editor to facilitate input and management of content in a table field.
    Blog / 12 April 2024
  • Subscribe to weekly ProcessWire news

“The end client and designer love the ease at which they can update the website. Training beyond how to log in wasn’t even necessary since ProcessWire’s default interface is straightforward.” —Jonathan Lahijani