how-to-one-to-many.md

How To Implement An One To Many Relationship To Form (E.g : Product <- Category)

Products Table - products

Field Name	Description
id	int(PK)
created_at	timestamp
name	varchar(255)
description	text
categories_id	int(11)

Categories Table - categories

Field Name	Description
id	int(PK)
created_at	timestamp
name	varchar(255)

Form

$this->form[] = ['label'=>'Name','name'=>'name','type'=>'text'];
$this->form[] = ['label'=>'Description','name'=>'description','type'=>'textarea'];
$this->form[] = ['label'=>'Category','name'=>'categories_id','type'=>'select','datatable'=>'categories,name'];

Column

$this->col[] = ['label'=>'Name','name'=>'name'];
$this->col[] = ['label'=>'Description','name'=>'description'];
$this->col[] = ['label'=>'Category','name'=>'categories_id','join'=>'categories,name'];

What's Next

• How To Put A Custom Condition At Grid Data Query

Table Of Contents

• Back To Index