field auto_increment

[lundy]

I need the equivalent of a auto_increment mysql field for user_id's.  In mysql, it's a setting of the field.  How do I accomplish this with processwire.

Thanks, Aloha

[Macrura]

users are pages. pages already have auto-id increment

[pwFoo]

But how could we build unique ids with pw if needed? For example unique topic, user and task ids starting with zero and auto increment?

[Joss]

How are you planing to use ids?

Since everything is a page, everything gets a unique ID. Though not starting from zero for each item. But that is not needed in PW for controlling data.

[Macrura]

But how could we build unique ids with pw if needed? For example unique topic, user and task ids starting with zero and auto increment?

it would be very easy to add a hook and do this; i've seen sample code here on the forum. you would hook into the page saveReady

    public function init() {
       $this->pages->addHookAfter('saveReady', $this, 'autoIncrememt');
    }

public function autoIncrement(HookEvent $event) {
 $page = $event->arguments[0];
  if($page->template != 'someTemplate') return; 

  // some logic here to count the existing pages of this template and then add 1 and set the value of your auto increment field to that value, if it is empty.

}

[pwFoo]

Thanks, Macrura. 

But it's also right... I've to think about unique (section) id vs (global) page id. Is it needed to use different IDs for different sections or simple use page id and filter with different templates/ categories.

So also thanks to you, Joss