Wiki articles tagged with "Junction Table"

Showing 1-1 of 1 item.

Yii2 GridView Sorting and Searching with a Junction Table Column(Many to Many Relationship)

Created 7 years ago by Amjad Khan, updated 7 years ago by Amjad Khan.

Following is the table structure

tblgroups

CREATE TABLE IF NOT EXISTS `tblgroups` (
  `id` int(11) NOT NULL,
  `groupname` varchar(150) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=Acitve,2=Inactive',
  `date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

tblcontacts

4 1
7 followers
Viewed: 86 959 times
Version: 2.0
Category: Tutorials