Toggle, select or multiselect a database field based on a set of conditions

Installs: 113

Dependents: 0

Suggesters: 0

Security: 0

Stars: 2

Watchers: 3

Forks: 4


0.0.1 2015-11-27 09:44 UTC

This package is not auto-updated.

Last update: 2024-03-30 16:14:36 UTC


Build Status Coverage Total Downloads License

Toggle, select or multiselect a database field based on a set of conditions


Using Composer:

composer require muffin/multiselect:1.0.x-dev

You then need to load the plugin. You can use the shell command:

bin/cake plugin load Muffin/Multiselect

or by manually adding statement shown below to your app's config/bootstrap.php:



In a playlist, a single song can be play at the time. Whenever a song is marked as playing, all of the other songs are marked as not playing. for this we use the boolean field playing.

CREATE table songs(
    id int(10) unsigned NOT NULL auto_increment,
    title varchar(255) NOT NULL,
    playing tinyint(1) NOT NULL,

Load the behavior in your model SongsTable.php:

$this->addBehavior('Multiselect.Multiselect', ['playing']);

More complex use cases can be covered like the following. Where only 2 articles can be marked as featured at the time for the same author. When a third article is marked as featured, one of the 3 articles gets unfeatured. In this case, ordered by the least view count and by modification date.

$this->addBehavior('Multiselect.Multiselect', [
    'featured' => [
        'state' => true, 
        'scope' => ['author_id'],
        'limit' => 2,
        'order' => [
            'view_count' => 'ASC',
            'modified' => 'ASC',


  • [field_name] The name of the field used as select
  • state Either mark the active field as true or false
  • scope Selections can be grouped by fields defined here
  • limit Maximum number of selected elements
  • order Order in which to unselect fields when the limit is exceeded

Patches & Features

  • Fork
  • Mod, fix
  • Test - this is important, so it's not unintentionally broken
  • Commit - do not mess with license, todo, version, etc. (if you do change any, bump them into commits of their own that I can ignore when I pull)
  • Pull request - bonus point for topic branches

To ensure your PRs are considered for upstream, you MUST follow the CakePHP coding standards.

Bugs & Feedback


Copyright (c) 2015, Use Muffin and licensed under The MIT License.