Valiukas Liutauras liutauras

layout	title	permalink
checklist_page	The Side Project Marketing Checklist	/marketing-checklist/

Pre-Launch

Market Research

Laravel 6 - Diving Into Pivot Tables

Pivot tables can be confusing and a little hard to wrap your head around at first. In this quick article we are going to dive into what a pivot table is, how to create one and finally how to use the pivot table. Let's dive in!

What is a pivot table?

A pivot table is used to connect relationships between two tables. Laravel provides a Many To Many relationship where you can use a pivot table.

	<?php

	// This can be found in the Symfony\Component\HttpFoundation\Response class

	const HTTP_CONTINUE = 100;
	const HTTP_SWITCHING_PROTOCOLS = 101;
	const HTTP_PROCESSING = 102; // RFC2518
	const HTTP_OK = 200;
	const HTTP_CREATED = 201;
	const HTTP_ACCEPTED = 202;

	/*
	Handle
	Title = oc_product_description.name
	Body (HTML) = oc_product_description.description
	Vendor = oc_product.manufacturer_id
	Type
	Tags = oc_product_description.tag
	Published = oc_product.status
	Option1 Name
	Option1 Value