$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.244

Latest news

  • ProcessWire Weekly #558
    In the 558th issue of ProcessWire Weekly we'll check out the blog post that introduces ProcessWire 3.0.244, share some recent ProcessWire highlights, and more. Read on!
    Weekly.pw / 18 January 2025
  • ProcessWire 3.0.244 new main/master version
    ProcessWire 3.0.244 is our newest main/master/stable version. It's been more than a year in the making and is packed with tons of new features, issue fixes, optimizations and more. This post covers all the details.
    Blog / 18 January 2025
  • Subscribe to weekly ProcessWire news

“We were really happy to build our new portfolio website on ProcessWire! We wanted something that gave us plenty of control on the back-end, without any bloat on the front end - just a nice, easy to access API for all our content that left us free to design and build however we liked.” —Castus, web design agency in Sheffield, UK